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

Anonymous — Thu, 18 Dec 2014 12:56:25 GMT

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

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

Anonymous — Fri, 19 Dec 2014 02:51:03 GMT

Hi,

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

Best regards
Sabrina

topic Re: Setting table property for hive table creation (transactional=true) in Talend Studio

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

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