[jira] [Commented] (HIVE-4663) Needlessly adding analytical windowing columns to my select

2013-07-19 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13714201#comment-13714201 ] Harish Butani commented on HIVE-4663: - You can express this as: {noformat} select

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-07-30 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13724866#comment-13724866 ] Harish Butani commented on HIVE-896: The syntax now is different from the original

[jira] [Created] (HIVE-4963) Support in memory PTF partitions

2013-07-30 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4963: --- Summary: Support in memory PTF partitions Key: HIVE-4963 URL: https://issues.apache.org/jira/browse/HIVE-4963 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-4964) Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced

2013-07-30 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4964: --- Summary: Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced Key: HIVE-4964 URL: https://issues.apache.org/jira/browse/HIVE-4964

[jira] [Created] (HIVE-4965) Add support so that PTFs can stream their output; Windowing PTF should do this

2013-07-30 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4965: --- Summary: Add support so that PTFs can stream their output; Windowing PTF should do this Key: HIVE-4965 URL: https://issues.apache.org/jira/browse/HIVE-4965 Project:

[jira] [Created] (HIVE-4966) Introduce Collect_Map UDAF

2013-07-31 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4966: --- Summary: Introduce Collect_Map UDAF Key: HIVE-4966 URL: https://issues.apache.org/jira/browse/HIVE-4966 Project: Hive Issue Type: Bug Reporter:

[jira] [Commented] (HIVE-4966) Introduce Collect_Map UDAF

2013-07-31 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13725882#comment-13725882 ] Harish Butani commented on HIVE-4966: - For my understanding, are you adding a new

[jira] [Commented] (HIVE-4964) Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced

2013-08-05 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13730044#comment-13730044 ] Harish Butani commented on HIVE-4964: - Yes the formatting issues are long overdue.

[jira] [Commented] (HIVE-4964) Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced

2013-08-07 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13732741#comment-13732741 ] Harish Butani commented on HIVE-4964: - No just dead code removal. This code was

[jira] [Commented] (HIVE-4964) Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced

2013-08-07 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13732921#comment-13732921 ] Harish Butani commented on HIVE-4964: - This one depends on HIVE-4963. Can you review

[jira] [Commented] (HIVE-4964) Cleanup PTF code: remove code dealing with non standard sql behavior we had original introduced

2013-08-07 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13732994#comment-13732994 ] Harish Butani commented on HIVE-4964: - This was not meant to be a jira for cleanup of

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-08-09 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13735038#comment-13735038 ] Harish Butani commented on HIVE-4963: - We already do this. The rows are accumulated in

[jira] [Updated] (HIVE-4963) Support in memory PTF partitions

2013-08-13 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-4963: Attachment: PTFRowContainer.patch Support in memory PTF partitions

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-08-13 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13738692#comment-13738692 ] Harish Butani commented on HIVE-4963: - [~ashutoshc] have attached a patch with

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-08-13 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13738822#comment-13738822 ] Harish Butani commented on HIVE-4963: - - PTFRecordWriter is needed to provide access to

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-08-15 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13741665#comment-13741665 ] Harish Butani commented on HIVE-4963: - This is to get around the issue of XMLEncoder

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-08-15 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13741680#comment-13741680 ] Harish Butani commented on HIVE-4963: - No XMLEncoder doesn't honor the transient

[jira] [Created] (HIVE-5125) Better error messages from Windowing queries

2013-08-20 Thread Harish Butani (JIRA)
Harish Butani created HIVE-5125: --- Summary: Better error messages from Windowing queries Key: HIVE-5125 URL: https://issues.apache.org/jira/browse/HIVE-5125 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-4214) OVER accepts general expression instead of just function

2013-08-20 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13745246#comment-13745246 ] Harish Butani commented on HIVE-4214: - +1 OVER accepts general

[jira] [Commented] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13751961#comment-13751961 ] Harish Butani commented on HIVE-5164: - +1 thanks [~thejas] add Thejas

[jira] [Commented] (HIVE-5129) Multiple table insert fails on count(distinct)

