[ https://issues.apache.org/jira/browse/PHOENIX-5936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Istvan Toth resolved PHOENIX-5936. ---------------------------------- Fix Version/s: queryserver-1.0.0 Resolution: Fixed > 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 > Fix For: queryserver-1.0.0 > > > 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)