I have created one dummy table in hive and then created druid table but now when I am running select query or show create table then I am getting following error.
Can someone please help me to solve it. I am using LLAP and HDP2.6.5.
CREATE TABLE druid_table3 STORED BY ‘org.apache.hadoop.hive.druid.DruidStorageHandler’ TBLPROPERTIES (“druid.segment.granularity” = “DAY”) AS select cast(timecolumn as timestamp) as __time, userid, num_l FROM test_table;
select * from druid_table3;
INFO : Compiling command(queryId=hive_20181016022847_a8225017-bc92-47ff-a6fc-56b95f43594c): select * from druid_table3
INFO : We are setting the hadoop caller context from HIVE_SSN_ID:2ea17791-940b-4dff-84b3-7645eec764f2 to hive_20181016022847_a8225017-bc92-47ff-a6fc-56b95f43594c
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:druid_table3.__time, type:timestamp, comment:null), FieldSchema(name:druid_table3.userid, type:string, comment:null), FieldSchema(name:druid_table3.num_l, type:float, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hive_20181016022847_a8225017-bc92-47ff-a6fc-56b95f43594c); Time taken: 0.207 seconds
INFO : We are resetting the hadoop caller context to HIVE_SSN_ID:2ea17791-940b-4dff-84b3-7645eec764f2
INFO : Setting caller context to query id hive_20181016022847_a8225017-bc92-47ff-a6fc-56b95f43594c
INFO : Executing command(queryId=hive_20181016022847_a8225017-bc92-47ff-a6fc-56b95f43594c): select * from druid_table3
ERROR : FAILED: Hive Internal Error: java.lang.NullPointerException(null)
java.lang.NullPointerException
at org.apache.hadoop.hive.druid.DruidStorageHandler.preAlterTable(DruidStorageHandler.java:673)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.alter_table_with_environmentContext(HiveMetaSto