Hi , I am running Spark on k8s and executing a Query on Cassandra below
CassandraJavaUtil.javaFunctions(jc).cassandraTable("keyspace", "table").select("key").where("column1 = ? AND value = ?", "colname", "colvalue"); which generates internally following query
'SELECT "key" FROM keyspace.table WHERE token("key") > ? AND token("key") <= ? AND column1 = ? AND value = ? ALLOW FILTERING
Schema is:
key text
column1 text,
value text,
PRIMARY KEY (key,column1)
My Question is: As shown in query , there are two columns , one is column1 which is clustering key and other is value , which is simple column. Can I put a query on non clustering key column "value" on a highly loaded database. Will it return me accurate result?