Re: Drill - Hive - Kerberos

Hi Joseph, Are you running DRILL on a secure cluster? I had success with the following storage plugin configuration with MapR distribution, SQL standard authorization with Kerberos: hive storage plugin: { "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris":

Drill - Hive - Kerberos

I have a Hive Storage plugin configured (bottom). I am using HDP 2.4 w/ Hive 1.2.1, Drill 1.6 I can connect just fine with Drill Explorer. I can browse, and view content on hdfs just fine with Drill Explorer. The .csv files etc, display fine. I can browse to see the list of schemas in

PAM installation issue

Hi all, I was recently going through the https://drill.apache.org/docs/ documentation to setup a Distributed Mode Drill cluster that will consume data off of HDFS. Our cluster runs Ubuntu 14.04. I found that following the PAM installation steps at

Fwd: Re: Hbase SQL

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:

Re: Dynamic UDFs support

Reviewed the spec; many comments posted. Three primary comments for the community to consider. 1. The design conflicts with the Drill-on-YARN project. Is this a specific fix for one unique problem, or is it worth expanding the solution to work with Drill-on-YARN deployments? Might be hard to

Snappy compression on JSON files stored on HDFS

Hi all, I'm attempting to read a nested JSON file compressed with Snappy using the following query: select * from hdfs.`/tmp/test/part-r-01195.json.snappy` limit 20 However I am encountering the following error: 2016-06-17 09:36:29,385 [USER-rpc-event-queue] ERROR

Re: Hbase SQL

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

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

Fwd: Hbase SQL

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 =