To convert a binary value to a String, you can use either cast() or convert_from() functions.
e.g. select cast(row_key as VARCHAR(50)) from hbase.tableName; OR select convert_from(row_key, 'UTF8') from hbase.tableName; On Tue, Jul 28, 2015 at 8:37 AM, Andries Engelbrecht < [email protected]> wrote: > Usman, > > Look into the convert functions > > https://drill.apache.org/docs/data-type-conversion/#convert_to-and-convert_from > < > https://drill.apache.org/docs/data-type-conversion/#convert_to-and-convert_from > > > > > > —Andries > > > > On Jul 28, 2015, at 8:35 AM, Usman Ali <[email protected]> > wrote: > > > > Hi, > > When we query an Hbase table like "select * from > > hbasePluginName.`tableName`" using Restful APIs, the json it returns > > contains values in the form of bytes. I know that all the values in my > > hbase table were originally of String form but I do not know exact schema > > (column families and column names) of my table. How can I convert those > > bytes stored in strings back to my original strings. > > > > Thanks. > > Usman Ali > >
