Filtering in related table could not be applied using Cloudera Impala connector
Article ID: KB0081872
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Cloudera Impala | All |
Description
Add a Product Table and a Fact Table using a Cloudera Impala connector. Now create a relationship between the Product Table and the Fact Table using the Product_ID field. If using the filters from the Product Table and applying them on the Fact Table will result in the following warning/error message, " Filtering in related table could not be applied."
External error:
ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Exceeded the maximum number of child expressions (10000).
Expression has 10669 children:
External error:
ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Exceeded the maximum number of child expressions (10000).
Expression has 10669 children:
Issue/Introduction
Filtering in a related table could not be applied using a Cloudera Impala connector if filtering has more than 10000 records.
Resolution
This is a known issue with Cloudera Impala. Cloudera Impala has a few limitations on the number of children an expression can have and the depth of the expression tree.
Additional Information
https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Exceeded-maximum-number-of-child-expressions/td-p/36223
Feedback
Yes
No
Powered by
