Hi,
I have a doubt on Hbase storage in Drill.

My HBase table 'X' has a column family 'CF' and a column name which is an
integer.
we store the data in hbase with column name as bytes array, using the
following code to create the byte[] (as normal in Hbase).
byte[] column = org.apache.hadoop.hbase.util.Bytes*.toBytes(integerValue)*

if my column name is integer 11503,
then how can I query the data from the specific column.
Currently the following query does not work, it returns zero rows even
though data exists in the column.
*select X.CF.`11503` from hbase.`X**` where
convert_from(byte_substr(row_key, 1, 12), 'bigint_be') = 916124337090;*

Can anyone help?


-- 
Krishnaprasad A S

Reply via email to