Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-04-19 11:19 AM

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 (?,?,?)
Labels (4)
Labels
260 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2016-04-20 03:37 AM
Author

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
260 Views
0 Likes
Anonymous
Not applicable
‎2016-04-20 03:58 AM
Author

i want to explicit table properties option while creating external table, refer below snap 
0683p000009MDty.png
260 Views
0 Likes
Anonymous
Not applicable
‎2016-04-20 05:08 AM
Author

Hi,
Are you able to  create external table in hive successfully? Are you using Talend Bigdata platform product 6.1?
Best regards
Sabrina
260 Views
0 Likes
Anonymous
Not applicable
‎2016-04-20 05:53 AM
Author

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