[
https://issues.apache.org/jira/browse/PHOENIX-5936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth updated PHOENIX-5936:
---------------------------------
Description:
calling inspector.get_columns() on a table with constraints will result in the
following error:
{noformat}
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{noformat}
was:
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
> 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
> Priority: Major
>
> calling inspector.get_columns() on a table with constraints will result in
> the following error:
> {noformat}
> 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{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
