[jira] [Updated] (HIVE-24100) Syntax compile failure occurs when INSERT table column Order by is greater than 2 columns when CBO is false

2020-09-01 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24100: Description: Executing the following SQL will fail to compile {code:java} set

[jira] [Updated] (HIVE-24122) When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

2020-09-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24122: Description: {code:java} create  database testdb; CREATE TABLE IF NOT EXISTS testdb.z_tab (    

[jira] [Updated] (HIVE-24124) NPE occurs when bucket_version different bucket tables are joined

2020-09-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24124: Description: {code:java} create table z_tab_1(     task_id  string,        data_date  string,    

[jira] [Updated] (HIVE-24124) NPE occurs when bucket_version different bucket tables are joined

2020-09-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24124: Description: {code:java} create table z_tab_1(     task_id  string,        data_date  string,    

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-22098: Attachment: (was: join_test.sql) > Data loss occurs when multiple tables are join with

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-22098: Attachment: join_test.sql > Data loss occurs when multiple tables are join with different

[jira] [Resolved] (HIVE-24122) When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu resolved HIVE-24122. - Fix Version/s: 4.0.0 Resolution: Fixed > When CBO is enable, CAST(STR as Bigint)IS NOT

[jira] [Commented] (HIVE-24122) When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17199362#comment-17199362 ] GuangMing Lu commented on HIVE-24122: - Hey {color:#0066cc} [~zabetak]  {color:#172b4d} Thanks for

[jira] [Comment Edited] (HIVE-24122) When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17199362#comment-17199362 ] GuangMing Lu edited comment on HIVE-24122 at 9/21/20, 12:44 PM: Hey 

[jira] [Assigned] (HIVE-24122) When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu reassigned HIVE-24122: --- Assignee: GuangMing Lu > When CBO is enable, CAST(STR as Bigint)IS NOT NULL result is wrong

[jira] [Commented] (HIVE-24060) When the CBO is false, NPE is thrown by an EXCEPT or INTERSECT execution

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17199373#comment-17199373 ] GuangMing Lu commented on HIVE-24060: - Hey [~dengzh] Such is the case, but hive-1.2.1 is available,

[jira] [Updated] (HIVE-24186) The aggregate class operation fails when the CBO is false

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24186: Fix Version/s: (was: 3.1.2) (was: 3.1.0) > The aggregate class

[jira] [Updated] (HIVE-24186) The aggregate class operation fails when the CBO is false

2020-09-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24186: Affects Version/s: 3.1.2 > The aggregate class operation fails when the CBO is false >

[jira] [Updated] (HIVE-24715) Increase bucketId range

2021-06-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-24715: Issue Type: Improvement (was: Bug) > Increase bucketId range > --- > >

[jira] [Updated] (HIVE-25239) Create the compression table but the properties Compressed is No

2021-06-10 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25239: Summary: Create the compression table but the properties Compressed is No (was: Create the

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: P10IDS_RISKLIST.zip p10ids_riskcon.zip

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: table_d_data.orc) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: comb_classcode.data > When the skew and parallel parameters are true simultaneously,

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: 样例分析-表入数据.sql > When the skew and parallel parameters are true simultaneously, the

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: table_b_data.orc) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: test.sql) > When the skew and parallel parameters are true simultaneously,

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: table_c_data.orc) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: table_a_data.orc) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: test.sql > When the skew and parallel parameters are true simultaneously, the result

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: 样例分析-表入数据.sql) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25269) When the skew and parallel parameters are true simultaneously, the result is less data

2021-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25269: Attachment: (was: comb_classcode.data) > When the skew and parallel parameters are true

[jira] [Updated] (HIVE-25239) Create the compression table but the properties Compressed is No

2021-06-10 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25239: Attachment: HIVE-25239.01.patch Fix Version/s: 4.0.0 Assignee: GuangMing Lu

[jira] [Assigned] (HIVE-25239) Create the compression table but the properties Compressed is No

2021-06-10 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu reassigned HIVE-25239: --- Assignee: (was: GuangMing Lu) > Create the compression table but the properties

[jira] [Commented] (HIVE-25239) Create the compression table but the properties Compressed is No

2021-06-10 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17361387#comment-17361387 ] GuangMing Lu commented on HIVE-25239: - Hi 

[jira] [Updated] (HIVE-25315) SQL executed hiveserver is killed by the HiveServer2-Handler-Pool thread, very occasionally

2021-07-08 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25315: Component/s: HiveServer2 > SQL executed hiveserver is killed by the HiveServer2-Handler-Pool

[jira] [Commented] (HIVE-20828) Upgrade to Spark 2.4.0

