PI73491: XQE-DAT-0001 ERROR WHEN RUNNING REPORTS USING IMPALA DATASOURCE

APAR status

• Closed as fixed if next.

Error description

• Cloudera Impala does not support multiple distinct aggregates.
  DQM property files are configured to not push the construct.
  DQM is generating SQL which is pushing multiple distinct
  aggregates to Impala which will not parse.
  
  Error:
  XQE-DAT-0001 Data source adapter error: java.sql.SQLException:
  [Simba][ImpalaJDBCDriver](500051) ERROR processing
  query/statement. Error Code: 0, SQL state:
  TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
  errorMessage:AnalysisException: all DISTINCT aggregate functions
  need to have the same set of parameters as count(DISTINCT
  order_details.quantity); deviating function: count(DISTINCT
  order_details.unit_cost)
  ), Query: WITH
  `New_Query_Subject` AS
  (
  SELECT
  `order_header`.`sales_branch_code`,
  COUNT(DISTINCT `order_details`.`quantity`) AS `c1`,
  COUNT(DISTINCT `order_details`.`unit_cost`) AS `c2`
  FROM
  `gosales1021`.`order_details` `order_details`,
  `gosales1021`.`order_header` `order_header`
  WHERE
  `order_header`.`order_number` = `order_details`.`order_number`
  GROUP BY
  `order_header`.`sales_branch_code`
  )
  SELECT
  `New_Query_Subject`.`sales_branch_code` AS `sales_branch_code`,
  `New_Query_Subject`.`c1` AS `c1`,
  `New_Query_Subject`.`c2` AS `c2`
  FROM
  `New_Query_Subject`.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytic 11.0.6.0                      *
  ****************************************************************
  

Problem conclusion

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:

Fix information

Applicable component levels

• RB00 PSN

     UP