Not able run hive query, getting following error ( Error while processing statement: FAILED: Hive )

[Saurabh khanna]

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 

[Gian Merlino]

Hi Saurabh,

This might be a better question for the Hive community. The Druid/Hive storage handler code lives in that project.

Gian

--
You received this message because you are subscribed to the Google Groups "Druid User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-user+...@googlegroups.com.
To post to this group, send email to druid...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/e7a35329-ad08-486c-9d6e-9cc144ce1e26%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Slim Bouguerra]

Can you please post your question here 

https://community.hortonworks.com/index.html