/opsBackupSnapshotRestore.html
Thank you.
Yours sincerely
RAVI TEJA A V
We are starting a new project in Cassandra. Is 3.2 stable enough to be used
in production. If not, which is the most stable version in 2.x.
thanks.
You are moving from a SQL database to C* ??? I hope you are aware of the
differences between a nosql like C* and a RDBMS. To keep it short, the app
has to change significantly.
Please read documentation on differences between nosql and RDBMS.
thanks.
On Tue, Jan 5, 2016 at 6:20 AM, Bhuvan Rawal
I did join on single big table and it's working fine using code you showed
below.
Can we do table join on non partition key? Or not a primary key column ?
Thanks,
Ravi
On Thu, Nov 12, 2015 at 5:41 AM DuyHai Doan wrote:
> Hello Prem
>
> I believe it's better to ask your qu
on C* node can connect
using localhost as connection url and remote program's using IP/name in
connection url?
Is this approach correct to connect local spark job to its local C* node
for any RDD operations?
Thanks,
Ravi
Hi,
I configured parameter as follows -
Gc_grace_seconds = 1hour.
Tombstone threshold = 1%
1. I deleted 33% of the existing data but I don't see any change in disk
space the next day (24 hrs). Column family had 24,000 rows and the number of
partition keys per row is about 1million. Is the
Cannot find something corresponding to where clause there.
From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com]
Sent: Tuesday, February 03, 2015 2:44 PM
To: user@cassandra.apache.org
Subject: RE: Smart column searching for a particular rowKey
Thanks, it does.
How about in astyanax?
From
b 3, 2015 at 11:28 AM, Ravi Agrawal
mailto:ragra...@clearpoolgroup.com>> wrote:
Hi Guys,
Need help with this.
My rowKey is stockName like GOOGLE, APPLE.
Columns are sorted as per timestamp and they include some set of data fields
like price and size. So, data would be like 1. 9:31:00, $520, 1
Hi Guys,
Need help with this.
My rowKey is stockName like GOOGLE, APPLE.
Columns are sorted as per timestamp and they include some set of data fields
like price and size. So, data would be like 1. 9:31:00, $520, 100 shares 2.
9:35:09, $530, 1000 shares 3. 9:45:39, $520, 500 shares
I want to searc
ot;, this parameter will do the job.
If you have fragments, you might trigger this compaction for nothing. In the
case of frequently updated rows (like when using wide rows / time series) your
only way to get rid of tombstone is a major compaction.
That's how I understand this.
Hope this
is trying to read 800k*200k rows. That will be 160B
rows!
Did you try “SELECT DISTINCT …” from cqlsh?
Mohammed
From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com]
Sent: Thursday, January 22, 2015 11:12 PM
To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Subject: RE: Retr
I don't think that such a thing exists as SSTables are immutable. You compact
it entirely or you don't. Minor compaction will eventually evict tombstones. If
it is too slow, AFAIK, the "better" solution is a major compaction.
C*heers,
Alain
2015-01-23 0:00 GMT+01:00 Ravi Agrawal
all the composite columns if you are using a composite
partition key.
Mohammed
From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com]
Sent: Thursday, January 22, 2015 1:57 PM
To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Subject: RE: Retrieving all row keys of a CF
Hi,
I want to trigger just tombstone compaction after gc grace seconds is completed
not nodetool compact keyspace column family.
Anyway I can do that?
Thanks
happening, but then reading 800,000 partitions is not a
normal operation.
Just as an experimentation, can you set the range timeout to 45 seconds on each
node and the timeout on the Astyanax client to 50 seconds? Restart the nodes
after increasing the timeout and try again.
Mohamme
4) What are the timeouts for the Astyanax client?
5) Do you see GC pressure on the C* nodes? How long does GC for new gen
and old gen take?
6) Does any node crash with OOM error when you try AllRowsReader?
Mohammed
From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com]
Sent: Fri
Hi,
I and Ruchir tried query using AllRowsReader recipe but had no luck. We are
seeing PoolTimeoutException.
SEVERE: [Thread_1] Error reading RowKeys
com.netflix.astyanax.connectionpool.exceptions.PoolTimeoutException:
PoolTimeoutException: [host=servername, latency=2003(2003), attempts=4]Timed
I'm seeing the same with cassandra-2.0.4 during compaction, after lot of
sstable files are streamed after bootstrap/repair. Strange thing is, the 'Last
written key >= current key' exception during compaction of L0, L1 sstables,
goes away after restarting cassandra. But, then see those warnings a
tual Nodes and
256 tokens are assigned to it, how does the STATUS line only show one token
value? In this case the -12331...#.
On Mon, Oct 7, 2013 at 9:00 PM, Sameer Farooqui wrote:
Thanks, Ravi!
>
>
>
>On Mon, Oct 7, 2013 at 2:40 AM, ravi prasad wrote:
>
>the output of &
SSANDRA-3722 for the details on how it
is used by dynamic snitching).
LOAD is the data size (sum of size of all the ColumnFamilies in a node).
the number next to the STATUS line is the token assigned to that node. you seem
to be using Murmur3Partitioner, which has negative tokens.
-Ravi
On Sun
able like below:
create table object (
id uuid,
facet text,
revision timeuuid
value text
primary key (id,facet,revision) #clustered on facet and revision
Does CQL3 support querying efficiently 'get latest revision for all facets
where id='something'; in a single query. What would the query look like?
Thanks,
-Ravi
21 matches
Mail list logo
