[Drill-Issues] Drill-1.6.0: CTAS - No table found in case select returns empty set.

Is there any configuration to do, To force create table even when SELECT statement return empty data ? 0: jdbc:drill:> create table glv_abcookie_min_newsid as . . . . . . . > select . . . . . . . > app_sessionid, . . . . . . . > new_sessionid, . . . . . . . > min(serverTime) as min_serverTime .

Re: [Drill-Issues] Drill-1.6.0: Drillbit not starting

Can you check if there are any errors in the drillbit.out file? This file should be in the same directory as the log file. Thank you, Sudheesh > On Aug 4, 2016, at 4:25 AM, Shankar Mane wrote: > > I am getting this error infrequently. Most of the time drill starts

[Drill-Issues] Drill-1.6.0: Drillbit not starting

I am getting this error infrequently. Most of the time drill starts normally and sometimes this gives below error. I am running drill 1.6.0 in cluster mode. ZK has also setup. Could some one please explain where the issue is ? 2016-08-04 03:45:15,870 [main] INFO

Re: Drill Issues

You can use CONVERT_TO and CONVERT_FROM functions, to get HDFS bytes read/write from drill queries. https://drill.apache.org/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions On Mon, May 23, 2016 at 11:28 AM, vinita.go...@siemens.com < vinita.go...@siemens.com>

Re: Drill Issues

Hello Vinita, A simple storage plugins for Hive looks like this. { "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris": "thrift://scflexnode09:9083", "hive.metastore.sasl.enabled": "false", "fs.default.name": "hdfs://scflexnode09:8020/" } }

RE: Drill Issues

Hi.. How can I use Hive tables for running drill queries. What will be the storage plug-in? Please help I tried it a lot But could not get how to do. Thanks and Regards Vinita Goyal

Fwd: Drill Issues

Hello I am facing some problem while using drill. I have also posted earlier my problem one by one, but didn't get any proper solution for that. This time again i am posting my problem. 1) Join Query Problem (for details check in April 16 with *subject*:- Regarding Join Query Problem) 2)

Re: Drill Issues

Hi Sanjiv, 3) As to authentication in windows, I think you already got a proper reply, that is you have to implement your own authenticator. Depends on your windows environment, you can decide either call windows API to check user+password, or connect Active Directory either through LDAP or

Re: Drill Issues

Hello Sanjiv, I work with the Drill team. I don't have your previous email (I joined the user group recently). I can take a look at your join query problem and your multiple columns having same name and same type issue. Please share/resend your earlier email, and I can take a look. Two things

Drill Issues

Hello I am facing some problem while using drill. I have also posted earlier my problem one by one, but didn't get any proper solution for that. This time again i am posting my problem. 1) Join Query Problem (for details check in April 16 with *subject*:- Regarding Join Query Problem) 2)

Re: Apache Drill issues

Hi Ananda, I’m somewhat new to Drill and I asked the same questions. Here’s what I understand (and I hope others will offer any needed corrections.) Drill uses a flow-based DAG model with no intermediate caching or checkpoints. That is a fancy way of saying that data streams from scanners to

Fwd: Apache Drill issues

Hi Team, I went through the Architecture of Drill and have couple of questions are in my mind . Can you please help me here : 1- what is the recovery model/process of Drill ? ( If one of the drillbit went down from cluster while processing the data , how to recover them .) 2- If any of the