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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Setting table property for hive table creation (transactional=true)

Hi,
I am trying to create table in hive from talend i am getting the following error.
partitioning job CVPS_Data at 17:59 18/12/2014.
connecting to socket on port 4069
connected
Query returned non-zero code: 40000, cause: FAILED: ParseException line 1:39 cannot recognize input near ')' 'ROW' 'FORMAT' in column specification
Query returned non-zero code: 10001, cause: FAILED: SemanticException : Line 1:57 Table not found 'TBL_TRANSACTION_DETAILS'
disconnected
Job CVPS_Data ended at 18:00 18/12/2014.


I have specified in table properties "transactional=true".

My requirement is to create and update table in hive using talend.

Please help me.

With Regards 
Midhun 
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,

On which official version did you get that ? Could you please show us your job setting screenshot?

Best regards
Sabrina