Member since
05-20-2021
2
Posts
0
Kudos Received
0
Solutions
07-11-2021
10:16 PM
@GangWar Thanks for your reply; Actually i am trying to query on Hive table; and I have followed the these steps; https://docs.cloudera.com/cdsw/1.9.1/import-data/topics/cdsw-accessing-data-from-apache-hive.html I am able to establish the connection and executed 'show tables;' -- it works fine as expected. The real problem comes only when i try to run select query on hive table. It is showing the above error which i mentioned early.
... View more
07-06-2021
04:39 AM
Hi Team, I am trying to connect the hive table from CDSW data science workbench using python. i am able to connect the hive from python using impala, when i try to execute the query i am getting below error, SemanticException [Error 10265]: This command is not allowed on an ACID table default.atlastest with a non-ACID transaction manager. Failed command: SELECT * FROM `default`.`table_name`'), operationHandle=None) PFB code ref: import os import pandas from impala.dbapi import connect from impala.util import as_pandas # Specify HIVE_HS2_HOST host name as an environment variable in your project settings HIVE_HS2_HOST='1.1.1.1' # This connection string depends on your cluster setup and authentication mechanism conn = connect(host=HIVE_HS2_HOST, port=10000, user = 'username', password = 'password', auth_mechanism='PLAIN', kerberos_service_name='hive') cursor = conn.cursor() res = cursor.execute('SELECT * FROM `default`.`table_name`') Kindly help me to close this issue
... View more