` where
convert_from(byte_substr(row_key, 1, 12), 'bigint_be') = 916124337090;*
Can anyone help?
--
Krishnaprasad A S
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.u
` where
convert_from(byte_substr(row_key, 1, 12), 'bigint_be') = 916124337090;*
Any help ?
--
Krishnaprasad A S
<http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>
rill'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
> convert_from(row_key, 'UTF8') = 916124337090;
>
&
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"
Date: Jun 17, 2016 7:10 PM
Subject: Re: Hbase SQL
To:
Cc:
Hi Faraaz,
> Thank
hi,
I'm trying to create a drill interpreter in zeppelin using the existing
jdbc interpreter.
*drill.url = jdbc:drill:zk=:2181/drill/drillbits1drill.driver =
org.apache.drill.jdbc.Driver*
my drillbit runs on the same server as of zeppelin.
Added the dependency 'apache-drill-1.7.0/jars/drill-jdbc-
connect directly to the drillbit
> jdbc:drill:drillbit=:31010
>
> It looks like you are trying to connect to a zk with a drill cluster, and
> your setup may just be embedded mode.
>
> --Andries
>
>
> > On Jul 11, 2016, at 12:55 PM, Krishnaprasad A S <
> krishna.
Drill connection.
>
> Some good info for configuring Zeppelin with Drill here
>
> https://community.mapr.com/docs/DOC-1493 <
> https://community.mapr.com/docs/DOC-1493>
>
> --Andries
>
>
> > On Jul 11, 2016, at 2:13 PM, Krishnaprasad A S <
> krishna.pra...@flytx
elp to see if it is a zk connection issue.
Also I assume the dill cluster is up and running, and if you go to the
webUI it shows all drillbits in the cluster connected and running.
> On Jul 11, 2016, at 2:27 PM, Krishnaprasad A S
wrote:
>
> I went through the same link before configur
=:31010?
>
> What does your drill-override.conf file look like?
>
>
> > On Jul 11, 2016, at 2:33 PM, Krishnaprasad A S <
> krishna.pra...@flytxt.com> wrote:
> >
> > I can see all the 4 drillbits in ui. Aso I tried the query in web ui
> before
> > runnin
tring URL_STRING =
> "jdbc:drill:schema=dfs.tmp;drillbit=";
> >
> > replace IPADDRESS with your IP address in the above line.
> >
> > On Tue, Jul 12, 2016 at 12:08 PM, Krishnaprasad A S <
> > krishna.pra...@flytxt.com> wrote:
> >
> >> Yes, I tr
Drill nodes, where is ZK
> located?
>
> --Andries
>
>
> > On Jul 12, 2016, at 5:31 AM, Krishnaprasad A S <
> krishna.pra...@flytxt.com> wrote:
> >
> > My zookeeper runs on port 2181, thats why I used the same port.
> > I think drill won't star
12 matches
Mail list logo
