[jira] [Created] (PHOENIX-6484) Python phoenixdb throws error on empty resultsets with array types

["Istvan Toth (Jira)" <ji...@apache.org>]

Istvan Toth created PHOENIX-6484:
------------------------------------

             Summary: Python phoenixdb throws error on empty resultsets with array types 
                 Key: PHOENIX-6484
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6484
             Project: Phoenix
          Issue Type: Bug
          Components: python
    Affects Versions: 1.0.1
            Reporter: Istvan Toth
            Assignee: Istvan Toth
             Fix For: 1.1.0



{noformat}
[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
{noformat}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)