Support Questions
Find answers, ask questions, and share your expertise

cannot insert row hive druid table

New Contributor

i created external table like

 

"""create external table druid_table (`__time` timestamp, accountroot string, countryname string) stored by 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" = "test");"""   

 

and i want to insert only 1 row like

 

"""insert into table druid_table (`__time`, accountroot, countryname) values ('2019-12-01 00:00:00', "mert", "5");"""

 

but i am getting exception like this after map reduce process:

 

 ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Transaction failed do to exception being thrown from within the callback. See cause for the original exception.
INFO : Completed executing command(queryId=hive_20210405181637_bd708c83-c895-496a-8168-f08f8b3c58ef); Time taken: 21.826 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Transaction failed do to exception being thrown from within the callback. See cause for the original exception. (state=08S01,code=1)

 

Anyone help?

Thanks.

@Shelton 

0 REPLIES 0