[HIVE-21844] HMS schema Upgrade Script is failing with NPE

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: HiveServer2
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: mahesh kumar behera
• Reporter: mahesh kumar behera
• Created: 07/Jun/19 04:52
• Updated: 17/Nov/22 08:51
• Resolved: 10/Jun/19 16:03

Description

schema upgrade tool is failing with NPE while executing "SELECT 'Upgrading MetaStore schema from 1.2.0 to 2.0.0' AS ' '". The header row (metadata) is coming with rows having value null. This is causing null pointer access in function TableOutputFormat::getOutputString when row.values[i] is accessed. Instead of " AS ' ' ", if some other value  like "AS dummy" is given, it's working fine. The issue is coming with mysql version 5.7 and above.

 

 

 

Issue Links

• links to: GitHub Pull Request #667