You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2018/08/24 06:33:00 UTC
[jira] [Updated] (PHOENIX-3934) VARBINARY type doesn't have a
useful representation in sqlline.py
[ https://issues.apache.org/jira/browse/PHOENIX-3934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva updated PHOENIX-3934:
------------------------------------
Labels: newbie (was: )
> 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
(v7.6.3#76005)