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 Plain View
Drill >> mail # dev >> RC3 Vote: Third time's the charm?


+
Jacques Nadeau 2013-09-06, 20:11
+
Grant Ingersoll 2013-09-09, 14:28
+
Ted Dunning 2013-09-07, 17:00
+
Ted Dunning 2013-09-08, 04:37
+
Jacques Nadeau 2013-09-08, 05:14
+
Ted Dunning 2013-09-08, 05:43
+
Ted Dunning 2013-09-08, 06:04
+
Jacques Nadeau 2013-09-08, 17:03
+
Ted Dunning 2013-09-08, 20:17
+
Isabel Drost-Fromm 2013-09-09, 14:33
+
Jacques Nadeau 2013-09-09, 16:11
+
Jason Altekruse 2013-09-10, 02:57
+
Ted Dunning 2013-09-09, 18:07
+
Grant Ingersoll 2013-09-09, 18:37
+
Ashish 2013-09-09, 03:55
+
Ashish 2013-09-09, 06:21
+
Lisen Mu 2013-09-09, 04:19
+
Timothy Chen 2013-09-09, 05:30
+
Michael Hausenblas 2013-09-10, 13:57
+
Ted Dunning 2013-09-10, 15:58
+
Harri Kinnunen 2013-09-10, 16:48
+
Ted Dunning 2013-09-10, 17:38
Copy link to this message
-
Re: RC3 Vote: Third time's the charm?
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.
>
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