[jira] [Commented] (HIVE-17587) Remove unnecessary filter from getPartitionsFromPartitionIds call

2022-11-28 Thread dzcxzl (Jira) 


[ 
https://issues.apache.org/jira/browse/HIVE-17587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17640036#comment-17640036
 ] 

dzcxzl commented on HIVE-17587:
---

 

[https://bugs.mysql.com/bug.php?id=91032]


[https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-45.html]


 * *InnoDB:* A query that scanned the primary key of a table did not return the 
expected result. (Bug #28104394, Bug #91032)

> Remove unnecessary filter from getPartitionsFromPartitionIds call
> -
>
> Key: HIVE-17587
> URL: https://issues.apache.org/jira/browse/HIVE-17587
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Tao Li
>Assignee: Tao Li
>Priority: Major
> Fix For: 3.0.0
>
> Attachments: HIVE-17587.1.patch
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Commented] (HIVE-17587) Remove unnecessary filter from getPartitionsFromPartitionIds call

2017-09-25 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-17587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16180071#comment-16180071
 ] 

Sergey Shelukhin commented on HIVE-17587:
-

+1

> Remove unnecessary filter from getPartitionsFromPartitionIds call
> -
>
> Key: HIVE-17587
> URL: https://issues.apache.org/jira/browse/HIVE-17587
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Tao Li
>Assignee: Tao Li
> Attachments: HIVE-17587.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-17587) Remove unnecessary filter from getPartitionsFromPartitionIds call

2017-09-23 Thread Tao Li (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-17587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16177892#comment-16177892
 ] 

Tao Li commented on HIVE-17587:
---

Test result looks good.

[~sershe], [~ashutoshc] Can you please review this change?

cc [~thejas]

> Remove unnecessary filter from getPartitionsFromPartitionIds call
> -
>
> Key: HIVE-17587
> URL: https://issues.apache.org/jira/browse/HIVE-17587
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Tao Li
>Assignee: Tao Li
> Attachments: HIVE-17587.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-17587) Remove unnecessary filter from getPartitionsFromPartitionIds call

2017-09-23 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-17587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16177639#comment-16177639
 ] 

Hive QA commented on HIVE-17587:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12888590/HIVE-17587.1.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 11059 tests 
executed
*Failed tests:*
{noformat}
TestAccumuloCliDriver - did not produce a TEST-*.xml file (likely timed out) 
(batchId=231)
TestDummy - did not produce a TEST-*.xml file (likely timed out) (batchId=231)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats]
 (batchId=156)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_explainuser_1]
 (batchId=170)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] 
(batchId=235)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] 
(batchId=235)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/6955/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/6955/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-6955/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 6 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12888590 - PreCommit-HIVE-Build

> Remove unnecessary filter from getPartitionsFromPartitionIds call
> -
>
> Key: HIVE-17587
> URL: https://issues.apache.org/jira/browse/HIVE-17587
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Tao Li
>Assignee: Tao Li
> Attachments: HIVE-17587.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-17587) Remove unnecessary filter from getPartitionsFromPartitionIds call

2017-09-22 Thread Tao Li (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-17587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16177441#comment-16177441
 ] 

Tao Li commented on HIVE-17587:
---

The background is that we identified a MySQL bug when dropping partitions: 
https://bugs.mysql.com/bug.php?id=87264
The community was able to verify the mysql bug, but has not given us a ETA. 
From our side we have a workaround with the attached patch.

> Remove unnecessary filter from getPartitionsFromPartitionIds call
> -
>
> Key: HIVE-17587
> URL: https://issues.apache.org/jira/browse/HIVE-17587
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Tao Li
>Assignee: Tao Li
>Priority: Minor
> Attachments: HIVE-17587.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)