[jira] [Updated] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-3190: - Attachment: HIVE-3190.1.patch patch v1 > allow INTEGER as a type name in a column/cast expression (per IS

[jira] [Updated] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-3190: - Status: Patch Available (was: Open) > allow INTEGER as a type name in a column/cast expression (per ISO-S

[jira] [Updated] (HIVE-5483) use metastore statistics to optimize max/min/etc. queries

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5483: --- Status: Open (was: Patch Available) > use metastore statistics to optimize max/min/etc. queri

[jira] [Updated] (HIVE-5483) use metastore statistics to optimize max/min/etc. queries

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5483: --- Attachment: HIVE-5483.2.patch Rewrote most of the patch. Addressed comments. Added more checks

[jira] [Updated] (HIVE-5483) use metastore statistics to optimize max/min/etc. queries

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5483: --- Status: Patch Available (was: Open) > use metastore statistics to optimize max/min/etc. queri

[jira] [Updated] (HIVE-5681) Validation doesn't catch SMBMapJoin

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5681: --- Resolution: Fixed Fix Version/s: 0.13.0 Status: Resolved (was: Patch Availab

[jira] [Updated] (HIVE-5657) TopN produces incorrect results with count(distinct)

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5657: Status: Patch Available (was: Open) > TopN produces incorrect results with count(distinct) > --

[jira] [Updated] (HIVE-5657) TopN produces incorrect results with count(distinct)

2013-10-30 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-5657: -- Attachment: D13797.1.patch navis requested code review of "HIVE-5657 [jira] TopN produces incorrect res

[jira] [Commented] (HIVE-5657) TopN produces incorrect results with count(distinct)

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13808830#comment-13808830 ] Navis commented on HIVE-5657: - Distinct bug fix + Multi-distinct support. But huge conflict wit

[jira] [Commented] (HIVE-5665) Update PMC status for navis

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13808836#comment-13808836 ] Navis commented on HIVE-5665: - Thanks, guys. I didn't know how to do this. > Update PMC status

[jira] [Created] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
Remus Rusanu created HIVE-5692: -- Summary: Make VectorGroupByOperator parameters configurable Key: HIVE-5692 URL: https://issues.apache.org/jira/browse/HIVE-5692 Project: Hive Issue Type: Sub-tas

[jira] [Commented] (HIVE-3562) Some limit can be pushed down to map stage

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13808846#comment-13808846 ] Navis commented on HIVE-3562: - [~sershe] Sorry for late reply. I thought the cost of top-n hash

[jira] [Updated] (HIVE-4144) Add "select database()" command to show the current database

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4144: Status: Open (was: Patch Available) > Add "select database()" command to show the current database > --

[jira] [Updated] (HIVE-4144) Add "select database()" command to show the current database

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4144: Attachment: HIVE-4144.6.patch.txt Rebased to trunk > Add "select database()" command to show the current database >

[jira] [Updated] (HIVE-4144) Add "select database()" command to show the current database

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4144: Status: Patch Available (was: Open) > Add "select database()" command to show the current database > --

[jira] [Updated] (HIVE-5598) Remove dummy new line at the end of non-sql commands

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5598: Status: Open (was: Patch Available) > Remove dummy new line at the end of non-sql commands > --

[jira] [Updated] (HIVE-5598) Remove dummy new line at the end of non-sql commands

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5598: Status: Patch Available (was: Open) > Remove dummy new line at the end of non-sql commands > --

[jira] [Updated] (HIVE-5598) Remove dummy new line at the end of non-sql commands

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5598: Attachment: HIVE-5598.4.patch.txt fix test results of newly added tests > Remove dummy new line at the end of non-s

[jira] [Created] (HIVE-5693) Rewrite some tests to reduce test time

2013-10-30 Thread Navis (JIRA)
Navis created HIVE-5693: --- Summary: Rewrite some tests to reduce test time Key: HIVE-5693 URL: https://issues.apache.org/jira/browse/HIVE-5693 Project: Hive Issue Type: Test Components: Tests

[jira] [Updated] (HIVE-5693) Rewrite some tests to reduce test time

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5693: Attachment: HIVE-5693.1.patch.txt > Rewrite some tests to reduce test time > --

[jira] [Created] (HIVE-5694) on hbase table, function's result like 'count' or 'sum' is multiplied by the number of map tasks.

2013-10-30 Thread Sam Chen (JIRA)
Sam Chen created HIVE-5694: -- Summary: on hbase table, function's result like 'count' or 'sum' is multiplied by the number of map tasks. Key: HIVE-5694 URL: https://issues.apache.org/jira/browse/HIVE-5694 Pro

[jira] [Updated] (HIVE-5694) on hbase table, function's result like 'count' or 'sum' is multiplied by the number of map tasks.

2013-10-30 Thread Sam Chen (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sam Chen updated HIVE-5694: --- Attachment: HiveHBaseTableInputFormat.java My simple solution of this problem is commenting the code around li

[jira] [Updated] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Remus Rusanu updated HIVE-5692: --- Attachment: HIVE-5692.1.patch Fix by making the constants configurable via the existing hive.groupby.

[jira] [Updated] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Remus Rusanu updated HIVE-5692: --- Attachment: HIVE-5692.2.patch Use new settings to avoid overlap with existing row-mode settings (which

Review Request 15095: Make the VectorGroupByOperator memory pressure factors configurable

2013-10-30 Thread Remus Rusanu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/15095/ --- Review request for hive, Gopal V and Jitendra Pandey. Bugs: HIVE-5692 https

[jira] [Commented] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809109#comment-13809109 ] Remus Rusanu commented on HIVE-5692: https://reviews.apache.org/r/15095/ > Make Vector

[jira] [Commented] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809117#comment-13809117 ] Remus Rusanu commented on HIVE-5692: The implementation is much more aggresive now: -

[jira] [Updated] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Remus Rusanu updated HIVE-5692: --- Status: Patch Available (was: Open) > Make VectorGroupByOperator parameters configurable > --

Jenkins host "master" appears to be misconfigured

2013-10-30 Thread Brock Noland
A bunch of Hive jobs failed with the same error as this hbase job: http://bigtop01.cloudera.org:8080/job/HBase-indexer-94/53/console Brock

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809133#comment-13809133 ] Xuefu Zhang commented on HIVE-3190: --- [~jdere] It might be simpler if we treat those as sy

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809136#comment-13809136 ] Xuefu Zhang commented on HIVE-3190: --- I meant to say this: {code} KW_INT : INT

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809142#comment-13809142 ] Xuefu Zhang commented on HIVE-3190: --- We should really have a preview button here. :) {cod

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809145#comment-13809145 ] Xuefu Zhang commented on HIVE-3190: --- INTEGER needs in ''. I guess you got my point now. :

FYI all precommit jobs failed last night - I have resubmitted them

2013-10-30 Thread Brock Noland
One slave appears to be misconfigured. I have banned that slave and resubmitted all the jobs. http://bigtop01.cloudera.org:8080/view/Hive/job/PreCommit-HIVE-Build/

Review Request 15097: Remove .array() assumptions from ORC RecordReaderImpl and InStream

2013-10-30 Thread Gopal V
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/15097/ --- Review request for hive and Owen O'Malley. Bugs: HIVE-5663 https://issues.a

[jira] [Commented] (HIVE-5663) Refactor ORC RecordReader to operate on direct & wrapped ByteBuffers

2013-10-30 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809169#comment-13809169 ] Gopal V commented on HIVE-5663: --- Opened review request - https://reviews.apache.org/r/15097/

[jira] [Updated] (HIVE-5690) Support subquery for single sourced multi query

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5690: Status: Patch Available (was: Open) > Support subquery for single sourced multi query > ---

[jira] [Updated] (HIVE-5690) Support subquery for single sourced multi query

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5690: Attachment: HIVE-5690.2.patch.txt > Support subquery for single sourced multi query > --

[jira] [Created] (HIVE-5695) PTest2 fix shutdown, duplicate runs, and add client retry

2013-10-30 Thread Brock Noland (JIRA)
Brock Noland created HIVE-5695: -- Summary: PTest2 fix shutdown, duplicate runs, and add client retry Key: HIVE-5695 URL: https://issues.apache.org/jira/browse/HIVE-5695 Project: Hive Issue Type:

[jira] [Commented] (HIVE-5695) PTest2 fix shutdown, duplicate runs, and add client retry

2013-10-30 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809225#comment-13809225 ] Brock Noland commented on HIVE-5695: 1) Propagating a shutdown flag seems appropriate 2

[jira] [Updated] (HIVE-5695) PTest2 fix shutdown, duplicate runs, and add client retry

2013-10-30 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland updated HIVE-5695: --- Attachment: HIVE-5695.patch PTest2 unit tests pass with the attached patch. > PTest2 fix shutdown, du

[jira] [Updated] (HIVE-5695) PTest2 fix shutdown, duplicate runs, and add client retry

2013-10-30 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland updated HIVE-5695: --- Status: Patch Available (was: Open) > PTest2 fix shutdown, duplicate runs, and add client retry > ---

[jira] [Updated] (HIVE-5693) Rewrite some tests to reduce test time

2013-10-30 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-5693: Description: {noformat} [junit] Done query: timestamp_1.q elapsedTime=182s [junit] Done query: timestamp_2.q

[jira] [Commented] (HIVE-5581) Implement vectorized year/month/day... etc. for string arguments

2013-10-30 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809287#comment-13809287 ] Eric Hanson commented on HIVE-5581: --- Teddy, Thanks for the patch. I think there is in er

[jira] [Commented] (HIVE-5695) PTest2 fix shutdown, duplicate runs, and add client retry

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809289#comment-13809289 ] Ashutosh Chauhan commented on HIVE-5695: +1 > PTest2 fix shutdown, duplicate runs,

[jira] [Commented] (HIVE-5354) Decimal precision/scale support in ORC file

2013-10-30 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809312#comment-13809312 ] Hive QA commented on HIVE-5354: --- {color:green}Overall{color}: +1 all checks pass Here are

[jira] [Created] (HIVE-5696) WebHCat e2e tests/jobsubmission.conf file is malformed and loosing tests

2013-10-30 Thread Eugene Koifman (JIRA)
Eugene Koifman created HIVE-5696: Summary: WebHCat e2e tests/jobsubmission.conf file is malformed and loosing tests Key: HIVE-5696 URL: https://issues.apache.org/jira/browse/HIVE-5696 Project: Hive

[jira] [Updated] (HIVE-5696) WebHCat e2e tests/jobsubmission.conf file is malformed and loosing tests

2013-10-30 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-5696: - Attachment: HIVE-5696.patch NO PRECOMMIT TESTS > WebHCat e2e tests/jobsubmission.conf file is mal

[jira] [Commented] (HIVE-5582) Implement BETWEEN filter in vectorized mode

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809349#comment-13809349 ] Ashutosh Chauhan commented on HIVE-5582: +1 Seems like timestamp type is also suppo

[jira] [Resolved] (HIVE-5696) WebHCat e2e tests/jobsubmission.conf file is malformed and loosing tests

2013-10-30 Thread Daniel Dai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Dai resolved HIVE-5696. -- Resolution: Fixed Fix Version/s: 0.13.0 Hadoop Flags: Reviewed +1. Patch committed to trunk

[jira] [Updated] (HIVE-5693) Rewrite some tests to reduce test time

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5693: --- Status: Patch Available (was: Open) +1 Marking Patch Available for Hive QA to run. > Rewrite

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Issue Type: Sub-task (was: Bug) Parent: HIVE-3667 > Correlation Optimizer may generate wrong plans fo

[jira] [Created] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
Yin Huai created HIVE-5697: -- Summary: Correlation Optimizer may generate wrong plans for cases involving outer join Key: HIVE-5697 URL: https://issues.apache.org/jira/browse/HIVE-5697 Project: Hive

[jira] [Created] (HIVE-5698) A few test file missing apache license header

2013-10-30 Thread Xuefu Zhang (JIRA)
Xuefu Zhang created HIVE-5698: - Summary: A few test file missing apache license header Key: HIVE-5698 URL: https://issues.apache.org/jira/browse/HIVE-5698 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Attachment: HIVE-5697.1.patch Will add test later. > Correlation Optimizer may generate wrong plans for cases

[jira] [Updated] (HIVE-5698) A few test file missing apache license header

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-5698: -- Status: Patch Available (was: Open) > A few test file missing apache license header > -

[jira] [Updated] (HIVE-5698) A few test file missing apache license header

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-5698: -- Attachment: HIVE-5698.patch > A few test file missing apache license header > --

[jira] [Updated] (HIVE-5692) Make VectorGroupByOperator parameters configurable

2013-10-30 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Remus Rusanu updated HIVE-5692: --- Attachment: HIVE-5692.3.patch Added hive.vectorized.groupby.maxentries (100) to cap the max number

[jira] [Commented] (HIVE-5698) A few test file missing apache license header

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809390#comment-13809390 ] Ashutosh Chauhan commented on HIVE-5698: +1 > A few test file missing apache licen

[jira] [Updated] (HIVE-5698) A few test file missing apache license header

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5698: --- Resolution: Fixed Fix Version/s: 0.13.0 Status: Resolved (was: Patch Availab

Re: Review Request 15095: Make the VectorGroupByOperator memory pressure factors configurable

2013-10-30 Thread Remus Rusanu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/15095/ --- (Updated Oct. 30, 2013, 6:10 p.m.) Review request for hive, Gopal V and Jitendr

[jira] [Commented] (HIVE-5582) Implement BETWEEN filter in vectorized mode

2013-10-30 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809429#comment-13809429 ] Eric Hanson commented on HIVE-5582: --- ok Thanks! > Implement BETWEEN filter in vectorized

[jira] [Updated] (HIVE-5698) A few test files missing apache license header

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-5698: -- Summary: A few test files missing apache license header (was: A few test file missing apache license he

[jira] [Updated] (HIVE-5699) Add unit test for vectorized BETWEEN for timestamp inputs

2013-10-30 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-5699: -- Assignee: (was: Eric Hanson) > Add unit test for vectorized BETWEEN for timestamp inputs > -

[jira] [Created] (HIVE-5699) Add unit test for vectorized BETWEEN for timestamp inputs

2013-10-30 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-5699: - Summary: Add unit test for vectorized BETWEEN for timestamp inputs Key: HIVE-5699 URL: https://issues.apache.org/jira/browse/HIVE-5699 Project: Hive Issue Type: Su

[jira] [Updated] (HIVE-5699) Add unit test for vectorized BETWEEN for timestamp inputs

2013-10-30 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-5699: -- Assignee: Eric Hanson (was: Jitendra Nath Pandey) > Add unit test for vectorized BETWEEN for timestamp

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809432#comment-13809432 ] Jason Dere commented on HIVE-3190: -- I can change it for the aliases which are just a singl

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Status: Patch Available (was: Open) > Correlation Optimizer may generate wrong plans for cases involving oute

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Attachment: HIVE-5697.2.patch added a test query > Correlation Optimizer may generate wrong plans for cases i

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Attachment: (was: HIVE-5697.2.patch) > Correlation Optimizer may generate wrong plans for cases involving

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Status: Open (was: Patch Available) > Correlation Optimizer may generate wrong plans for cases involving oute

[jira] [Commented] (HIVE-5679) add date support to metastore JDO/SQL

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809447#comment-13809447 ] Ashutosh Chauhan commented on HIVE-5679: I think we need to add support in Filter.g

[jira] [Commented] (HIVE-5655) Hive incorrecly handles divide-by-zero case

2013-10-30 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809452#comment-13809452 ] Hive QA commented on HIVE-5655: --- {color:green}Overall{color}: +1 all checks pass Here are

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Attachment: HIVE-5697.2.patch > Correlation Optimizer may generate wrong plans for cases involving outer join

[jira] [Commented] (HIVE-5286) Negative test date_literal1.q fails on java7 because the syntax is valid

2013-10-30 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809456#comment-13809456 ] Szehon Ho commented on HIVE-5286: - [~brocknoland], I am wondering what this test was trying

Review Request 15101: HIVE-5697: Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/15101/ --- Review request for hive. Bugs: HIVE-5697 https://issues.apache.org/jira/bro

[jira] [Updated] (HIVE-5697) Correlation Optimizer may generate wrong plans for cases involving outer join

2013-10-30 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5697: --- Status: Patch Available (was: Open) > Correlation Optimizer may generate wrong plans for cases involving oute

[jira] [Assigned] (HIVE-5626) enable metastore direct SQL for drop/similar queries

2013-10-30 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin reassigned HIVE-5626: -- Assignee: Sergey Shelukhin > enable metastore direct SQL for drop/similar queries >

[jira] [Updated] (HIVE-5626) enable metastore direct SQL for drop/similar queries

2013-10-30 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5626: --- Status: Patch Available (was: Open) > enable metastore direct SQL for drop/similar queries >

[jira] [Updated] (HIVE-5626) enable metastore direct SQL for drop/similar queries

2013-10-30 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5626: --- Status: Open (was: Patch Available) > enable metastore direct SQL for drop/similar queries >

[jira] [Commented] (HIVE-5425) Provide a configuration option to control the default stripe size for ORC

2013-10-30 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809463#comment-13809463 ] Gunther Hagleitner commented on HIVE-5425: -- [~thejas] & [~brocknoland] I believe [

[jira] [Updated] (HIVE-5425) Provide a configuration option to control the default stripe size for ORC

2013-10-30 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5425: Status: Patch Available (was: Open) Ok, that makes sense. Thanks [~hagleitn]. +1 Making it patch av

[jira] [Commented] (HIVE-5286) Negative test date_literal1.q fails on java7 because the syntax is valid

2013-10-30 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809472#comment-13809472 ] Brock Noland commented on HIVE-5286: Perhaps we can just remove this test. Looks like d

[jira] [Updated] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-3190: - Attachment: HIVE-3190.2.patch Tried doing Xuefu's suggestion of doing some of the aliases as lexer rules.

[jira] [Commented] (HIVE-5286) Negative test date_literal1.q fails on java7 because the syntax is valid

2013-10-30 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809487#comment-13809487 ] Szehon Ho commented on HIVE-5286: - Sounds good, thanks. > Negative test date_literal1.q fa

[jira] [Assigned] (HIVE-5286) Negative test date_literal1.q fails on java7 because the syntax is valid

2013-10-30 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Szehon Ho reassigned HIVE-5286: --- Assignee: Szehon Ho > Negative test date_literal1.q fails on java7 because the syntax is valid > -

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809490#comment-13809490 ] Xuefu Zhang commented on HIVE-3190: --- Not sure I understand the problem. Don't you mean to

[jira] [Commented] (HIVE-5286) Negative test date_literal1.q fails on java7 because the syntax is valid

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809482#comment-13809482 ] Jason Dere commented on HIVE-5286: -- No preference, you can go ahead and remove it. > Nega

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809497#comment-13809497 ] Jason Dere commented on HIVE-3190: -- The issue would have been if we had put the folliowing

[jira] [Commented] (HIVE-5679) add date support to metastore JDO/SQL

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809484#comment-13809484 ] Ashutosh Chauhan commented on HIVE-5679: [~jdere] Shall we assume string represen

[jira] [Commented] (HIVE-5679) add date support to metastore JDO/SQL

2013-10-30 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809502#comment-13809502 ] Jason Dere commented on HIVE-5679: -- So one thing that was just brought to my attention 10

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809503#comment-13809503 ] Xuefu Zhang commented on HIVE-3190: --- Got it. Thanks for the explanation. I think we can h

Re: Review Request 14953: Pushdown join conditions

2013-10-30 Thread Ashutosh Chauhan
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/14953/#review27806 --- ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out

[jira] [Commented] (HIVE-5556) Pushdown join conditions

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809518#comment-13809518 ] Ashutosh Chauhan commented on HIVE-5556: [~rhbutani] +1 for current Patch. Can you

[jira] [Commented] (HIVE-5626) enable metastore direct SQL for drop/similar queries

2013-10-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809526#comment-13809526 ] Ashutosh Chauhan commented on HIVE-5626: If we have config enabled by default, then

[jira] [Commented] (HIVE-5664) Drop cascade database fails when the db has any tables with indexes

2013-10-30 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13809548#comment-13809548 ] Hive QA commented on HIVE-5664: --- {color:green}Overall{color}: +1 all checks pass Here are

[jira] [Updated] (HIVE-4523) round() function with specified decimal places not consistent with mysql

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-4523: -- Status: Patch Available (was: Open) > round() function with specified decimal places not consistent wit

[jira] [Updated] (HIVE-4523) round() function with specified decimal places not consistent with mysql

2013-10-30 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-4523: -- Attachment: HIVE-4523.3.patch Patch #3 added test cases. > round() function with specified decimal plac

Review Request 15103: HIVe-4523: round() function with specified decimal places not consistent with mysql

2013-10-30 Thread Xuefu Zhang
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/15103/ --- Review request for hive. Bugs: HIVE-4523 https://issues.apache.org/jira/bro

Re: Review Request 14953: Pushdown join conditions

2013-10-30 Thread Harish Butani
> On Oct. 30, 2013, 7:43 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out, lines 497-500 > > > > > > If I am reading this right, this is cross followed by filter. An > >

  1   2   3   >