Forum Discussion

williamy281's avatar
williamy281
Frequent Visitor
4 years ago

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:  

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]

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

    • williamy281's avatar
      williamy281
      Frequent Visitor
      4 years ago

      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.