[PHOENIX-6484] Python phoenixdb throws error on empty resultsets with array types

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1
• Fix Version/s: python-phoenixdb-1.1.0
• Component/s: python
• Release Note: Fixed an error where phoenixdb threw an exception when en empty result set had an array type column.
• Assignee: Istvan Toth
• Reporter: Istvan Toth
• Created: 31/May/21 05:04
• Updated: 18/Aug/21 08:47
• Resolved: 01/Jun/21 03:22

Description

[30/May/2021 12:17:59 -0700] decorators   ERROR    Error running execute
Traceback (most recent call last):
  File "/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py", line 100, in decorator
    return func(*args, **kwargs)
  File "/usr/share/hue/desktop/libs/notebook/src/notebook/connectors/sql_alchemy.py", line 253, in execute
    result = connection.execute(statement)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 982, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1155, in _execute_text
    parameters,
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1475, in _handle_dbapi_exception
    util.reraise(*exc_info)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/phoenixdb/cursor.py", line 228, in execute
    self._set_signature(statement.signature)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/phoenixdb/cursor.py", line 141, in _set_signature
    dtype = TypeHelper.from_column(column)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/phoenixdb/types.py", line 294, in from_column
    return TypeHelper._from_jdbc(column.type.component.id)
  File "/usr/share/hue/build/env/lib/python3.6/site-packages/phoenixdb/types.py", line 302, in _from_jdbc
    raise NotImplementedError('JDBC TYPE CODE {} is not supported'.format(jdbc_code))
NotImplementedError: JDBC TYPE CODE 2000 is not supported

Issue Links

• links to: GitHub Pull Request #66