Re: Re: Hbase SQL

2016-06-20 Thread Kunal Khatua
t; From: "Krishnaprasad A S" <krishna.pra...@flytxt.com> > Date: Jun 17, 2016 7:10 PM > Subject: Re: Hbase SQL > To: <user@drill.apache.org> > Cc: > > Hi Faraaz, > > Thank you for the reply. > > I'm trying these on Drill SQL prompt. > > Actually I c

Fwd: Re: Hbase SQL

2016-06-17 Thread Krishnaprasad A S
Can anyone help me on this. Is it possible to query a column from hbase who's column name is an integer. (In the form of byte[]). -- Forwarded message -- From: "Krishnaprasad A S" <krishna.pra...@flytxt.com> Date: Jun 17, 2016 7:10 PM Subject: Re: Hba

Re: Hbase SQL

2016-06-17 Thread Krishnaprasad A S
Hi Faraaz, Thank you for the reply. I'm trying these on Drill SQL prompt. Actually I can query the data from column family 'M' for the same key and the value is a byte[] serialized using avro. But my issue is I can't query the specific column from the column family 'M'. The column name is '11503'

Re: Hbase SQL

2016-06-17 Thread Khurram Faraaz
Can you try these two queries ?, and are you trying to execute your query from Drill's sqlline prompt or from a Java program ? select X.CF.`11503` from hbase.`X**` where convert_from(row_key, 'bigint_be') = 916124337090; and this one select X.CF.`11503` from hbase.`X**` where