cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hellogadde@gmail.com"<helloga...@gmail.com>
Subject Cassandra COPY TO CSV format , producing inconsistent data
Date Fri, 01 Sep 2017 16:12:10 GMT
HI , 

we are facing issues with copy to  csv file , from a table.  the date field value is not getting
in CSV, 
but the select state on the same table will show the date.. 

and this behavior is  inconsistent , sometimes we get the data for date filed and sometimes
not.. 
also the select statement  very occasionally  on the first run date column shown as empty
and on immediate second run it shows the date column value

improper result:
select call_uid,call_start_date from customer_calls where customer_uid=2904;

 call_uid        | call_start_date
-----------------+---------------------------------
 19096285868247 | 2017-08-30 13:30:23.839000+0000
  19096285878250 | 2017-08-30 13:30:33.842000+0000
  19096374614659 |                            null
  19096374616659 |                            null
  19096374618669 |                            null
  19096374620665 |                            null
  19096374622671 |                            null
  19096374624662 |                            null
  19096374626656 |                            null
 20195690924360 | 2017-08-29 07:54:12.171000+0000
  20195797463722 | 2017-08-30 13:29:51.558000+0000


Proper result: (on executing second time)
cqlsh:ncm> select call_uid,call_start_date from customer_calls where customer_uid=2904;

 call_uid       | call_start_date
----------------+---------------------------------
 19096374614659 | 2017-08-31 14:09:30.248000+0000
 19096374616659 | 2017-08-31 14:09:32.247000+0000
 19096374618669 | 2017-08-31 14:09:34.258000+0000
 19096374620665 | 2017-08-31 14:09:36.253000+0000
 19096374622671 | 2017-08-31 14:09:38.259000+0000
 19096374624662 | 2017-08-31 14:09:40.250000+0000
 19096374626656 | 2017-08-31 14:09:42.244000+0000





---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message