Member since
07-21-2016
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5183 | 07-25-2016 07:18 AM |
07-25-2016
07:18 AM
Thanks MJ, will definitely try that and let you know.
... View more
07-22-2016
01:30 PM
Sorry didnt answer all your questions: The complete error is this: AnalysisException: Syntax error in line 1: ... id BIGINT, name STRING ) DISTRIBUTE BY HASH (id) INTO... ^ Encountered: IDENTIFIER Expected: CACHED, COMMENT, LOCATION, PARTITIONED, PRODUCED, ROW, STORED, TBLPROPERTIES, UNCACHED, WITH CAUSED BY: Exception: Syntax error
... View more
07-22-2016
07:05 AM
Yes, I did do that with the same error message.
... View more
07-21-2016
02:29 PM
I have impala running on a Linux box (Version 2.7) and Kudu is the storage manager. I am attempting to create a table via the docs in this fashion: CREATE TABLE my_first_table ( id BIGINT, name STRING ) DISTRIBUTE BY HASH (id) INTO 16 BUCKETS TBLPROPERTIES( 'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler', 'kudu.table_name' = 'my_first_table', 'kudu.master_addresses' = 'kudu-master.example.com:7051', 'kudu.key_columns' = 'id' ); However, the "DISTRIBUTE BY HASH(id)" causes an invalid syntax near "DISTRIBUTE BY". This create table statement is coming directly from the docs (http://kudu.apache.org/docs/kudu_impala_integration.html#kudu_impala_insert_bulk). Any idea what I am doing wrong? I did notice that "partition by" works, but not the distribute clause.
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala
-
Apache Kudu