Re: Drill JDBC Interpreter: Connection Refused

2016-07-12 Thread Krishnaprasad A S
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 start zoo

Re: Drill JDBC Interpreter: Connection Refused

2016-07-12 Thread Krishnaprasad A S
st fine for me > > > > final String 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...@f

Re: Drill JDBC Interpreter: Connection Refused

2016-07-12 Thread Krishnaprasad A S
our 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 > > running it in zeppelin. In web ui it

Re: Drill JDBC Interpreter: Connection Refused

2016-07-11 Thread Krishnaprasad A S
ct to a drillbit directly? This will help 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 <krishna.pra...@flytxt.

Re: Drill JDBC Interpreter: Connection Refused

2016-07-11 Thread Krishnaprasad A S
user and password info for the 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, Krishnapras

Re: Drill JDBC Interpreter: Connection Refused

2016-07-11 Thread Krishnaprasad A S
mbedded mode you may want to try to 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,

Drill JDBC Interpreter: Connection Refused

2016-07-11 Thread Krishnaprasad A S
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

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
> 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; > > > On Fri, Jun 17, 2016 at 5:31 PM, Krishnaprasad A S < &g

Fwd: Hbase SQL

2016-06-17 Thread Krishnaprasad A S
(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=ncsrch_hits>

Hbase SQL

2016-06-16 Thread 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 =

Fwd: Hbase query using Drill

2016-06-16 Thread Krishnaprasad A S
(byte_substr(row_key, 1, 12), 'bigint_be') = 916124337090;* Can anyone help? -- Krishnaprasad A S