Review Request 35949: DRILL-3151: Fix many ResultSetMetaData method return values.

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/35949/ --- Review request for drill. Bugs: DRILL-3151

[jira] [Created] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

Victoria Markman created DRILL-3414: --- Summary: Window function on a null producing column of an outer join results in the wrong result Key: DRILL-3414 URL: https://issues.apache.org/jira/browse/DRILL-3414

Re: Review Request 36019: Patch for DRILL-3418

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36019/ --- (Updated June 30, 2015, 12:09 a.m.) Review request for drill. Bugs:

[jira] [Created] (DRILL-3417) Filter present in query plan when we should not see one

Khurram Faraaz created DRILL-3417: - Summary: Filter present in query plan when we should not see one Key: DRILL-3417 URL: https://issues.apache.org/jira/browse/DRILL-3417 Project: Apache Drill

[jira] [Created] (DRILL-3418) Partition Pruning : We are over-pruning and this leads to wrong results

Rahul Challapalli created DRILL-3418: Summary: Partition Pruning : We are over-pruning and this leads to wrong results Key: DRILL-3418 URL: https://issues.apache.org/jira/browse/DRILL-3418

[jira] [Resolved] (DRILL-3410) Partition Pruning : We are doing a prune when we shouldn't

[ https://issues.apache.org/jira/browse/DRILL-3410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips resolved DRILL-3410. Resolution: Fixed Fixed by c1998605dc2acdc5fa55792a279a473ff890a010 Partition Pruning :

[jira] [Resolved] (DRILL-3400) After shifting CTAS's data, query on CTAS table failed

[ https://issues.apache.org/jira/browse/DRILL-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3400. --- Resolution: Cannot Reproduce After shifting CTAS's data, query on CTAS table failed

[jira] [Resolved] (DRILL-3346) Windowing query over View should display a better error message

[ https://issues.apache.org/jira/browse/DRILL-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-3346. -- Resolution: Fixed Fix Version/s: (was: 1.2.0) 1.1.0

[jira] [Resolved] (DRILL-3199) GenericAccessor doesn't support isNull

[ https://issues.apache.org/jira/browse/DRILL-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra resolved DRILL-3199. -- Resolution: Fixed Resolved in commit: 6ad3577 GenericAccessor doesn't support isNull

[jira] [Resolved] (DRILL-2272) Tibco Spotfire Desktop configuration for Drill documentation

[ https://issues.apache.org/jira/browse/DRILL-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristine Hahn resolved DRILL-2272. -- Resolution: Fixed Staged:

Re: Review Request 36019: Patch for DRILL-3418

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36019/#review89805 ---

[jira] [Resolved] (DRILL-1784) Ignore boolean type enforcement on filter conditions during validation

[ https://issues.apache.org/jira/browse/DRILL-1784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1784. -- Resolution: Duplicate Ignore boolean type enforcement on filter conditions during

[jira] [Created] (DRILL-3419) Ambiguity in query plan when we do partition pruning

Khurram Faraaz created DRILL-3419: - Summary: Ambiguity in query plan when we do partition pruning Key: DRILL-3419 URL: https://issues.apache.org/jira/browse/DRILL-3419 Project: Apache Drill

[jira] [Resolved] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

[ https://issues.apache.org/jira/browse/DRILL-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-3414. - Resolution: Invalid Window function on a null producing column of an outer join results

Opposite of FLATTEN

Given a data set: 'ndb_no','description' '02001','SPICE OR HERB (US CFR)' '02001','ALLSPICE' '02001','FINELY GROUND' '02001','NOT HEAT-TREATED' '02001','COOKING METHOD NOT APPLICABLE' '02001','WATER REMOVED' '02001','NATURALLY DRIED' '02001','SUN DRIED' I'm seeking the capability to be able

Review Request 36019: Patch for DRILL-3418

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36019/ --- Review request for drill. Bugs: DRILL-3418

Re: Review Request 36019: Patch for DRILL-3418

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36019/#review89830 --- Ship it! Ship It! - Aman Sinha On June 30, 2015, 12:09 a.m.,

Re: Opposite of FLATTEN

Like array_agg in postgres: http://www.craigkerstiens.com/2013/04/17/array-agg/ On Mon, Jun 29, 2015 at 2:23 PM, Jim Scott jsc...@maprtech.com wrote: Given a data set: 'ndb_no','description' '02001','SPICE OR HERB (US CFR)' '02001','ALLSPICE' '02001','FINELY GROUND' '02001','NOT

[jira] [Resolved] (DRILL-3370) FLATTEN error with a where clause

[ https://issues.apache.org/jira/browse/DRILL-3370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-3370. Resolution: Fixed Fixed in a915085e8a8b4255ff659086d047cc5dd874a5bf FLATTEN error with a

Re: Review Request 36019: Patch for DRILL-3418

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36019/#review89828 --- Ship it!

Re: Opposite of FLATTEN

Couldn¹t you write a custom aggregate function in Hive? (I don¹t have one). Thanks, Venky On 6/29/15, 6:41 PM, Ted Dunning ted.dunn...@gmail.com wrote: Like array_agg in postgres: http://www.craigkerstiens.com/2013/04/17/array-agg/ On Mon, Jun 29, 2015 at 2:23 PM, Jim Scott