JR58371: IMPROVED SUPPORT OF HIVE SQL

APAR status

• Closed as program error.

Error description

• Added support for statements containing sub-select aliases, for
  example:
  
  CREATE VIEW viewABC
  AS SELECT
    colA,
    colB
  FROM
  ( SELECT
       tabA.colA,
       tabB.colB
     FROM
       schemaA.tabA
    ) `subSelectAlias`;
  

Local fix

Problem summary

• *********************************************
  APAR Users Affected:
  *********************************************
  Users running lineage on Hive database views
  
  *********************************************
  APAR Problem Description:
  *********************************************
  Definitions of a Hive view that contains sub-select aliases are
  not parsed correctly. Example of the view definition:
  
  CREATE VIEW viewABC
  AS SELECT
    colA,
    colB
  FROM
  ( SELECT
       tabA.colA,
       tabB.colB
     FROM
       schemaA.tabA
    ) `subSelectAlias`;
  
  As a result, lineage is not created for such Hive views.
  
  *********************************************
  APAR Recommendation:
  *********************************************
  Apply a fix for the APAR JR58371
  
  *********************************************
  

Problem conclusion

• Apply a fix for the APAR JR58371
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS GOVCATLOG

• Fixed component ID

  5724Q36GC

Applicable component levels

• RB50 PSY

     UP