You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "VitaliyFedorov (via GitHub)" <gi...@apache.org> on 2023/04/27 16:02:27 UTC
[GitHub] [superset] VitaliyFedorov opened a new issue, #23850: There was an error loading the tables - for impala datasource
VitaliyFedorov opened a new issue, #23850:
URL: https://github.com/apache/superset/issues/23850
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`
1. Go to 'SQL' -> 'SQL Lab'
2. Choose impala datasource
3. Choose schema
4. 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
### 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', 'DE
FAULT_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': '5
24288', '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_C
ODEGEN': '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_REQU
EST_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\x
00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0
0\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\x
00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "pyroman30 (via GitHub)" <gi...@apache.org>.
pyroman30 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2036357225
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=<thrift.transport.TSocket.TSocket object at 0x7f46c4e4e790>
2024-04-04 06:57:22,364:DEBUG:impala._thrift_api:get_transport: socket=<thrift.transport.TSocket.TSocket object at 0x7f46c4e4e790> 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=<thrift_sasl.TSaslClientTransport object at 0x7f4615d06280> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7f46c4e57190> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f46c4e4eca0>
2024-04-04 06:57:22,454:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7f46c4de18e0>, 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=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f46c4e4eca0>
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=<thrift.transport.TSocket.TSocket object at 0x7f46c4e4e760>
2024-04-04 06:57:22,456:DEBUG:impala._thrift_api:get_transport: socket=<thrift.transport.TSocket.TSocket object at 0x7f46c4e4e760> 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=<thrift_sasl.TSaslClientTransport object at 0x7f46c4e4e8b0> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7f46c4e4e790> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f46c4de1940>
2024-04-04 06:57:22,517:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7f46c4de18e0>, 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_THRESH
OLD': '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_ST
ATISTICS': '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=<impala.hiveserver2.HS2Service object at 0x7f46c4de18e0>, 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_FILTER
ING': '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=<thrift.transport.TSocket.TSocket object at 0x7f4615de19a0>
2024-04-04 06:58:22,306:DEBUG:impala._thrift_api:get_transport: socket=<thrift.transport.TSocket.TSocket object at 0x7f4615de19a0> 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=<thrift_sasl.TSaslClientTransport object at 0x7f4615de1b20> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7f4615de1430> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f4615de1340>
2024-04-04 06:58:22,431:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7f4615de14c0>, 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=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f4615de1340>
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=<thrift.transport.TSocket.TSocket object at 0x7f4615de14c0>
2024-04-04 06:58:22,432:DEBUG:impala._thrift_api:get_transport: socket=<thrift.transport.TSocket.TSocket object at 0x7f4615de14c0> 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=<thrift_sasl.TSaslClientTransport object at 0x7f4615de1970> protocol=<thrift.protocol.TBinaryProtocol.TBinaryProtocolAccelerated object at 0x7f4615de1e20> service=<impala._thrift_gen.ImpalaService.ImpalaHiveServer2Service.Client object at 0x7f4615de1a00>
2024-04-04 06:58:22,537:DEBUG:impala.hiveserver2:HiveServer2Connection(service=<impala.hiveserver2.HS2Service object at 0x7f4615de1880>, 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_THRESH
OLD': '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_ST
ATISTICS': '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=<impala.hiveserver2.HS2Service object at 0x7f4615de1880>, 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_FILTER
ING': '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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] chathawee commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "chathawee (via GitHub)" <gi...@apache.org>.
chathawee commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1592603282
@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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "pyroman30 (via GitHub)" <gi...@apache.org>.
pyroman30 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2036283017
@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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] giuturtu commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "giuturtu (via GitHub)" <gi...@apache.org>.
giuturtu commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1549712295
Same here!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "pyroman30 (via GitHub)" <gi...@apache.org>.
pyroman30 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2035471869
Same here!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] huw0 commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "huw0 (via GitHub)" <gi...@apache.org>.
huw0 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1557469525
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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] 0xfcryowbk2ca65z commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "0xfcryowbk2ca65z (via GitHub)" <gi...@apache.org>.
0xfcryowbk2ca65z commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1554261827
Same here!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1942529253
Is this still an issue people are facing in Superset 3.x?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2035505110
@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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] nferrario commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "nferrario (via GitHub)" <gi...@apache.org>.
nferrario commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1527506922
Same here!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] linxt20 commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "linxt20 (via GitHub)" <gi...@apache.org>.
linxt20 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1528780769
I meet the same problem
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] MarioDurantez commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "MarioDurantez (via GitHub)" <gi...@apache.org>.
MarioDurantez commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1556779220
I met a similar problem with an Athena datasource. I found that superset 2.1.0 uses SQLAlchemy's get_view_names() [here](https://github.com/apache/superset/blob/fc8c537118ce6c7b3a4624f88a31e2e7fb287327/superset/db_engine_specs/base.py#L1186). 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](https://github.com/cloudera/impyla/blob/db67498e0a4e833b64e5e070272be2fcbd36f443/impala/sqlalchemy.py) does not implement this call, only get_table_names().
Currently the only solution seems to be downgrading Superset to 2.0.1.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] VitaliyFedorov commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "VitaliyFedorov (via GitHub)" <gi...@apache.org>.
VitaliyFedorov commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1592998207
> @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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] raulbla commented on issue #23850: There was an error loading the tables - for impala datasource
Posted by "raulbla (via GitHub)" <gi...@apache.org>.
raulbla commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-1551851187
I can confirm we have the same issue. Instead the query from sql tab is working fine
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "dkrat7 (via GitHub)" <gi...@apache.org>.
dkrat7 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2036323587
@pyroman30
get_view_name support was added in impyla==0.19.0. You should try with that version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "pyroman30 (via GitHub)" <gi...@apache.org>.
pyroman30 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2036341181
@dkrat7 thanks for the answer, unfortunately it didn't work
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] There was an error loading the tables - for impala datasource [superset]
Posted by "pyroman30 (via GitHub)" <gi...@apache.org>.
pyroman30 commented on issue #23850:
URL: https://github.com/apache/superset/issues/23850#issuecomment-2039409735
If I change the cache parameters, it helps for a while, then it doesn't work again
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org