Hi All,
I'm trying to create and external table using Thrift Server to which I'm
connected via Beeline. In order to do this I run the following Hive SQL
query, as described here:
https://cwiki.apache.org/confluence/display/Hive/Druid+Integration
CREATE EXTERNAL TABLE druid_table_1
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "test");
Doing it shows this error:
1: jdbc:hive2://localhost:10000> CREATE EXTERNAL TABLE druid_table_1
1: jdbc:hive2://localhost:10000> STORED BY
'org.apache.hadoop.hive.druid.DruidStorageHandler'
1: jdbc:hive2://localhost:10000> TBLPROPERTIES ("druid.datasource" =
"test");
Error: org.apache.spark.sql.catalyst.parser.ParseException:
Operation not allowed: STORED BY(line 2, pos 0)
== SQL ==
CREATE EXTERNAL TABLE druid_table_1
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
^^^
TBLPROPERTIES ("druid.datasource" = "test") (state=,code=0)
Googling this error results in this JIRA:
https://jira.mongodb.org/browse/HADOOP-301
I've tried all the solutions in the JIRA, but none of them worked.
Do you have any advice on how to solve this issue?
Thank you,
Val