2021-09-01 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17408106#comment-17408106 ] GuangMing Lu commented on HIVE-20828: - Hi [~stakiar], How is the hive on spark evolving? > Upgrade

[jira] [Updated] (HIVE-20682) Async query execution can potentially fail if shared sessionHive is closed by master thread.

2021-09-02 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-20682: Affects Version/s: (was: 3.1.0) > Async query execution can potentially fail if shared

[jira] [Commented] (HIVE-20682) Async query execution can potentially fail if shared sessionHive is closed by master thread.

2021-09-02 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17408892#comment-17408892 ] GuangMing Lu commented on HIVE-20682: - Hivs 3.1.0 does not match the current code, which is not shown

[jira] [Updated] (HIVE-25525) TestRetryingThriftCLIServiceClient test case optimization

2021-09-14 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25525: Description: {code:java} //devil's Numbers cliServiceClient.openSession("anonymous", "anonymous");

[jira] [Updated] (HIVE-25853) Security Vulnerability CVE-2021-44832 log4j2 need upgrade to 2.17.1

2022-01-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25853: Summary: Security Vulnerability CVE-2021-44832 log4j2 need upgrade to 2.17.1 (was: Security

[jira] [Updated] (HIVE-25853) Security Vulnerability CVE-2021-44832 log4j2 upgrade to 2.17.1

2022-01-07 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25853: Description: Security Vulnerability CVE-2021-44832 log4j2 need upgrade to 2.17.1 (was: Security

[jira] [Updated] (HIVE-25853) Security Vulnerability CVE-2021-44832 log4j2 need upgrade to 2.17.1

2022-01-10 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-25853: Issue Type: Bug (was: Improvement) > Security Vulnerability CVE-2021-44832 log4j2 need upgrade to

[jira] [Updated] (HIVE-26018) The result of UNIQUEJOIN on Hive on Tez is inconsistent with that of MR

2022-03-09 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26018: Attachment: (was: image-2022-03-09-21-08-17-835.png) > The result of UNIQUEJOIN on Hive on Tez

[jira] [Updated] (HIVE-26018) The result of UNIQUEJOIN on Hive on Tez is inconsistent with that of MR

2022-03-09 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26018: Description: The result of UNIQUEJOIN on Hive on Tez is inconsistent with that of MR, and the

[jira] [Updated] (HIVE-26018) The result of UNIQUEJOIN on Hive on Tez is inconsistent with that of MR

2022-03-09 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26018: Description: The result of UNIQUEJOIN on Hive on Tez is inconsistent with that of MR, and the

[jira] [Assigned] (HIVE-25853) Security Vulnerability CVE-2021-44832 log4j2 need upgrade to 2.17.1

2022-03-26 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu reassigned HIVE-25853: --- Assignee: GuangMing Lu > Security Vulnerability CVE-2021-44832 log4j2 need upgrade to

[jira] [Commented] (HIVE-20607) TxnHandler should use PreparedStatement to execute direct SQL queries.

2022-06-17 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1745#comment-1745 ] GuangMing Lu commented on HIVE-20607: - Hi [~sankarh]  [~kgyrtkirk],  Do you know Hive's EOL schedule?

[jira] [Assigned] (HIVE-26342) About EOL schedule discussion

2022-06-20 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu reassigned HIVE-26342: --- Assignee: Aihua Xu > About EOL schedule discussion > - > >

[jira] [Updated] (HIVE-26342) About EOL schedule discussion

2022-06-20 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26342: Affects Version/s: All Versions > About EOL schedule discussion > - >

[jira] [Commented] (HIVE-26342) About EOL schedule discussion

2022-06-20 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17556325#comment-17556325 ] GuangMing Lu commented on HIVE-26342: - * Related discussion posts

[jira] [Updated] (HIVE-26342) About EOL schedule discussion

2022-06-20 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26342: Description: h4. Hi [Aihua

[jira] [Updated] (HIVE-26342) About EOL schedule discussion

2022-06-20 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26342: Issue Type: Task (was: Bug) > About EOL schedule discussion > - > >

[jira] [Commented] (HIVE-26342) About EOL schedule discussion

2022-06-21 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17556765#comment-17556765 ] GuangMing Lu commented on HIVE-26342: - h4. Hi [Stamatis

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-09-01 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26505: Description: {code:java} create table test0831 (id string) partitioned by (cp string); insert into

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26505: Description: {code:java} create table test0831 (id string, cp string) stored as orc; insert into

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26505: Priority: Critical (was: Major) > Case When Some result data is lost when there are common column

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26505: Description: {code:java} create table test0831 (id string) partitioned by (cp string); insert into

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] GuangMing Lu updated HIVE-26505: Description: {code:java} create table test0831 (id string) partitioned by (cp string); insert into