Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB