Getting table list is not working while creating dataset and in SQL Lab, got following error: There was an error loading the tables

How to reproduce the bug

  1. Go to 'Datasets'
  2. Click on '+ Dataset'
  3. Choose impala datasource
  4. Choose schema

  5. See error: There was an error loading the tables

  6. Go to 'SQL' -> 'SQL Lab'

  7. Choose impala datasource
  8. Choose schema
  9. See error: There was an error loading the tables

Expected results

List of tables are seen in at SEE TABLE SCHEMA field

Actual results

Nothing happens and error message appear at UI

Screenshots

Screenshot_7

Environment

  • browser type and version: Google-Chrome 108.0.5359.72
  • superset version: 2.1.0
  • python version: Python 3.8.12
  • impyla version: 0.18.0
  • thrift version: 0.16.0
  • any feature flags active:
"DASHBOARD_RBAC": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"DASHBOARD_NATIVE_FILTERS": True,
"DASHBOARD_CROSS_FILTERS": True,
"ALERT_REPORTS": True,
"THUMBNAILS": True,
"ENABLE_TEMPLATE_PROCESSING": True,

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • [x] I have reproduced the issue with at least the latest released version of superset.
  • [x] I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Here is logs that I found, but it contains no error:

xxx.xxx.xxx.xxx - - [27/Apr/2023:15:32:36 +0000] "GET /api/v1/me/ HTTP/1.1" 200 242 "https://superset-host:8888/superset/sqllab/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"
xxx.xxx.xxx.xxx - - [27/Apr/2023:15:32:36 +0000] "GET /api/v1/me/ HTTP/1.1" 200 242 "https://superset-host:8888/superset/sqllab/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"
2023-04-27 15:32:39,110:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some-host:21050 with PLAIN authentication mechanism
2023-04-27 15:32:39,112:DEBUG:impala._thrift_api:get_socket: host=some-host port=21050 use_ssl=True ca_cert=/certs/ca.crt
2023-04-27 15:32:39,113:DEBUG:impala.hiveserver2:sock=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faec1eef490>
2023-04-27 15:32:39,114:DEBUG:impala._thrift_api:get_transport: socket=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faec1eef490> host=some-host kerberos_service_name=impala auth_mechanism=PLAIN user=some-user password=fuggetaboutit

2023-04-27 15:32:39,233:DEBUG:impala.hiveserver2:transport=<thrift_sasl.TSaslClientTransport object at 0x7faec1eefdc0> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7faec1eef1f0> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faec1eef4c0>
2023-04-27 15:32:39,233:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7faec1eefac0>, default_db=some_schema)
2023-04-27 15:32:39,233:DEBUG:impala.hiveserver2:Closing HS2 connection
2023-04-27 15:32:39,233:DEBUG:impala.hiveserver2:close_service: client=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faec1eef4c0>
2023-04-27 15:32:39,235:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some-host:21050 with PLAIN authentication mechanism
2023-04-27 15:32:39,236:DEBUG:impala._thrift_api:get_socket: host=some-host port=21050 use_ssl=True ca_cert=/certs/ca.crt
2023-04-27 15:32:39,236:DEBUG:impala.hiveserver2:sock=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faec1eef610>
2023-04-27 15:32:39,237:DEBUG:impala._thrift_api:get_transport: socket=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faec1eef610> host=some-host kerberos_service_name=impala auth_mechanism=PLAIN user=some-user password=fuggetaboutit

2023-04-27 15:32:39,343:DEBUG:impala.hiveserver2:transport=<thrift_sasl.TSaslClientTransport object at 0x7faec1eef820> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7faec1eef1c0> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faec1eefee0>
2023-04-27 15:32:39,344:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7faec1eef5e0>, default_db=some_schema)
2023-04-27 15:32:39,344:DEBUG:impala.hiveserver2:Getting a cursor (Impala session)
2023-04-27 15:32:39,350:DEBUG:impala.hiveserver2:.cursor(): getting new session_handle
2023-04-27 15:32:39,350:DEBUG:impala.hiveserver2:OpenSession: req=TOpenSessionReq(client_protocol=5, username='superset', password=None, configuration={})
2023-04-27 15:32:39,350:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,350:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:OpenSession: resp=TOpenSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), serverProtocolVersion=5, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xe1\xd1\x9c\x1b\xbcHB\xd8\xa4\x16u<\x7fNxT', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c')), configuration={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BROADCAST_BYTES_LIMIT': '34359738368', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_FILE_FORMAT': 'PARQUET', 'DEFAULT_HINTS_INSERT_STATEMENT': 'NOCLUSTERED', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'SHUFFLE', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DEFAULT_TRANSACTIONAL_TYPE': 'NONE', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_DATA_CACHE': '0', 'DISABLE_HBASE_NUM_ROWS_ESTIMATE': '0', 'DISABLE_HDFS_NUM_ROWS_ESTIMATE': '0', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLED_RUNTIME_FILTER_TYPES': 'ALL', 'ENABLE_CNF_REWRITES': '1', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'FETCH_ROWS_TIMEOUT_MS': '0', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'KUDU_REPLICA_SELECTION': 'CLOSEST_REPLICA', 'KUDU_SNAPSHOT_READ_TIMESTAMP_MICROS': '0', 'MAX_CNF_EXPRS': '1000', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_RESULT_SPOOLING_MEM': '104857600', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MAX_SPILLED_RESULT_SPOOLING_MEM': '1073741824', 'MAX_STATEMENT_LENGTH_BYTES': '16777216', 'MEM_LIMIT': '0', 'MEM_LIMIT_EXECUTORS': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NOW_STRING': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'OPTIMIZE_SIMPLE_LIMIT': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_OBJECT_STORE_SPLIT_SIZE': '268435456', 'PARQUET_PAGE_ROW_COUNT_LIMIT': '', 'PARQUET_READ_PAGE_INDEX': '1', 'PARQUET_READ_STATISTICS': '1', 'PARQUET_TIMESTAMP_TYPE': 'INT96_NANOS', 'PARQUET_WRITE_PAGE_INDEX': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREAGG_BYTES_LIMIT': '-1', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REFRESH_UPDATED_HMS_PARTITIONS': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'SPOOL_QUERY_RESULTS': '0', 'STATEMENT_EXPRESSION_LIMIT': '250000', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some-host:25000'})
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:HiveServer2Cursor(service=<impala.hiveserver2.HS2Service object at 0x7faec1eef5e0>, session_handle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xe1\xd1\x9c\x1b\xbcHB\xd8\xa4\x16u<\x7fNxT', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c')), default_config={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BROADCAST_BYTES_LIMIT': '34359738368', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_FILE_FORMAT': 'PARQUET', 'DEFAULT_HINTS_INSERT_STATEMENT': 'NOCLUSTERED', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'SHUFFLE', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DEFAULT_TRANSACTIONAL_TYPE': 'NONE', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_DATA_CACHE': '0', 'DISABLE_HBASE_NUM_ROWS_ESTIMATE': '0', 'DISABLE_HDFS_NUM_ROWS_ESTIMATE': '0', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLED_RUNTIME_FILTER_TYPES': 'ALL', 'ENABLE_CNF_REWRITES': '1', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'FETCH_ROWS_TIMEOUT_MS': '0', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'KUDU_REPLICA_SELECTION': 'CLOSEST_REPLICA', 'KUDU_SNAPSHOT_READ_TIMESTAMP_MICROS': '0', 'MAX_CNF_EXPRS': '1000', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_RESULT_SPOOLING_MEM': '104857600', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MAX_SPILLED_RESULT_SPOOLING_MEM': '1073741824', 'MAX_STATEMENT_LENGTH_BYTES': '16777216', 'MEM_LIMIT': '0', 'MEM_LIMIT_EXECUTORS': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NOW_STRING': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'OPTIMIZE_SIMPLE_LIMIT': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_OBJECT_STORE_SPLIT_SIZE': '268435456', 'PARQUET_PAGE_ROW_COUNT_LIMIT': '', 'PARQUET_READ_PAGE_INDEX': '1', 'PARQUET_READ_STATISTICS': '1', 'PARQUET_TIMESTAMP_TYPE': 'INT96_NANOS', 'PARQUET_WRITE_PAGE_INDEX': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREAGG_BYTES_LIMIT': '-1', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REFRESH_UPDATED_HMS_PARTITIONS': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'SPOOL_QUERY_RESULTS': '0', 'STATEMENT_EXPRESSION_LIMIT': '250000', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some-host:25000'}, hs2_protocol_version=5)
2023-04-27 15:32:39,353:INFO:impala.hiveserver2:Using database some_schema as default
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:Executing query USE some_schema
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xe1\xd1\x9c\x1b\xbcHB\xd8\xa4\x16u<\x7fNxT', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c')), statement='USE some_schema', confOverlay=None, runAsync=True)
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,353:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,495:DEBUG:impala.hiveserver2:ExecuteStatement: resp=TExecuteStatementResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\xd3\\\xdb\xe1N(C\x87\x00\x00\x00\x00\xf0\xe2\x11\xfa', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=False, modifiedRowCount=None))
2023-04-27 15:32:39,495:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'\xd3\\\xdb\xe1N(C\x87\x00\x00\x00\x00\xf0\xe2\x11\xfa', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=False, modifiedRowCount=None)
2023-04-27 15:32:39,495:DEBUG:impala.hiveserver2:Waiting for query to finish
2023-04-27 15:32:39,495:DEBUG:impala.hiveserver2:GetOperationStatus: req=TGetOperationStatusReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\xd3\\\xdb\xe1N(C\x87\x00\x00\x00\x00\xf0\xe2\x11\xfa', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=False, modifiedRowCount=None))
2023-04-27 15:32:39,496:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,496:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:GetOperationStatus: resp=TGetOperationStatusResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationState=2, sqlState=None, errorCode=None, errorMessage=None, hasResultSet=None)
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:_wait_to_finish: waited 0.0024073123931884766 seconds so far
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:Query finished
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:Executing query SHOW TABLES IN `some_schema`
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'\xd3\\\xdb\xe1N(C\x87\x00\x00\x00\x00\xf0\xe2\x11\xfa', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=False, modifiedRowCount=None)
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:CloseOperation: req=TCloseOperationReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\xd3\\\xdb\xe1N(C\x87\x00\x00\x00\x00\xf0\xe2\x11\xfa', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=False, modifiedRowCount=None))
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,498:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,501:DEBUG:impala.hiveserver2:CloseOperation: resp=TCloseOperationResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None))
2023-04-27 15:32:39,501:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None
2023-04-27 15:32:39,502:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xe1\xd1\x9c\x1b\xbcHB\xd8\xa4\x16u<\x7fNxT', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c')), statement='SHOW TABLES IN `some_schema`', confOverlay=None, runAsync=True)
2023-04-27 15:32:39,502:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,502:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:ExecuteStatement: resp=TExecuteStatementResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None))
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None)
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:Waiting for query to finish
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:GetOperationStatus: req=TGetOperationStatusReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None))
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,691:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,693:DEBUG:impala.hiveserver2:GetOperationStatus: resp=TGetOperationStatusResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationState=2, sqlState=None, errorCode=None, errorMessage=None, hasResultSet=None)
2023-04-27 15:32:39,693:DEBUG:impala.hiveserver2:_wait_to_finish: waited 0.002398252487182617 seconds so far
2023-04-27 15:32:39,694:DEBUG:impala.hiveserver2:Query finished
2023-04-27 15:32:39,694:DEBUG:impala.hiveserver2:description=None has_result_set=True => getting schema
2023-04-27 15:32:39,694:DEBUG:impala.hiveserver2:GetResultSetMetadata: req=TGetResultSetMetadataReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None))
2023-04-27 15:32:39,694:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,694:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,696:DEBUG:impala.hiveserver2:GetResultSetMetadata: resp=TGetResultSetMetadataResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), schema=TTableSchema(columns=[TColumnDesc(columnName='name', typeDesc=TTypeDesc(types=[TTypeEntry(primitiveEntry=TPrimitiveTypeEntry(type=7, typeQualifiers=None), arrayEntry=None, mapEntry=None, structEntry=None, unionEntry=None, userDefinedTypeEntry=None)]), position=0, comment=None)]))
2023-04-27 15:32:39,696:DEBUG:impala.hiveserver2:get_result_schema: schema=[('name', 'STRING', None, None, None, None, None)]
2023-04-27 15:32:39,697:DEBUG:impala.hiveserver2:Fetching all result rows
2023-04-27 15:32:39,697:DEBUG:impala.hiveserver2:_ensure_buffer_is_filled: buffer empty and op is active => fetching more data
2023-04-27 15:32:39,697:DEBUG:impala.hiveserver2:FetchResults: req=TFetchResultsReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None), orientation=0, maxRows=10240, fetchType=0)
2023-04-27 15:32:39,697:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,697:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,711:DEBUG:impala.hiveserver2:FetchResults: resp=TFetchResultsResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), hasMoreRows=False, results=TRowSet(startRowOffset=0, rows=[], columns=[TColumn(boolVal=None, byteVal=None, i16Val=None, i32Val=None, i64Val=None, doubleVal=None, stringVal=TStringColumn(values=[b'table1', ..., b'tableN'], nulls=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'), binaryVal=None)]))
2023-04-27 15:32:39,717:DEBUG:impala.hiveserver2:fetch_results: constructing CBatch
2023-04-27 15:32:39,717:DEBUG:impala.hiveserver2:CBatch: input TRowSet num_cols=1 num_rows=7269 tcols=[TStringColumn(values=[b'tableN', ..., b'tableN+K'], nulls=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00')]
2023-04-27 15:32:39,724:DEBUG:impala.hiveserver2:pop_from_buffer: popping row out of buffer
2023-04-27 15:32:39,731:DEBUG:impala.hiveserver2:_ensure_buffer_is_filled: buffer empty and op is active => fetching more data
2023-04-27 15:32:39,731:DEBUG:impala.hiveserver2:FetchResults: req=TFetchResultsReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None), orientation=0, maxRows=10240, fetchType=0)
2023-04-27 15:32:39,731:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,731:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,733:DEBUG:impala.hiveserver2:FetchResults: resp=TFetchResultsResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), hasMoreRows=False, results=TRowSet(startRowOffset=7269, rows=[], columns=[TColumn(boolVal=None, byteVal=None, i16Val=None, i32Val=None, i64Val=None, doubleVal=None, stringVal=TStringColumn(values=[], nulls=b''), binaryVal=None)]))
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:fetch_results: constructing CBatch
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:CBatch: input TRowSet num_cols=1 num_rows=0 tcols=[TStringColumn(values=[], nulls=b'')]
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:_ensure_buffer_is_filled: no more data to fetch
2023-04-27 15:32:39,734:INFO:impala.hiveserver2:Closing active operation
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:CloseOperation: req=TCloseOperationReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'_\x8d0\xee\xff\x99@r\x00\x00\x00\x00U\xdf\x99\xa1', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c'), operationType=0, hasResultSet=True, modifiedRowCount=None))
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,734:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,738:DEBUG:impala.hiveserver2:CloseOperation: resp=TCloseOperationResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None))
2023-04-27 15:32:39,738:DEBUG:impala.hiveserver2:Closing HiveServer2Cursor
2023-04-27 15:32:39,738:DEBUG:impala.hiveserver2:CloseSession: req=TCloseSessionReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xe1\xd1\x9c\x1b\xbcHB\xd8\xa4\x16u<\x7fNxT', secret=b'\xaf+\x83\x8e\xbc\xa5F\xed\xab\xe3%\xf4\xf7I!c')))
2023-04-27 15:32:39,738:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3)
2023-04-27 15:32:39,739:DEBUG:impala.hiveserver2:Transport opened
2023-04-27 15:32:39,741:DEBUG:impala.hiveserver2:CloseSession: resp=TCloseSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None))
2023-04-27 15:32:39,747:DEBUG:impala.hiveserver2:Closing HS2 connection
2023-04-27 15:32:39,748:DEBUG:impala.hiveserver2:close_service: client=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faec1eefee0>
2023-04-27 15:32:39,777:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some-host:21050 with PLAIN authentication mechanism
2023-04-27 15:32:39,777:DEBUG:impala._thrift_api:get_socket: host=some-host port=21050 use_ssl=True ca_cert=/certs/ca.crt
2023-04-27 15:32:39,778:DEBUG:impala.hiveserver2:sock=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faedc480400>
2023-04-27 15:32:39,778:DEBUG:impala._thrift_api:get_transport: socket=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faedc480400> host=some-host kerberos_service_name=impala auth_mechanism=PLAIN user=some-user password=fuggetaboutit

2023-04-27 15:32:39,874:DEBUG:impala.hiveserver2:transport=<thrift_sasl.TSaslClientTransport object at 0x7faedc480430> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7faedc480a60> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faedc480460>
2023-04-27 15:32:39,875:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7faedc480c10>, default_db=some_schema)
2023-04-27 15:32:39,875:DEBUG:impala.hiveserver2:Closing HS2 connection
2023-04-27 15:32:39,876:DEBUG:impala.hiveserver2:close_service: client=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faedc480460>
2023-04-27 15:32:39,878:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some-host:21050 with PLAIN authentication mechanism
2023-04-27 15:32:39,878:DEBUG:impala._thrift_api:get_socket: host=some-host port=21050 use_ssl=True ca_cert=/certs/ca.crt
2023-04-27 15:32:39,879:DEBUG:impala.hiveserver2:sock=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faedc480a00>
2023-04-27 15:32:39,879:DEBUG:impala._thrift_api:get_transport: socket=<impala._thrift_api.get_socket.<locals>.ImpalaTSSLSocket object at 0x7faedc480a00> host=some-host kerberos_service_name=impala auth_mechanism=PLAIN user=some-user password=fuggetaboutit

2023-04-27 15:32:39,980:DEBUG:impala.hiveserver2:transport=<thrift_sasl.TSaslClientTransport object at 0x7faedc480e80> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7faedc480af0> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faedc4806a0>
2023-04-27 15:32:39,980:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7faedc480e50>, default_db=some_schema)
2023-04-27 15:32:39,980:DEBUG:impala.hiveserver2:Closing HS2 connection
2023-04-27 15:32:39,980:DEBUG:impala.hiveserver2:close_service: client=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7faedc4806a0>
xxx.xxx.xxx.xxx - - [27/Apr/2023:15:32:39 +0000] "GET /api/v1/database/19/tables/?q=(force:!t,schema_name:some_schema) HTTP/1.1" 422 76 "https://superset-host:8888/superset/sqllab/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"

