Forum Discussion
HIVE Transactional Table Unable to Load
After connecting to HIVE, the error below occurs. I suspected this would happen given the developers created the HIVE tables and when using HUE, I had to set this statement to retrieve the table: ...
run the same statement as part of your custom ODBC "SQL" query.
It produced another error. "ODBC: ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 1:set hive.txn.manager = org.apache.ha...
^ Encountered: . Expected: = CAUSED BY: Exception: Syntax error". Wondering if there is some way to set it in M language.