Re: CASSANDRA-8072

2016-02-08 Thread Stefania Alborghetti
~[dse-core-4.8.4.jar:4.8.4] > at > org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:564) > ~[cassandra-all-2.1.12.1046.jar:2.1.12.1046] > at com.datastax.bdp.DseModule.main(DseModule.java:74) > [dse-core-4.8.4.jar:4.8.4] > INFO [Thread-2] 2016-02-

Re: CASSANDRA-8072

2016-02-09 Thread Stefania Alborghetti
ollision(StorageService.java:541) > ~[cassandra-all-2.1.12.1046.jar:2.1.12.1046] > at > org.apache.cassandra.service.StorageService.prepareToJoin(StorageService.java:789) > ~[cassandra-all-2.1.12.1046.jar:2.1.12.1046] > > Cheers > > On Mon, Feb 8, 2016 at 5:36 PM, Stefania Albo

Re: CASSANDRA-8072

2016-02-08 Thread Stefania Alborghetti
>>>>>> Have you started seed first and after waiting for 30 seconds started >>>>>> other nodes? >>>>>> >>>>>> >>>>>> On Tue, Feb 9, 2016 at 12:14 AM, Ted Yu <yuzhih...@gmail.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> I am trying to setup a cluster with DSE 4.8.4 >>>>>>> >>>>>>> I added the following in resources/cassandra/conf/cassandra.yaml : >>>>>>> >>>>>>> cluster_name: 'cass' >>>>>>> >>>>>>> which resulted in: >>>>>>> >>>>>>> http://pastebin.com/27adxKTM >>>>>>> >>>>>>> This seems to be resolved by CASSANDRA-8072 >>>>>>> >>>>>>> My question is whether there is workaround ? >>>>>>> If not, when can I expect 2.1.13 release ? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com

Re: SELECT JSON timestamp lacks timezone information

2016-02-08 Thread Stefania Alborghetti
"2016-01-04 16:05:47.123" >>> >>> (1 rows) >>> >>> vs. >>> >>> cqlsh:events> select created_at FROM event_by_user_timestamp ; >>> >>> created_at >>> -- >>> 2016-01-04 15:05:

Re: Can't select count(*)

2016-02-01 Thread Stefania Alborghetti
t I should to tweak there? > > Thank you. > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com

Re: Cassandra-stress output

2016-03-09 Thread Stefania Alborghetti
nal intention was to avoid control characters however, given the +32 in the original line. For this reason I've copied this message to the dev mailing list. -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com

Re: What does FileCacheService's log message (invalidating cache) mean?

2016-03-19 Thread Stefania Alborghetti
t; Here is my experimental configurations. >> >> - Cassandra node: An aws EC2 instance(t2.medium. 4GBRAM, 2vCPU) >> - Cassandra version: 2.2.5 >> - inserted data size: about 100GB >> - cassandra-env.sh: default >> - cassandra.yaml >> - compaction_throughput_mb_per

Re: What does FileCacheService's log message (invalidating cache) mean?

2016-03-16 Thread Stefania Alborghetti
with a SSTable > file. But I'm not sure what it does actually mean. When the cache is > invalidated? And What happens is after cache invalidation? > > > Regards, > Satoshi > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com

Re: Possible bug in Cassandra

2016-03-09 Thread Stefania Alborghetti
he typo was in the name of event_client_date. It should have been > client_event_date. > > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com

Re: What does FileCacheService's log message (invalidating cache) mean?

2016-03-20 Thread Stefania Alborghetti
eed sequential read to merge. > > If I have something wrong, I'm glad if you could correct. > > > Regards, > Satoshi > > > On Thu, Mar 17, 2016 at 5:19 PM, Stefania Alborghetti < > stefania.alborghe...@datastax.com> wrote: > >> Q1. Readers are created as n

Re: Hi Memory consumption with Copy command

2016-04-22 Thread Stefania Alborghetti
scenario? > > Regards, > Bhuvan > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com [image: cassandrasummit.org/Email_Signature] <http://cassandrasummit.org/Email_Signature>

Re: Hi Memory consumption with Copy command

2016-04-23 Thread Stefania Alborghetti
l.com> wrote: > >> Thanks Stefania for the informative answer. The next blog was pretty >> useful as well: >> http://www.datastax.com/dev/blog/how-we-optimized-cassandra-cqlsh-copy-from >> . Ill upgrade to 3.0.5 and test with C extensions enabled and report on >>

Re: COPY TO export fails with

