[jira] [Updated] (HIVE-18537) [Calcite-CBO] Queries with a nested distinct clause and a windowing function seem to fail with calcite Assertion error

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-18537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-18537: - Affects Version/s: 3.1.2 > [Calcite-CBO] Queries with a nested distinct clause and a windowing function

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Description: One way to reproduce:   {code:sql} CREATE TABLE test( `device_id` string, `level` strin

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Description: One way to reproduce:   {code:sql} CREATE TABLE test( `device_id` string, `level` strin

[jira] [Commented] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17195807#comment-17195807 ] Nemon Lou commented on HIVE-24165: -- In fact , i reproduce this issue by apply HIVE-22448

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Attachment: HIVE-24165.patch > CBO: Query fails after multiple count distinct rewrite >

[jira] [Commented] (HIVE-10781) HadoopJobExecHelper Leaks RunningJobs

2015-05-21 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14553972#comment-14553972 ] Nemon Lou commented on HIVE-10781: -- Thanks for providing this patch. :) I think this patc

[jira] [Commented] (HIVE-10781) HadoopJobExecHelper Leaks RunningJobs

2015-05-21 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1404#comment-1404 ] Nemon Lou commented on HIVE-10781: -- I think " Utilities.clearWork(job); " should also be

[jira] [Commented] (HIVE-10817) Blacklist For Bad MetaStore

2015-05-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14558043#comment-14558043 ] Nemon Lou commented on HIVE-10817: -- Thread stack that waiting to lock : {code} "HiveServe

[jira] [Updated] (HIVE-10817) Blacklist For Bad MetaStore

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10817: - Attachment: HIVE-10817 > Blacklist For Bad MetaStore > --- > > Key

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.patch > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: (was: HIVE-10815.patch) > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.patch > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.patch > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: (was: HIVE-10815.patch) > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Commented] (HIVE-4239) Remove lock on compilation stage

2015-05-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14564086#comment-14564086 ] Nemon Lou commented on HIVE-4239: - Pasting from email : I have tested it on a 7 nodes clus

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-05-29 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14564437#comment-14564437 ] Nemon Lou commented on HIVE-10815: -- Failed test cases seem unrelated . What this patch do

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-06-04 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14572558#comment-14572558 ] Nemon Lou commented on HIVE-10815: -- [~thiruvel],could you review this patch. I think this

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-06-08 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14576724#comment-14576724 ] Nemon Lou commented on HIVE-10815: -- [~thiruvel] Thanks for reply. I find that only the

[jira] [Commented] (HIVE-10890) Provide implementable engine selector

2015-06-10 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14581332#comment-14581332 ] Nemon Lou commented on HIVE-10890: -- I'm a little confused by this.Here is my thoughts: In

[jira] [Commented] (HIVE-10820) Hive Server2 should register itself again when encounters some failures in HA mode

2015-06-11 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14581715#comment-14581715 ] Nemon Lou commented on HIVE-10820: -- This has been fixed in 1.2.0 by HIVE-8890. > Hive Se

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2015-06-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587743#comment-14587743 ] Nemon Lou commented on HIVE-10815: -- The mechanism in promoteRandomMetaStoreURI() has som

[jira] [Commented] (HIVE-9625) Delegation tokens for HMS are not renewed

2015-06-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14602324#comment-14602324 ] Nemon Lou commented on HIVE-9625: - Thanks all for working on this. Seeing the same issue.We

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-05 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15316127#comment-15316127 ] Nemon Lou commented on HIVE-10815: -- Seems that no failure tests are related. [~thejas] wo

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-06-12 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Open (was: Patch Available) > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.patch > RawDataSize of RCFile is zero after analyze >

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15359940#comment-15359940 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] Thanks for your attention. RawDataSize for

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15360049#comment-15360049 ] Nemon Lou commented on HIVE-14143: -- Agreed. As describe in TableScanDesc.java {code} /

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15360057#comment-15360057 ] Nemon Lou commented on HIVE-14143: -- Referring to ORC and LazySimpleSerde, rawDataSize is

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: (was: HIVE-14143.1.patch) > RawDataSize of RCFile is zero after analyze > ---

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.1.patch Patch updated. > RawDataSize of RCFile is zero after analyze > --

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.1.patch > RawDataSize of RCFile is zero after analyze > --

[jira] [Issue Comment Deleted] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Comment: was deleted (was: Patch updated.) > RawDataSize of RCFile is zero after analyze > -

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-04 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15361156#comment-15361156 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] The "ids" passed in is just "sizeOfColumnsI

[jira] [Assigned] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-14143: Assignee: Nemon Lou (was: Abhishek) > RawDataSize of RCFile is zero after analyze > -

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396893#comment-15396893 ] Nemon Lou commented on HIVE-14353: -- ||queries||CBO_total_time||CBO_time_in_SelectOP|| |q2

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396922#comment-15396922 ] Nemon Lou commented on HIVE-14353: -- [~pxiong] Sorry for the misleading. Performance degr

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_no_projection_prune_explain.txt > Performance degradation after Projection Pruning in

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_projection_prune_explain.rar > Performance degradation after Projection Pruning in CB

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397041#comment-15397041 ] Nemon Lou commented on HIVE-14353: -- A preliminary analysis: Hive has a built in column pr

[jira] [Comment Edited] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396893#comment-15396893 ] Nemon Lou edited comment on HIVE-14353 at 7/29/16 1:08 AM: --- ||qu

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398540#comment-15398540 ] Nemon Lou commented on HIVE-14353: -- The motivation of this jira ticket is that ,I found t

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_explain_cbo_vs_nocbo.tar.gz > Performance degradation after Projection Pruning in CBO > -

[jira] [Updated] (HIVE-13546) Patch for HIVE-12893 is broken in branch-1

2016-04-19 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13546: - Attachment: HIVE-13546.patch > Patch for HIVE-12893 is broken in branch-1 > -

[jira] [Commented] (HIVE-13546) Patch for HIVE-12893 is broken in branch-1

2016-04-19 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15247335#comment-15247335 ] Nemon Lou commented on HIVE-13546: -- [~prasanth_j] would you take a look ? Seems that the

[jira] [Commented] (HIVE-13546) Patch for HIVE-12893 is broken in branch-1

2016-04-19 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15247342#comment-15247342 ] Nemon Lou commented on HIVE-13546: -- After reverting HIVE-12893 or applying the patch abov

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255897#comment-15255897 ] Nemon Lou commented on HIVE-13602: -- I used MR engine. The attachment is bigger than 50K

[jira] [Updated] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13602: - Attachment: explain_cbo_bad_part3.out explain_cbo_bad_part2.out explain_cbo

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255914#comment-15255914 ] Nemon Lou commented on HIVE-13602: -- Another information : after rewrite q16 into the foll

[jira] [Updated] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13602: - Attachment: explain_cbo_good(rewrite)_part3.out explain_cbo_good(rewrite)_part2.out

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255937#comment-15255937 ] Nemon Lou commented on HIVE-13602: -- The join order seems to be the same for both queries.

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255964#comment-15255964 ] Nemon Lou commented on HIVE-13602: -- >From calcite rel plan ,we can see the p_brand column

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255976#comment-15255976 ] Nemon Lou commented on HIVE-13602: -- I just copy it from the result of "explain rewrite q1

[jira] [Updated] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13602: - Affects Version/s: (was: 1.2.1) 1.2.2 1.3.0 > TPCH q16 r

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256275#comment-15256275 ] Nemon Lou commented on HIVE-13602: -- The result is right when using hive 1.2.1. After som

[jira] [Updated] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13602: - Description: Running tpch with factor 2, q16 returns 1,160 rows when CBO is on, while returns 24,581 rows

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15257398#comment-15257398 ] Nemon Lou commented on HIVE-13602: -- It's 24581 on my computer. I must have checked the wr

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-05-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284045#comment-15284045 ] Nemon Lou commented on HIVE-13602: -- Thanks [~pxiong] .It will be nice to provide a patch

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15285941#comment-15285941 ] Nemon Lou commented on HIVE-10815: -- Seems that it fail to attract any volunteer to review

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Open (was: Patch Available) > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.1.patch > Let HiveMetaStoreClient Choose MetaStore Randomly > -

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Patch Available (was: Open) Patch rebased to master. > Let HiveMetaStoreClient Choose MetaStore

[jira] [Updated] (HIVE-13791) Fix failure Unit Test TestHiveSessionImpl.testLeakOperationHandle

2016-05-19 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13791: - Attachment: HIVE-13791.patch I have run TestHiveSessionImpl successfully from local . > Fix failure Uni

[jira] [Updated] (HIVE-10417) Parallel Order By return wrong results for partitioned tables

2016-05-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10417: - Status: Open (was: Patch Available) > Parallel Order By return wrong results for partitioned tables > ---

[jira] [Commented] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303389#comment-15303389 ] Nemon Lou commented on HIVE-5999: - [~ashutoshc] Do you plan to work on this? I have impleme

[jira] [Comment Edited] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303389#comment-15303389 ] Nemon Lou edited comment on HIVE-5999 at 5/27/16 3:05 AM: -- [~ashut

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Attachment: HIVE-5999.patch Limitations: 1,"lines terminated by" only works with text file. 2,"Multiple table

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Patch Available (was: Open) > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Open (was: Patch Available) > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Attachment: HIVE-5999.1.patch Fixing failure test. > Allow other characters for LINES TERMINATED BY > -

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Patch Available (was: Open) > Allow other characters for LINES TERMINATED BY >

[jira] [Commented] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15311563#comment-15311563 ] Nemon Lou commented on HIVE-5999: - Failure tests seem unrelated.This patch is ready for rev

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Open (was: Patch Available) > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.2.patch Now there are less failure tests.So trigger it again. > Let HiveMetaStoreC

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Patch Available (was: Open) > Let HiveMetaStoreClient Choose MetaStore Randomly > ---

[jira] [Updated] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-09-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-11768: - Description: More than 490,000 paths was added to java.io.DeleteOnExitHook on one of our long running H

[jira] [Commented] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-09-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14736333#comment-14736333 ] Nemon Lou commented on HIVE-11768: -- [~navis] Thanks for working on this. > java.io.Delet

[jira] [Commented] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-09-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14909973#comment-14909973 ] Nemon Lou commented on HIVE-11768: -- What HIVE-6091 did was trying to make sure the deleti

[jira] [Commented] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-09-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14909982#comment-14909982 ] Nemon Lou commented on HIVE-11768: -- For better understand: The deletion of temp file can

[jira] [Reopened] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-09-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reopened HIVE-11768: -- > java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances > ---

[jira] [Updated] (HIVE-11768) java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instances

2015-10-07 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-11768: - Priority: Minor (was: Major) > java.io.DeleteOnExitHook leaks memory on long running Hive Server2 Instanc

[jira] [Updated] (HIVE-12371) Adding a timeout connection parameter for JDBC

2015-11-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-12371: - Priority: Minor (was: Major) > Adding a timeout connection parameter for JDBC > -

[jira] [Updated] (HIVE-12371) Adding a timeout connection parameter for JDBC

2015-11-10 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-12371: - Assignee: (was: Vaibhav Gumashta) > Adding a timeout connection parameter for JDBC > -

[jira] [Commented] (HIVE-12382) return actual row count for JDBC executeUpdate

2015-11-10 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14999784#comment-14999784 ] Nemon Lou commented on HIVE-12382: -- HIVE-8244 has same proposal for ACID but in this one,

[jira] [Commented] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-21 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14374764#comment-14374764 ] Nemon Lou commented on HIVE-9839: - Refering to SQLOperation.java,there is no chance that a

[jira] [Updated] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-23 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-9839: Attachment: (was: hive-9839.patch) > HiveServer2 leaks OperationHandle on async queries which fail at com

[jira] [Updated] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-23 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-9839: Attachment: HIVE-9839.patch > HiveServer2 leaks OperationHandle on async queries which fail at compile phase

[jira] [Assigned] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-23 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-9839: --- Assignee: Nemon Lou > HiveServer2 leaks OperationHandle on async queries which fail at compile phase >

[jira] [Updated] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-9839: Attachment: HIVE-9839.patch Adding an test case. > HiveServer2 leaks OperationHandle on async queries which

[jira] [Commented] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14377744#comment-14377744 ] Nemon Lou commented on HIVE-9839: - This patch is ready for review.Thanks > HiveServer2 lea

[jira] [Updated] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-9839: Attachment: HIVE-9839.patch Updating the patch addressing Jimmy's comments. The test case is mainly verifying

[jira] [Updated] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-9839: Attachment: HIVE-9839.patch Updating again.Thanks for your advice. > HiveServer2 leaks OperationHandle on as

[jira] [Commented] (HIVE-9839) HiveServer2 leaks OperationHandle on async queries which fail at compile phase

2015-03-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14381329#comment-14381329 ] Nemon Lou commented on HIVE-9839: - Seems that the failure is unrelated. Running this on my

[jira] [Updated] (HIVE-5672) Insert with custom separator not supported for non-local directory

2015-04-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5672: Attachment: HIVE-5672.3.patch > Insert with custom separator not supported for non-local directory >

[jira] [Assigned] (HIVE-7797) using hive schema tool to upgrade hive schema in postgres from 0.9.0 to 0.13.1 failed

2015-04-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-7797: --- Assignee: Nemon Lou > using hive schema tool to upgrade hive schema in postgres from 0.9.0 to > 0.13

[jira] [Updated] (HIVE-7797) upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres

2015-04-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-7797: Description: Using the following command to upgrade hive schema : schematool -dbType postgres -upgradeSchema

[jira] [Updated] (HIVE-7797) upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres

2015-04-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-7797: Summary: upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres (was: using hive sc

[jira] [Updated] (HIVE-7797) upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres

2015-04-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-7797: Description: Using the following command to upgrade hive schema : schematool -dbType postgres -upgradeSchema

[jira] [Assigned] (HIVE-10417) Parallel Order By return wrong results for partitioned tables

2015-04-21 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-10417: Assignee: Nemon Lou > Parallel Order By return wrong results for partitioned tables > -

[jira] [Commented] (HIVE-10417) Parallel Order By return wrong results for partitioned tables

2015-04-22 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14506648#comment-14506648 ] Nemon Lou commented on HIVE-10417: -- There are 2 major issues in ExecDriver's handleSampli

[jira] [Commented] (HIVE-10417) Parallel Order By return wrong results for partitioned tables

2015-04-22 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14506650#comment-14506650 ] Nemon Lou commented on HIVE-10417: -- Issue 1 raise the following error and makes sampling

  1   2   3   >