Four Stars

unable to create avro table with TBLPROPERTIES ('avro.schema.url'

Hi Experts,
i am unable to create avro table with TBLPROPERTIES option 
getting following error 
talend 6.1
Cloudera 5.5
tHiveCreateTable_1 Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: Put request failed : INSERT INTO "TABLE_PARAMS" ("PARAM_VALUE","TBL_ID","PARAM_KEY") VALUES (?,?,?)
4 REPLIES
Moderator

Re: unable to create avro table with TBLPROPERTIES ('avro.schema.url'

Hi,
Could you please give us your component parameter? The setting screenshot of tHiveCreateTable will be helpful for us to address your issue.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: unable to create avro table with TBLPROPERTIES ('avro.schema.url'

i want to explicit table properties option while creating external table, refer below snap 
Moderator

Re: unable to create avro table with TBLPROPERTIES ('avro.schema.url'

Hi,
Are you able to  create external table in hive successfully? Are you using Talend Bigdata platform product 6.1?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: unable to create avro table with TBLPROPERTIES ('avro.schema.url'

Yes in hive browser i can create table , but unable from talned.
version-Talend-Studio-20151214_1327-V6.1.1 Talend-Studio-20160126_1936