[HIVE-22236] Fail to create View selecting View containing NOT IN subquery

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Zoltan Matyus
• Reporter: Zoltan Matyus
• Created: 24/Sep/19 10:03
• Updated: 17/Nov/22 08:51
• Resolved: 27/Sep/19 08:53

Description

• Given a complicated view with a select statement that has subquery containing "NOT IN"
• Hive fails to create a simple view as SELECT * FROM complicated_view
• (with CBO disabled).

The unparse replacements of the complicated view will be applied to the text of the simple view, resulting in IllegalArgumentException: replace: range invalid exceptions from org.antlr.runtime.TokenRewriteStream.replace.