PI72736: QUERYING DATA STORED WITH SNAPPY COMPRESSION WITH JSQSH OR DB2 CLIENT

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