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
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
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'
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