[teiid-issues] [JBoss JIRA] (TEIID-2724) Suggestion for Cassandra: implement fallback plan if push-down CQL fails

Suggestion for Cassandra: implement fallback plan if push-down CQL fails ------------------------------------------------------------------------- Key: TEIID-2724 URL: https://issues.jboss.org/browse/TEIID-2724 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.6 Environment: Teiid 8.6 with Cassandra Reporter: Ivan Chan Assignee: Steven Hawkins Labels: teiid Sometimes push down sql doesn't work in Cassandra database because most of the time filtering only works on petition key or index column. For example, it won't be possible to apply "IN" clause on non-petition key column. Therefore, I suggest if push down sql fails to execute, I would like to see Teiid to the filtering using Teiid in-memory engine. Thanks.