2016-05-10 Thread Stefania Alborghetti
llschaft: Solingen | HRB 25917| Amtsgericht Wuppertal >>> Vorstand: Michael Hochgürtel . Mirko Novakovic . Rainer Vehns >>> Aufsichtsrat: Patric Fedlmeier (Vorsitzender) . Klaus Jäger . Jürgen >>> Schütz >>> >>> Diese E-Mail einschließlich evtl. beigefügter Dateien enthält >>> vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht >>> der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, >>> informieren Sie bitte sofort den Absender und löschen Sie diese E-Mail und >>> evtl. beigefügter Dateien umgehend. Das unerlaubte Kopieren, Nutzen oder >>> Öffnen evtl. beigefügter Dateien sowie die unbefugte Weitergabe dieser >>> E-Mail ist nicht gestattet >>> >> >> >> -- >> >> >> >> > > > -- > Matthias Niehoff | IT-Consultant | Agile Software Factory | Consulting > codecentric AG | Zeppelinstr 2 | 76185 Karlsruhe | Deutschland > tel: +49 (0) 721.9595-681 | fax: +49 (0) 721.9595-666 | mobil: +49 (0) > 172.1702676 > www.codecentric.de | blog.codecentric.de | www.meettheexperts.de | > www.more4fi.de > > Sitz der Gesellschaft: Solingen | HRB 25917| Amtsgericht Wuppertal > Vorstand: Michael Hochgürtel . Mirko Novakovic . Rainer Vehns > Aufsichtsrat: Patric Fedlmeier (Vorsitzender) . Klaus Jäger . Jürgen Schütz > > Diese E-Mail einschließlich evtl. beigefügter Dateien enthält vertrauliche > und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige > Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie > bitte sofort den Absender und löschen Sie diese E-Mail und evtl. > beigefügter Dateien umgehend. Das unerlaubte Kopieren, Nutzen oder Öffnen > evtl. beigefügter Dateien sowie die unbefugte Weitergabe dieser E-Mail ist > nicht gestattet > -- [image: datastax_logo.png] <http://www.datastax.com/> Stefania Alborghetti Apache Cassandra Software Engineer |+852 6114 9265| stefania.alborghe...@datastax.com [image: cassandrasummit.org/Email_Signature] <http://cassandrasummit.org/Email_Signature>

Re: Cannot set TTL in COPY command

2016-10-26 Thread Stefania Alborghetti
gt; >> >> On Wed, Oct 26, 2016 at 10:07 AM, techpyaasa . <techpya...@gmail.com> >> wrote: >> >>> Can some one please tell me how to set TTL using COPY command? >> >> >> It looks like you're using Cassandra 2.0. I don't think COPY supports >>

Re: How to insert "Empty" timeuuid by Cql

2016-10-19 Thread Stefania Alborghetti
column2, column3, column4) >> ) WITH COMPACT STORAGE AND >> bloom_filter_fp_chance=0.01 AND >> caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND >> comment='' AND >> dclocal_read_repair_chance=0.10 AND >> gc_grace_seconds=432000 AND >> read_repair_chance=0.00 AND >> default_time_to_live=0 AND >> speculative_retry='NONE' AND >> memtable_flush_period_in_ms=0 AND >> compaction={'class': 'SizeTieredCompactionStrategy'} AND >> compression={'sstable_compression': 'LZ4Compressor'}; >> >> -- >> Thanks, >> Lijun Huang >> >> >> > > > -- > Best regards, > Lijun Huang > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com

Re: How to insert "Empty" timeuuid by Cql

2016-10-19 Thread Stefania Alborghetti
t; [cqlsh 4.1.1 | Cassandra 2.1.11 | CQL spec 3.1.1 | Thrift protocol 19.39.0] > > On Thu, Oct 20, 2016 at 10:33 AM, Stefania Alborghetti < > stefania.alborghe...@datastax.com> wrote: > >> Have you already tried using unset values? >> >> http://www.datastax.com/dev

Re: CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation

2016-10-24 Thread Stefania Alborghetti
che.cassandra.db.commitlog.CommitLog.recoverSegmentsOnDisk(CommitLog.java:167) >>> [apache-cassandra-3.9.jar:3.9]* >>> * at >>> org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:323) >>> [apache-cassandra-3.9.jar:3.9]* >>> * at >>> org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:601) >>> [apache-cassandra-3.9.jar:3.9]* >>> * at >>> org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:730) >>> [apache-cassandra-3.9.jar:3.9]* >>> >>> >>> I then have to do 'sudo rm -rf /var/lib/cassandra/commitlog/*' which >>> fixes the problem, but then I lose all of my data. >>> >>> It looks like its saying there wasn't enough data to read the field >>> 'board_id', any ideas why that would be? >>> >>> >>> >>> >>> >>> >>> > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com

Re: CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation

2016-10-24 Thread Stefania Alborghetti
ps://github.com/instaclustr/cassandra > > Read the README at the repo for more info. > > Kurt Greaves > k...@instaclustr.com > www.instaclustr.com > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com

Re: Hadoop vs Cassandra

2016-10-24 Thread Stefania Alborghetti
x.com/nosql-databases/nosql-cassandra-and-hadoop> >>> >>>> >>> >>>> My question is, can we just use cassandra to rule them all ? >>> >>>> >>> >>>> What we are trying to achieve is to minimize the moving part on our >>> system. &g

Re: Problem with COPY FROM/TO and counters

2016-11-13 Thread Stefania Alborghetti
58e-4e29450fd577,SA,2" > > data.csv > > > table definitions, first one is with counter column, second with > int column > > > CREATE TABLE woc.table_test ( > object_id ascii, > user_id timeuuid, > counter_id ascii, > count counter, > PRIMARY KEY ((object_id, user_id), counter_id) > ); > > DROP TABLE woc.table_test; > > CREATE TABLE woc.table_test ( > object_id ascii, > user_id timeuuid, > counter_id ascii, > count int, > PRIMARY KEY ((object_id, user_id), counter_id) > ); > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com

Re: cqlsh problem

2016-10-13 Thread Stefania Alborghetti
;>>>>>>>>>>>> '--connect-timeout', cqlsh >>>>>>>>>>>>>> seems don't have such parameters. >>>>>>>>>>>>>> >>>>>>>>>>>>>> 2016-03-18 17:29 GMT+08:00 Alain RODRIGUEZ < >>>>>>&

Re: Python Upgrade to 2.7

2016-12-21 Thread Stefania Alborghetti
, or not on PYTHONPATH. > > You might try "pip install cassandra-driver". > > Python: /opt/isv/python27/bin/python > > Error: can't decompress data; zlib not available > > --- > > What am I missing? > -- Jacob Shadix > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com

Re: COPY FROM performance

2017-03-14 Thread Stefania Alborghetti
cluster and with multiple nodes cluster - it > doesn't impact on performance. > However, I see that COPY FROM is CPU bounded on my machines, so these > steps should definitely increase the performance. > > > The question: what I did wrong? Maybe some step is missed. > How to

Re: Copy from CSV on OS X problem with varint values <= -2^63

2017-04-04 Thread Stefania Alborghetti
:12 PM, Boris Babic <bo...@icloud.com> wrote: > Thanks Stefania, going from memory don't think I noticed this on windows > but haven't got a machine handy to test it on at the moment. > > On Apr 4, 2017, at 19:44, Stefania Alborghetti <stefania.alborghetti@ > datastax.c

Re: Copy from CSV on OS X problem with varint values <= -2^63

2017-04-04 Thread Stefania Alborghetti
ace.data (id,varint) > values(1,-9223372036854775808898989898) > ; > > Had not observed this before on other OS, is this something todo with the > way the copy from parser is interpreting varint for values <= -2^63 ? > > Thanks for any input > Boris > > > > >

Re: Copy from CSV on OS X problem with varint values <= -2^63

2017-04-05 Thread Stefania Alborghetti
l v4] > Use HELP for help. > > > On Apr 5, 2017, at 12:07 PM, Stefania Alborghetti <stefania.alborghetti@ > datastax.com> wrote: > > You are welcome. > > I traced the problem to a commit of the Python driver that shipped in > version 3.8 of the driver. It is fixed in 3.8

Re: HELP with bulk loading

2017-03-09 Thread Stefania Alborghetti
s there any real examples of multi-threaded using of CQLSSTableWriter? >> Maybe ready to use libraries like: https://github.com/spotify/hdfs2cass? >> >> 3. sstableloader is slow too. Assuming that I have new empty C* cluster, >> how can I improve the upload speed? Ma

Re: CQL: fails to COPY FROM with null values

2017-06-19 Thread Stefania Alborghetti
ParseError - badly formed hexadecimal UUID > string, given up without retries* > > > > So, how do I import my CSV file and set the columns which does not have a > UUID to null ? > > > > -Tobias > -- <http://www.datastax.com/> STEFANIA ALBORGHETTI Software engineer | +852 6114 9265 | stefania.alborghe...@datastax.com [image: http://www.datastax.com/cloud-applications] <http://www.datastax.com/cloud-applications>