PI79485: SQL5105 RETURNED FROM A QUERY AGAINST A TABLE THAT USES A CUSTOM STORAGE HANDLER

APAR status

• Closed as program error.

Error description

• If a table is defined to use a custom storage handler using the
  "STORED BY" argument of the create table syntax, for example:
  CREATE TABLE testtab
  (
     <columns>
  )
  STORED BY '<java url for a customer storage handler>';
  and then a query is executed against that table, the query may
  fail with an error like this for example:
  SQL5105N  The statement failed because a Big SQL component
  encountered an
  error. Component receiving the error: "SCHEDULER". Component
  returning the
  error: "STORAGE HANDLER". Log entry identifier:
  "[SCL-0-2d8ad6a8e]".
  SQLSTATE=58040
  In the bigsql scheduler log (bigsql-sched.log) you may see an
  error like:
  2017-03-16 12:52:07,260 ERROR
  com.ibm.biginsights.bigsql.scheduler.server.StorageHandlerScanSt
  ate [pool-1-thread-6] : [SCL-0-2d8ad675a] [createScanSt\
  ate] Error while getting Storage Handler splits for: <custom
  storage handler java url>
  java.io.IOException: Query cannot proceed as no predicates are
  pushed down.
  proceed as no predicates are
  pushed down.
  

Local fix

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