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.