[jira] [Resolved] (PHOENIX-3934) VARBINARY type doesn't have a useful representation in sqlline.py

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

     [ https://issues.apache.org/jira/browse/PHOENIX-3934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Istvan Toth resolved PHOENIX-3934.
----------------------------------
    Resolution: Fixed

As mentioned above, this is no longer an issue.

IMO controlling the length ot the toString() result is out of the scope of the JDBC interface.
That should be handled in sqlline, or simply by using string functions like SUBSTR in the query to limit the length.

> VARBINARY type doesn't have a useful representation in sqlline.py
> -----------------------------------------------------------------
>
>                 Key: PHOENIX-3934
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3934
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Shehzaad Nakhoda
>            Priority: Major
>              Labels: newbie
>
> When interacting with a commonly-used command line client like sqlline.py a VARBINARY type is not represented in a useful way in query results. The value seems to be a representation of the Java hashcode for the byte array, which changes with every query.
> The following transcript will make this obvious. Note the value of MYBYTES is hard to make use of and moreover it changes with every query. I would like to see some stable representation of the byte array itself.
> 0: jdbc:phoenix:localhost:2181:/hbase> create table my_table (name VARCHAR PRIMARY KEY, mybytes VARBINARY);
> No rows affected (2.33 seconds)
> 0: jdbc:phoenix:localhost:2181:/hbase> upsert into my_table(name, mybytes) values('hello', '12312');
> 1 row affected (0.004 seconds)
> 0: jdbc:phoenix:localhost:2181:/hbase> select * from my_table;
> +--------+-------------+
> |  NAME  |   MYBYTES   |
> +--------+-------------+
> | hello  | [B@650eab8  |
> +--------+-------------+
> 1 row selected (0.017 seconds)
> 0: jdbc:phoenix:localhost:2181:/hbase> select * from my_table;
> +--------+--------------+
> |  NAME  |   MYBYTES    |
> +--------+--------------+
> | hello  | [B@53f48368  |
> +--------+--------------+
> 1 row selected (0.015 seconds)
> 0: jdbc:phoenix:localhost:2181:/hbase> select * from my_table;
> +--------+--------------+
> |  NAME  |   MYBYTES    |
> +--------+--------------+
> | hello  | [B@71b3bc45  |
> +--------+--------------+
> 1 row selected (0.015 seconds)



--
This message was sent by Atlassian Jira
(v8.20.10#820010)