PI63040: ERROR QUERYING PARTITIONED COLUMN THAT USES "DATE STORED AS DATE"

APAR status

• Closed as program error.

Error description

• loading data into the table I created using:
  
  create hadoop table bigsql_dates2 (col1 int, col2 date)
  PARTITIONED BY (col3 date stored as date);
  
  The following error is generated:
  
  select * from bigsql_dates2
  
  =========DB2 LOG===========
  
  The statement failed because a Big SQL component encountered an
  error. Component receiving the error: "SCHEDULER". Component
  returning the error: "FRONT-END". Log entry identifier:
  "[SCL-0-4c4961f04]".. SQLCODE=-5105, SQLSTATE=58040,
  DRIVER=3.69.24 Learn more about this error
  
  =========BIG SQL LOG=======
  
      at
  com.thirdparty.cimp.catalog.HdfsTable.createPartition(HdfsTable.
  java:868)
      at
  com.thirdparty.cimp.catalog.HdfsTable.loadPartitions(HdfsTable.j
  ava:743)
      at
  com.thirdparty.cimp.catalog.HdfsTable.load(HdfsTable.java:1232)
      at
  com.thirdparty.cimp.catalog.TableLoader.load(TableLoader.java:85
  )
      at
  com.thirdparty.cimp.catalog.TableLoadingMgr$2.call(TableLoadingM
  gr.java:232)
      at
  com.thirdparty.cimp.catalog.TableLoadingMgr$2.call(TableLoadingM
  gr.java:229)
      at java.util.concurrent.FutureTask.run(FutureTask.java:273)
      at
  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
  utor.java:1156)
      at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.java:626)
      at java.lang.Thread.run(Thread.java:804)
  2016-05-18 08:57:33,319 ERROR
  com.ibm.biginsights.bigsql.scheduler.server.cache.DescriptorTabl
  eCache [pool-1-thread-8] : [SCL-0-4c4961f04] Incomplete-table:
  Front-End-Exception.  schemaName=bigsql tableName=bigsql_dates2.
  com.thirdparty.cimp.catalog.TableLoadingException: Failed to
  load metadata for table: bigsql_dates2
      at
  com.thirdparty.cimp.catalog.HdfsTable.load(HdfsTable.java:1253)
      at
  com.thirdparty.cimp.catalog.TableLoader.load(TableLoader.java:85
  )
      at
  com.thirdparty.cimp.catalog.TableLoadingMgr$2.call(TableLoadingM
  gr.java:232)
      at
  com.thirdparty.cimp.catalog.TableLoadingMgr$2.call(TableLoadingM
  gr.java:229)
      at java.util.concurrent.FutureTask.run(FutureTask.java:273)
      at
  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
  utor.java:1156)
      at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.java:626)
      at java.lang.Thread.run(Thread.java:804)
  Caused by: com.thirdparty.cimp.catalog.CatalogException:
  Invalid partition key value of type: DATE
  

Local fix

• This does not occur if
  the data is of TIMESTAMP Format.
  

Problem summary

• See error description
  

Problem conclusion

• The problem is fixed in Version 4.1 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

• Unknown
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R410 PSY

     UP