drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Love Drill - Hate Key Has String Token
Date Mon, 27 Aug 2018 23:37:51 GMT
Can you post a sample file with, say, 5-10 lines?

Is it the file names?

Or the data values that are giving you fits?

On Mon, Aug 27, 2018, 12:51 John Folkers <john.folkers@bethesda.net> wrote:

> Hello, I downloaded Drill over the weekend, and I love it.
>
>
> Problem: $ string token in a key.
>
>
> Question: How can I get Drill to not trip on the $ string token when it
> sees it inside the keyname?
>
>
> Error Message
> Error: DATA_READ ERROR: Failure while reading ExtendedJSON typed value.
> Expected a VALUE_NUMBER_INT but received a token of type VALUE_STRING
>
>
> Solution is to remove $ string token from key
> sed -i 's/\$key/key/g' <file>
>
>
> Once I do the above, Drill can now query it.  I have no control over
> source.  I have TBs of this streaming NDJSON I'd love to sort through with
> Drill.  I can do this if I can solve this.  Please help.
>
> Thanks,
> John
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message