Enc: [Please] Connect Java Class to Drill Distributed

2017-06-28 Thread Thiago Hernandes
Other snippet, embedded doesn't work too. Problems with Java 8 and Gradle. Could u send me a code for 2 cases (embedded/distributed)? It's missing on documentation.  Thiago Hernandes de Souza Analista de Sistemas e Consultor de TI http://br.linkedin.com/pub/thiago-hernandes/a9/b89/176/ "O temor do

[Please] Connect Java Class to Drill Distributed

2017-06-28 Thread Thiago Hernandes
Hi! Connect to embedded i did. But, the question is: "How can i connect Java Classes/Clients to Drill Distributed? How the Drillbit know what node execute some query?" Thanks Thiago Hernandes de Souza Analista de Sistemas e Consultor de TI http://br.linkedin.com/pub/thiago-hernandes/a9/b89/176/ "O

Writing to EMS ECS

2017-06-28 Thread Bob Carter
I can read from our EMS ECS S3 storage with Drill but I cannot write to it. When I try to write I get the following: Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request ID: 0acc510f:15a1f6415cc:918a3:3ce, AWS Error Code: AccessDenied, AWS Error Message

Re: Drill Query Engine for nested json or parquet

2017-06-28 Thread Jinfeng Ni
You are right that Q2 has to first apply flatten the field "details" before applying filter on top of the flattened rows. I do not think Drill currently supports to push filter down. The difference between Q1 and Q2: Q1 is querying a 4-row table, while Q2 is querying a 1-row table; the flatten o

Drill Query Engine for nested json or parquet

2017-06-28 Thread Lee, David
 Is there a fundamental difference between the following queries? I can't get the second example working with parquet files which contain 400,000+ nested records.. It seems like the system wants to flatten every possible record before applying the SQL Where clause to the flattened data structu