[jira] [Commented] (HIVE-7232) VectorReduceSink is emitting incorrect JOIN keys

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041785#comment-14041785 ] Gopal V commented on HIVE-7232: --- [~navis]: LGTM +1. I will commit this. As part of my review

[jira] [Updated] (HIVE-2954) The statement fails when a column part of an ORDER BY is not specified in the SELECT.

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2954: Status: Patch Available (was: Open) Running preliminary test > The statement fails when a column part of an ORDER

[jira] [Updated] (HIVE-2954) The statement fails when a column part of an ORDER BY is not specified in the SELECT.

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2954: Attachment: HIVE-2954.4.patch.txt > The statement fails when a column part of an ORDER BY is not specified in the >

Re: branch for cbo work

2014-06-23 Thread Ashutosh Chauhan
Created a branch at https://svn.apache.org/repos/asf/hive/branches/cbo Folks interested to contribute feel free to create jiras and provide patches for branch. Lets advance Hive's optimizer by teaching it how to cost different plans! Thanks, Ashutosh On Mon, Jun 23, 2014 at 11:13 PM, Ashutosh

[jira] [Commented] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread wangmeng (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041761#comment-14041761 ] wangmeng commented on HIVE-7277: well, the MR api can not fit up with this logical pla

[jira] [Commented] (HIVE-7271) Speed up unit tests

2014-06-23 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041755#comment-14041755 ] Szehon Ho commented on HIVE-7271: - +1, thanks a lot for this Gunther. Just for my understa

Re: branch for cbo work

2014-06-23 Thread Ashutosh Chauhan
Seems like folks are in agreement. I will go ahead and create a branch. On Mon, Jun 23, 2014 at 11:40 AM, John Pullokkaran < jpullokka...@hortonworks.com> wrote: > I see that design doc doesn't talk about plug and play aspect of cost > model; and it also doesn't make it clear that cost model des

[jira] [Commented] (HIVE-7258) Move qtest-Driver properties from pom to separate file

2014-06-23 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041746#comment-14041746 ] Szehon Ho commented on HIVE-7258: - Yes thanks a lot, this should work. Let's get it in and

[jira] [Commented] (HIVE-7211) Throws exception if the name of conf var starts with "hive." does not exists in HiveConf

2014-06-23 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041744#comment-14041744 ] Hive QA commented on HIVE-7211: --- {color:red}Overall{color}: -1 at least one tests failed H

[jira] [Commented] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041745#comment-14041745 ] Gopal V commented on HIVE-7277: --- [~wangmeng]: The hive code changes to mark the logical plan

[jira] [Commented] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread wangmeng (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041742#comment-14041742 ] wangmeng commented on HIVE-7277: As I know ,TEZ is a new compute engine different from ma

[jira] [Commented] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread wangmeng (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041741#comment-14041741 ] wangmeng commented on HIVE-7277: As I know ,TEZ is a new compute engine different from

[jira] [Updated] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li updated HIVE-4118: -- Status: Patch Available (was: Open) HIVE-4118.2.patch is generated based on the latest trunk > ANALYZE TABLE .

[jira] [Updated] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li updated HIVE-4118: -- Status: Open (was: Patch Available) > ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully

[jira] [Updated] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li updated HIVE-4118: -- Attachment: HIVE-4118.2.patch Re-created the patch against the latest trunk. > ANALYZE TABLE ... COMPUTE STATIS

[jira] [Commented] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041737#comment-14041737 ] Bing Li commented on HIVE-4118: --- Re-assign this JIRA to myself. > ANALYZE TABLE ... COMPUTE

[jira] [Assigned] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li reassigned HIVE-4118: - Assignee: Bing Li (was: Shreepadma Venugopalan) > ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails

[jira] [Commented] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041733#comment-14041733 ] Gopal V commented on HIVE-7277: --- Yes, this is how HIVE-7158 works. The reducer counts are es

[jira] [Commented] (HIVE-7229) String is compared using equal in HiveMetaStore#HMSHandler#init()

2014-06-23 Thread KangHS (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041732#comment-14041732 ] KangHS commented on HIVE-7229: -- I do re-patch after check/rebase. Thanks for your advice. > S

[jira] [Updated] (HIVE-7229) String is compared using equal in HiveMetaStore#HMSHandler#init()

2014-06-23 Thread KangHS (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] KangHS updated HIVE-7229: - Attachment: HIVE-7229.1.patch > String is compared using equal in HiveMetaStore#HMSHandler#init() > --

[jira] [Updated] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-7090: Status: Patch Available (was: Open) Submitting for test, let's see the result. > Support session-level temporary t

[jira] [Updated] (HIVE-7242) alter table drop partition is acquiring the wrong type of lock

2014-06-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-7242: --- Resolution: Fixed Status: Resolved (was: Patch Available) Committed to trunk. Thanks,

[jira] [Updated] (HIVE-7241) Wrong lock acquired for alter table rename partition

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

[jira] [Updated] (HIVE-6564) WebHCat E2E tests that launch MR jobs fail on check job completion timeout

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

[jira] [Updated] (HIVE-7235) TABLESAMPLE on join table is regarded as alias

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

[jira] [Updated] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li updated HIVE-4118: -- Assignee: Shreepadma Venugopalan (was: Bing Li) > ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when u

[jira] [Created] (HIVE-7277) how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage?

2014-06-23 Thread wangmeng (JIRA)
wangmeng created HIVE-7277: -- Summary: how to decide reduce numbers according to the input size of reduce stage rather than the input size of map stage? Key: HIVE-7277 URL: https://issues.apache.org/jira/browse/HIVE

[jira] [Assigned] (HIVE-4118) ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails when using fully qualified table name

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bing Li reassigned HIVE-4118: - Assignee: Bing Li (was: Shreepadma Venugopalan) > ANALYZE TABLE ... COMPUTE STATISTICS FOR COLUMNS fails

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Jayesh Senjaliya
Congratulations Gopal and Szehon !! On Mon, Jun 23, 2014 at 10:35 AM, Vikram Dixit wrote: > Congrats Gopal and Szehon! > > > On Mon, Jun 23, 2014 at 10:34 AM, Jason Dere > wrote: > >> Congrats! >> >> On Jun 23, 2014, at 10:28 AM, Hari Subramaniyan < >> hsubramani...@hortonworks.com> wrote: >>

[jira] [Created] (HIVE-7276) BaseSemanticAnalyzer.unescapeSQLString fails to parse Windows like path

2014-06-23 Thread Xiaobing Zhou (JIRA)
Xiaobing Zhou created HIVE-7276: --- Summary: BaseSemanticAnalyzer.unescapeSQLString fails to parse Windows like path Key: HIVE-7276 URL: https://issues.apache.org/jira/browse/HIVE-7276 Project: Hive

[jira] [Updated] (HIVE-7258) Move qtest-Driver properties from pom to separate file

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7258: - Attachment: HIVE-7258.1.patch > Move qtest-Driver properties from pom to separate file >

[jira] [Assigned] (HIVE-7258) Move qtest-Driver properties from pom to separate file

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner reassigned HIVE-7258: Assignee: Gunther Hagleitner > Move qtest-Driver properties from pom to separate fil

[jira] [Updated] (HIVE-7258) Move qtest-Driver properties from pom to separate file

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7258: - Status: Patch Available (was: Open) > Move qtest-Driver properties from pom to separate f

[jira] [Commented] (HIVE-7258) Move qtest-Driver properties from pom to separate file

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041691#comment-14041691 ] Gunther Hagleitner commented on HIVE-7258: -- [~szehon] - is that what you were look

[jira] [Commented] (HIVE-7242) alter table drop partition is acquiring the wrong type of lock

2014-06-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041685#comment-14041685 ] Ashutosh Chauhan commented on HIVE-7242: +1 > alter table drop partition is acquir

[jira] [Commented] (HIVE-7241) Wrong lock acquired for alter table rename partition

2014-06-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041679#comment-14041679 ] Ashutosh Chauhan commented on HIVE-7241: +1 > Wrong lock acquired for alter table

[jira] [Commented] (HIVE-6564) WebHCat E2E tests that launch MR jobs fail on check job completion timeout

2014-06-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041678#comment-14041678 ] Ashutosh Chauhan commented on HIVE-6564: +1 > WebHCat E2E tests that launch MR job

[jira] [Commented] (HIVE-2597) Repeated key in GROUP BY is erroneously displayed when using DISTINCT

2014-06-23 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041669#comment-14041669 ] Hive QA commented on HIVE-2597: --- {color:red}Overall{color}: -1 at least one tests failed H

[jira] [Commented] (HIVE-4577) hive CLI can't handle hadoop dfs command with space and quotes.

2014-06-23 Thread Bing Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041657#comment-14041657 ] Bing Li commented on HIVE-4577: --- Hi, [~thejas] Thank you for your comments. I tried StrTokeni

[jira] [Updated] (HIVE-7274) Update PTest2 to JClouds 1.7.3

2014-06-23 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland updated HIVE-7274: --- Resolution: Fixed Fix Version/s: 0.14.0 Status: Resolved (was: Patch Available) Tha

[jira] [Commented] (HIVE-7271) Speed up unit tests

2014-06-23 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041634#comment-14041634 ] Brock Noland commented on HIVE-7271: +1 LGTM Regardless of the memory item, I updated

[jira] [Updated] (HIVE-7271) Speed up unit tests

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7271: - Status: Open (was: Patch Available) > Speed up unit tests > --- > >

[jira] [Updated] (HIVE-7271) Speed up unit tests

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7271: - Attachment: HIVE-7271.6.patch .6 fixes test failures (golden files again). Also includes t

[jira] [Updated] (HIVE-7271) Speed up unit tests

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7271: - Status: Patch Available (was: Open) > Speed up unit tests > --- > >

[jira] [Updated] (HIVE-7194) authorization_ctas.q failing on trunk

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-7194: Resolution: Fixed Fix Version/s: 0.14.0 Status: Resolved (was: Patch Available) Committed to trun

[jira] [Commented] (HIVE-7257) UDF format_number() does not work on FLOAT types

2014-06-23 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041576#comment-14041576 ] Szehon Ho commented on HIVE-7257: - Ah, I guess that is most bits that fit into that float.

[jira] [Commented] (HIVE-7232) VectorReduceSink is emitting incorrect JOIN keys

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041575#comment-14041575 ] Gopal V commented on HIVE-7232: --- [~ashutoshc]: Yes, I will review this today. > VectorReduce

Review Request 22904: Throws exception if the name of conf var starts with "hive." does not exists in HiveConf

2014-06-23 Thread Navis Ryu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/22904/ --- Review request for hive. Bugs: HIVE-7211 https://issues.apache.org/jira/bro

Review Request 22903: Extend join transitivity PPD to non-column expressions

2014-06-23 Thread Navis Ryu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/22903/ --- Review request for hive. Bugs: HIVE-7111 https://issues.apache.org/jira/bro

[jira] [Updated] (HIVE-7211) Throws exception if the name of conf var starts with "hive." does not exists in HiveConf

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-7211: Attachment: HIVE-7211.4.patch.txt > Throws exception if the name of conf var starts with "hive." does not exists >

[jira] [Updated] (HIVE-7237) hive.exec.parallel=true w/ Hive 0.13/Tez causes application to linger forever

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-7237: Resolution: Fixed Fix Version/s: 0.14.0 Status: Resolved (was: Patch Available) Committed to trun

[jira] [Updated] (HIVE-7205) Wrong results when union all of grouping followed by group by with correlation optimization

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-7205: Status: Patch Available (was: Open) > Wrong results when union all of grouping followed by group by with > correla

[jira] [Commented] (HIVE-7257) UDF format_number() does not work on FLOAT types

2014-06-23 Thread Wilbur Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041533#comment-14041533 ] Wilbur Yang commented on HIVE-7257: --- [~szehon], thanks for the review. That particular ca

Review Request 22902: SerDe Properties are not considered by show create table Command

2014-06-23 Thread Navis Ryu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/22902/ --- Review request for hive. Bugs: HIVE-7270 https://issues.apache.org/jira/bro

Review Request 22901: Repeated key in GROUP BY is erroneously displayed when using DISTINCT

2014-06-23 Thread Navis Ryu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/22901/ --- Review request for hive. Bugs: HIVE-2597 https://issues.apache.org/jira/bro

[jira] [Updated] (HIVE-2597) Repeated key in GROUP BY is erroneously displayed when using DISTINCT

2014-06-23 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2597: Attachment: HIVE-2597.4.patch.txt Updated XML results > Repeated key in GROUP BY is erroneously displayed when usin

[jira] [Commented] (HIVE-7257) UDF format_number() does not work on FLOAT types

2014-06-23 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041525#comment-14041525 ] Szehon Ho commented on HIVE-7257: - [~wilbur.yang]. Thanks for this patch, I do have one co

[jira] [Commented] (HIVE-6893) out of sequence error in HiveMetastore server

2014-06-23 Thread Gilad Wolff (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041510#comment-14041510 ] Gilad Wolff commented on HIVE-6893: --- I encountered the same issue, we get a socket read t

[jira] [Updated] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-7090: - Attachment: HIVE-7090.3.patch rebase with trunk > Support session-level temporary tables in Hive > --

[jira] [Updated] (HIVE-7266) Optimized HashTable with vectorized map-joins results in String columns extending

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gopal V updated HIVE-7266: -- Assignee: Matt McCline (was: Jitendra Nath Pandey) > Optimized HashTable with vectorized map-joins results in S

[jira] [Commented] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041399#comment-14041399 ] Jason Dere commented on HIVE-7090: -- Yes good point. The patch actually does this - each s

[jira] [Created] (HIVE-7275) optimize these functions for windowing function.

2014-06-23 Thread Kiet Ly (JIRA)
Kiet Ly created HIVE-7275: - Summary: optimize these functions for windowing function. Key: HIVE-7275 URL: https://issues.apache.org/jira/browse/HIVE-7275 Project: Hive Issue Type: Bug Affects Ver

[jira] [Commented] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041378#comment-14041378 ] Eugene Koifman commented on HIVE-7090: -- In that case it may make sense to generate uni

[jira] [Commented] (HIVE-6469) skipTrash option in hive command line

2014-06-23 Thread Ravi Prakash (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041372#comment-14041372 ] Ravi Prakash commented on HIVE-6469: Can folks watching this JIRA please review HIVE-71

[jira] [Updated] (HIVE-7159) For inner joins push a 'is not null predicate' to the join sources for every non nullSafe join condition

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gunther Hagleitner updated HIVE-7159: - Resolution: Fixed Fix Version/s: 0.14.0 Status: Resolved (was: Patch Ava

[jira] [Commented] (HIVE-7225) Unclosed Statement's in TxnHandler

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041306#comment-14041306 ] Alan Gates commented on HIVE-7225: -- +1 > Unclosed Statement's in TxnHandler > ---

[jira] [Commented] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041304#comment-14041304 ] Jason Dere commented on HIVE-7090: -- The temp table scratch directory is deleted during ses

[jira] [Updated] (HIVE-6207) Integrate HCatalog with locking

2014-06-23 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-6207: - Attachment: ACIDHCatalogDesign.pdf > Integrate HCatalog with locking > ---

[jira] [Commented] (HIVE-7159) For inner joins push a 'is not null predicate' to the join sources for every non nullSafe join condition

2014-06-23 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041282#comment-14041282 ] Gunther Hagleitner commented on HIVE-7159: -- Remaining failures are unrelated. > F

[jira] [Commented] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041250#comment-14041250 ] Eugene Koifman commented on HIVE-7090: -- If the client fails, how does the temp table g

[jira] [Commented] (HIVE-7230) Add Eclipse formatter file for Hive coding conventions

2014-06-23 Thread David Chen (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041189#comment-14041189 ] David Chen commented on HIVE-7230: -- Thanks, Brock! > Add Eclipse formatter file for Hive

[jira] [Commented] (HIVE-7094) Separate out static/dynamic partitioning code in FileRecordWriterContainer

2014-06-23 Thread David Chen (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041188#comment-14041188 ] David Chen commented on HIVE-7094: -- Thanks, Carl and Sushanth! > Separate out static/dyna

[jira] [Commented] (HIVE-7235) TABLESAMPLE on join table is regarded as alias

2014-06-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041183#comment-14041183 ] Harish Butani commented on HIVE-7235: - +1 lgtm > TABLESAMPLE on join table is regarded

[jira] [Commented] (HIVE-7249) HiveTxnManager.closeTxnManger() throws if called after commitTxn()

2014-06-23 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041158#comment-14041158 ] Eugene Koifman commented on HIVE-7249: -- yes, i did turn on DbTxnManager, but since we

[jira] [Updated] (HIVE-7090) Support session-level temporary tables in Hive

2014-06-23 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-7090: - Attachment: HIVE-7090.2.patch Patch v2 moves the management of the temp tables completely to the client si

[jira] [Commented] (HIVE-7249) HiveTxnManager.closeTxnManger() throws if called after commitTxn()

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041135#comment-14041135 ] Alan Gates commented on HIVE-7249: -- TestOrcDynamicPartitioned runs fine in my tests. But

[jira] [Commented] (HIVE-7229) String is compared using equal in HiveMetaStore#HMSHandler#init()

2014-06-23 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041132#comment-14041132 ] Xuefu Zhang commented on HIVE-7229: --- Never mind about above code snippet. > String is co

[jira] [Commented] (HIVE-7229) String is compared using equal in HiveMetaStore#HMSHandler#init()

2014-06-23 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041126#comment-14041126 ] Xuefu Zhang commented on HIVE-7229: --- [~HS] Thanks for working on this. It seemed that you

[jira] [Updated] (HIVE-7246) Hive transaction manager hardwires bonecp as the JDBC pooling implementation

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated HIVE-7246: - Attachment: HIVE-7246-2.patch Rebased patch. > Hive transaction manager hardwires bonecp as the JDBC pool

[jira] [Updated] (HIVE-7246) Hive transaction manager hardwires bonecp as the JDBC pooling implementation

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated HIVE-7246: - Status: Patch Available (was: Open) > Hive transaction manager hardwires bonecp as the JDBC pooling imple

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041115#comment-14041115 ] Xuefu Zhang commented on HIVE-5775: --- Cool. Thanks for the clarifications. > Introduce Co

[jira] [Updated] (HIVE-7246) Hive transaction manager hardwires bonecp as the JDBC pooling implementation

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated HIVE-7246: - Status: Open (was: Patch Available) Patch no longer applies after recent checkins. > Hive transaction m

Re: branch for cbo work

2014-06-23 Thread John Pullokkaran
I see that design doc doesn't talk about plug and play aspect of cost model; and it also doesn't make it clear that cost model described is for Join Algorithm selection; also it doesn't have cost model for MR. I will update the doc appropriately. Thanks John -- CONFIDENTIALITY NOTICE NOTICE: Th

[jira] [Commented] (HIVE-7242) alter table drop partition is acquiring the wrong type of lock

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041101#comment-14041101 ] Alan Gates commented on HIVE-7242: -- dynpart_sort_optimization passes on both trunk and wit

Re: branch for cbo work

2014-06-23 Thread Xuefu Zhang
Thanks for the clarification. I'm happily on board with this as long as our approach takes account of the differences between execution engines. While MR and Tez might be similar, there could be new execution engines in the future which might not be that similar. Ideally, all execution engines shou

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041085#comment-14041085 ] Laljo John Pullokkaran commented on HIVE-5775: -- Cost Model described doesn't a

[jira] [Commented] (HIVE-7274) Update PTest2 to JClouds 1.7.3

2014-06-23 Thread Szehon Ho (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041075#comment-14041075 ] Szehon Ho commented on HIVE-7274: - Thanks for researching that. +1 > Update PTest2 to JC

[jira] [Commented] (HIVE-7241) Wrong lock acquired for alter table rename partition

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041061#comment-14041061 ] Alan Gates commented on HIVE-7241: -- root_dir_external_table and authorization_ctas fail on

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041056#comment-14041056 ] Xuefu Zhang commented on HIVE-5775: --- Thanks for the clarification, [~gopalv]. We are in t

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041053#comment-14041053 ] Laljo John Pullokkaran commented on HIVE-5775: -- Following may help in reducing

Re: branch for cbo work

2014-06-23 Thread John Pullokkaran
Following may help in reducing the confusion: 1. In design doc the cost formula is for choosing Join Algorithm. The cost formula as described in the doc assumes Tez execution. 2. However current work on CBO doesn’t include Join algorithm selection. Instead it rearranges Join based on Join cardina

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Vikram Dixit
Congrats Gopal and Szehon! On Mon, Jun 23, 2014 at 10:34 AM, Jason Dere wrote: > Congrats! > > On Jun 23, 2014, at 10:28 AM, Hari Subramaniyan < > hsubramani...@hortonworks.com> wrote: > > > congrats to Gopal and Szehon! > > > > Thanks > > Hari > > > > > > On Mon, Jun 23, 2014 at 9:59 AM, Xiaob

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Jason Dere
Congrats! On Jun 23, 2014, at 10:28 AM, Hari Subramaniyan wrote: > congrats to Gopal and Szehon! > > Thanks > Hari > > > On Mon, Jun 23, 2014 at 9:59 AM, Xiaobing Zhou > wrote: > >> Congrats! >> >> >> >> On Mon, Jun 23, 2014 at 9:52 AM, Vaibhav Gumashta < >> vgumas...@hortonworks.com >>

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Hari Subramaniyan
congrats to Gopal and Szehon! Thanks Hari On Mon, Jun 23, 2014 at 9:59 AM, Xiaobing Zhou wrote: > Congrats! > > > > On Mon, Jun 23, 2014 at 9:52 AM, Vaibhav Gumashta < > vgumas...@hortonworks.com > > wrote: > > > Congrats Gopal and Szehon! > > > > --Vaibhav > > > > > > On Mon, Jun 23, 2014 at

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14040986#comment-14040986 ] Gopal V commented on HIVE-5775: --- [~xuefuz]: The CBO model rewrites queries using cardinality

[jira] [Commented] (HIVE-5775) Introduce Cost Based Optimizer to Hive

2014-06-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14040970#comment-14040970 ] Laljo John Pullokkaran commented on HIVE-5775: -- The cost model as described in

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Xiaobing Zhou
Congrats! On Mon, Jun 23, 2014 at 9:52 AM, Vaibhav Gumashta wrote: > Congrats Gopal and Szehon! > > --Vaibhav > > > On Mon, Jun 23, 2014 at 8:48 AM, Szehon Ho wrote: > > > Thank you all very much, and congrats Gopal! > > Szehon > > > > > > On Sun, Jun 22, 2014 at 8:42 PM, Carl Steinbach wrot

Re: [ANNOUNCE] New Hive Committers - Gopal Vijayaraghavan and Szehon Ho

2014-06-23 Thread Vaibhav Gumashta
Congrats Gopal and Szehon! --Vaibhav On Mon, Jun 23, 2014 at 8:48 AM, Szehon Ho wrote: > Thank you all very much, and congrats Gopal! > Szehon > > > On Sun, Jun 22, 2014 at 8:42 PM, Carl Steinbach wrote: > > > The Apache Hive PMC has voted to make Gopal Vijayaraghavan and Szehon Ho > > commit

[jira] [Commented] (HIVE-7118) Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables

2014-06-23 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14040929#comment-14040929 ] Alan Gates commented on HIVE-7118: -- +1 > Oracle upgrade schema scripts do not map Java lo

[jira] [Commented] (HIVE-2597) Repeated key in GROUP BY is erroneously displayed when using DISTINCT

2014-06-23 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14040900#comment-14040900 ] Hive QA commented on HIVE-2597: --- {color:red}Overall{color}: -1 at least one tests failed H

  1   2   >