Re: Understanding Messages in the Debug.log

2017-09-22 Thread Alex Kotelnikov
I see a lot of that on one of our clusters. There is pretty much no load on it. Clocks are quite well synchronized. date +start:%H:%M:%S.%N ; for d in 2 3 4 5 6 8 9; do ssh 10.3.0.17$d date +%H:%M:%S.%N & done;date +end:%H:%M:%S.%N start:01:22:45.478726356 end:01:22:45.480993049 01:22:45.570313

Re: No columns are defined for Materialized View other than primary key

2017-09-07 Thread Alex Kotelnikov
your MV has the same primary key as your view, how can it be > possible ? > > Can you elaborate on what you mean by "non filtered full scan on MV" ? > Please give us some sample SELECT queries > > On Thu, Sep 7, 2017 at 5:11 PM, Alex Kotelnikov < > alex.kotelni...@di

Re: No columns are defined for Materialized View other than primary key

2017-09-07 Thread Alex Kotelnikov
question is in the error message. For once it's very >> clear. The primary key of your materialized view is EXACTLY the same as for >> your base table. >> >> So the question is what's the point creating this materialized view ... >> >> >> >

Re: No columns are defined for Materialized View other than primary key

2017-09-07 Thread Alex Kotelnikov
LY the same as for > your base table. > > So the question is what's the point creating this materialized view ... > > > > On Thu, Sep 7, 2017 at 4:01 PM, Alex Kotelnikov < > alex.kotelni...@diginetica.com> wrote: > >> Hey. I have a problem creating

No columns are defined for Materialized View other than primary key

2017-09-07 Thread Alex Kotelnikov
Hey. I have a problem creating a materialized view. My case is quite similar to https://issues.apache.org/jira/browse/CASSANDRA-13564 but discussion in comments there faded, let me describe by case. I have a table like CREATE TABLE users ( site_id int, user_id text, n int, data set>, PR

Re: Full table scan with cassandra

2017-08-17 Thread Alex Kotelnikov
ra-loader/blob/master/ > src/main/java/com/datastax/loader/CqlDelimUnload.java > > > > On Thu, Aug 17, 2017 at 10:00 AM, Alex Kotelnikov < > alex.kotelni...@diginetica.com> wrote: > >> yup, user_id is the primary key. >> >> First of all,can you sha

Re: Full table scan with cassandra

2017-08-17 Thread Alex Kotelnikov
17 August 2017 at 19:54, Dor Laor wrote: > On Thu, Aug 17, 2017 at 9:36 AM, Alex Kotelnikov < > alex.kotelni...@diginetica.com> wrote: > >> Dor, >> >> I believe, I tried it in many ways and the result is quite disappointing. >> I've run my scans on 3 diff

Re: Full table scan with cassandra

2017-08-17 Thread Alex Kotelnikov
do it in this blog: http://www.scylladb.com/ > 2017/02/13/efficient-full-table-scans-with-scylla-1-6/ > and the results are here: http://www.scylladb.com/ > 2017/03/28/parallel-efficient-full-table-scan-scylla/ > The algorithm should translate to Cassandra but you'll have to use &

Full table scan with cassandra

2017-08-16 Thread Alex Kotelnikov
Hey, we are trying Cassandra as an alternative for storage huge stream of data coming from our customers. Storing works quite fine, and I started to validate how retrieval does. We have two types of that: fetching specific records and bulk retrieval for general analysis. Fetching single record wo