RE: Support/Consulting companies

2016-08-19 Thread Huang, Roger
http://thelastpickle.com/


From: Roxy Ubi [mailto:roxy...@gmail.com]
Sent: Friday, August 19, 2016 2:02 PM
To: user@cassandra.apache.org
Subject: Support/Consulting companies

Howdy,
I'm looking for a list of support or consulting companies that provide 
contracting services related to Cassandra.  Is there a comprehensive list 
somewhere?  Alternatively could you folks tell me who you use?
Thanks in advance for any replies!
Roxy


RE: Validation of Data after data migration from RDBMS to Cassandra

2015-08-06 Thread Huang, Roger
Surbhi,
A general note, Cassandra tables are not normalized as in an RDBMS schema, so 
it’s not straight migration.
Best practice is to design your queries and then design your Cassandra schema 
to support those queries.
Patrick McFadin has a series on C* data modeling.
http://docs.datastax.com/en/cassandra/2.1
Roger



From: Surbhi Gupta [mailto:surbhi.gupt...@gmail.com]
Sent: Thursday, August 06, 2015 11:31 AM
To: user@cassandra.apache.org
Subject: Validation of Data after data migration from RDBMS to Cassandra

Hi,

We have to migrate the data from Oracle/mysql to Cassandra.
I wanted to understand, if we have any tool/utilitiy which can help in 
validation the data after the data migration to Cassandra.

Thanks
Surbhi


RE: Validation of Data after data migration from RDBMS to Cassandra

2015-08-06 Thread Huang, Roger
Surbhi
Sorry I meant to send the CQL link 
http://docs.datastax.com/en/cql/3.1/cql/cql_intro_c.html

Roger

From: Huang, Roger [mailto:rohu...@visa.com]
Sent: Thursday, August 06, 2015 11:39 AM
To: user@cassandra.apache.org
Subject: RE: Validation of Data after data migration from RDBMS to Cassandra

Surbhi,
A general note, Cassandra tables are not normalized as in an RDBMS schema, so 
it’s not straight migration.
Best practice is to design your queries and then design your Cassandra schema 
to support those queries.
Patrick McFadin has a series on C* data modeling.
http://docs.datastax.com/en/cassandra/2.1
Roger



From: Surbhi Gupta [mailto:surbhi.gupt...@gmail.com]
Sent: Thursday, August 06, 2015 11:31 AM
To: user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: Validation of Data after data migration from RDBMS to Cassandra

Hi,

We have to migrate the data from Oracle/mysql to Cassandra.
I wanted to understand, if we have any tool/utilitiy which can help in 
validation the data after the data migration to Cassandra.

Thanks
Surbhi


RE: Problem inserting set when query contains IF NOT EXISTS.

2014-01-13 Thread Huang, Roger
Validimir,
Thanks what version of Cassandra?
-Roger


From: Vladimir Prudnikov [mailto:v.prudni...@gmail.com]
Sent: Monday, January 13, 2014 11:57 AM
To: user
Subject: Problem inserting set when query contains IF NOT EXISTS.

Hi all,
I've spend a lot of time finding a bug in system, but it turns out that the 
problem is in Cassandra.

Here is how to reproduce.

=
CREATE KEYSPACE IF NOT EXISTS test_set WITH REPLICATION = { 'class' : 
'SimpleStrategy', 'replication_factor' : 1 };
USE test_set;

CREATE TABLE IF NOT EXISTS user (
key timeuuid PRIMARY KEY,
username text,
email text,
first_name text,
last_name text,
features settext,
) WITH caching='all';

INSERT INTO user(key,username,email,first_name,last_name,features) VALUES 
(now(),'ainsttp0ess2kiphu2pe1bbrle','l3b7brn6jp9e8s0mmsr7ae5...@mmcm4jf9a9g9b95c053ksbsi18.commailto:l3b7brn6jp9e8s0mmsr7ae5...@mmcm4jf9a9g9b95c053ksbsi18.com','gqh9ekmv6vc9nf1ce8eo3rjcdd','fmg92158br9ddivoj59417q514',{'i6v8i4a5gpnris5chjibllqf0','480m4c1obiq61ilii1g7rm0v17','50kovlifrtrtqihnvmbefaeacl'})
 IF NOT EXISTS;

select * from user;
==

The problem here is that user.features is null instead of set of 3 strings.
If you remove `IF NOT EXISTS` it executes correctly and set of string will be 
inserted.

I don't see any problem with the queries, seems to be the problem with C*.

--
Vladimir Prudnikov


RE: documentation on PlayOrm released

2012-11-07 Thread Huang, Roger
Dean,
What's the URL?
-Roger


-Original Message-
From: Hiller, Dean [mailto:dean.hil...@nrel.gov] 
Sent: Wednesday, November 07, 2012 7:43 AM
To: user@cassandra.apache.org
Subject: documentation on PlayOrm released

The first set of documentation on PlayOrm is now released.  It is also still 
growing as we have a dedicated person working on more documentation.  Check it 
out when you have a chance.

Later,
Dean