Istvan Toth created PHOENIX-5936:
------------------------------------
Summary: sqlAlchemy get_columns KeyError: None
Key: PHOENIX-5936
URL: https://issues.apache.org/jira/browse/PHOENIX-5936
Project: Phoenix
Issue Type: Bug
Components: queryserver
Affects Versions: queryserver-1.0.0
Reporter: Romain Rigaux
Assignee: Istvan Toth
calling inspector.get_columns() on a table with constraints will result in the
following error:
Traceback (most recent call last):
File
"/home/romain/projects/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py",
line 101, in decorator return func(*args, **kwargs)
File
"/home/romain/projects/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py",
line 362, in autocomplete
columns = assist.get_columns(database, table)
File
"/home/romain/projects/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py",
line 453, in get_columns return self.db.get_columns(table, database)
File
"/home/romain/projects/hue/build/env/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py",
line 372, in get_columns
col_defs = self.dialect.get_columns(
File
"/home/romain/projects/hue/build/env/lib/python3.8/site-packages/phoenixdb/sqlalchemy_phoenix.py",
line 163, in get_columns
col_type = COLUMN_DATA_TYPE[row[1]]
KeyError: None
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
