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?

       

      Thanks,

       

      - Ivan