On Thu, Jun 21, 2012 at 12:06 AM, Data Craftsman
wrote:
> Hello,
>
> CQL BATCH is good for INSERT/UPDATE performance.
>
> But it cannot do binding variable, exposed to SQL injection.
>
> Is there a plan to make CQL BATCH to support binding variable in near future?
>
> e.g.
> http://code.google.com
On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis wrote:
> I have the following schema:
>
> describe columnfamily visitor_audit;
>
> CREATE TABLE visitor_audit (
> visitor_id text,
> audit_id uuid,
> account_id int,
> audit_type int,
> created_at text,
> PRIMARY KEY (visitor_id, audit_id)
I have the following schema:
describe columnfamily visitor_audit;
CREATE TABLE visitor_audit (
visitor_id text,
audit_id uuid,
account_id int,
audit_type int,
created_at text,
PRIMARY KEY (visitor_id, audit_id)
) WITH
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.1
Thanks.
I just fix my problem, I missing a jar named libthrift-0.6.jar.
On Thu, Jun 21, 2012 at 10:10 AM, dong.yajun wrote:
> Hi list
>
> I'd like to connect to remote Cassandra using Java client, the following
> code I use, but ImcompatibleClassChangeError was occured, the source that
> was ju
Hi list
I'd like to connect to remote Cassandra using Java client, the following
code I use, but ImcompatibleClassChangeError was occured, the source that
was just dependent on the following jars:
apache-cassandra-1.0.9.jar, apache-cassandra-clientutil-1.0.9.jar,
apache-cassandra-thrift-1.0.9.jar
Hello,
CQL BATCH is good for INSERT/UPDATE performance.
But it cannot do binding variable, exposed to SQL injection.
Is there a plan to make CQL BATCH to support binding variable in near future?
e.g.
http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/
Query substitution
Use named pa
why not just store the URL of pic / video, just like the RDBMS did,
cassandra is merely a distributed database from some kind point of view. it
is more like a schema design issue. Any video or pic should not be put into
the DB especially big data table DB as raw binary format. and did this kind
of
Take also into account Thrift's limits.
http://wiki.apache.org/cassandra/CassandraLimitations
Paolo
On Jun 20, 2012 10:11 PM, "Dave Brosius" wrote:
>
> Column values are limited at 2G.
>
> Why store them as Base64? that just adds overhead. Storing the raw bytes
> will save you a bunch.
>
>
> *-
Column values are limited at 2G.Why store them as Base64? that just adds
overhead. Storing the raw bytes will save you a bunch. - Original Message
-From: "Cyril Auburtin" >;cyril.aubur...@gmail.com
Hi all
I'm wondering how or if it's possible to implement efficient wildcards at
both ends, e.g. *string*
I can think of a few options... please comment, thanks =D
- if I can get another equality constraint which narrows down potential
result set significantly, I can do a scan. I'm not sure how
Thanks very much, Sylvain, for the hints.
Thierry
Yes, you have to use double quotes in CQL3 to force the case of an
identifier (so CREATE TABLE "FooBar" rather than CREATE TABLE FooBar).
-- Sylvain
Nick, thanks for the response. Does cleanup only cleanup keys that no
longer belong to that node. Just to add more color, when I bulk loaded all
my data into these 6 nodes, all of them had the same amount of data. After
the first nodetool repair, the first node started having more data than the
res
On Wed, Jun 20, 2012 at 1:45 PM, Thierry Templier
wrote:
> Hello,
>
> I'm using CQL 3 to create column families within a keyspace with Cassandra
> 1.1.1. Column families are
> created but all names (column families and their column definitions) are in
> lowercase. Is it possible to prevent
> from
How did you solve your problem eventually? I am experiencing something
similar. Did you run cleanup on the node that has 80GB data?
-Raj
On Mon, Aug 15, 2011 at 10:12 PM, aaron morton wrote:
> Just checking do you have read_repair_chance set to something ? The second
> request is going to all re
Hello,
I'm using cqlsh tool to create column families and it works fine.
However I don't know how to use the following commands:
Documented commands (type help ):
ASSUME CAPTURE DESC DESCRIBE EXIT HELP SELECT SHOW SOURCE USE
Moreover I can't d
Hello,
I'm using CQL 3 to create column families within a keyspace with
Cassandra 1.1.1. Column families are
created but all names (column families and their column definitions) are
in lowercase. Is it possible to prevent
from this behavior?
Thanks very much for your help.
Thierry
Hi I solved the problem. Some of my sstables where owned by
"root:root". Probably from a previous cluster I had. A chown -R
cassandra:cassandra solved the problem.
So it apparently was a combination of JNA + permission problem. No It
works like a charm.
Thanks !
2012/6/20 Rob Coli :
> On Tue, Ju
Good day,
I'm load testing our cassandra instance. I have a column family with 2300 rows,
each being ~ 5MB. And I run same query which asks for same rows. With
caching='keys_only" response time is adequate. But with caching='ALL', we get
four times larger response time and 40-50$ of requests do
yep, good idea, I have created an issue.
2012/6/19 Yuhan Zhang
> Hi Jeremy,
>
> Glad to see the update. It would be nice if secondary index in
> cassandra-unit supports DoubleType.
>
> Yuhan
>
>
> On Wed, Jun 13, 2012 at 1:32 PM, Jérémy SEVELLEC wrote:
>
>> Hi all,
>>
>> cassandra-unit 1.1.0.1 i
19 matches
Mail list logo
