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
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
/products-services/devcenter
On Thu, Nov 21, 2013 at 12:23 AM, subhankar biswas
neo20iit...@gmail.comwrote:
Afaik. you can't. u can only see the created tables..
On Nov 21, 2013 11:18 AM, Techy Teck comptechge...@gmail.com wrote:
Anyone?
On Tue, Nov 19, 2013 at 1:26 PM, Techy Teck
Anyone?
On Tue, Nov 19, 2013 at 1:26 PM, Techy Teck comptechge...@gmail.com 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
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..
', '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_new (
employee_id text,
employee_name text,
value text,
last_modified_date timeuuid
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
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
, at 12:54 pm, Techy Teck comptechge...@gmail.com wrote:
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)
);
Before
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
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
of the 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 comptechge...@gmail.com wrote:
I have below table in CQL-
create table test (
employee_id text,
employee_name text,
value text,
last_modified_date
3.)
Then you populate all those tables with your data and then you use those
tables depending on the query.
Cheers,
Hannu
2013/11/3 Techy Teck comptechge...@gmail.com
I have below table in CQL-
create table test (
employee_id text,
employee_name text,
value text
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
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](
, Techy Teck comptechge...@gmail.comwrote:
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
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 h...@filez.com wrote:
Dne 11.5.2013 21:36, Techy
How to figure out from the Datastax OPSCENTER whether the compaction is
finished/done?
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?
, 2013 at 2:19 AM, Utkarsh Sengar utkarsh2...@gmail.comwrote:
Difference b/w cqlsh and cli is documented by the datastax guys here
nicely: http://www.datastax.com/support-forums/topic/cli-vs-cql
Thanks,
-Utkarsh
On Sun, Apr 21, 2013 at 1:39 PM, Techy Teck comptechge...@gmail.comwrote:
Yeah
to me that you are not saying the keyspace of your column family
'profile'.
Regards,
Francisco.
On Apr 20, 2013, at 9:56 PM, Techy Teck comptechge...@gmail.com wrote:
I created my column family like this from the CLI-
create column family profile
with key_validation_class = 'UTF8Type
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 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
://www.datastax.com/docs/1.0/references/cql/SELECT
Thanks,
-Utkarsh
On Sun, Apr 21, 2013 at 1:04 PM, Techy Teck comptechge...@gmail.comwrote:
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
.
But If 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 comptechge...@gmail.com wrote:
I created my column family like this from the CLI-
create
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 MapString, String getAttributes(final String userId, final
CollectionString attributeNames) {
String query=SELECT
...@mebigfatguy.comwrote:
getColumnDefinitions only returns meta data, to get the data, use the
iterator to navigate the rows
IteratorRow 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
, Tyler Hobbs ty...@datastax.com wrote:
On Thu, Apr 18, 2013 at 9:02 PM, Techy Teck comptechge...@gmail.comwrote:
When I was working with Cassandra CLI using the Netflix client(Astyanax
client), then I created the column family like this-
create column family profile
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 =
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
)
* Solution to read all rows efficiently
problems:
* It consume more memory
2013/4/16 Techy Teck comptechge...@gmail.com
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
families.
From: Techy Teck [mailto:comptechge...@gmail.com]
Sent: woensdag 17 april 2013 8:14
To: user
Subject: Re: Cassandra Client Recommendation
Thanks Everton for the suggestion. Couple of questions-
1) Does Astyanax client have any problem with previous version of
Cassandra
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
35 matches
Mail list logo