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

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux
Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

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 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