There are more sample queries on the HOWTO doc.
On Tue, Sep 10, 2013 at 8:58 AM, 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. >
