Re: TWCS Parameters - min max trreshold

2017-08-14 Thread Jeff Jirsa
TWCS will pass through all of the options to STCS, and use them for the TWCS first window ("now"). It will also use min_threshold to determine whether or not to try to invoke STCS in the current ("now") bucket, and max_threshold to determine how many sstables it will combine per pass in older

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread Tobin Landricombe
Can't change the delimiter (I'm on cqlsh 5.0.1). Best I can offer is https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlshExpand.html > On 14 Aug 2017, at 16:17, Jim Witschey wrote: > > Not knowing the problem you're trying to solve, I'm going to guess > cqlsh

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread Jim Witschey
Not knowing the problem you're trying to solve, I'm going to guess cqlsh is a bad tool for this job. If you want to put the results of CQL queries into a shell pipeline, a small custom script using a driver is probably a better fit, and should be possible to write without much effort.

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread Harikrishnan A
I have column values with Pipe separator, hence unable to replace this default delimiter from the output. ThanksĀ Hari On Monday, August 14, 2017 12:12 AM, algermissen1971 wrote: On 14.08.2017, at 07:49, Harikrishnan A wrote:

TWCS Parameters - min max trreshold

2017-08-14 Thread Lucas Benevides
Hello community, I am testing the Time Window Compaction Strategy (TWCS), in Cassandra 3.11 version with 10 nodes. The documentation ( https://docs.datastax.com/en/cassandra/3.0/cassandra/operations/opsConfigureCompaction.html) says it has only two parameters that are related to the same

Re: Large tombstones creation

2017-08-14 Thread Vlad
Hi, that's the issue, thanks! On Sunday, August 13, 2017 2:49 PM, Christophe Schmitz wrote: Hi Vlad, Are you by any chance inserting null values? If so you will create tombstones. The work around (Cassandra >= 2.2) is to use unset on your bound statement

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread algermissen1971
> On 14.08.2017, at 07:49, Harikrishnan A wrote: > > Hello, > > When I execute cqlsh -e "SELECT statement .." , it gives the output with a > pipe ('|') separator. Is there anyway I can change this default delimiter in > the output of cqlsh -e " SELECT statement