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

Announcements
Join us in Toronto Sept 9th 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