Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3934

VARBINARY type doesn't have a useful representation in sqlline.py

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.14.1
    • None

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              shehzaadn Shehzaad Nakhoda
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: