[jira] [Updated] (DRILL-3261) Tpch query 4 over hive sf100 fails with an OOM error. Query runs fine against text and parquet

2015-06-08 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-3261: - Assignee: Venki Korukanti (was: Chris Westin) Tpch query 4 over hive sf100 fails with

[jira] [Updated] (DRILL-3216) Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3216: -- Fix Version/s: 1.1.0 Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns

[jira] [Updated] (DRILL-3261) Tpch query 4 over hive sf100 fails with an OOM error. Query runs fine against text and parquet

2015-06-08 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-3261: - Attachment: error.log tpch100_hive.ddl Tpch query 4 over hive sf100

[jira] [Created] (DRILL-3261) Tpch query 4 over hive sf100 fails with an OOM error. Query runs fine against text and parquet

2015-06-08 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-3261: Summary: Tpch query 4 over hive sf100 fails with an OOM error. Query runs fine against text and parquet Key: DRILL-3261 URL:

[jira] [Assigned] (DRILL-3211) Assert in a query with window function and group by clause

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-3211: - Assignee: Aman Sinha (was: Jinfeng Ni) Assert in a query with window function and group by

[jira] [Updated] (DRILL-3211) Assert in a query with window function and group by clause

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3211: -- Fix Version/s: 1.1.0 Assert in a query with window function and group by clause

[jira] [Resolved] (DRILL-2952) Hive 1.0 plugin for Drill

2015-06-08 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti resolved DRILL-2952. Resolution: Fixed +1. Fixed in

[jira] [Resolved] (DRILL-3260) Conflicting servlet-api jar causing web UI to be slow

2015-06-08 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti resolved DRILL-3260. Resolution: Fixed Fix Version/s: 1.1.0 Fixed in

[jira] [Updated] (DRILL-3210) Star is not expanded correctly in projection list when used with window function

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3210: -- Fix Version/s: 1.2.0 Star is not expanded correctly in projection list when used with window

[jira] [Commented] (DRILL-3198) JDBC driver returns null DatabaseMetaData#getTypeInfo()

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577589#comment-14577589 ] Daniel Barclay (Drill) commented on DRILL-3198: --- For references, the

[jira] [Commented] (DRILL-3188) Disable ability to specify window frame

2015-06-08 Thread Jacques Nadeau (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577698#comment-14577698 ] Jacques Nadeau commented on DRILL-3188: --- It seems like we should only fail if the

[jira] [Updated] (DRILL-3260) Conflicting servlet-api jar causing web UI to be slow

2015-06-08 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-3260: --- Attachment: DRILL-3260-1.patch Conflicting servlet-api jar causing web UI to be slow

[jira] [Updated] (DRILL-3219) Filter is not pushed into subquery with window function

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3219: -- Fix Version/s: 1.2.0 Filter is not pushed into subquery with window function

[jira] [Updated] (DRILL-3189) Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3189: -- Fix Version/s: 1.2.0 Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar

[jira] [Comment Edited] (DRILL-3198) JDBC driver returns null DatabaseMetaData#getTypeInfo()

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577589#comment-14577589 ] Daniel Barclay (Drill) edited comment on DRILL-3198 at 6/8/15 6:18 PM:

[jira] [Updated] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3195: -- Fix Version/s: 1.1.0 Throw unsupported exception for Window functions that are not currently

[jira] [Updated] (DRILL-3188) Disable ability to specify window frame

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3188: -- Fix Version/s: 1.1.0 Disable ability to specify window frame ---

[jira] [Updated] (DRILL-3213) Better error message - Use of aggregate function in order by clause within an over clause

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3213: -- Component/s: (was: Execution - Flow) Query Planning Optimization Better error

[jira] [Updated] (DRILL-3213) Better error message - Use of aggregate function in order by clause within an over clause

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3213: -- Assignee: Jinfeng Ni (was: Deneche A. Hakim) Better error message - Use of aggregate function in

[jira] [Updated] (DRILL-3213) Better error message - Use of aggregate function in order by clause within an over clause

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3213: -- Fix Version/s: (was: 1.1.0) 1.2.0 Better error message - Use of aggregate

[jira] [Updated] (DRILL-3198) JDBC driver returns null DatabaseMetaData#getTypeInfo()

2015-06-08 Thread Matt Keranen (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Matt Keranen updated DRILL-3198: Priority: Major (was: Minor) JDBC driver returns null DatabaseMetaData#getTypeInfo()

[jira] [Updated] (DRILL-3196) Disable multiple partition by clauses in the same sql query

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3196: -- Fix Version/s: 1.1.0 Disable multiple partition by clauses in the same sql query

[jira] [Commented] (DRILL-3260) Conflicting servlet-api jar causing web UI to be slow

2015-06-08 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577503#comment-14577503 ] Jason Altekruse commented on DRILL-3260: +1 Conflicting servlet-api jar causing

[jira] [Updated] (DRILL-3216) Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3216: -- Description: Change logical null from {{-1}} to actual {{NULL}}: - Change

[jira] [Updated] (DRILL-3252) Error message must provide information about grouping column

2015-06-08 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-3252: -- Fix Version/s: 1.2.0 Error message must provide information about grouping column

[jira] [Closed] (DRILL-1910) ROW_NUMBER() window function throws exception during execution

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim closed DRILL-1910. --- Resolution: Duplicate once DRILL-3200 is merged, this should no longer be a problem

[jira] [Created] (DRILL-3262) Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-3262: - Summary: Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to Key: DRILL-3262 URL: https://issues.apache.org/jira/browse/DRILL-3262

[jira] [Assigned] (DRILL-3262) Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) reassigned DRILL-3262: - Assignee: Daniel Barclay (Drill) Rename missed

[jira] [Commented] (DRILL-3211) Assert in a query with window function and group by clause

2015-06-08 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577815#comment-14577815 ] Abhishek Girish commented on DRILL-3211: I hit this too. Can't see where I'm

[jira] [Updated] (DRILL-3198) JDBC driver returns null from DatabaseMetaData.getTypeInfo(...)

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3198: -- Summary: JDBC driver returns null from DatabaseMetaData.getTypeInfo(...) (was:

[jira] [Commented] (DRILL-3204) Problem in name resolution with window functions

2015-06-08 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577999#comment-14577999 ] Sean Hsuan-Yi Chu commented on DRILL-3204: -- We need to tackle this issue from

[jira] [Created] (DRILL-3260) Conflicting servlet-api jar causing web UI to be slow

2015-06-08 Thread Venki Korukanti (JIRA)
Venki Korukanti created DRILL-3260: -- Summary: Conflicting servlet-api jar causing web UI to be slow Key: DRILL-3260 URL: https://issues.apache.org/jira/browse/DRILL-3260 Project: Apache Drill

[jira] [Commented] (DRILL-3198) JDBC driver returns null from DatabaseMetaData.getTypeInfo(...)

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14578106#comment-14578106 ] Daniel Barclay (Drill) commented on DRILL-3198: --- Review is at

[jira] [Commented] (DRILL-3262) Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14578104#comment-14578104 ] Daniel Barclay (Drill) commented on DRILL-3262: --- Review is at

[jira] [Created] (DRILL-3263) Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill

2015-06-08 Thread Jason Altekruse (JIRA)
Jason Altekruse created DRILL-3263: -- Summary: Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill Key: DRILL-3263 URL:

[jira] [Resolved] (DRILL-2449) JDBC : DatabaseMetaData.getProcedures should return an empty result set

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) resolved DRILL-2449. --- Resolution: Fixed Resolving because superseded by (fix for) DRILL-3198.

[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1

2015-06-08 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-3257: Fix Version/s: 1.1.0 TPCDS query 74 results in a StackOverflowError on Scale Factor 1

[jira] [Updated] (DRILL-3205) Test framework should report actual values in case of failures

2015-06-08 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-3205: Fix Version/s: 1.2.0 Test framework should report actual values in case of failures

[jira] [Updated] (DRILL-3224) DrillTestWrapper test-failure message doesn't show actual values

2015-06-08 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-3224: Fix Version/s: 1.2.0 DrillTestWrapper test-failure message doesn't show actual values

[jira] [Updated] (DRILL-3251) TPC-DS SF 100 query 37 82 fail with possible memory leak

2015-06-08 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-3251: Fix Version/s: 1.1.0 TPC-DS SF 100 query 37 82 fail with possible memory leak

[jira] [Updated] (DRILL-3172) Can not plan exception when over clause is empty

2015-06-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3172: Labels: window_function (was: ) Can not plan exception when over clause is empty

[jira] [Updated] (DRILL-3198) JDBC driver returns null from DatabaseMetaData.getTypeInfo(...)

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3198: -- Attachment: DRILL-3198.1.patch.txt JDBC driver returns null from

[jira] [Updated] (DRILL-2420) Identify, fix DatabaseMetaData.getColumns() bugs [umbrella]

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2420: -- Description: Drill's implementation of {{DatabaseMetaData.getColumns(...)}}

[jira] [Updated] (DRILL-3262) Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-3262: -- Attachment: DRILL-3262.1.patch.txt Rename missed .impl.DrillDatabaseMetaData

[jira] [Updated] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

2015-06-08 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-3214: Fix Version/s: 1.1.0 Config option to cast empty string to null does not cast empty string to null

[jira] [Updated] (DRILL-2676) Review Drill casting combinations re SQL standard (ISO 9705:2011 part 2 ยง 6.13)

2015-06-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2676: -- Description: Drill doesn't allow casting an expression of an ARRAY type to that

[jira] [Commented] (DRILL-3173) Invalid inputs are NOT handled properly by Window functions

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577341#comment-14577341 ] Deneche A. Hakim commented on DRILL-3173: - Drill/Calcite seem to ignore invalid

[jira] [Closed] (DRILL-3173) Invalid inputs are NOT handled properly by Window functions

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim closed DRILL-3173. --- Resolution: Invalid Invalid inputs are NOT handled properly by Window functions

[jira] [Closed] (DRILL-3255) Queries must fail when invalid-positions are specified in order by clause of a window function

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim closed DRILL-3255. --- Resolution: Invalid Tried a similar query using Calcite and Postgres and both seem to ignore

[jira] [Commented] (DRILL-3255) Queries must fail when invalid-positions are specified in order by clause of a window function

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577355#comment-14577355 ] Deneche A. Hakim commented on DRILL-3255: - More specifically. Postgres

[jira] [Commented] (DRILL-3213) Better error message - Use of aggregate function in order by clause within an over clause

2015-06-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14577452#comment-14577452 ] Deneche A. Hakim commented on DRILL-3213: - Here is the plan for a similar query: