Hello All,
we are using pig (pig-0.10.0) to store some data in CF with compound key.
Cassandra version is 1.1.15. Here is the script for creating CF
CREATE TABLE clicks_c (
user_id varchar,
time timestamp,
url varchar,
PRIMARY KEY (user_id, time)
) WITH COMPACT STORAGE;
Here is descript
I am sorry if this is an FAQ. But I was wondering what the syntax for
describing an array? I have gotten as far as feeling a need to understand a
'super-column' but I fail after that. Once I have the metadata in place to
describe an array how do I insert data into the array? Get data from the
arra
I've updated the readme, thanks
On Sun, Nov 11, 2012 at 6:49 PM, Jean-Armel Luce wrote:
> Hello,
>
> I have installed the 1.2 beta2 (download source + compil)
>
> The CREATE SCHEMA fails if I do as explained in README.txt :
>
> bin/cqlsh --cql3<== --cql3 is the default in 1.2 so it is not n
If you shutdown c* and remove an sstable (and it associated data,
index, bloom filter , and etc) files it is safe. I would delete any
saved caches as well.
It is safe in the sense that Cassandra will start up with no issues,
but you could be missing some data.
On Sun, Nov 11, 2012 at 11:09 PM, B.
with NetworkTopologyStrategy it theoretically should work
http://www.datastax.com/docs/1.0/cluster_architecture/replication
On Thu, Nov 8, 2012 at 5:11 PM, ws wrote:
> If I have multiple clusters can I replicate a keyspace from each of those
> cluster to separate cluster?
>
>
That is fine. You just have to be careful that you haven't already inserted
data which would be rejected by the type you update to, as a client will have
issues reading that data back.
-Jeremiah
On Nov 11, 2012, at 4:09 PM, Kevin Burton wrote:
> What happens when you are mainly concerned abo
What happens when you are mainly concerned about the human readable formats?
Say initially you don't supply metadata for a key like foo in the column
family, but you get tired of seeing binary data displayed for the values so
you update the column family to get a more human readable format by addin
Past discussion here
http://www.mail-archive.com/user@cassandra.apache.org/msg08786.html
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 11/11/2012, at 4:51 PM, Jason Wee wrote:
> option -XX:+UseLargePages ?
>
>
> On Sat, Nov 10, 2012 a
If you have a long lived row with a lot of tombstones or overwrites, it's often
more efficient to select a known list of columns. There are short circuits in
the read path that can avoid older tombstones filled fragments of the row being
read. (Obviously this is hard to do if you don't know the
Also most idomatic clients use the information so they can return the
appropriate type to you.
> Can the metadata be applied
> after the fact? If so how?
UPDATE COLUMN FAMILY in the CLI will let you change it.
Note that we do not update the existing data. This can be a problem if you do
somet
> warning that Cassandra would not be auto-booted since it was listed as a seed
> machine and the init process never happened.
The warning is that it wont join the ring and try to request data from other
servers in the cluster.
If you are testing a single node it's not an issue.
> I am not s
I finally got it to work by putting the putting “127.0.0.1” in the list of seed
IPs. Any other address triggered the warning that Cassandra would not be
auto-booted since it was listed as a seed machine and the init process never
happened. I am not sure of the impact of setting it to this loopba
For your testing, I think put your machine's ip should work.
Thanks.
-Wei
Sent from my Samsung smartphone on AT&T
Original message
Subject: RE: Connecting to cassandra.
From: Kevin Burton
To: user@cassandra.apache.org
CC:
Thank you in the output.log I see the line:
I would be careful with the patch that was referred to above, it
hasn't been reviewed, and from a glance it appears that it will cause
an infinite compaction loop if you get more than 4 SSTables at max size.
it will, you need to setup max sstable size correctly.
How many hint sstables are there? What does sstable2json show?
On Thu, Nov 8, 2012 at 3:23 PM, Mike Heffner wrote:
> Is there a ticket open for this for 1.1.6?
>
> We also noticed this after upgrading from 1.1.3 to 1.1.6. Every node runs a
> 0 row hinted handoff every 10 minutes. N-1 nodes hint
Thank you this helps with my understanding.
So the goal here is to supply as many name/type pairs as can be reasonably
be foreseen when the column family is created? Can the metadata be applied
after the fact? If so how?
-Original Message-
From: Edward Capriolo [mailto:edlinuxg...@gmail.
Correct. Which is one reason there is a separate setting for
cross-datacenter read repair, by the way.
On Thu, Nov 8, 2012 at 4:43 PM, sankalp kohli wrote:
> Hi,
> Lets say I am reading with consistency TWO and my replication is 3. The
> read is eligible for global read repair. It will send
Forget about it, should have read
https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile instead
of source snapshot (not merged in 1.2-b2 snapshot ?)
- Pierre
From: Pierre Chalamet [mailto:pie...@chalamet.net]
Sent: Sunday, November 11, 2012 6:11 PM
To: user@cassandra.apache.o
Hello,
I have installed the 1.2 beta2 (download source + compil)
The CREATE SCHEMA fails if I do as explained in README.txt :
bin/cqlsh --cql3<== --cql3 is the default in 1.2 so it is not needed
Connected to Test Cluster at localhost:9160.
[cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL
Hi all,
I'm trying to create a keyspace through the CQL Binary Protocol but lamely
failed at doing this simple task with 1.2b2/cql3.
Various command tried:
DEBUG 18:08:23,240 Received: OPTIONS
DEBUG 18:08:23,240 Responding: SUPPORTED {CQL_VERSION=[3.0.0],
COMPRESSION=[snappy]}
DEBUG 1
If you supply metadata cassandra can use it for several things.
1) It validates data on insertion
2) Helps display the information in human readable formats in tools
like the CLI and
sstabletojson
3) If you add a built-in secondary index the type information is
needed, strings sort differently the
On Sat, Nov 10, 2012 at 7:17 PM, Edward Capriolo wrote:
> No it does not exist. Rob and I might start a donation page and give
> the money to whoever is willing to code it. If someone would write a
> tool that would split an sstable into 4 smaller sstables (even an
> offline command line tool)
S
Actually, if we're going to be precise, it's -2^63 to 2^63 - 1.
Long.MIN_VALUE is not a valid token for technical reasons.
Do note that you can still not change partitioner, so the new partitioner
is for new cluster. But that does mean that for existing ones you'll have
to make sure you do keep Ra
On Nov 11, 2012, at 12:01 AM, Binh Nguyen wrote:
> FYI: Repair does not remove tombstones. To remove tombstones you need to run
> compaction.
> If you have a lot of data then make sure you run compaction on all nodes
> before running repair. We had a big trouble with our system regarding
> tom
24 matches
Mail list logo
