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?
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.