Secondary indices on boolean type columns

I have two questions, 1. Does creating secondary index on low cardinality columns like of boolean type helps in read performance any ways? Because there will be only two values( true and false ) for that column in index table. 2. Should secondary indexes be created on clustering columns even if

Re: Is replication possible with already existing data?

Hi Ajay, On Fri, Oct 9, 2015 at 9:00 AM, Ajay Garg wrote: > On Thu, Oct 8, 2015 at 9:47 AM, Ajay Garg wrote: > > Thanks Eric for the reply. > > > > > > On Thu, Oct 8, 2015 at 1:44 AM, Eric Stevens wrote: > >> If you're at 1

Sorting & pagination in apache cassandra 2.1

HI All, If suppose I have a cassandra table with structure CREATE TABLE test.t1 ( col1 text, col2 text, col3 text, col4 text, PRIMARY KEY (col1, col2, col3, col4) ) WITH CLUSTERING ORDER BY (col2 ASC, col3 ASC, col4 ASC); and it has following data col1 | col2 | col3 | col4

Re: Running sstableloader from every node when migrating?

Hello George, You can use sstable2json to create the json of your keyspace and then load this json to your keyspace in new cluster using json2sstable utility. On Tue, Dec 1, 2015 at 3:06 AM, Robert Coli wrote: > On Thu, Nov 19, 2015 at 7:01 AM, George Sigletos

Re: Sorting & pagination in apache cassandra 2.1

is already in production.? On Wed, Jan 13, 2016 at 12:17 AM, Robert Coli <rc...@eventbrite.com> wrote: > On Mon, Jan 11, 2016 at 11:30 PM, anuja jain <anujaja...@gmail.com> wrote: > >> 1 more question, what does it mean by "cassandra inherently sorts data"? >

Re: Sorting & pagination in apache cassandra 2.1

planning if we need to search using SOLR. What is other alternative when we do not know the size of the data ? Thanks, Anuja On Fri, Jan 8, 2016 at 12:15 AM, Tyler Hobbs <ty...@datastax.com> wrote: > > On Thu, Jan 7, 2016 at 6:45 AM, anuja jain <anujaja...@gmail.com> wrote

Re: Sorting & pagination in apache cassandra 2.1

abc | WB On Tue, Jan 12, 2016 at 12:52 PM, anuja jain <anujaja...@gmail.com> wrote: > What is the alternative if my cassandra version is prior to 3.0 > (specifically) 2.1) and which is already in production.? > > Also as per the docs given at > > > https://

Re: Sorting & pagination in apache cassandra 2.1

gt; > To see some meaningful ordering there should be some clustering column > defined. > > You can use create additional column families to maintain ordering. Or use > external solutions like elasticsearch. > On Jan 12, 2016 10:07 PM, "anuja jain" <anujaja...@gmail.com> wrot

How to find total data size of a keyspace.

Hi, Using nodetool cfstats gives me data size of each table/column family and nodetool ring gives me load of all keyspace in cluster but I need total data size of one keyspace in the cluster. How can I get that?

Can we get username and timestamp in cqlsh_history?

Hi, I have a cassandra cluster having a lot of keyspaces and users. I want to get the history of cql commands along with the username and the time at which the command is run. Also if we are running some commands from GUI tools like Devcenter,dbeaver, can we log those commands too? If yes, how?

Re: Frozen type sin cassandra.

Thanks Tyler. On Tue, Mar 7, 2017 at 10:54 PM, Tyler Hobbs <ty...@datastax.com> wrote: > > On Sun, Mar 5, 2017 at 11:53 PM, anuja jain <anujaja...@gmail.com> wrote: > >> Is there is difference between creating column of type >> frozen<list> and frozen whe

Re: [Marketing Mail] Re: nodetool status high load info

Do you perform a lot of deletes or updates on your database? On restart, it performs major compaction which can reduce the load on your node by removing stale data. Try configuring compaction in you conf to perform minor compaction i.e. compactions at a regular interval. Thanks, Anuja On Wed,

Re: Can we get username and timestamp in cqlsh_history?

(but I could be > missing something). DataStax Enterprise does have an auditing feature. > > > > > > Sean Durity > > > > *From:* anuja jain [mailto:anujaja...@gmail.com] > *Sent:* Wednesday, March 29, 2017 7:37 AM > *To:* user@cassandra.apache.org > *Subject:* Can we g

How to change frozen to non frozen columns in cassandra

Hi , I have a table with columns of type frozen I want to convert it to simple list How can I do that without droping existing column? I have data in that column. I am using dse 4.8.11 Thanks, Anuja

Frozen type sin cassandra.

Hi, Is there is difference between creating column of type frozen and frozen where list_double is UDT of type frozen ? Also how to create a solr index on such columns?

Re: How to find total data size of a keyspace.

nodetool status or nodetool ring still gives the load of all keyspaces on cluster. On Tue, Feb 28, 2017 at 6:56 PM, Surbhi Gupta <surbhi.gupt...@gmail.com> wrote: > Nodetool status key space_name . > On Tue, Feb 28, 2017 at 4:53 AM anuja jain <anujaja...@gmail.com> wrote: