On Tue, Aug 26, 2014 at 6:50 PM, Jaydeep Chovatia <
chovatia.jayd...@gmail.com> wrote:
> Hi,
>
> I have question on inserting multiple cluster keys under same partition
> key.
>
> Ex:
>
> CREATE TABLE Employee (
> deptId int,
> empId int,
> name varchar,
> address varchar,
> salary int
I already have a 3node m3.large DSE cluster, but I can't seem to add
another m3.large node. I'm using the
ubuntu-trusty-14.04-amd64-server-20140607.1
(ami-a7fdfee2) AMI (instance-store backed, PV) on AWS, I install java 7 and
the JNA, then I go into opscenter to add a node. Things look good for 3 o
Hi stephen,
I have never added a node via OpsCenter, so this may be a short coming of
that process. However in non OpsCenter installs you would have to create
the data directories first:
sudo mkdir -p /mnt/cassandra/commitlog
sudo mkdir -p /mnt/cassandra/data
sudo mkdir -p /mnt/cassandra/saved_ca
Worked great! Thanks Mark!
On Wed, Aug 27, 2014 at 2:00 AM, Mark Reddy wrote:
> Hi stephen,
>
> I have never added a node via OpsCenter, so this may be a short coming of
> that process. However in non OpsCenter installs you would have to create
> the data directories first:
>
> sudo mkdir -p /m
Hi
I installed Cassandra on one node successfully using CLI I am able to add a
table to the keyspace as well as retrieve the data from the table. My query is
if I have text file on my local file system and I want to load on Cassandra
cluster or you can say bulk load. How can I achieve that. Ple
Hi Malay,
Yesterday i answered for your question but you didn't replied back whether
it worked for you or not.
Anyways you mean by importing text file into cassandra.
you can do that by following way.
COPY keyspace.columnfamily (column1, column2,...) FROM 'temp.csv' (location
of file);
for dir
Please try COPY command via CQL shell if it is delimited file.
Regards,
Baskar Duraikannu
-Original Message-
From: Malay Nilabh
Date: Wed, 27 Aug 2014 17:43:21
To: user@cassandra.apache.org
Reply-To: user@cassandra.apache.org
Subject: Bulk load in cassandra
Hi
I installed Cassandra on
Hi,
You can use the COPY command to load in data from a local file, however it
needs to be a csv formatted file. For more info see
http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/copy_r.html
Regards,
Mark
On 27 August 2014 13:13, Malay Nilabh wrote:
> Hi
>
> I installed Cass
Hey Patricia,
Thanks for your kind response. I will surely take care of that provided the
use of virtual nodes.
Thanks again!
On Tue, Aug 26, 2014 at 10:42 PM, Patricia Gorla wrote:
> Vineet,
>
> One more thing -- you have initial_token and num_tokens both set. If you
> are trying to use virt
I looked for the newest release, but only see release candidates, not a
stable release.
http://archive.apache.org/dist/cassandra/2.1.0/
" Using the post's example, consider the query of "get all readings for
sensor 1". With dynamic columns, the query is just "select * from data
where sensor_id=1". In CQL, not only does this take N different queries
(one per sample) but you have to explicitly know the collected_at values to
query
This release is for 2.0.10, not the 2.1.x line. If you want this release it is
at http://archive.apache.org/dist/cassandra/2.0.10/ The 2.1.x line is not
stable yet.
On August 27, 2014 at 11:29:46 AM, Razi Khaja (razi.kh...@gmail.com) wrote:
I looked for the newest release, but only see releas
Deepak -
Yes, you are indeed right. I must admit I am still trying to learn what
queries can and cannot be performed in Cassandra and I didn't realize that
you could query on a non-fully-specified primary key, as long as you *do* fully
qualify the partition key.
Cheers,
Ian
On Wed, Aug 27, 20
This clarifies my doubt.
Thanks You Sylvain for your help.
On Tue, Aug 26, 2014 at 11:59 PM, Sylvain Lebresne
wrote:
> On Tue, Aug 26, 2014 at 6:50 PM, Jaydeep Chovatia <
> chovatia.jayd...@gmail.com> wrote:
>
>> Hi,
>>
>> I have question on inserting multiple cluster keys under same partition
I'm using JMX to retrieve Cassandra metrics. I notice that Max and Count are
cumulative and aren't reset.How often are the stats for Mean,
99tthPercentile, etc reset back to zero?
For example, 99thPercentile shows as 1.5 mls. Over how many minutes?
ClientRequest/Read/Latency:
Latency
On Wed, Aug 27, 2014 at 12:38 PM, Donald Smith <
donald.sm...@audiencescience.com> wrote:
> I’m using JMX to retrieve Cassandra metrics. I notice that Max and
> Count are cumulative and aren’t reset.How often are the stats for Mean,
> 99tthPercentile, etc reset back to zero?
>
If they're
On Wed, Aug 27, 2014 at 5:13 AM, Malay Nilabh
wrote:
> I installed Cassandra on one node successfully using CLI I am able to
> add a table to the keyspace as well as retrieve the data from the table.
> My query is if I have text file on my local file system and I want to load
> on Cassandra clu
Try turning down 'tombstone_threshold' to something like '0.05' from it's
default of '0.2.' This will cause the SSTable to be considered for
tombstone only compactions more frequently (if %5 of the columns are
tombstones instead of 20%).
For a bit more info, see:
http://www.datastax.com/documentat
Great idea, will try that (right now is 10%, but being more aggressive
should hopefully work).
Cheers!
On Wed, Aug 27, 2014 at 7:02 PM, Nate McCall wrote:
> Try turning down 'tombstone_threshold' to something like '0.05' from it's
> default of '0.2.' This will cause the SSTable to be considere
Another option to force things - deleting the json metadata file for that
table will cause LCS to put all SSTables in level 0 and begin recompacting
them.
On Wed, Aug 27, 2014 at 5:15 PM, Paulo Ricardo Motta Gomes <
paulo.mo...@chaordicsystems.com> wrote:
> Great idea, will try that (right now i
On Wed, Aug 27, 2014 at 3:27 PM, Nate McCall wrote:
> Another option to force things - deleting the json metadata file for that
> table will cause LCS to put all SSTables in level 0 and begin recompacting
> them.
>
That's possible in versions where the level is in a JSON file, which is
versions
Make sure you have also setup the ephemeral drives as a raid device (use mdadm)
and mounted it under /mnt/cassandra otherwise your data dir is the os partition
which is usually very small.
Ben Bromhead
Instaclustr | www.instaclustr.com | @instaclustr | +61 415 936 359
On 27 Aug 2014, at 8:21 pm
22 matches
Mail list logo