Also I tested when schema has about 40 tables and 0 tables with same result

Comment From: nferrario

Same here!

Comment From: linxt20

I meet the same problem

Comment From: giuturtu

Same here!

Comment From: raulbla

I can confirm we have the same issue. Instead the query from sql tab is working fine

Comment From: 0xfcryowbk2ca65z

Same here!

Comment From: MarioDurantez

I met a similar problem with an Athena datasource. I found that superset 2.1.0 uses SQLAlchemy's get_view_names() here. The pyAthena version suggested in the docs did not implement this call, and the NotImplementedError was being caught and supressed by superset code.

I solved by upgrading pyAthena to >=2.0.0, which already implements get_view_names(). Unfortunately, the most recent Impala driver for sqlAlchemy does not implement this call, only get_table_names().

Currently the only solution seems to be downgrading Superset to 2.0.1.

Comment From: huw0

Thanks @MarioDurantez for this pointer.

I've raised a PR which stubs this method - cloudera/impyla#511. For now, I'm manually patching this file as part of our Docker build pipeline.

Comment From: chathawee

@huw0 Could you please provide the solution. I have tried to add this fuction to superset/db_engine_specs/impala.py but it didn't work. Please suggest.

Comment From: VitaliyFedorov

@huw0 Could you please provide the solution. I have tried to add this fuction to superset/db_engine_specs/impala.py but it didn't work. Please suggest.