2013-08-30 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13755324#comment-13755324 ] Harish Butani commented on HIVE-5129: - +1 will commit if tests pass

[jira] [Updated] (HIVE-5129) Multiple table insert fails on count(distinct)

2013-09-03 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-5129: Resolution: Fixed Status: Resolved (was: Patch Available) Multiple table insert fails

[jira] [Commented] (HIVE-5129) Multiple table insert fails on count(distinct)

2013-09-03 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13756812#comment-13756812 ] Harish Butani commented on HIVE-5129: - Committed to trunk. Thanks, Vikram!

[jira] [Commented] (HIVE-5087) Rename npath UDF

2013-09-08 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13761480#comment-13761480 ] Harish Butani commented on HIVE-5087: - [~cartershanklin] suggested 'matchPath'; imho

[jira] [Commented] (HIVE-5087) Rename npath UDF

2013-09-08 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13761492#comment-13761492 ] Harish Butani commented on HIVE-5087: - Just tried to apply the patch. Have the same

[jira] [Commented] (HIVE-5087) Rename npath UDF

2013-09-08 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13761504#comment-13761504 ] Harish Butani commented on HIVE-5087: - Patch applies now, but patch doesn't remove

[jira] [Commented] (HIVE-5087) Rename npath UDF

2013-09-08 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13761508#comment-13761508 ] Harish Butani commented on HIVE-5087: - {noformat} I turned my attention away from the

[jira] [Commented] (HIVE-4998) support jdbc documented table types in default configuration

2013-09-13 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13767025#comment-13767025 ] Harish Butani commented on HIVE-4998: - +1 will commit once tests pass

[jira] [Updated] (HIVE-4998) support jdbc documented table types in default configuration

2013-09-16 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-4998: Resolution: Fixed Fix Version/s: 0.12.0 Status: Resolved (was: Patch Available)

[jira] [Commented] (HIVE-5297) Hive does not honor type for partition columns

2013-09-20 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13773414#comment-13773414 ] Harish Butani commented on HIVE-5297: - +1 thanks Vikram, will commit.

[jira] [Commented] (HIVE-4891) Distinct includes duplicate records

2013-09-20 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13773683#comment-13773683 ] Harish Butani commented on HIVE-4891: - I am not able to reproduce. Tried the scenario

[jira] [Commented] (HIVE-4963) Support in memory PTF partitions

2013-09-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13775896#comment-13775896 ] Harish Butani commented on HIVE-4963: - Sorry forgot to respond. Original plan was to

[jira] [Commented] (HIVE-4661) Unable to wrap analytical function in another function

2013-09-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13775912#comment-13775912 ] Harish Butani commented on HIVE-4661: - This is fixed with HIVE-4214. Can you retry with

[jira] [Commented] (HIVE-5297) Hive does not honor type for partition columns

2013-09-27 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13780016#comment-13780016 ] Harish Butani commented on HIVE-5297: - +1 Hive does not honor type

[jira] [Updated] (HIVE-5297) Hive does not honor type for partition columns

2013-09-27 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-5297: Resolution: Fixed Fix Version/s: 0.12.0 Status: Resolved (was: Patch Available)

[jira] [Updated] (HIVE-784) Support uncorrelated subqueries in the WHERE clause

2013-10-02 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-784: --- Attachment: HIVE-784.2.patch SubQuerySpec.pdf Support uncorrelated subqueries in the

[jira] [Commented] (HIVE-784) Support uncorrelated subqueries in the WHERE clause

2013-10-02 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13784810#comment-13784810 ] Harish Butani commented on HIVE-784: Uploaded a Spec and preliminary patch. Has support

[jira] [Updated] (HIVE-784) Support uncorrelated subqueries in the WHERE clause

2013-10-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-784: --- Attachment: tpchQueriesUsingSubQueryClauses.sql Support uncorrelated subqueries in the WHERE clause

[jira] [Commented] (HIVE-784) Support uncorrelated subqueries in the WHERE clause

