by using the below query i am not getting anyrecords
SELECT * FROM test_table where prty_ad_line3_tx = '' and prty_role_type_cd='Co-Borrower' and prty_role_sq_nb =5 limit 10 ALLOW FILTERING;
need help from your end.
Asked
Active
Viewed 34 times
0
-
1How many records are in your test_table? Are you timing out? – LHWizard Dec 05 '18 at 13:30
-
sample data of 80 records. – Rajesh Vakcharla Jan 05 '19 at 14:06
-
from what I can determine from [reading](http://www.aaronstechcenter.com/null-query-cassandra.php), you can't search by null. Null values aren't allowed in primary keys. Also [this question](https://stackoverflow.com/questions/20981075/how-can-i-search-for-records-that-have-a-null-empty-field-using-cql) – LHWizard Jan 07 '19 at 13:44