Apache Drill 1.0 JDBC issue

2015-06-23 Thread Ilangovan Sathasivan
Hi Team, We are facing the below issue when we try to use REST API + JDBC in Drill 1.0. The same is working in Drill 0.8. Please help to resolve this issue. 15:16:57.144 [Client-1] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.maxCapacity.default: 262144 java.sql.SQLException: Failure

[jira] [Created] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type

2015-06-23 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3343: --- Summary: Seemingly incorrect result with SUM window functions and float data type Key: DRILL-3343 URL: https://issues.apache.org/jira/browse/DRILL-3343

Re: Unit test failing on master

2015-06-23 Thread Abdel Hakim Deneche
my bad, I had a custom calcite r8 in my maven cache. The test is no longer failing now. Thanks! On Tue, Jun 23, 2015 at 9:45 AM, Hsuan Yi Chu hyi...@maprtech.com wrote: Make sure you are using drill-calcite-r8. In intellij, you need to reimport maven projects On Tue, Jun 23, 2015 at 9:44

Hangout happening now

2015-06-23 Thread Parth Chandra
Come join the Drill community as we discuss what has been happening lately and what is in the pipeline. All are welcome, if you know about Drill, want to know more or just want to listen in. Link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Thanks

Re: Apache Drill 1.0 JDBC issue

2015-06-23 Thread Rajkumar Singh
I can see a rpc version mismatch in the logs. please try connection with the updated drill jdbc driver which can be found at the following location apache-drill-1.0.0/jars/jdbc-driver/drill-jdbc-all-1.0.0.jar Rajkumar Singh MapR Technologies On Jun 23, 2015, at 8:52 PM, Ilangovan Sathasivan

Re: Hangout starting a little late this morning, should start around 10:10

2015-06-23 Thread Jason Altekruse
That is pacific time, the meeting will start in about 10 minutes. On Tue, Jun 23, 2015 at 9:59 AM, Jason Altekruse altekruseja...@gmail.com wrote: Join us at our weekly hangout to discuss what has been happening in the Drill community!

Re: Unit test failing on master

2015-06-23 Thread Abdel Hakim Deneche
hold on, I may have corrupted my local maven repository with a custom calcite build. I will clean the local repository and try again On Tue, Jun 23, 2015 at 9:41 AM, Abdel Hakim Deneche adene...@maprtech.com wrote: TestWindowFunctions#testWindowWithJoin is failing consistently on today's

Hangout starting a little late this morning, should start around 10:10

2015-06-23 Thread Jason Altekruse
Join us at our weekly hangout to discuss what has been happening in the Drill community! https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc

Re: Review Request 35609: DRILL-3243: Need a better error message - Use of alias in window function definition

2015-06-23 Thread Hanifi Gunes
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35609/#review89036 --- Ship it! Ship It! - Hanifi Gunes On June 18, 2015, 3:14 p.m.,

Re: Review Request 35634: DRILL-3319: UserExceptions should be logged from the right class

2015-06-23 Thread Sudheesh Katkam
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35634/ --- (Updated June 23, 2015, 6:50 p.m.) Review request for drill, abdelhakim

Re: Review Request 35623: DRILL-2494: Have PreparedStmt. set-param. methods throw unsupported.

2015-06-23 Thread Hanifi Gunes
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35623/#review89035 --- Ship it! Ship It! - Hanifi Gunes On June 19, 2015, 7 p.m.,

Re: Review Request 35636: DRILL-2447: Add already-closed checks to remaining ResultSet methods.

2015-06-23 Thread Daniel Barclay
On June 23, 2015, 7:24 p.m., Hanifi Gunes wrote: exec/jdbc/src/main/java/org/apache/drill/jdbc/DrillResultSet.java, line 400 https://reviews.apache.org/r/35636/diff/2/?file=988487#file988487line400 Do we really need to have these comments checked-in? These look extensive. The

Re: Drill should validate column names within window functions

2015-06-23 Thread Jason Altekruse
You can mistype a column that you are sorting on or joining on and get the same problem. Vicky has filed a bug for a subquery that looked to be returning wrong results, but one of the columns she was trying to refer to was not available within that scope, and we happily filled it in with all null

Re: Review Request 34004: DRILL-1942: Improved memory allocator

2015-06-23 Thread Sudheesh Katkam
On June 18, 2015, 7:09 p.m., Sudheesh Katkam wrote: exec/java-exec/src/main/java/org/apache/drill/exec/work/fragment/RootFragmentManager.java, line 74 https://reviews.apache.org/r/34004/diff/3/?file=983386#file983386line74 cancel() and isCancelled() need to be synchronized

Re: [DISCUSS] Allowing the option to use github pull requests in place of reviewboard

