IBM Support

JR58518: HIVE DOES NOT DISTINGUISH DATABASE AND SCHEMA CONCEPTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In Hive the database and schema concepts are interchangeable.
    IGC lineage processing has to be enhanced to automatically look
    for database schema under database with the same name.
    

Local fix

Problem summary

  • Hive does not distinguish database and schema concepts
    

Problem conclusion

  • Apache Hive can have views created from database tables that are
     defined across multiple schemas . Lineage algorithm is building
     flows based on the information in SQL . However the cross
    schema views were not  process correctly and tables from
    multiple schemas were not found correctly in the database. The
    code was enhanced to cover cross schema SQL on Apache Hive.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR58518

  • Reported component name

    IS GOVCATLOG

  • Reported component ID

    5724Q36GC

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-11

  • Closed date

    2017-11-02

  • Last modified date

    2017-11-02

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 June 2020