I am trying to setup two node Cassandra Cluster on windows machine. I have
basically two windows machine and I was following this datastax tutorial (
http://www.datastax.com/2012/01/how-to-setup-and-monitor-a-multi-node-cassandra-cluster-on-windows
)
Whenever I use the below command to get the tok
I am trying to setup two nodes of Cassandra cluster on my windows machine.
Basically, I have two windows machine. In both of my machine, I have
installed Cassandra 1.2.11 from Datastax. Now I was following this
[tutorial](
http://www.datastax.com/2012/01/how-to-setup-and-monitor-a-multi-node-cassan
lable
> for your architecture (i had 64-bit linux), starting up will fail to link
> the nodes. It'll also be silent unless you set a certain class logging
> level to DEBUG, but it basically presented as if nodes would each form
> their own single-machine ring
>
>
> On Fr
I have below table in CQL-
create table test (
employee_id text,
employee_name text,
value text,
last_modified_date timeuuid,
primary key (employee_id)
);
I inserted couple of records in the above table like this which I will be
inserting in our actual use case scenario as
employee_name? 4. Give me all the
employee_id for any of the employee_name?*
On Sun, Nov 3, 2013 at 10:26 AM, Techy Teck wrote:
> I have below table in CQL-
>
> create table test (
> employee_id text,
> employee_name text,
> value text,
> last_m
3) A table with employee_name as the primary key (your test query with
> employee_name 'e27' and use cases 1 & 3.)
>
> Then you populate all those tables with your data and then you use those
> tables depending on the query.
>
> Cheers,
> Hannu
>
>
>
We are using CQL table like this -
CREATE TABLE testing (
description text,
last_modified_date timeuuid,
employee_id text,
value text,
PRIMARY KEY (employee_name, last_modified_date)
)
We have made description as text in the above table. I am thinking is there
any limitations on text d
I am using the below table in our use case -
create table testing1 (
employee_id text,
employee_name text,
value text,
last_modified_date timeuuid,
primary key (employee_name,last_modified_date)
);
In my above table employee_id will be unique always starting from 1 till
327
I am using the below table in our use case -
create table test_new (
employee_id text,
employee_name text,
value text,
last_modified_date timeuuid,
primary key (employee_id, last_modified_date)
);
create index employee_name_idx on test_new (e
@Jacob - See my this question with the subject - *CQL Tables in Cassandra
with an Index*
I just send it out.. Sorry for duplicacy.. After I posted it out, I realize
I missed the important details..
On Thu, Nov 7, 2013 at 6:52 PM, Jacob Rhoden wrote:
>
>
> > On 8 Nov 2013, at 12:
st_modified_date) values ('1', 'e29', 'some_new_value', now()) *if not
> exists*;
>
>
>
> Le vendredi 8 novembre 2013 03:53:12 UTC+1, Techy Teck a écrit :
>
>> I am using the below table in our use case -
>>
>> create table test_n
Does OpsCenter support CF created using CQL? If yes, then is there any
specific version that we need to use for the OpsCenter?
Currently we have OpsCenter in production which doesn't show the tables
created using CQL..
Anyone?
On Tue, Nov 19, 2013 at 1:26 PM, Techy Teck wrote:
> Does OpsCenter support CF created using CQL? If yes, then is there any
> specific version that we need to use for the OpsCenter?
>
> Currently we have OpsCenter in production which doesn't show the tables
> created using CQL..
>
we-offer/products-services/devcenter
>
>
> On Thu, Nov 21, 2013 at 12:23 AM, subhankar biswas
> wrote:
>
>> Afaik. you can't. u can only see the created tables..
>> On Nov 21, 2013 11:18 AM, "Techy Teck" wrote:
>>
>>> Anyone?
>>>
>>
I am trying to insert into Cassandra database using Datastax Java driver.
But everytime I am getting below exception at `prBatchInsert.bind` line-
com.datastax.driver.core.exceptions.InvalidTypeException: Invalid type
for value 1 of CQL type text, expecting class java.lang.String but class
[Lj
Below is my CQL table -
CREATE TABLE test1 (
id text,
record_name text,
record_value blob,
PRIMARY KEY (id, record_name)
)
here id column will have data like this -
timestamp.count
And here timestamp is in milliseconds but rounded up to nearest seconds. So
as
Hello,
I have recently started working with Cassandra Database. Now I am in the
process of evaluating which Cassandra client I should go forward with.
I am mainly interested in these three-
--1) Astyanax client
2--) New Datastax client that uses Binary protocol.
--3) Pelops clien
than 15mb)
> * Solution to read all rows efficiently
>
> problems:
> * It consume more memory
>
>
> 2013/4/16 Techy Teck
>
>> Hello,
>> I have recently started working with Cassandra Database. Now I am in the
>> process of evaluating which Cassandra client
itute Hector by Astyanax totally but
> at this moment we are using both:
> >
> > - Astyanax for cql.
> > - Hector for dynamic column families.
> >
> >
> > From: Techy Teck [mailto:comptechge...@gmail.com]
> > Sent: woensdag 17 april 2
I have started working with Cassandra database. I am planning to use
Datastax API to upsert/read into/from cassandra database. I am totally new
to this Datastax API (which uses new Binary protocol) and I am not able to
find lot of documentations as well which have some proper examples.
I am not su
e help.
On Fri, Apr 19, 2013 at 2:17 PM, Tyler Hobbs wrote:
>
> On Thu, Apr 18, 2013 at 9:02 PM, Techy Teck wrote:
>
>>
>> When I was working with Cassandra CLI using the Netflix client(Astyanax
>> client), then I created the column family like this-
>>
>
I am also running into this problem. I have already enabled
*start_native_transport:
true*
And by this, I am trying to make a connection-
private CassandraDatastaxConnection() {
try{
cluster =
Cluster.builder().addContactPoint("localhost").build();
session = c
I created my column family like this from the CLI-
create column family profile
with key_validation_class = 'UTF8Type'
and comparator = 'UTF8Type'
and default_validation_class = 'UTF8Type'
and column_metadata = [
{column_name : account, validation_class : 'UTF8Type'}
{
I am working with Datastax java-driver. And I am trying to retrieve few
columns from the database basis on the input that is being passed to the
below method-
public Map getAttributes(final String userId, final
Collection attributeNames) {
String query="SELECT " +attributeNames.toString().substr
eta data, to get the data, use the
> iterator to navigate the rows
>
>
> Iterator it = result.iterator();
>
> while (it.hasNext()) {
> Row r = it.next();
> //do stuff with row
>
> }
>
> On 04/21/2013 12:02 AM, Techy Teck wrote:
>
> I am working with
I have inserted 1000 rows in Cassandra database. Now I am trying to find
out how many rows have been inserted in Cassandra database using the CLI
mode.
In rdbms, I can do this sql-
* SELECT count(*) from TABLE;*
And this will give me total count for that table;
How to do the same thing i
www.datastax.com/docs/1.0/references/cql/SELECT
>
> Thanks,
> -Utkarsh
>
>
>
> On Sun, Apr 21, 2013 at 1:04 PM, Techy Teck wrote:
>
>> I have inserted 1000 rows in Cassandra database. Now I am trying to find
>> out how many rows have been inserted in Cassandra da
I try to insert into table that I have created in CQLsh mode, I am
able to insert into that.
Any help will be appreciated.
I am running Cassandra 1.2.3
On Sat, Apr 20, 2013 at 5:56 PM, Techy Teck wrote:
> I created my column family like this from the CLI-
>
>
> create column fa
not saying the keyspace of your column family
> 'profile'.
>
> Regards,
> Francisco.
>
>
> On Apr 20, 2013, at 9:56 PM, Techy Teck wrote:
>
> I created my column family like this from the CLI-
>
>
> create column family profile
> with ke
I created my column family in Cassandra database like this from the CLI-
create column family PROFILE
with key_validation_class = 'UTF8Type'
and comparator = 'UTF8Type'
and default_validation_class = 'UTF8Type'
and column_metadata = [
{column_name : lmd, validation_class : 'DateType'}
];
Now I
I have bunch of `SSTables` with me that I got from somebody within my team.
Now I was trying to push those `SSTABLES` into `Cassandra database`.
I created corresponding keyspace and column family successfully.
Now as soon as I execute `SSTableLoader` command, I always get below
exception?
S
ogLog
>
> we tested the library very well, but not with real live data.
> version for Redis is included too for easy testing.
>
> Nikolay.
>
>
>
>
>
> On Mon, Apr 22, 2013 at 2:19 AM, Utkarsh Sengar wrote:
>
>> Difference b/w cqlsh and cli is documented by th
How to figure out from the Datastax OPSCENTER whether the compaction is
finished/done?
Does anyone using Astyanax client in production mainly for reading purpose?
I am running Cassandra 1.2.2 in production. What kind of problems you
talking about? Might be I get some root cause why I am seeing bad read
performance with Astyanax client in production cluster.
On Sat, May 11, 2013 at 5:16 PM, Radim Kolar wrote:
> Dne 11.5.2013 21:36, Techy Teck napsa
35 matches
Mail list logo
