DRILL JDBC Driver setFetchSize

2016-09-13 Thread Sudip Mukherjee
Hi, Should the setFetchSize work similar to applying LIMIT clause with drill JDBC driver? I've set setFetchSize to java.sql.Statement

Re: Nested/n-dimensional Arrays in Mongo/Json and Drill

2016-09-13 Thread Sudheesh Katkam
Hi Pradeeban, Can you post the detailed error message? First set the option: > SET `exec.errors.verbose` = true; And then run the query. The detailed output will point us to where the error occurred. Thank you, Sudheesh > On Sep 12, 2016, at 10:47 AM, Pradeeban Kathiravelu > wrote: > > Hi,

[GitHub] drill issue #518: DRILL-4653.json - Malformed JSON should not stop the entir...

2016-09-13 Thread paul-rogers
Github user paul-rogers commented on the issue: https://github.com/apache/drill/pull/518 Poking around in the code a bit more, it looks like we rely on the Jackson JsonParser which delivers a stream of tokens. Here's the code in JsonReader: public ReadState write(ComplexWr

[jira] [Created] (DRILL-4888) putIfAbsent for ZK stores is not atomic

2016-09-13 Thread Arina Ielchiieva (JIRA)
Arina Ielchiieva created DRILL-4888: --- Summary: putIfAbsent for ZK stores is not atomic Key: DRILL-4888 URL: https://issues.apache.org/jira/browse/DRILL-4888 Project: Apache Drill Issue Type

[jira] [Created] (DRILL-4887) KVGEN throws a Heterogenous Type error while applying on a JSON when querying a JDBC Storage Plugin

2016-09-13 Thread Nataraj Gnanavadivel (JIRA)
Nataraj Gnanavadivel created DRILL-4887: --- Summary: KVGEN throws a Heterogenous Type error while applying on a JSON when querying a JDBC Storage Plugin Key: DRILL-4887 URL: https://issues.apache.org/jira/brow

Re: Right outer join fails

2016-09-13 Thread Kathiresan S
​Hi, Additional info on this. Array column ('city' in the example) is the issue. 1. When i select the just the first occurrence of the array column, the query works fine select a.name,a.city[0],b.name from dfs.tmp.`data.json` a right join dfs.tmp.`cities.json` b on a.city[0]=b.id Result Jim 1 S

[GitHub] drill pull request #574: DRILL-4726: Dynamic UDFs support

2016-09-13 Thread arina-ielchiieva
Github user arina-ielchiieva commented on a diff in the pull request: https://github.com/apache/drill/pull/574#discussion_r78527103 --- Diff: exec/java-exec/src/test/java/org/apache/drill/TestDynamicUDFSupport.java --- @@ -0,0 +1,292 @@ +/** + * Licensed to the Apache Softw

[GitHub] drill pull request #574: DRILL-4726: Dynamic UDFs support

2016-09-13 Thread arina-ielchiieva
Github user arina-ielchiieva commented on a diff in the pull request: https://github.com/apache/drill/pull/574#discussion_r78525988 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/DrillSqlWorker.java --- @@ -69,29 +72,43 @@ public static PhysicalPlan getPl