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 
1 REPLY
Moderator

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

Hi,

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

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.