[
https://issues.apache.org/jira/browse/PHOENIX-6484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth resolved PHOENIX-6484.
----------------------------------
Release Note: Fixed an error where phoenixdb threw an exception when en
empty result set had an array type column.
Resolution: Fixed
Committed.
Thanks for the review and the help in repro, Romain.
> 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
> Priority: Major
> 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)
