APAR status
Closed as program error.
Error description
Querying a table that was loaded with snappy in jsqsh generates an error: Incomplete-table: Front-End-Exception. schemaName=<schema> tableName=<tablename>. com.thirdparty.cimp.catalog.TableLoadingException: Failed to load metadata for table: <tablename> Querying the same table in hive works as expected.
Local fix
Workaround: Force min split size to be at file level: The following flag works around the miscalculation. Please set this TBLPROPERTIES on any tables that show this issue. Note that there will be *no* performance degradation as the problem only applies to non splittable files. Steps: 1) ALTER table ==> db2 "ALTER TABLE <tablename> set TBLPROPERTIES( 'scheduler.minSplitSize'='file')" DB20000I The SQL command completed successfully. 2) restart big sql => bigsql stop => bigsql start 3) run query
Problem summary
See error description.
Problem conclusion
The problem is fixed in Version 4.3 and later fix packs.
Temporary fix
Comments
APAR Information
APAR number
PI72736
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-23
Closed date
2017-04-06
Last modified date
2017-04-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
n/a
Fix information
Fixed component name
INFO BIGINSIGHT
Fixed component ID
5725C0900
Applicable component levels
R430 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"420","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 August 2020