Member since
05-15-2017
5
Posts
0
Kudos Received
0
Solutions
09-13-2017
06:06 PM
Thank you! I've used hive1, not interactive) With interactive it works, thanks!
... View more
06-22-2017
08:14 PM
Hi @Slim! Thank you once again, but unfortunately no, I use beeline and hiveserver2
... View more
06-21-2017
08:06 PM
Hi @Slim!
Thank you for your reply 😉 First I try: CREATE EXTERNAL TABLE druid_table_1
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "wikiticker"); But no jar: 23:01:08 [CREATE - 0 rows, 0.023 secs] [Code: 40000, SQL State: 42000] Error while compiling statement: FAILED: SemanticException Cannot find class 'org.apache.hadoop.hive.druid.DruidStorageHandler'
Than I try to add driver: add jar hdfs://hdfscian/user/ptarasov/jars/hive-druid-handler.jar; Ok: INFO : converting to local hdfs://hdfscian/user/ptarasov/jars/hive-druid-handler.jar
INFO : Added [/tmp/e4328d39-3c33-47fd-bd08-c7b0a72dcf73_resources/hive-druid-handler.jar] to class path
INFO : Added resources: [hdfs://hdfscian/user/ptarasov/jars/hive-druid-handler.jar] And once again create external table, but no luck: Error: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/DefaultHiveMetaHook (state=,code=0)
... View more
05-15-2017
01:50 PM
Hi! I've installed HDP 2.6 and installed druid. Trying to create external table to a wikiticker datasource gives me an error: Error: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/DefaultHiveMetaHook (state=,code=0) I've added druid handler (lib/hive-druid-handler.jar) with "add jar" before. Tried to add hive metastore jar - it did not help. How to use this handler? Thank you!
... View more
Labels:
- Labels:
-
Apache Hive