2015-06-23 Thread Parth Chandra
+1 on trying this. RB has been pretty painful to us. On Mon, Jun 22, 2015 at 9:45 PM, Matthew Burgess mattyb...@gmail.com wrote: Is Travis https://travis-ci.org/ a viable option for the GitHub route? I use it for my own projects to build pull requests (with additional code quality targets

Re: [DISCUSS] Allowing the option to use github pull requests in place of reviewboard

2015-06-23 Thread Hanifi Gunes
+1 At the very least GitHub will be UP. On Tue, Jun 23, 2015 at 2:18 PM, Parth Chandra pchan...@maprtech.com wrote: +1 on trying this. RB has been pretty painful to us. On Mon, Jun 22, 2015 at 9:45 PM, Matthew Burgess mattyb...@gmail.com wrote: Is Travis https://travis-ci.org/ a

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Parth Chandra
I'd be in favor of doing this in the 1.2 release cycle. On Thu, Jun 18, 2015 at 6:30 PM, Aditya a...@apache.org wrote: Few of the storage plugins like HBase and Hive have matured enough to be moved out of contrib and into the mainline, probably under exec/storage. If people think that it is

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Ted Dunning
Not yet. On Wed, Jun 24, 2015 at 12:38 AM, Jacques Nadeau jacq...@apache.org wrote: Ted, That's a great repo. Do you have a blog entry that can drive to it for others? On Tue, Jun 23, 2015 at 9:34 PM, Ted Dunning ted.dunn...@gmail.com wrote: As a transitional stage, it does make

[jira] [Created] (DRILL-3342) like query is not working properly

2015-06-23 Thread Devender Yadav (JIRA)
Devender Yadav created DRILL-3342: -- Summary: like query is not working properly Key: DRILL-3342 URL: https://issues.apache.org/jira/browse/DRILL-3342 Project: Apache Drill Issue Type: Bug

Re: [DISCUSS] Allowing the option to use github pull requests in place of reviewboard

2015-06-23 Thread Ted Dunning
Travis won't likely be faster for the CI part, but it is super easy to set up so it can't hurt to try it out. On Tue, Jun 23, 2015 at 9:10 PM, Chris Westin chriswesti...@gmail.com wrote: And I'll bet GitHub is a lot faster too. On Tue, Jun 23, 2015 at 2:23 PM, Hanifi Gunes hgu...@maprtech.com

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Ted Dunning
As a transitional stage, it does make sense. Having separated builds at least for a few examples is really helpful for the people interested in extending Drill without necessarily contributing their code back in (at least not right away). That was my motive behind

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Jacques Nadeau
Ted, That's a great repo. Do you have a blog entry that can drive to it for others? On Tue, Jun 23, 2015 at 9:34 PM, Ted Dunning ted.dunn...@gmail.com wrote: As a transitional stage, it does make sense. Having separated builds at least for a few examples is really helpful for the people

Re: Review Request 35673: DRILL-3326: Query with unsupported windows function containing AS blocks correct error message

2015-06-23 Thread Aman Sinha
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35673/#review89130 --- Ship it! Ship It! - Aman Sinha On June 24, 2015, 12:15 a.m.,

[jira] [Created] (DRILL-3346) Windowing query over View fails

2015-06-23 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3346: - Summary: Windowing query over View fails Key: DRILL-3346 URL: https://issues.apache.org/jira/browse/DRILL-3346 Project: Apache Drill Issue Type: Bug

Re: Review Request 35673: DRILL-3326: Query with unsupported windows function containing AS blocks correct error message

2015-06-23 Thread Aman Sinha
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35673/#review89084 ---

Review Request 35808: DRILL-2862: Convert_to/Convert_From throw assertion when an incorrect encoding type is specified

2015-06-23 Thread Parth Chandra
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35808/ --- Review request for drill, Jinfeng Ni and Sudheesh Katkam. Repository:

[jira] [Resolved] (DRILL-1616) Add support for count() on maps and arrays

2015-06-23 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-1616. Resolution: Duplicate Add support for count() on maps and arrays

Re: Review Request 35673: DRILL-3326: Query with unsupported windows function containing AS blocks correct error message

2015-06-23 Thread Sean Hsuan-Yi Chu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35673/ --- (Updated June 24, 2015, 12:15 a.m.) Review request for drill and Aman Sinha.

Re: Review Request 35808: DRILL-2862: Convert_to/Convert_From throw assertion when an incorrect encoding type is specified

2015-06-23 Thread Venki Korukanti
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35808/#review89103 --- How about the case where the function is not found for the specific

[jira] [Created] (DRILL-3350) query of csv with 65k columns causes Drill Explorer exception

2015-06-23 Thread Nick Amato (JIRA)
Nick Amato created DRILL-3350: - Summary: query of csv with 65k columns causes Drill Explorer exception Key: DRILL-3350 URL: https://issues.apache.org/jira/browse/DRILL-3350 Project: Apache Drill

