4 Replies Latest reply on Mar 28, 2014 7:24 PM by Steven Hawkins

    Filter on Cassandra

    Ivan Chan Apprentice

      I got exception when running the follow SQL on Cassandra :


      y:SELECT Cassandra.sales.store_country, Cassandra.sales.store_city FROM Cassandra.sales

      WHERE (Cassandra.sales.store_city = 'Los Angeles') AND (Cassandra.sales.store_country = 'USA') LIMIT 1000


      Caused by: org.teiid.jdbc.TeiidSQLException: TEIID30504 -401769519: Cannot execute this query as it might involve data filtering and thus may have unpredictable performance. If you want to execute ths query despite the performance unpredictability, use ALLOW FILTERING


      How do I turn ALLOW FILTERING?




      - Ivan