Multiplying two columns in CASE statement overrides pushdown (Impala) --------------------------------------------------------------------- Key: TEIID-3937 URL: https://issues.jboss.org/browse/TEIID-3937 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.4 Environment: Ubuntu Trusty Reporter: Don Krapohl Assignee: Steven Hawkins Pushdown doesn't happen when two columns are multiplied in the THEN portion of a CASE statement with bigdecimal data type. //this should push down but does not CASE WHEN column1 IS NOT NULL THEN column1 * column2 ELSE column3 END //but you can multiply the columns by a constant and it will push down CASE WHEN column1 IS NOT NULL THEN column1 * 34567 ELSE column3 END //or CASE WHEN column1 IS NOT NULL THEN 34567 * column2 ELSE column3 END We're ouputting as bigdecimal so that may be a factor in the decision to push down as double datatype does work.