I've just build impyla with his PR and install it via pip in superset dockerfile. @huw0 patch impyla code, not superset

Comment From: rusackas

Is this still an issue people are facing in Superset 3.x?

Comment From: pyroman30

Same here!

Comment From: rusackas

@pyroman30 which version of Superset are you using, and which version of the Impala driver? If "same here" means you're using the old versions, as reported in the initial report, then you need to update both pieces of software.

Comment From: pyroman30

@rusackas I'm using helm chart version 2.0.1 and impyla version 0.18.0. I can't figure out how to view the impala driver version?

Comment From: dkrat7

@pyroman30 get_view_name support was added in impyla==0.19.0. You should try with that version.

Comment From: pyroman30

@dkrat7 thanks for the answer, unfortunately it didn't work

Comment From: pyroman30

2024-04-04 06:57:22,363:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some_host:21050 with GSSAPI authentication mechanism 2024-04-04 06:57:22,363:DEBUG:impala._thrift_api:get_socket: host=some_host port=21050 use_ssl=False ca_cert=None 2024-04-04 06:57:22,363:DEBUG:impala.hiveserver2:sock= 2024-04-04 06:57:22,364:DEBUG:impala._thrift_api:get_transport: socket= host=some_host kerberos_service_name=impala auth_mechanism=GSSAPI user=None password=fuggetaboutit 2024-04-04 06:57:22,454:DEBUG:impala.hiveserver2:transport= protocol= service= 2024-04-04 06:57:22,454:DEBUG:impala.hiveserver2:HiveServer2Connection(service=, default_db=p_datalake) 2024-04-04 06:57:22,455:DEBUG:impala.hiveserver2:Closing HS2 connection 2024-04-04 06:57:22,455:DEBUG:impala.hiveserver2:close_service: client= 2024-04-04 06:57:22,456:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some_host:21050 with GSSAPI authentication mechanism 2024-04-04 06:57:22,456:DEBUG:impala._thrift_api:get_socket: host=some_host port=21050 use_ssl=False ca_cert=None 2024-04-04 06:57:22,456:DEBUG:impala.hiveserver2:sock= 2024-04-04 06:57:22,456:DEBUG:impala._thrift_api:get_transport: socket= host=some_host kerberos_service_name=impala auth_mechanism=GSSAPI user=None password=fuggetaboutit 2024-04-04 06:57:22,517:DEBUG:impala.hiveserver2:transport= protocol= service= 2024-04-04 06:57:22,517:DEBUG:impala.hiveserver2:HiveServer2Connection(service=, default_db=p_datalake) 2024-04-04 06:57:22,517:DEBUG:impala.hiveserver2:Getting a cursor (Impala session) 2024-04-04 06:57:22,518:DEBUG:impala.hiveserver2:.cursor(): getting new session_handle 2024-04-04 06:57:22,518:DEBUG:impala.hiveserver2:OpenSession: req=TOpenSessionReq(client_protocol=5, username='root', password=None, configuration={}) 2024-04-04 06:57:22,518:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:57:22,519:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:57:22,521:DEBUG:impala.hiveserver2:OpenSession: resp=TOpenSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), serverProtocolVersion=5, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xa7\xd8\x8f\x00w+B\x0c\x91\xf2\xc9\xa8\xde\xfcS\xd1', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"')), configuration={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_HINTS_INSERT_STATEMENT': '', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'BROADCAST', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MEM_LIMIT': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_READ_STATISTICS': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some_host:25000'}) 2024-04-04 06:57:22,521:DEBUG:impala.hiveserver2:HiveServer2Cursor(service=, session_handle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xa7\xd8\x8f\x00w+B\x0c\x91\xf2\xc9\xa8\xde\xfcS\xd1', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"')), default_config={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_HINTS_INSERT_STATEMENT': '', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'BROADCAST', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MEM_LIMIT': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_READ_STATISTICS': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some_host:25000'}, hs2_protocol_version=5) 2024-04-04 06:57:22,522:INFO:impala.hiveserver2:Using database p_datalake as default 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:Executing query USE p_datalake 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xa7\xd8\x8f\x00w+B\x0c\x91\xf2\xc9\xa8\xde\xfcS\xd1', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"')), statement='USE p_datalake', confOverlay=None, runAsync=True) 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:57:22,525:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:57:22,561:DEBUG:impala.hiveserver2:ExecuteStatement: resp=TExecuteStatementResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'O\xef\x89Q\x9f\xd8Ct\x00\x00\x00\x00\xd6\x8b\xa1\xb3', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:57:22,561:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'O\xef\x89Q\x9f\xd8Ct\x00\x00\x00\x00\xd6\x8b\xa1\xb3', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"'), operationType=0, hasResultSet=False, modifiedRowCount=None) 2024-04-04 06:57:22,561:DEBUG:impala.hiveserver2:Waiting for query to finish 2024-04-04 06:57:22,561:DEBUG:impala.hiveserver2:GetOperationStatus: req=TGetOperationStatusReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'O\xef\x89Q\x9f\xd8Ct\x00\x00\x00\x00\xd6\x8b\xa1\xb3', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:57:22,562:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:57:22,562:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:57:22,563:DEBUG:impala.hiveserver2:GetOperationStatus: resp=TGetOperationStatusResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationState=2, sqlState=None, errorCode=None, errorMessage=None, hasResultSet=None) 2024-04-04 06:57:22,563:DEBUG:impala.hiveserver2:_wait_to_finish: waited 0.0019729137420654297 seconds so far 2024-04-04 06:57:22,564:DEBUG:impala.hiveserver2:Query finished 2024-04-04 06:57:22,564:DEBUG:impala.hiveserver2:Executing query SHOW SCHEMAS 2024-04-04 06:57:22,564:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'O\xef\x89Q\x9f\xd8Ct\x00\x00\x00\x00\xd6\x8b\xa1\xb3', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"'), operationType=0, hasResultSet=False, modifiedRowCount=None) 2024-04-04 06:57:22,565:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state 2024-04-04 06:57:22,565:DEBUG:impala.hiveserver2:CloseOperation: req=TCloseOperationReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'O\xef\x89Q\x9f\xd8Ct\x00\x00\x00\x00\xd6\x8b\xa1\xb3', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:57:22,565:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:57:22,565:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:57:22,567:DEBUG:impala.hiveserver2:CloseOperation: resp=TCloseOperationResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None)) 2024-04-04 06:57:22,567:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:57:22,567:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\xa7\xd8\x8f\x00w+B\x0c\x91\xf2\xc9\xa8\xde\xfcS\xd1', secret=b'\x81\xfc\xa8"\xda@I\x8b\xa8\xa2a\xc4b\xcce"')), statement='SHOW SCHEMAS', confOverlay=None, runAsync=True) 2024-04-04 06:57:22,568:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:57:22,568:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:58:22,306:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some_host:21050 with GSSAPI authentication mechanism 2024-04-04 06:58:22,306:DEBUG:impala._thrift_api:get_socket: host=some_host port=21050 use_ssl=False ca_cert=None 2024-04-04 06:58:22,306:DEBUG:impala.hiveserver2:sock= 2024-04-04 06:58:22,306:DEBUG:impala._thrift_api:get_transport: socket= host=some_host kerberos_service_name=impala auth_mechanism=GSSAPI user=None password=fuggetaboutit 2024-04-04 06:58:22,431:DEBUG:impala.hiveserver2:transport= protocol= service= 2024-04-04 06:58:22,431:DEBUG:impala.hiveserver2:HiveServer2Connection(service=, default_db=p_datalake) 2024-04-04 06:58:22,432:DEBUG:impala.hiveserver2:Closing HS2 connection 2024-04-04 06:58:22,432:DEBUG:impala.hiveserver2:close_service: client= 2024-04-04 06:58:22,432:DEBUG:impala.hiveserver2:Connecting to HiveServer2 some_host:21050 with GSSAPI authentication mechanism 2024-04-04 06:58:22,432:DEBUG:impala._thrift_api:get_socket: host=some_host port=21050 use_ssl=False ca_cert=None 2024-04-04 06:58:22,432:DEBUG:impala.hiveserver2:sock= 2024-04-04 06:58:22,432:DEBUG:impala._thrift_api:get_transport: socket= host=some_host kerberos_service_name=impala auth_mechanism=GSSAPI user=None password=fuggetaboutit 2024-04-04 06:58:22,536:DEBUG:impala.hiveserver2:transport= protocol= service= 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:HiveServer2Connection(service=, default_db=p_datalake) 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:Getting a cursor (Impala session) 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:.cursor(): getting new session_handle 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:OpenSession: req=TOpenSessionReq(client_protocol=5, username='root', password=None, configuration={}) 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:58:22,539:DEBUG:impala.hiveserver2:OpenSession: resp=TOpenSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), serverProtocolVersion=5, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b"\x01c\xbd\x84'\xedG^\xb3\xf1y\x13V\xf1\xa6\x91", secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/')), configuration={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_HINTS_INSERT_STATEMENT': '', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'BROADCAST', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MEM_LIMIT': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_READ_STATISTICS': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some_host:25000'}) 2024-04-04 06:58:22,539:DEBUG:impala.hiveserver2:HiveServer2Cursor(service=, session_handle=TSessionHandle(sessionId=THandleIdentifier(guid=b"\x01c\xbd\x84'\xedG^\xb3\xf1y\x13V\xf1\xa6\x91", secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/')), default_config={'ABORT_ON_DEFAULT_LIMIT_EXCEEDED': '', 'ABORT_ON_ERROR': '0', 'ALLOW_ERASURE_CODED_FILES': '0', 'ALLOW_UNSUPPORTED_FORMATS': '', 'APPX_COUNT_DISTINCT': '0', 'BATCH_SIZE': '0', 'BUFFER_POOL_LIMIT': '', 'CLIENT_IDENTIFIER': '', 'COMPRESSION_CODEC': '', 'COMPUTE_STATS_MIN_SAMPLE_SIZE': '1073741824', 'CPU_LIMIT_S': '0', 'DEBUG_ACTION': '', 'DECIMAL_V2': '1', 'DEFAULT_HINTS_INSERT_STATEMENT': '', 'DEFAULT_JOIN_DISTRIBUTION_MODE': 'BROADCAST', 'DEFAULT_ORDER_BY_LIMIT': '', 'DEFAULT_SPILLABLE_BUFFER_SIZE': '2097152', 'DISABLE_CACHED_READS': '', 'DISABLE_CODEGEN': '0', 'DISABLE_CODEGEN_ROWS_THRESHOLD': '50000', 'DISABLE_OUTERMOST_TOPN': '0', 'DISABLE_ROW_RUNTIME_FILTERING': '0', 'DISABLE_STREAMING_PREAGGREGATIONS': '0', 'DISABLE_UNSAFE_SPILLS': '0', 'ENABLE_EXPR_REWRITES': '1', 'EXEC_SINGLE_NODE_ROWS_THRESHOLD': '100', 'EXEC_TIME_LIMIT_S': '0', 'EXPLAIN_LEVEL': 'STANDARD', 'HBASE_CACHE_BLOCKS': '0', 'HBASE_CACHING': '0', 'IDLE_SESSION_TIMEOUT': '1800', 'KUDU_READ_MODE': 'DEFAULT', 'MAX_ERRORS': '100', 'MAX_IO_BUFFERS': '', 'MAX_MEM_ESTIMATE_FOR_ADMISSION': '0', 'MAX_NUM_RUNTIME_FILTERS': '10', 'MAX_ROW_SIZE': '524288', 'MAX_SCAN_RANGE_LENGTH': '0', 'MEM_LIMIT': '0', 'MIN_SPILLABLE_BUFFER_SIZE': '65536', 'MT_DOP': '', 'NUM_NODES': '0', 'NUM_REMOTE_EXECUTOR_CANDIDATES': '3', 'NUM_ROWS_PRODUCED_LIMIT': '0', 'NUM_SCANNER_THREADS': '0', 'OPTIMIZE_PARTITION_KEY_SCANS': '0', 'PARQUET_ANNOTATE_STRINGS_UTF8': '0', 'PARQUET_ARRAY_RESOLUTION': 'THREE_LEVEL', 'PARQUET_DICTIONARY_FILTERING': '1', 'PARQUET_FALLBACK_SCHEMA_RESOLUTION': 'POSITION', 'PARQUET_FILE_SIZE': '0', 'PARQUET_READ_STATISTICS': '1', 'PLANNER_TESTCASE_MODE': '0', 'PREFETCH_MODE': 'HT_BUCKET', 'QUERY_TIMEOUT_S': '0', 'REPLICA_PREFERENCE': 'CACHE_LOCAL', 'REQUEST_POOL': '', 'RESERVATION_REQUEST_TIMEOUT': '', 'RESOURCE_TRACE_RATIO': '0.000000', 'RM_INITIAL_MEM': '', 'RUNTIME_BLOOM_FILTER_SIZE': '1048576', 'RUNTIME_FILTER_MAX_SIZE': '16777216', 'RUNTIME_FILTER_MIN_SIZE': '1048576', 'RUNTIME_FILTER_MODE': 'GLOBAL', 'RUNTIME_FILTER_WAIT_TIME_MS': '0', 'S3_SKIP_INSERT_STAGING': '1', 'SCAN_BYTES_LIMIT': '0', 'SCAN_NODE_CODEGEN_THRESHOLD': '', 'SCHEDULE_RANDOM_REPLICA': '0', 'SCRATCH_LIMIT': '-1', 'SEQ_COMPRESSION_MODE': '', 'SHUFFLE_DISTINCT_EXPRS': '1', 'STRICT_MODE': '0', 'SYNC_DDL': '0', 'THREAD_RESERVATION_AGGREGATE_LIMIT': '0', 'THREAD_RESERVATION_LIMIT': '3000', 'TIMEZONE': '', 'TOPN_BYTES_LIMIT': '536870912', 'V_CPU_CORES': '', 'http_addr': 'some_host:25000'}, hs2_protocol_version=5) 2024-04-04 06:58:22,539:INFO:impala.hiveserver2:Using database p_datalake as default 2024-04-04 06:58:22,539:DEBUG:impala.hiveserver2:Executing query USE p_datalake 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b"\x01c\xbd\x84'\xedG^\xb3\xf1y\x13V\xf1\xa6\x91", secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/')), statement='USE p_datalake', confOverlay=None, runAsync=True) 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:58:22,540:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:58:22,575:DEBUG:impala.hiveserver2:ExecuteStatement: resp=TExecuteStatementResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\x08.\x1c\x0c\xfe\x1cEn\x00\x00\x00\x00\xa1\xbe%', secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:58:22,576:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'\x08.\x1c\x0c\xfe\x1cEn\x00\x00\x00\x00\xa1\xbe%', secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/'), operationType=0, hasResultSet=False, modifiedRowCount=None) 2024-04-04 06:58:22,576:DEBUG:impala.hiveserver2:Waiting for query to finish 2024-04-04 06:58:22,576:DEBUG:impala.hiveserver2:GetOperationStatus: req=TGetOperationStatusReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\x08.\x1c\x0c\xfe\x1cEn\x00\x00\x00\x00\xa1\xbe%', secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:58:22,576:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:58:22,576:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:58:22,578:DEBUG:impala.hiveserver2:GetOperationStatus: resp=TGetOperationStatusResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationState=2, sqlState=None, errorCode=None, errorMessage=None, hasResultSet=None) 2024-04-04 06:58:22,578:DEBUG:impala.hiveserver2:_wait_to_finish: waited 0.0021505355834960938 seconds so far 2024-04-04 06:58:22,578:DEBUG:impala.hiveserver2:Query finished 2024-04-04 06:58:22,578:DEBUG:impala.hiveserver2:Executing query SHOW SCHEMAS 2024-04-04 06:58:22,579:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=True self._last_operation=TOperationHandle(operationId=THandleIdentifier(guid=b'\x08.\x1c\x0c\xfe\x1cEn\x00\x00\x00\x00\xa1\xbe%', secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/'), operationType=0, hasResultSet=False, modifiedRowCount=None) 2024-04-04 06:58:22,579:DEBUG:impala.hiveserver2:_reset_state: Resetting cursor state 2024-04-04 06:58:22,579:DEBUG:impala.hiveserver2:CloseOperation: req=TCloseOperationReq(operationHandle=TOperationHandle(operationId=THandleIdentifier(guid=b'\x08.\x1c\x0c\xfe\x1cEn\x00\x00\x00\x00\xa1`\xbe%', secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/'), operationType=0, hasResultSet=False, modifiedRowCount=None)) 2024-04-04 06:58:22,579:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:58:22,579:DEBUG:impala.hiveserver2:Transport opened 2024-04-04 06:58:22,581:DEBUG:impala.hiveserver2:CloseOperation: resp=TCloseOperationResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None)) 2024-04-04 06:58:22,582:DEBUG:impala.hiveserver2:_execute_async: self._buffer=Batch() self._description=None self._last_operation_active=False self._last_operation=None 2024-04-04 06:58:22,582:DEBUG:impala.hiveserver2:ExecuteStatement: req=TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b"\x01c\xbd\x84'\xedG^\xb3\xf1y\x13V\xf1\xa6\x91", secret=b'\x1b\xeb\xec\xab\x15\x85B\xec\xa6\xd1x3\xcf\xb1w/')), statement='SHOW SCHEMAS', confOverlay=None, runAsync=True) 2024-04-04 06:58:22,582:DEBUG:impala.hiveserver2:Attempting to open transport (tries_left=3) 2024-04-04 06:58:22,582:DEBUG:impala.hiveserver2:Transport opened

Comment From: pyroman30

If I change the cache parameters, it helps for a while, then it doesn't work again Screenshot_1

Comment From: JasonHug

Upgrade impyla to 0.19.0 may solve the problem.

Comment From: rusackas

Anyone still facing this issue in 4.1.2/5.0.0? If not, we'll be closing it as inactive before long.

Comment From: rusackas

Closing as inactive/not-planned, but happy to revisit if it's still an issue in 5.0.0 with the correct impala driver. Happy to review PRs if relevant!