-
1. Re: Filter on Cassandra
van.halbert Mar 28, 2014 6:12 PM (in response to ichanjasper)Here's an example CQL in the upcoming Teiid 8.7 documentation:
SELECT
X.*
FROM
cassandra_source.native(
'SELECT firstname, lastname FROM users WHERE birth_year = $1 AND country = $2 ALLOW FILTERING'
, 1981,
'US'
) n,
ARRAYTABLE(n.tuple COLUMNS firstname string, lastname string)
AS
X
-
2. Re: Filter on Cassandra
ichanjasper Mar 28, 2014 6:40 PM (in response to van.halbert)Can I use regular SQL syntax? Can Teiid transforms regular SQL to CQL and append ALLOW FILTERING?
-
3. Re: Filter on Cassandra
van.halbert Mar 28, 2014 6:55 PM (in response to ichanjasper)According to the doc, its done with a direct query. So not sure about using SQL, there's no indication (maybe needing more clarification in the documentation). Here's the draft of 8.7: Cassandra Translator - Teiid 8.7 (draft) - Project Documentation Editor
-
4. Re: Filter on Cassandra
shawkins Mar 28, 2014 7:24 PM (in response to van.halbert)> Can Teiid transforms regular SQL to CQL and append ALLOW FILTERING?
I'm not sure if it was intentional on the part of the author or the translator or not, but it does not currently have any logic related to ALLOW FILTERING. If it's generally required, then we'll need to add something. But if it's something that can be configured on the driver or server side that will mitigate the need for additional translator logic.