[HIVE-28203] Fix qtest mv_iceberg_orc5.q

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Component/s: Iceberg integration
• Labels: pull-request-available
• Assignee: Butao Zhang
• Reporter: Butao Zhang
• Created: 17/Apr/24 15:35
• Updated: 18/Apr/24 10:20
• Resolved: 18/Apr/24 10:20

Description

http://ci.hive.apache.org/blue/organizations/jenkins/hive-precommit/detail/PR-5190/3/tests

http://ci.hive.apache.org/blue/organizations/jenkins/hive-precommit/detail/PR-5195/4/tests

 

Flaky CI report:

http://ci.hive.apache.org/job/hive-flaky-check/837/testReport/ 

 

Execution succeeded but contained differences (error code = 1) after executing mv_iceberg_orc5.q 
101c101
<     HiveJoin(condition=[AND(IS NOT DISTINCT FROM($0, $5), IS NOT DISTINCT FROM($1, $6))], joinType=[right], algorithm=[BucketJoin], cost=[not available])
---
>     HiveJoin(condition=[AND(IS NOT DISTINCT FROM($0, $5), IS NOT DISTINCT FROM($1, $6))], joinType=[right], algorithm=[none], cost=[not available])
106c106
<           HiveJoin(condition=[=($0, $3)], joinType=[inner], algorithm=[CommonJoin], cost=[not available])
---
>           HiveJoin(condition=[=($0, $3)], joinType=[inner], algorithm=[none], cost=[not available]) 

Issue Links

• relates to: HIVE-28127 Exception when rebuilding materialized view with calculated columns on iceberg sources
• links to: GitHub Pull Request #5200