martin-raymond commented on issue #25749:
URL: https://github.com/apache/superset/issues/25749#issuecomment-1779784793
@zhaoyongjie yes, here it is :
`2023-10-25 17:13:09,270:INFO:pinotdb.sqlalchemy:Updated pinot dialect args
from {'dbapi': <module 'pinotdb' from
'/usr/local/lib/python3.9/site-packages/pinotdb/__init__.py'>,
'compiler_linting': 1, 'debug': False}: None and False
2023-10-25 17:13:09,270:INFO:pinotdb.sqlalchemy:Updated pinot dialect args
from {'host': 'pinot-broker.pinot.svc.cluster.local', 'port': 8099, 'path':
'query/sql', 'scheme': 'http', 'username': None, 'password': None, 'debug':
False}: http://pinot-controller.pinot.svc.cluster.local:9000/ and False
2023-10-25 17:13:09,274:DEBUG:urllib3.connectionpool:Starting new HTTP
connection (1): pinot-controller.pinot.svc.cluster.local:9000
2023-10-25
17:13:09,280:DEBUG:urllib3.connectionpool:http://pinot-controller.pinot.svc.cluster.local:9000/
"GET /tables/knada-indicateur-visite-v2/schema HTTP/1.1" 200 1350
2023-10-25 17:13:09,281:INFO:pinotdb.sqlalchemy:Getting columns for
knada-indicateur-visite-v2 from
http://pinot-controller.pinot.svc.cluster.local:9000/: {'schemaName':
'knada-indicateur-visite-v2', 'dimensionFieldSpecs': [{'name': 'profil',
'dataType': 'STRING'}, {'name': 'codeSite', 'dataType': 'STRING'}, {'name':
'libelleSite', 'dataType': 'STRING'}, {'name': 'timezone', 'dataType':
'STRING'}, {'name': 'plateforme', 'dataType': 'STRING'}, {'name': 'service',
'dataType': 'STRING', 'singleValueField': False}, {'name': 'categorieService',
'dataType': 'STRING', 'singleValueField': False}, {'name': 'codeReseau',
'dataType': 'STRING', 'singleValueField': False}, {'name': 'reseau',
'dataType': 'STRING', 'singleValueField': False}, {'name': 'type', 'dataType':
'STRING', 'singleValueField': False}, {'name': 'nature', 'dataType': 'STRING',
'singleValueField': False}], 'dateTimeFieldSpecs': [{'name': 'dateHeureDebut',
'dataType': 'LONG', 'format': '1:MILLISECONDS:EPOCH', 'granularity': '
1:MILLISECONDS'}, {'name': 'dateHeureFin', 'dataType': 'LONG', 'format':
'1:MILLISECONDS:EPOCH', 'granularity': '1:MILLISECONDS'}, {'name': 'ts',
'dataType': 'TIMESTAMP', 'format': '1:MILLISECONDS:EPOCH', 'granularity':
'1:MILLISECONDS'}]}
2023-10-25 17:13:09,282:ERROR:flask_appbuilder.api:'timestamp'
Traceback (most recent call last):
File
"/usr/local/lib/python3.9/site-packages/flask_appbuilder/api/__init__.py", line
110, in wraps
return f(self, *args, **kwargs)
File "/app/superset/views/base_api.py", line 127, in wraps
raise ex
File "/app/superset/views/base_api.py", line 121, in wraps
duration, response = time_function(f, self, *args, **kwargs)
File "/app/superset/utils/core.py", line 1526, in time_function
response = func(*args, **kwargs)
File "/app/superset/utils/log.py", line 255, in wrapper
value = f(*args, **kwargs)
File "/app/superset/databases/api.py", line 728, in table_metadata
table_info = get_table_metadata(database, table_name, schema_name)
File "/app/superset/databases/utils.py", line 67, in get_table_metadata
columns = database.get_columns(table_name, schema_name)
File "/app/superset/models/core.py", line 847, in get_columns
return self.db_engine_spec.get_columns(inspector, table_name, schema)
File "/app/superset/db_engine_specs/base.py", line 1294, in get_columns
cast(list[SQLAColumnType], inspector.get_columns(table_name, schema))
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line
497, in get_columns
col_defs = self.dialect.get_columns(
File "/usr/local/lib/python3.9/site-packages/pinotdb/sqlalchemy.py", line
415, in get_columns
columns = [
File "/usr/local/lib/python3.9/site-packages/pinotdb/sqlalchemy.py", line
418, in <listcomp>
"type": get_type(spec["dataType"], spec.get("fieldSize")),
File "/usr/local/lib/python3.9/site-packages/pinotdb/sqlalchemy.py", line
486, in get_type
return type_map[data_type.lower()]
KeyError: 'timestamp'
10.42.9.0 - - [25/Oct/2023:17:13:09 +0000] "GET
/api/v1/database/1/table/knada-indicateur-visite-v2/knada-indicateur-visite-v2/
HTTP/1.1" 500 26 "https://superset.knada.rancher.kosmos.fr/dataset/add/";
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/118.0.0.0 Safari/537.36"`
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
