Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> RC3 Vote: Third time's the charm?


Copy link to this message
-
Re: RC3 Vote: Third time's the charm?
It's "!quit" to quit sqlline.

I'll update the Wiki How-To.

Cheers,
-Harri

On 10.9.2013, at 18.58, Ted Dunning <[EMAIL PROTECTED]> wrote:

> On Tue, Sep 10, 2013 at 6:57 AM, Michael Hausenblas <
> [EMAIL PROTECTED]> wrote:
>
>> * We should document how to exit sqlline—this one is rather annoying
>> (standard stuff like exit; or quit; or CTRL+C doesn't seem to work and
>> CTRL+D kills my terminal)
>>
>
> Ctrl-D works for me.
>
>
>> * A JSON example data file seems to be missing in sample-data/
>>
>
> I prefer to focus on the parquet files, but adding a JSON example file is
> probably good from the stand point of flexibility demo.
>
>
>> * I created a JSON doc in sample-data/ as seen in
>> https://github.com/vrtx/incubator-drill/blob/getting_started/docs/getting_started.rstand that resulted in:
>>
>
> The query needs a storage type.  Try:
>
> select _MAP['name'] from "jsonl"."sample-data/test-0.json";
>
>
>
>>
>> 0: jdbc:drill:schema=json> SELECT _MAP['name'], _MAP['age'] FROM
>> "sample-data/test-0.json";
>> Sep 10, 2013 2:48:30 PM org.eigenbase.sql.validate.SqlValidatorException
>> <init>
>> SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table
>> 'sample-data/test-0.json' not found
>> Sep 10, 2013 2:48:30 PM org.eigenbase.util.EigenbaseException <init>
>>
>> BTW, I'll give a live demo in two days time in Stockholm, see
>> http://www.meetup.com/stockholm-hug/events/129201812/ and will share the
>> slides, afterwards.
>>
>
> Record a talk track if you can.