Fixes are available
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 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