Home | About | Sematext search-lucene.com search-hadoop.com
 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: