Re: Cqlsh copy command on a larger data set

2020-07-15 Thread Russell Spitzer
Alex is referring to the "writetime" and "tttl" values for each cell. Most tools copy via CQL writes and don't by default copy those previous writetime and ttl values and instead just give a new writetime value which matches the copy time rather than initial insert time. On Wed, Jul 15, 2020 at 3:

Re: Is cassandra schemaless?

2019-12-15 Thread Russell Spitzer
Cassandra is not schemaless. Not all nosql databases are schemaless either, the term is a little outdated since many nosql databases now support some or all of ansi SQL. Cassandra does not though, just a very limited subset called CQL On Sun, Dec 15, 2019, 8:04 PM lampahome wrote: > I read some

Re: PreparedStatement prepare what?

2019-12-13 Thread Russell Spitzer
Preparing statement basically lets the server optimize for the structure of a given query. So for example, say you want to Insert a lot of rows to a table with columns a, b, c. You may prepare a statement *Insert into fun_table (a,b,c) values (?,?,?)* The question marks are basically slots for va

Re: Inserting list data

2016-10-14 Thread Russell Spitzer
Are you sure you aren't using batches? These will assign the same timestamp to your inserts which can lead to unexpected behaviors. On Fri, Oct 14, 2016 at 9:45 PM Vladimir Yudovin wrote: > Did you try the same quires with Java driver without using prepared > statements? > > > Best regards, Vlad