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

2020-08-31 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-24100: --- Description: Executing the following SQL will fail to compile {code:java} set hive.cbo.enable=false;

[jira] [Comment Edited] (HIVE-23545) Insert table partition(column) occasionally occurs when the target partition is not created

2020-07-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17154374#comment-17154374 ] LuGuangMing edited comment on HIVE-23545 at 7/9/20, 9:17 AM: - Hello

[jira] [Commented] (HIVE-23545) Insert table partition(column) occasionally occurs when the target partition is not created

2020-07-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17154374#comment-17154374 ] LuGuangMing commented on HIVE-23545: Hello Ashish Sharma # This problem occurs in HiveOnMR and also

[jira] [Updated] (HIVE-22753) Fix gradual mem leak: Operationlog related appenders should be cleared up on errors

2020-06-17 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22753: --- Description: In case of exception in SQLOperation, operational log does not get cleared up. This

[jira] [Updated] (HIVE-22753) Fix gradual mem leak: Operationlog related appenders should be cleared up on errors

2020-06-17 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22753: --- Description: In case of exception in SQLOperation, operational log does not get cleared up. This

[jira] [Updated] (HIVE-20983) Vectorization: Scale up small hashtables, when collisions are detected

2020-05-26 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-20983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-20983: --- Issue Type: Improvement (was: Bug) > Vectorization: Scale up small hashtables, when collisions are

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

2020-01-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Attachment: sample.sql > SkewJoin throws NullPointException. > --- >

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

2020-01-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Attachment: (was: sample.sql) > SkewJoin throws NullPointException. >

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

2020-01-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Description: When hive.optimize.skewjoin=ture and hive.auto.convert.join=true it throws

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

2020-01-09 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Description: When hive.optimize.skewjoin=ture and hive.auto.convert.join=true it throws

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-10-07 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946392#comment-16946392 ] LuGuangMing commented on HIVE-22198: [~aditya-shah] ConditionalTask is not easily aware of the parent

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-10-07 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-10-08-09-51-06-144.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Status: Patch Available (was: In Progress) > Execute unoin-all with childs Join in parallel >

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

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Status: Patch Available (was: Reopened) > Data loss occurs when multiple tables are join with

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: HIVE-22198.patch > Execute unoin-all with childs Join in parallel >

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16934132#comment-16934132 ] LuGuangMing commented on HIVE-22198: 【repair】 Fix the parent dependencies of children stage-3 when

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Affects Version/s: (was: 3.0.0) (was: 1.2.0) > Execute unoin-all with

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-20 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16934016#comment-16934016 ] LuGuangMing commented on HIVE-22198: 【analyze】 explain  SELECT sum(1) as a  FROM tab1 t1  INNER JOIN

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-09-20-11-39-30-347.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-09-20-11-38-37-433.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Affects Version/s: 1.2.0 3.0.0 > Execute unoin-all with childs Join in

[jira] [Work started] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-22198 started by LuGuangMing. -- > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: test-parallel.sql > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: (was: test-parallel-skewJoin-unoinall.sql) > Execute unoin-all with childs Join in

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: it's missing a part of data. details check attatchment sql file   was: connect

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: Execute unoin-all with childs Join in parallel (was: parallel to run unoin-all missing a

[jira] [Updated] (HIVE-22198) parallel to run unoin-all missing a part of data

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: parallel to run unoin-all missing a part of data (was: set parallel to run an unoin-all

[jira] [Assigned] (HIVE-22198) set parallel to run an unoin-all SQL and result missing a part of data

2019-09-19 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing reassigned HIVE-22198: -- Assignee: LuGuangMing > set parallel to run an unoin-all SQL and result missing a part of

[jira] [Updated] (HIVE-22198) set parallel to run an unoin-all SQL and result missing a part of data

2019-09-12 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: set parallel to run an unoin-all SQL and result missing a part of data (was: set parallel

[jira] [Updated] (HIVE-22198) set parallel to run an unoin all SQL result loss data

2019-09-12 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: connect hiveserver to set hive.auto.convert.join=false,hive.optimize.skewjoin=true, 

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

2019-09-06 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing resolved HIVE-22098. Target Version/s: 3.1.0 (was: 3.1.0, 3.2.0) Resolution: Fixed > Data loss occurs when

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

2019-08-21 Thread LuGuangMing (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912911#comment-16912911 ] LuGuangMing commented on HIVE-22098: please check and verify this patch update,

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: HIVE-22098.1.patch > Data loss occurs when multiple tables are join with different

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: (was: HIVE-22098.1.patch) > Data loss occurs when multiple tables are join with

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-22098 started by LuGuangMing. -- > Data loss occurs when multiple tables are join with different bucket_version >

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: HIVE-22098.1.patch > Data loss occurs when multiple tables are join with different

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16905063#comment-16905063 ] LuGuangMing commented on HIVE-22098: Modifying the hashcode algorithm to get key is consistent, and

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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: image-2019-08-12-18-45-15-771.png > 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

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Summary: Data loss occurs when multiple tables are join with different bucket_version (was: Data

[jira] [Updated] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: table_c_data.orc table_b_data.orc table_a_data.orc

[jira] [Updated] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Target Version/s: 3.1.0, 3.2.0 (was: 3.2.0) > Data loss occurs when joins occur on tables with

[jira] [Assigned] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

2019-08-12 Thread LuGuangMing (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing reassigned HIVE-22098: -- > Data loss occurs when joins occur on tables with different bucket_version >