IBM Support

JR59692: HIVE CONNECTOR FAILS TO PARSE QUERY WHEN PARALLEL READ IS ENABLED AND KEYWORDS ARE PART OF A COLUMN NAME.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For example: Table name extracted from "select
    column_from_column from table_name;" is "_column" while it
    should be "table_name".
    It results in SyntaxErrorException:
    [SQLSTATE 42000] java.sql.SQLSyntaxErrorException: [IBM][Hive
    JDBC Driver][Hive]Error while compiling statement: FAILED:
    ParseException line 1:16 cannot recognize input near '_column'
    '<EOF>' '<EOF>' in table name.
    It happens only when parallel read is enabled and sql
    generation disabled because only then the name has to be
    extracted. Parallel read requires partition info that has to be
    queried for a given table.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Hive Connector users attempting partitioned read.
    ****************************************************************
    PROBLEM DESCRIPTION:
    When keyword 'from' is part of a column name Hive Connector
    extracts what comes after 'from' as the table name.
    For example: Table name extracted from "select
    column_from_column from table_name;" is "_column" while it
    should be "table_name".
    It results in SyntaxErrorException:
    [SQLSTATE 42000] java.sql.SQLSyntaxErrorException: [IBM][Hive
    JDBC Driver][Hive]Error while compiling statement: FAILED:
    ParseException line 1:16 cannot recognize input near '_column'
    '<EOF>' '<EOF>' in table name.
    It happens only when parallel read is enabled and sql generation
    disabled because only then the name has to be extracted.
    Parallel read requires partition info that has to be queried for
    a given table.
    ****************************************************************
    RECOMMENDATION:
    Install patch.
    ****************************************************************
    

Problem conclusion

  • Fixed query parsing to allow 'from' be used as part of column or
     table name.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR59692

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-06-26

  • Closed date

    2018-08-17

  • Last modified date

    2018-08-17

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • RB50 PSY

       UP

  • RB70 PSY

       UP

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

Document Information

Modified date:
10 January 2022