2013-10-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13786749#comment-13786749 ] Harish Butani commented on HIVE-784: Just uploaded a script with tpch queries Q4, Q15,

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559154#comment-13559154 ] Harish Butani commented on HIVE-896: Alan, Thanks for spending the time. Yes your e.g.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559263#comment-13559263 ] Harish Butani commented on HIVE-896: Its https://github.com/hbutani/hive (ptf branch)

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13560860#comment-13560860 ] Harish Butani commented on HIVE-896: Alan, I have attached a document describing the

[jira] [Updated] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-896: --- Attachment: (was: DataStructs.html) Add LEAD/LAG/FIRST/LAST analytical windowing functions to

[jira] [Updated] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-896: --- Attachment: DataStructs.pdf Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13561145#comment-13561145 ] Harish Butani commented on HIVE-896: Done. Sorry about that. Add

[jira] [Updated] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-896: --- Attachment: Hive-896.2.patch.txt Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13563594#comment-13563594 ] Harish Butani commented on HIVE-896: Hi, Just posted a second preliminary patch. This

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13563617#comment-13563617 ] Harish Butani commented on HIVE-896: No this needs addressing. Currently the Definition

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-30 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567271#comment-13567271 ] Harish Butani commented on HIVE-896: Yes, exactly. Will start to introduce the new Spec

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568035#comment-13568035 ] Harish Butani commented on HIVE-896: can you try set

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568425#comment-13568425 ] Harish Butani commented on HIVE-896: Ashutosh, So the plan looks like this: ... -

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569257#comment-13569257 ] Harish Butani commented on HIVE-896: Yes you got most of it correct. So if there are no

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569345#comment-13569345 ] Harish Butani commented on HIVE-896: Yes Aster is the one I had looked at too. The other

[jira] [Updated] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-896: --- Attachment: hive-896.3.patch.txt Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570306#comment-13570306 ] Harish Butani commented on HIVE-896: Attached patch to be used as starting point for

[jira] [Updated] (HIVE-3981) Split up tests in ptf_general_queries.q

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3981: Attachment: part.seq part.rc Split up tests in ptf_general_queries.q

[jira] [Commented] (HIVE-3981) Split up tests in ptf_general_queries.q

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570485#comment-13570485 ] Harish Butani commented on HIVE-3981: - I attached the files. Several things: - the rc

[jira] [Commented] (HIVE-3981) Split up tests in ptf_general_queries.q

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570809#comment-13570809 ] Harish Butani commented on HIVE-3981: - Oh yes, I forgot. +1 Split up

[jira] [Commented] (HIVE-3982) Merge PTFDesc and PTFDef classes

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570832#comment-13570832 ] Harish Butani commented on HIVE-3982: - Hi Ashutosh, Thanks for doing this. Looks like

[jira] [Created] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-04 Thread Harish Butani (JIRA)
Harish Butani created HIVE-3984: --- Summary: Maintain a clear separation between Windowing PTF at the specification level. Key: HIVE-3984 URL: https://issues.apache.org/jira/browse/HIVE-3984 Project:

[jira] [Created] (HIVE-3985) Update new UDAFs introduced for Windowing to work with new Decimal Type

2013-02-04 Thread Harish Butani (JIRA)
Harish Butani created HIVE-3985: --- Summary: Update new UDAFs introduced for Windowing to work with new Decimal Type Key: HIVE-3985 URL: https://issues.apache.org/jira/browse/HIVE-3985 Project: Hive

[jira] [Created] (HIVE-3986) Fix select expr processing in PTF Operator

2013-02-04 Thread Harish Butani (JIRA)
Harish Butani created HIVE-3986: --- Summary: Fix select expr processing in PTF Operator Key: HIVE-3986 URL: https://issues.apache.org/jira/browse/HIVE-3986 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-3982) Merge PTFDesc and PTFDef classes

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570883#comment-13570883 ] Harish Butani commented on HIVE-3982: - +1 Merge PTFDesc and PTFDef

[jira] [Created] (HIVE-3987) Update PTF invocation and windowing grammar

