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, Apr
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
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 get username and timestamp in c
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?
Th
Thanks Tyler.
On Tue, Mar 7, 2017 at 10:54 PM, Tyler Hobbs wrote:
>
> On Sun, Mar 5, 2017 at 11:53 PM, anuja jain wrote:
>
>> Is there is difference between creating column of type
>> frozen> and frozen where list_double is UDT of
>> type frozen> ?
>
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?
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
wrote:
> Nodetool status key space_name .
> On Tue, Feb 28, 2017 at 4:53 AM anuja jain wrote:
>
>> Hi,
>> Using nodetool cfstats gives me dat
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?
Hi,
I am using solr of dse 4.8.3 to do text search on cassandra data.
On a String type column when I am use regex email:*gmail* it does not
return me the data that is inserted after starting cassandra in solr mode.
Infact on hitting query everytime it is returning different result.
Schema.xml has f
rdering 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" wrote:
>
>> I understand the meaning of SSTable but
already in
production.?
On Wed, Jan 13, 2016 at 12:17 AM, Robert Coli wrote:
> On Mon, Jan 11, 2016 at 11:30 PM, anuja jain wrote:
>
>> 1 more question, what does it mean by "cassandra inherently sorts data"?
>>
>
> SSTable = Sorted Strings Table.
>
&
abc | WB
On Tue, Jan 12, 2016 at 12:52 PM, anuja jain 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://docs.datastax.com/en/datastax_
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 wrote:
>
> On Thu, Jan 7, 2016 at 6:45 AM, anuja jain wrote:
>
>> My question is, what is the alternative if w
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
-
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
> wrote:
>
>> We would like to mig
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 node (N=1) and RF=1 now, and you want to go N=3 RF=3, you
> >> ought
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 th
17 matches
Mail list logo
