Hello    I am suspecting that either of below are enabled in impala as these only generate audit logs. Enable Audit Collection Enable Impala Audit Event Generation   To be able to disable auditing for Impala service, you need to uncheck both of the above options. Once done make sure to restart Impala service. CM would show stale and restart icon as well.   ... View more

Hello Kais   From the error attached above I obsereved some issue with the file place under this directory[2][1], could you please confirm if this directory only contains files and not directories inside.   Pleas try with new location and place the corresponding file inside it.     [1] hdfs://quickstart.cloudera:8020/user/hive/warehouse/categories:25:24',   [2] Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\xc3\xd7\x97\xd3coB\xa1\x90P\x9e\xab\x82\xa4\xf4A', guid='\x80\xa1\x93\xe2\x10\xefJ\xd9\xa3\xa3\xdb\x1f\x95\x85\x88\xb3')), orientation=4, maxRows=100): TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='java.io.IOException: java.io.IOException: Not a file: hdfs://quickstart.cloudera:8020/user/hive/warehouse/categories', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:java.io.IOException: java.io.IOException: Not a file: hdfs://quickstart.cloudera:8020/user/hive/warehouse/categories:25:24', 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:463',   Thanks  Manpreet Singh ... View more

Hello Rahul   Our Hive documentation [1] states currently "Hive in CDH does not support transactions (HIVE-5317)", so you can't use the Insert ,Update and Delete statements in Hive.   Based on the requirements you may want to consider using Kudu storage through Impala [2]   Please let me know if you have any more questions or concerns. [1] https://www.cloudera.com/documentation/enterprise/5-14-x/topics/hive_ingesting_and_querying_data.html#hive_transaction_support [2] https://www.cloudera.com/documentation/enterprise/5-14-x/topics/kudu_impala.html   Thanks Manpreet Singh ... View more