2013-02-04 Thread Harish Butani (JIRA)
Harish Butani created HIVE-3987: --- Summary: Update PTF invocation and windowing grammar Key: HIVE-3987 URL: https://issues.apache.org/jira/browse/HIVE-3987 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-4028) Bring paranthesis handling in windowing specification in compliance with sql standard

2013-02-15 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13579701#comment-13579701 ] Harish Butani commented on HIVE-4028: - +1 you mean this worked: {noformat} select

[jira] [Commented] (HIVE-4030) Name windowing function in consistence with sql standard

2013-02-16 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13580014#comment-13580014 ] Harish Butani commented on HIVE-4030: - +1 Name windowing function in

[jira] [Commented] (HIVE-4031) Add apache headers in new files

2013-02-16 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13580016#comment-13580016 ] Harish Butani commented on HIVE-4031: - +1 Add apache headers in new

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Attachment: HIVE-3984.1.patch.txt Maintain a clear separation between Windowing PTF at the

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Assignee: Harish Butani Maintain a clear separation between Windowing PTF at the

[jira] [Commented] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13580841#comment-13580841 ] Harish Butani commented on HIVE-3984: - Patch is attached. - Spec and Def classes are

[jira] [Created] (HIVE-4035) Column Pruner for PTF Op

2013-02-18 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4035: --- Summary: Column Pruner for PTF Op Key: HIVE-4035 URL: https://issues.apache.org/jira/browse/HIVE-4035 Project: Hive Issue Type: Bug Components:

[jira] [Created] (HIVE-4036) remove use of FunctionRegistry during PTF Op initialization

2013-02-18 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4036: --- Summary: remove use of FunctionRegistry during PTF Op initialization Key: HIVE-4036 URL: https://issues.apache.org/jira/browse/HIVE-4036 Project: Hive Issue

[jira] [Created] (HIVE-4037) Merge a PTFOp for PTF invocation and a PTFOp for Windowing if possible

2013-02-18 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4037: --- Summary: Merge a PTFOp for PTF invocation and a PTFOp for Windowing if possible Key: HIVE-4037 URL: https://issues.apache.org/jira/browse/HIVE-4037 Project: Hive

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Attachment: HIVE-3984.2.patch.txt Maintain a clear separation between Windowing PTF at the

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Attachment: (was: HIVE-3984.2.patch.txt) Maintain a clear separation between Windowing

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Attachment: HIVE-3984.2.patch.txt Maintain a clear separation between Windowing PTF at the

[jira] [Commented] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-18 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13580916#comment-13580916 ] Harish Butani commented on HIVE-3984: - Have responded to your comments. Attached patch

[jira] [Updated] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-19 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-3984: Attachment: HIVE-3984.3.patch.txt Maintain a clear separation between Windowing PTF at the

[jira] [Commented] (HIVE-3984) Maintain a clear separation between Windowing PTF at the specification level.

2013-02-19 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13581860#comment-13581860 ] Harish Butani commented on HIVE-3984: - patch attached. - added the comments - many of

[jira] [Created] (HIVE-4040) fix ptf negative tests

2013-02-19 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4040: --- Summary: fix ptf negative tests Key: HIVE-4040 URL: https://issues.apache.org/jira/browse/HIVE-4040 Project: Hive Issue Type: Bug Components:

[jira] [Created] (HIVE-4041) Support multiple partitionings in a single Query

2013-02-19 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4041: --- Summary: Support multiple partitionings in a single Query Key: HIVE-4041 URL: https://issues.apache.org/jira/browse/HIVE-4041 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-4040) fix ptf negative tests

2013-02-19 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13581985#comment-13581985 ] Harish Butani commented on HIVE-4040: - +1 looks good; just ran the tests and

[jira] [Commented] (HIVE-4048) Allow partition by/order by in partitioning spec in over clause and partition function

2013-02-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13583728#comment-13583728 ] Harish Butani commented on HIVE-4048: - +1 Allow partition by/order by

[jira] [Commented] (HIVE-4035) Column Pruner for PTF Op

2013-02-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13583943#comment-13583943 ] Harish Butani commented on HIVE-4035: - Ashutosh can you please review. We have

