This content has been marked as final.
Show 2 replies
-
1. Re: Why Cassandra connector fetches entire table data?
rareddy Feb 2, 2017 12:37 PM (in response to vijaynm)Can you see if you can grab the DDL of schema from first scenario and matches with the second?
I believe the built-in metadata importer (in the first case) automatically sets "searchable" property on "country" to true if this column is indexed in Cassandra. Where as in the second form there is no searchability. It is defined here Cassandra Translator · Teiid Documentation
so you can change
<model name="TeiidTables" visible="true"> <source name="cassandraDB" translator-name="cassandra" connection-jndi-name="java:/cassandraDS" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE Person ( nr integer, country varchar OPTIONS(SEARCHABLE 'SEARCHABLE'), name varchar, PRIMARY KEY (nr) ); ]]> </metadata> </model>
-
2. Re: Why Cassandra connector fetches entire table data?
shawkins Feb 2, 2017 12:59 PM (in response to rareddy)Yes, this should be addressed at the same time as [TEIID-4717] Add Support for 'ALLOW FILTERING' in Teiid Cassandra Translator - JBoss Issue Tracker
If that is what you are working on see teiid/CassandraMetadataProcessor.java at master · teiid/teiid · GitHub for the importer logic.