Count(*) is not working

2017-02-16 Thread Selvam Raman
ken(id) > token(test:-2220-UV033/04) LIMIT 100 (see tombstone_warn_threshold). Can you please help me to get the total count of the table. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Re: Count(*) is not working

2017-02-16 Thread Selvam Raman
I am using cassandra 3.9. Primary Key: id text; On Thu, Feb 16, 2017 at 12:25 PM, Cogumelos Maravilha < cogumelosmaravi...@sapo.pt> wrote: > C* version please and partition key. > > On 02/16/2017 12:18 PM, Selvam Raman wrote: > > Hi, > > I want to know the total re

Re: Count(*) is not working

2017-02-16 Thread Selvam Raman
esult. > > Do you really need the actual live count? To get a idea you can always > look at nodetool cfstats (but those numbers also contain deleted rows). > > > Am 16.02.2017 um 13:18 schrieb Selvam Raman: > > Hi, > > I want to know the total records count in table. >

Cassandra timestamp to spark Date field

2016-09-05 Thread Selvam Raman
ues)),schema) in schema fields I have mentioned timestamp as *StructField*("shipped_datetime", *DateType*), when I try to show the result, it throws java.util.Date can not convert to java.sql.Date. so how can I solve the issue. First I have converted cassandrascanrdd to -- Selvam

Reading cassandra table using Spark

2016-09-04 Thread Selvam Raman
t when i crate action it throws plenty of error example: com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured columnfamily size_estimates -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Re: Cassandra: maximum size of collection list type

2016-12-01 Thread Selvam Raman
I am getting the below error when i am having huge list( greater than 3lakh). "Cassandra timeout during write query at consistency LOCAL_ONE (1 replica were required but only 0 acknowledged the write)" 2016-12-01 16:20 GMT+00:00 Selvam Raman <sel...@gmail.com>: > Hi, >

Cassandra: maximum size of collection list type

2016-12-01 Thread Selvam Raman
Hi, What is the maximum size which can be stored into collection list(in a row ) in cassandra. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Java Collections.emptyList inserted as null object in cassandra

2016-11-29 Thread Selvam Raman
Filed Type in cassandra : List I am trying to insert Collections.emptyList() from spark to cassandra list field. In cassandra it stores as null object. How can i avoid null values here. -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"