I am using consistency one for both. However, the writes had happened a few days before, so it does not look like an issue of eventual consistency.
On Thu, Jun 25, 2015 at 3:59 PM, Perica Milošević < perica.milose...@gmail.com> wrote: > Which ConsistencyLevel do you use for writing and reading of the data? > > Cheers, > Perica > > > On Thu, Jun 25, 2015 at 12:12 PM, Aditya Shetty < > aditya.she...@snapdeal.com> wrote: > >> Hi >> >> I have a 3 node cassandra cluster with a replication factor of 2. I have >> a basic column family which I am reading by primary key. Here is the CF >> structure: >> >> CREATE TABLE reviews_platform.object_stats ( >> >> object_owner_id int, >> >> object_type int, >> >> object_id text, >> num_of_reviews int, PRIMARY KEY ((object_owner_id, object_type), >> object_id) >> >> ); >> However, when I query this column family by primary key, I sometimes get >> no records, even though the record exists. The same query after some time >> gives a proper response. >> >> >> >> >> >> >> *Query: select * from reviews_platform.object_stats whereobject_id = >> '674813358269'and object_type = 0and object_owner_id = 0;* >> Note that I am querying using the java driver. >> >> -- >> >> Aditya Shetty >> *Lead Engineer* >> >> *M*: +91 7022423545, *T*: 080 46603000 *EXT*: 4417 >> 2nd FLOOR, WEST WING, >> >> SALARPURIA SUPREME, MARATHAHALLI, BENGALURU >> >> Download Our App [image: A] >> <https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android> >> [image: A] >> <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios> >> [image: W] >> <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> >> > > -- Aditya Shetty *Lead Engineer* *M*: +91 7022423545, *T*: 080 46603000 *EXT*: 4417 2nd FLOOR, WEST WING, SALARPURIA SUPREME, MARATHAHALLI, BENGALURU Download Our App [image: A] <https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android> [image: A] <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios> [image: W] <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>