Product: TIBCO Spotfire®
Filtering in related table could not be applied using Cloudera Impala connector
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."
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: 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. https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Exceeded-maximum-number-of-child-expressions/td-p/36223