[SPARK-23710] Upgrade the built-in Hive to 2.3.5 for hadoop-3.2

• Type: Umbrella
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Target Version/s: 3.0.0
• Assignee: Yuming Wang
• Reporter: Yuming Wang
• Created: 16/Mar/18 16:07
• Updated: 12/Dec/22 18:10
• Resolved: 08/Feb/20 05:24

Description

Spark fail to run on Hadoop 3.x, because Hive's ShimLoader considers Hadoop 3.x to be an unknown Hadoop version. see SPARK-18673 and HIVE-16081 for more details. So we need to upgrade the built-in Hive for Hadoop-3.x. This is an umbrella JIRA to track this upgrade.

 

Upgrade Plan:

1. SPARK-27054 Remove the Calcite dependency. This can avoid some jar conflicts.
2. SPARK-23749 Replace built-in Hive API (isSub/toKryo) and remove OrcProto.Type usage
3. SPARK-27158, SPARK-27130 Update dev/* to support dynamic change profiles when testing
4. Fix ORC dependency conflict to makes it test passed on Hive 1.2.1 and compile passed on Hive 2.3.4
5. Add an empty hive-thriftserverV2 module. then we could test all test cases in next step
6. Make Hadoop-3.1 with Hive 2.3.4 test passed
7. Adapted hive-thriftserverV2 from hive-thriftserver with Hive 2.3.4's TCLIService.thrift

 

I have completed the initial work and plan to finish this upgrade step by step.
 

 

Issue Links

• blocks: SPARK-27361 YARN support for GPU-aware scheduling
• is related to: SPARK-31113 Support DDL "SHOW VIEWS"
• is related to: SPARK-12014 Spark SQL query containing semicolon is broken in Beeline (related to HIVE-11100)
• is related to: SPARK-24766 CreateHiveTableAsSelect and InsertIntoHiveDir won't generate decimal column stats in parquet
• relates to: SPARK-27500 Add tests for built-in Hive 2.3
• supercedes: SPARK-27377 Upgrade YARN to 3.1.2+ to support GPU
• supercedes: SPARK-24472 Orc RecordReaderFactory throws IndexOutOfBoundsException
• supercedes: SPARK-28748 0 as decimal (n , n) in Hive tables shows as NULL in Spark
• links to: GitHub Pull Request #23552
• links to: GitHub Pull Request #23553
• links to: GitHub Pull Request #23788