[jira] [Updated] (HIVE-4036) remove use of FunctionRegistry during PTF Op initialization

2013-02-22 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-4036: Attachment: HIVE-4036.1.patch.txt remove use of FunctionRegistry during PTF Op initialization

[jira] [Commented] (HIVE-4036) remove use of FunctionRegistry during PTF Op initialization

2013-02-22 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13584572#comment-13584572 ] Harish Butani commented on HIVE-4036: - patch attached. apply after 4035, because

[jira] [Updated] (HIVE-4052) Disallow partition/sort and distribute/order combinations in windowing and partitioning spec

2013-02-25 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-4052: Attachment: HIVE-4052.1.patch.txt Disallow partition/sort and distribute/order combinations in

[jira] [Commented] (HIVE-4052) Disallow partition/sort and distribute/order combinations in windowing and partitioning spec

2013-02-25 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13586323#comment-13586323 ] Harish Butani commented on HIVE-4052: - patch attached. Disallow

[jira] [Created] (HIVE-4080) Add Lead Lag UDAFs

2013-02-26 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4080: --- Summary: Add Lead Lag UDAFs Key: HIVE-4080 URL: https://issues.apache.org/jira/browse/HIVE-4080 Project: Hive Issue Type: Bug Components:

[jira] [Created] (HIVE-4081) allow expressions with over clause

2013-02-26 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4081: --- Summary: allow expressions with over clause Key: HIVE-4081 URL: https://issues.apache.org/jira/browse/HIVE-4081 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-4082) Break up ptf tests in PTF, Windowing and Lead/Lag tests

2013-02-26 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4082: --- Summary: Break up ptf tests in PTF, Windowing and Lead/Lag tests Key: HIVE-4082 URL: https://issues.apache.org/jira/browse/HIVE-4082 Project: Hive Issue Type:

[jira] [Created] (HIVE-4083) PTF ColumnPruner doesn't account for Partition Order expressions

2013-02-26 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4083: --- Summary: PTF ColumnPruner doesn't account for Partition Order expressions Key: HIVE-4083 URL: https://issues.apache.org/jira/browse/HIVE-4083 Project: Hive

[jira] [Created] (HIVE-4084) Generated aliases for windowing expressions is broken

2013-02-26 Thread Harish Butani (JIRA)
Harish Butani created HIVE-4084: --- Summary: Generated aliases for windowing expressions is broken Key: HIVE-4084 URL: https://issues.apache.org/jira/browse/HIVE-4084 Project: Hive Issue Type:

[jira] [Updated] (HIVE-4080) Add Lead Lag UDAFs

2013-02-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harish Butani updated HIVE-4080: Attachment: HIVE-4080.1.patch.txt Add Lead Lag UDAFs

[jira] [Commented] (HIVE-4080) Add Lead Lag UDAFs

2013-02-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13588041#comment-13588041 ] Harish Butani commented on HIVE-4080: - patch attached Add Lead Lag

[jira] [Commented] (HIVE-4080) Add Lead Lag UDAFs

2013-02-27 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13588560#comment-13588560 ] Harish Butani commented on HIVE-4080: - Yes, there are several related issues: 1.

[jira] [Commented] (HIVE-4073) Make partition by optional in over clause

2013-02-28 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1358#comment-1358 ] Harish Butani commented on HIVE-4073: - The ptf_negative_AggrFuncsWithNoGBYNoPartDef

[jira] [Commented] (HIVE-4110) Aggregation functions must have aliases when multiple functions are used

2013-03-02 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13591551#comment-13591551 ] Harish Butani commented on HIVE-4110: - this is going to get fixed with 4081. We don't

[jira] [Commented] (HIVE-4081) allow expressions with over clause

2013-03-02 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13591664#comment-13591664 ] Harish Butani commented on HIVE-4081: - This also includes the fix for the alias issue:

[jira] [Commented] (HIVE-4112) Window range specification should be more flexible

2013-03-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13592284#comment-13592284 ] Harish Butani commented on HIVE-4112: - Would these rules be sufficient: Range based

  1   2   3   4   5   6   7   8   9   10   >