HIVE Transactional Table Unable to Load

[williamy281]

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:  

set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

Is there an equivalent statement that can be used in Power Query ?

DataSource.Error: ODBC: ERROR [42000] [Microsoft][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: AnalysisException: Table lzpsds_raw.mbrshp_mm_anlytc_raw not supported. Transactional (ACID) tables are only supported when they are configured as insert_only.

Details:
DataSourceKind=ApacheHive
DataSourcePath=lzimpala-prod.kp.org:21050;lzpsds_raw;1
OdbcErrors=[Table]

[lbendlin]

run the same statement as part of your custom ODBC "SQL" query.

[williamy281]

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.