Re: Wrong results - windowing query over view

2015-06-23 Thread Khurram Faraaz
The second query (below) that uses group by is not supported by Postgres, I will file a JIRA to block that query. SELECT MIN(col_int) OVER() FROM vwOnParq group by col_char_2; Output from Postgres postgres=# select min(col_int) over() from all_typs_tbl group by col_char_2; ERROR: column

[jira] [Created] (DRILL-3351) Invalid query must be caught earlier

2015-06-23 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-3351: - Summary: Invalid query must be caught earlier Key: DRILL-3351 URL: https://issues.apache.org/jira/browse/DRILL-3351 Project: Apache Drill Issue Type: Bug

Re: [DISCUSS] Allowing the option to use github pull requests in place of reviewboard

2015-06-23 Thread Chris Westin
And I'll bet GitHub is a lot faster too. On Tue, Jun 23, 2015 at 2:23 PM, Hanifi Gunes hgu...@maprtech.com wrote: +1 At the very least GitHub will be UP. On Tue, Jun 23, 2015 at 2:18 PM, Parth Chandra pchan...@maprtech.com wrote: +1 on trying this. RB has been pretty painful to us.

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Chris Westin
It's never been clear to me why these are in the same repo at all. If someone wants to go off and build a plug-in, they don't really need to be part of the project. Being part of the project brings a certain expectation by users of support from developers, and Aditya's explanation basically

Re: Review Request 35739: Patch for DRILL-3333

2015-06-23 Thread Aman Sinha
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35739/#review89113 --- Ship it!

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Jason Altekruse
In light of Aditya's explanation I think this is a good way to clarify the relationship between Drill, Hive and Hbase. These are core plugins that we are planning to support completely, just as we do with the HDFS API in the FileSystemPlugin, which is currently a part of the exec module. +1 On

Re: Review Request 35673: DRILL-3326: Query with unsupported windows function containing AS blocks correct error message

2015-06-23 Thread Sean Hsuan-Yi Chu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35673/ --- (Updated June 24, 2015, 12:12 a.m.) Review request for drill and Aman Sinha.

Re: Review Request 35673: DRILL-3326: Query with unsupported windows function containing AS blocks correct error message

2015-06-23 Thread Sean Hsuan-Yi Chu
On June 23, 2015, 11:27 p.m., Aman Sinha wrote: exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java, line 203 https://reviews.apache.org/r/35673/diff/2/?file=989815#file989815line203 It wasn't clear why you were using non-existent columns 'age' and

Re: Review Request 35739: Patch for DRILL-3333

2015-06-23 Thread Steven Phillips
On June 22, 2015, 10:25 p.m., Jacques Nadeau wrote: exec/java-exec/src/main/java/org/apache/drill/exec/store/parquet/ParquetGroupScan.java, line 278 https://reviews.apache.org/r/35739/diff/1/?file=989875#file989875line278 Is creating the metadata converter repeatedly expensive?

[jira] [Created] (DRILL-3348) NPE when two different window functions are used in projection list and order by clauses

2015-06-23 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-3348: --- Summary: NPE when two different window functions are used in projection list and order by clauses Key: DRILL-3348 URL: https://issues.apache.org/jira/browse/DRILL-3348

Wrong results - windowing query over view

2015-06-23 Thread Khurram Faraaz
Windowing query over a view returns wrong results when used with and without a group by clause. Please let me know if this is a planning bug ? Postgres does not support the query where we use a group by. DDL used for view creation was, create view vwOnParq (col_int, col_bigint, col_char_2,

[jira] [Resolved] (DRILL-3094) TPCH query 15 returns non-deterministic result

2015-06-23 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved DRILL-3094. --- Resolution: Won't Fix Pls see previous comments and try the round() function. I am closing this for

Re: Moving matured storage plugins out of contrib

2015-06-23 Thread Aditya
I have always interpreted contrib as an experimental code which are provided as is[1], not fully validated by the main project and possibly has not reached the same maturity as the rest of the project. It will help us in communicate the maturity of few plugins like hbase, hive and mongo as such

Re: Wrong results - windowing query over view

2015-06-23 Thread Abdel Hakim Deneche
What happens if you run the queries on the original parquet files and not the views ? On Tue, Jun 23, 2015 at 5:28 PM, Khurram Faraaz kfar...@maprtech.com wrote: Windowing query over a view returns wrong results when used with and without a group by clause. Please let me know if this is a

[jira] [Created] (DRILL-3349) Resolve whether BoundCheckingAccessor still needs to exist

2015-06-23 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-3349: - Summary: Resolve whether BoundCheckingAccessor still needs to exist Key: DRILL-3349 URL: https://issues.apache.org/jira/browse/DRILL-3349 Project: