You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by jb...@apache.org on 2012/07/11 18:39:15 UTC
[1/3] git commit: update README to cql
Updated Branches:
refs/heads/trunk ee5c09a85 -> 54a3d5395
update README to cql
Project: http://git-wip-us.apache.org/repos/asf/cassandra/repo
Commit: http://git-wip-us.apache.org/repos/asf/cassandra/commit/54a3d539
Tree: http://git-wip-us.apache.org/repos/asf/cassandra/tree/54a3d539
Diff: http://git-wip-us.apache.org/repos/asf/cassandra/diff/54a3d539
Branch: refs/heads/trunk
Commit: 54a3d5395650830104fc5e7c1b5162dec66a0057
Parents: 326312b
Author: Jonathan Ellis <jb...@apache.org>
Authored: Wed Jul 11 11:38:54 2012 -0500
Committer: Jonathan Ellis <jb...@apache.org>
Committed: Wed Jul 11 11:38:54 2012 -0500
----------------------------------------------------------------------
README.txt | 86 ++++++++++++++++++++++++------------------------------
1 files changed, 38 insertions(+), 48 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cassandra/blob/54a3d539/README.txt
----------------------------------------------------------------------
diff --git a/README.txt b/README.txt
index 3985a98..3391f64 100644
--- a/README.txt
+++ b/README.txt
@@ -1,3 +1,5 @@
+
+
Cassandra is a highly scalable, eventually consistent, distributed, structured
key-value store.
@@ -48,66 +50,54 @@ environment variable to the full path of prunsrv (e.g.,
C:\procrun\prunsrv.exe), and run "bin\cassandra.bat install".
Similarly, "uninstall" will remove the service.
-Now let's try to read and write some data using the command line client.
+Now let's try to read and write some data using the Cassandra Query Language:
- * bin/cassandra-cli --host localhost
+ * bin/cqlsh --cql3
The command line client is interactive so if everything worked you should
be sitting in front of a prompt...
- Connected to: "Test Cluster" on localhost/9160
- Welcome to cassandra CLI.
+ Connected to Test Cluster at localhost:9160.
+ [cqlsh 2.2.0 | Cassandra 1.1.3 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
+ Use HELP for help.
+ cqlsh>
+
- Type 'help;' or '?' for help. Type 'quit;' or 'exit;' to quit.
- [default@unknown]
-
-As the banner says, you can use 'help;' or '?' to see what the CLI has to
+As the banner says, you can use 'help;' or '?' to see what CQL has to
offer, and 'quit;' or 'exit;' when you've had enough fun. But lets try
-something slightly more interesting...
-
- [default@unknown] create keyspace Keyspace1;
- ece86bde-dc55-11df-8240-e700f669bcfc
- [default@unknown] use Keyspace1;
- Authenticated to keyspace: Keyspace1
- [default@Keyspace1] create column family Users with comparator=UTF8Type and default_validation_class=UTF8Type and key_validation_class=UTF8Type;
- 737c7a71-dc56-11df-8240-e700f669bcfc
-
- [default@KS1] set Users[jsmith][first] = 'John';
- Value inserted.
- [default@KS1] set Users[jsmith][last] = 'Smith';
- Value inserted.
- [default@KS1] set Users[jsmith][age] = long(42);
- Value inserted.
- [default@KS1] get Users[jsmith];
- => (column=last, value=Smith, timestamp=1287604215498000)
- => (column=first, value=John, timestamp=1287604214111000)
- => (column=age, value=42, timestamp=1287604216661000)
- Returned 3 results.
+something slightly more interesting:
+
+ cqlsh> CREATE SCHEMA schema1
+ WITH strategy_class = 'SimpleStrategy'
+ AND strategy_options:replication_factor='1';
+ cqlsh> USE schema1;
+ cqlsh:Schema1> CREATE TABLE users (
+ user_id varchar PRIMARY KEY,
+ first varchar,
+ last varchar,
+ age int
+ );
+ cqlsh:Schema1> INSERT INTO users (user_id, first, last, age)
+ VALUES ('jsmith', 'John', 'Smith', 42);
+ cqlsh:Schema1> SELECT * FROM users;
+ user_id | age | first | last
+ ---------+-----+-------+-------
+ jsmith | 42 | john | smith
+
+ cqlsh:Schema1>
If your session looks similar to what's above, congrats, your single node
-cluster is operational! But what exactly was all of that? Let's break it
-down into pieces and see.
-
- set Users[jsmith][first] = 'John';
- \ \ \ \
- \ \_ key \ \_ value
- \ \_ column
- \_ column family
+cluster is operational!
-Data stored in Cassandra is associated with a column family (Users),
-which in turn is associated with a keyspace (Keyspace1). In the example
-above, we set the value 'John' in the 'first' column for key 'jsmith'.
-
-For more information on the Cassandra data model be sure to checkout
-http://wiki.apache.org/cassandra/DataModel
+For more on what commands are supported by CQL, see
+https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile. A
+reasonable way to think of it is as, "SQL minus joins and subqueries."
Wondering where to go from here?
- * The wiki (http://wiki.apache.org/cassandra/) is the
- best source for additional information.
- * Join us in #cassandra on irc.freenode.net and ask questions.
+ * Getting started: http://wiki.apache.org/cassandra/GettingStarted
+ * Join us in #cassandra on irc.freenode.net and ask questions
* Subscribe to the Users mailing list by sending a mail to
user-subscribe@cassandra.apache.org
-
-
-
+ * Planet Cassandra aggregates Cassandra articles and news:
+ http://planetcassandra.org/