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 >> Drill terminology issue: "schema"


Copy link to this message
-
Re: Drill terminology issue: "schema"
I am not sure now what the schema was set to when I ran that example.
Currently I am getting a different error when I set the schema to
json_click:

0: jdbc:drill:> use MFS.json_click;

+------------+------------+

|     ok     |  summary   |

+------------+------------+

| true       | Default schema changed to 'MFS.json_click' |

+------------+------------+

1 row selected (0.326 seconds)

0: jdbc:drill:>  select * from MFS.json_click.`mobile.json` limit 2;

+------------+------------+------------+------------+----------------+------------+

|  trans_id  | datestamp  | timestamp  | user_info  | marketing_info |
trans_info |

+------------+------------+------------+------------+----------------+------------+

| 0          | 07/31/2013 | 11:54:24   |
{"cust_id":31,"device":"IOS5","state":"ms"} |
{"camp_id":1,"searchwords":["no","kiss","ever"]} | {"prod_id":[6], |

| 1          | 06/12/2013 | 11:27:12   |
{"cust_id":0,"device":"IOS5","state":"wa"} |
{"camp_id":3,"searchwords":["you"]} | {"prod_id":[93],"purch_flag": |

+------------+------------+------------+------------+----------------+------------+

2 rows selected (0.439 seconds)

0: jdbc:drill:> create table mobile as select * from
MFS.json_click.`mobile.json` limit 2;

+------------+------------+

|     ok     |  summary   |

+------------+------------+

| false      | Table 'mobile' already exists. |

+------------+------------+

1 row selected (0.144 seconds)

0: jdbc:drill:> create table mobile2 as select * from
MFS.json_click.`mobile.json` limit 2;

Query failed: Screen received stop request sent. null
[72d50e2d-2072-428a-96f4-e7b1debdc2a2]
Error: exception while executing query: Failure while trying to get next
result batch. (state=,code=0)
On Mon, Aug 11, 2014 at 11:49 AM, Steven Phillips <[EMAIL PROTECTED]>
wrote:
 
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