[HIVE-25012] Parsing table alias is failing if query has table properties specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO, Parser
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 14/Apr/21 02:54
• Updated: 17/Nov/22 08:48
• Resolved: 22/Apr/21 08:17

Description

select t1.ROW__IS__DELETED, t1.*, t2.ROW__IS__DELETED, t2.* from t1('acid.fetch.deleted.rows'='true')
join t2('acid.fetch.deleted.rows'='true') on t1.a = t2.a;

When creating Join RelNode the aliases are used to lookup left and right input RelNodes. Aliases are extracted from the AST subtree of the left and right inputs of the join AST node. In case of a table reference:

TOK_TABREF
   TOK_TABNAME
      t1
   TOK_TABLEPROPERTIES
      TOK_TABLEPROPLIST
         TOK_TABLEPROPERTY
            'acid.fetch.deleted.rows'
            'true'

Prior HIVE-24854 queries mentioned above failed because existing solution was not expect TOK_TABLEPROPERTIES.

The goal of this patch is to parse TOK_TABREF properly using existing solution also used in SemanticAnalyser.doPhase1

Issue Links

• links to: GitHub Pull Request #2177