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.