You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2021/05/31 05:06:00 UTC
[jira] [Commented] (PHOENIX-6484) Python phoenixdb throws error on
empty resultsets with array types
[ https://issues.apache.org/jira/browse/PHOENIX-6484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17354222#comment-17354222 ]
Istvan Toth commented on PHOENIX-6484:
--------------------------------------
Avatica (and possibly Phoenix) returns JAVA_OBJECT type for Arrays in empty resultsets.
PhoenixDB cannot map that.
> 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)