Hi
Is their any official JDBC connectivity for Datastax Cassandra (or
Cassandra in general).
I am looking to fire insert into cassandra like that I can do in CQL.
Thanks
Hi,
I’m not sure how consistency level is applied on batch statement. I didn’t
found detailed information on datastax.com (1)
http://docs.datastax.com/en/cql/3.0/cql/cql_reference/batch_r.html
regarding that.
- It is possible to set a CL on individual statements.
- It is possible to set a
Hi,
I have basic doubt: I have an RDBMS with the following two tables:
Emp - EmpID, FN, LN, Phone, Address
Sal - Month, Empid, Basic, Flexible Allowance
My use case is to print the Salary slip at the end of each month and the
slip contains emp name and his other details.
Now, if
Thanks Rob.
1) Cassandra version is 2.0.12.
2) Interesting. Looking at JMX org.apache.cassandra.db - ColumnFamilies -
trackcontent - track_content - Attributes, I get:
LiveDiskSpaceUsed: 17788740448, i.e. ~17GB
LiveSSTableCount: 3
TotalDiskSpaceUsed: 55714084629, i.e. ~55GB
So it obviously
On Mon, Jul 6, 2015 at 1:30 PM, John Wong gokoproj...@gmail.com wrote:
But is there a problem with letting schema disagreement running for a long
time?
It depends on what the nature of the desynch is, but generally speaking
there may be.
If you added a column or a columnfamily, and one node
When we reboot the problematic node, we see the following errors in
system.log.
1. Does this mean hints column family is corrupted?
2. Can we scrub system column family on problematic node and its
replication partners?
3. How do we rebuild System keyspace?
On Mon, Jul 6, 2015 at 1:46 PM, Jeff Williams je...@wherethebitsroam.com
wrote:
1) Cassandra version is 2.0.12.
2) Interesting. Looking at JMX org.apache.cassandra.db - ColumnFamilies
- trackcontent - track_content - Attributes, I get:
LiveDiskSpaceUsed: 17788740448, i.e. ~17GB
Thanks. Yeah we typically restart the nodes in the minor version to force
resync.
But is there a problem with letting schema disagreement running for a long
time?
Thanks.
John
On Mon, Jul 6, 2015 at 2:29 PM, Robert Coli rc...@eventbrite.com wrote:
On Thu, Jul 2, 2015 at 9:31 PM, John Wong
Hey guys,
I'm using Ruby driver( http://datastax.github.io/ruby-driver/ ) for backup
scripts. I tried to discover all peers and got wrong peers that are different
with nodetool status.
=
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens
Anton,
I have also seen this issue with decommissioned nodes remaining in the
system.peers table.
On the bright side, they can be safely removed from the system.peers table
without issue. You will have to check every node in the cluster since this
is a local setting per node.
Jeff
On 6 July
On Mon, Jul 6, 2015 at 7:25 AM, Jeff Williams je...@wherethebitsroam.com
wrote:
So it appears that the 10 sstables that were compacted
to
/var/lib/cassandra/data/trackcontent/track_content/trackcontent-track_content-jb-57372
are still sitting around, with a couple of them being very large!
On Thu, Jul 2, 2015 at 9:31 PM, John Wong gokoproj...@gmail.com wrote:
Hi Graham. Thanks. We are still running on 1.2.16, but we do plan to
upgrade in the near future. The load on the cluster at the time was very
very low. All nodes were responsive, except nothing was show up in the logs
Hello,
I cannot find documentation on the last two parameters given by cfstats
below. It looks like most examples show 0 for these metrics, but our table has
large numbers. What do these mean?
Read Count: 60601817
Read Latency: 6.107321156707232 ms.
Write Count: 185864222
Write Latency:
On Mon, Jul 6, 2015 at 4:19 PM, Venkatesh Kandaswamy ve...@walmartlabs.com
wrote:
I cannot find documentation on the last two parameters given by
cfstats below. It looks like most examples show 0 for these metrics, but
our table has large numbers. What do these mean?
Average live cells
I’ve seen the same thing: https://issues.apache.org/jira/browse/CASSANDRA-9577
https://issues.apache.org/jira/browse/CASSANDRA-9577
I’ve had cases where a restart clears the old tables, and I’ve had cases where
a restart considers the old tables to be live.
On Jul 6, 2015, at 1:51 PM, Robert
There is a bug in Jira related to this, it is not a driver issue, is a
Cassandra issue. It is solved on 2.0.14 I think. I will post the ticket
once I find it.
Regards,
Carlos Juzarte Rolo
Cassandra Consultant
Pythian - Love your data
rolo@pythian | Twitter: cjrolo | Linkedin:
Wouldn't it suggest a delete heavy workload, rather than update?
On Mon, Jul 6, 2015 at 5:21 PM Robert Coli rc...@eventbrite.com wrote:
On Mon, Jul 6, 2015 at 4:19 PM, Venkatesh Kandaswamy
ve...@walmartlabs.com wrote:
I cannot find documentation on the last two parameters given by
Hi,
I have a keyspace which is using about 19GB on most nodes in the cluster.
However on one node the data directory for the only table in that keyspace
now uses 52GB. It seems that old sstables are not removed after compaction.
Here is a view of the data directory Data files before compaction
Hi Srinivasa,
I think you're right, In Cassandra you should favor denormalisation when in
RDBMS you find a relationship like this.
I'd suggest a cf like this
CREATE TABLE salaries (
EmpID varchar,
FN varchar,
LN varchar,
Phone varchar,
Address varchar,
month integer,
basic integer,
For 2.1-
https://github.com/apache/cassandra/blob/cassandra-2.1/src/java/org/apache/cassandra/dht/BootStrapper.java#L61
All the best,
[image: datastax_logo.png] http://www.datastax.com/
Sebastián Estévez
Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com
[image:
20 matches
Mail list logo