Hope these links would help you.
--Getting started with CQL
http://www.datastax.com/docs/0.8/dml/using_cql
--Getting started with CLI
http://www.datastax.com/docs/0.8/dml/using_cli
Thanks
Santosh
*From:*ÐΞ€ρ@Ҝ (๏̯͡๏) [mailto:deepuj...@gmail.com]
*Sent:* Sunday, October 13, 2013 2:22 PM
*To:* user
*Subject:* Re: Unable to start server
How do i install or start using CQL ? Can anyone point me to some
document, where i can start with ?
On Sun, Oct 13, 2013 at 1:55 PM, Sean McCully <sean_mccu...@yahoo.com
<mailto:sean_mccu...@yahoo.com>> wrote:
On Sunday, October 13, 2013 12:36:59 PM ÐΞ€ρ@Ҝ wrote:
I was able to connect to test cluster using
deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$
<mailto:deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$>
bin/cassandra-cli
-h localhost -p 9160
Connected to: "Test Cluster" on localhost/9160
Welcome to Cassandra CLI version 2.0.1
Please consider using the more convenient cqlsh instead of CLI
CQL3 is fully backwards compatible with Thrift data; see
http://www.datastax.com/dev/blog/thrift-to-cql3
Type 'help;' or '?' for help.
Type 'quit;' or 'exit;' to quit.
[default@unknown] show cluster name
/[default@unknown]/ <mailto:default@unknown> show cluster name;
Test Cluster
...
But show cluster name command is spinning and does not return "Test
Cluster"
Am i missing something ?
On Sun, Oct 13, 2013 at 12:34 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com
<mailto:deepuj...@gmail.com>> wrote:
> Am unable to connect to single node "Test Cluster" from casssandra client.
>
>
> Upon starting server, i see the following logs
> deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$
<mailto:deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$>
bin/cassandra -f
>
> xss = -ea -javaagent:bin/../lib/jamm-0.2.5.jar -XX:+UseThreadPriorities
>
> -XX:ThreadPriorityPolicy=42 -Xms2932M -Xmx2932M -Xmn600M
> -XX:+HeapDumpOnOutOfMemoryError -Xss256k
>
> INFO 12:27:56,613 Logging initialized
> INFO 12:27:56,632 JVM vendor/version: Java HotSpot(TM) 64-Bit Server
>
> VM/1.7.0_40
>
> INFO 12:27:56,632 Heap size: 3011510272/3011510272
>
> INFO 12:27:56,632 Classpath:
> bin/../conf:bin/../build/classes/main:bin/../build/classes/thrift:bin/../l
> ib/antlr-3.2.jar:bin/../lib/apache-cassandra-2.0.1.jar:bin/../lib/apache-c
> assandra-clientutil-2.0.1.jar:bin/../lib/apache-cassandra-thrift-2.0.1.jar
> :bin/../lib/commons-cli-1.1.jar:bin/../lib/commons-codec-1.2.jar:bin/../li
> b/commons-lang3-3.1.jar:bin/../lib/compress-lzf-0.8.4.jar:bin/../lib/concu
> rrentlinkedhashmap-lru-1.3.jar:bin/../lib/disruptor-3.0.1.jar:bin/../lib/g
> uava-15.0.jar:bin/../lib/high-scale-lib-1.1.2.jar:bin/../lib/jackson-core-
> asl-1.9.2.jar:bin/../lib/jackson-mapper-asl-1.9.2.jar:bin/../lib/jamm-0.2.
> 5.jar:bin/../lib/jbcrypt-0.3m.jar:bin/../lib/jline-1.0.jar:bin/../lib/json
> -simple-1.1.jar:bin/../lib/libthrift-0.9.1.jar:bin/../lib/log4j-1.2.16.jar
> :bin/../lib/lz4-1.1.0.jar:bin/../lib/metrics-core-2.2.0.jar:bin/../lib/net
> ty-3.6.6.Final.jar:bin/../lib/servlet-api-2.5-20081211.jar:bin/../lib/slf4
> j-api-1.7.2.jar:bin/../lib/slf4j-log4j12-1.7.2.jar:bin/../lib/snakeyaml-1.
> 11.jar:bin/../lib/snappy-java-1.0.5.jar:bin/../lib/snaptree-0.1.jar:bin/..
> /lib/thrift-server-0.3.2.jar:bin/../lib/jamm-0.2.5.jar>
> INFO 12:27:56,634 JNA not found. Native methods will be disabled.
> INFO 12:27:56,647 Loading settings from
>
> file:/home/deepakkv/ebay/softwares/apache-cassandra-2.0.1/conf/cassandra.y
> aml>
> INFO 12:27:57,002 Data files directories: [/var/lib/cassandra/data]
> INFO 12:27:57,002 Commit log directory: /var/lib/cassandra/commitlog
> INFO 12:27:57,002 DiskAccessMode 'auto' determined to be mmap,
>
> indexAccessMode is mmap
>
> INFO 12:27:57,003 disk_failure_policy is stop
> INFO 12:27:57,008 Global memtable threshold is enabled at 718MB
> INFO 12:27:57,133 Not using multi-threaded compaction
> INFO 12:27:57,359 Initializing key cache with capacity of 100 MBs.
> INFO 12:27:57,368 Scheduling key cache save to each 14400 seconds (going
>
> to save all keys).
>
> INFO 12:27:57,369 Initializing row cache with capacity of 0 MBs
> INFO 12:27:57,378 Scheduling row cache save to each 0 seconds (going to
>
> save all keys).
>
> INFO 12:27:57,468 Initializing system.schema_triggers
> INFO 12:27:57,493 Initializing system.batchlog
> INFO 12:27:57,499 Initializing system.peer_events
> INFO 12:27:57,504 Initializing system.compactions_in_progress
> INFO 12:27:57,510 Initializing system.hints
> INFO 12:27:57,515 Initializing system.schema_keyspaces
> INFO 12:27:57,519 Initializing system.range_xfers
> INFO 12:27:57,523 Initializing system.schema_columnfamilies
> INFO 12:27:57,527 Initializing system.NodeIdInfo
> INFO 12:27:57,531 Initializing system.paxos
> INFO 12:27:57,536 Initializing system.schema_columns
> INFO 12:27:57,540 Initializing system.IndexInfo
> INFO 12:27:57,544 Initializing system.peers
> INFO 12:27:57,550 Initializing system.local
> INFO 12:27:57,555 Opening
>
> /var/lib/cassandra/data/system/local/system-local-jb-5 (5675 bytes)
>
> INFO 12:27:57,752 Couldn't detect any schema definitions in local
> storage.
> INFO 12:27:57,753 To create keyspaces and column families, see 'help
>
> create' in cqlsh.
>
> INFO 12:27:57,955 Enqueuing flush of Memtable-local@638095074(114/1140
>
> serialized/live bytes, 4 ops)
>
> INFO 12:27:57,957 Writing Memtable-local@638095074(114/1140
>
> serialized/live bytes, 4 ops)
>
> INFO 12:27:57,986 Completed flushing
>
> /var/lib/cassandra/data/system/local/system-local-jb-6-Data.db (142 bytes)
> for commitlog position ReplayPosition(segmentId=1381647477882,
> position=289)>
> INFO 12:27:58,002 Initializing system_traces.sessions
> INFO 12:27:58,007 Initializing system_traces.events
> INFO 12:27:58,008 completed pre-loading (1 keys) key cache.
> INFO 12:27:58,014 Replaying
>
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448994.log,
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448995.log
>
> INFO 12:27:58,045 Replaying
>
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448994.log
>
> INFO 12:27:58,177 Finished reading
>
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448994.log
>
> INFO 12:27:58,178 Replaying
>
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448995.log
>
> INFO 12:27:58,178 Finished reading
>
> /var/lib/cassandra/commitlog/CommitLog-3-1381647448995.log
>
> INFO 12:27:58,229 Enqueuing flush of
> Memtable-schema_keyspaces@1166982606(251/2510>
> serialized/live bytes, 8 ops)
>
> INFO 12:27:58,230 Writing Memtable-schema_keyspaces@1166982606(251/2510
>
> serialized/live bytes, 8 ops)
>
> INFO 12:27:58,230 Enqueuing flush of
> Memtable-schema_columns@508510991(45669/456690>
> serialized/live bytes, 765 ops)
>
> INFO 12:27:58,231 Enqueuing flush of
>
> Memtable-schema_columnfamilies@1706794324(25092/250920 serialized/live
> bytes, 402 ops)
>
> INFO 12:27:58,247 Completed flushing
>
> /var/lib/cassandra/data/system/schema_keyspaces/system-schema_keyspaces-jb
> -1-Data.db (214 bytes) for commitlog position
> ReplayPosition(segmentId=1381647477882, position=289)
>
> INFO 12:27:58,248 Writing Memtable-schema_columns@508510991(45669/456690
>
> serialized/live bytes, 765 ops)
>
> INFO 12:27:58,294 Completed flushing
>
> /var/lib/cassandra/data/system/schema_columns/system-schema_columns-jb-1-D
> ata.db (9127 bytes) for commitlog position
> ReplayPosition(segmentId=1381647477882, position=289)
>
> INFO 12:27:58,295 Writing
> Memtable-schema_columnfamilies@1706794324(25092/250920>
> serialized/live bytes, 402 ops)
>
> INFO 12:27:58,318 Completed flushing
>
> /var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnf
> amilies-jb-1-Data.db (5130 bytes) for commitlog position
> ReplayPosition(segmentId=1381647477882, position=289)
>
> INFO 12:27:58,319 Log replay complete, 12 replayed mutations
> INFO 12:27:58,757 Cassandra version: 2.0.1
> INFO 12:27:58,758 Thrift API version: 19.37.0
> INFO 12:27:58,760 CQL supported versions: 2.0.0,3.1.1 (default: 3.1.1)
> INFO 12:27:58,774 Loading persisted ring state
> INFO 12:27:58,776 Starting up server gossip
> INFO 12:27:58,809 Enqueuing flush of Memtable-local@1273012638(286/2860
>
> serialized/live bytes, 10 ops)
>
> INFO 12:27:58,810 Writing Memtable-local@1273012638(286/2860
>
> serialized/live bytes, 10 ops)
>
> INFO 12:27:58,825 Completed flushing
>
> /var/lib/cassandra/data/system/local/system-local-jb-7-Data.db (261 bytes)
> for commitlog position ReplayPosition(segmentId=1381647477882,
> position=161327)
>
> INFO 12:27:58,886 Starting Messaging Service on port 7000
> INFO 12:27:58,930 Using saved token [-1086307546053397765,
>
> -1145684508927896070, -1203410806881645909, -12385167840517165,
> -1254320265771852286, -1377116641332761648, -1382089419729812429,
> -1474754088788855467, -1539128487190909405, -1599941757064866687,
> -160031977236386102, -1644304851871996123, -1742023409641977363,
> -1749175726952377532, -1787048501143263605, -1839820538995681675,
> -1910227357685291306, -1922106730579645270, -1984693972760788974,
> -2018567724281109600, -2077165490838644091, -2078521460383948000,
> -2095149687762130834, -2175147914823318356, -2378159128880702223,
> -2493806251572337862, -255195462784197155, -2593134019329554765,
> -2759724126401690929, -2886402383074267230, -302471105523610974,
> -31016478333142538, -311095361586559263, -3127821391506322905,
> -3191922163773209115, -328705332336339873, -3730766478814553433,
> -3746575685134521522, -381701267049082824, -3959825013248494014,
> -3968326117442182867, -4138435740068232949, -4256819020274370499,
> -4769869711316296639, -4844803717994573140, -5016094290261903595,
> -5023131119531886308, -5029190657390228859, -5037106408376191420,
> -5135957152663616399, -5252929307409711991, -5418189455260057811,
> -5432295110033396674, -5466627219107351359, -5533084481744195005,
> -559761963372947820, -5605743988575116570, -5616466477620675726,
> -5729426026665581378, -5755434282424229053, -5885414003889327638,
> -591707695090170964, -5978750348060744008, -6004117746715344675,
> -6067415679752175976, -6092630111605999380, -6104509004659034167,
> -6141175313391781388, -6184593435106254360, -6218039759257956583,
> -6254626935159313122, -6258473422108388575, -6397482147088058638,
> -6426374962491121530, -6532341650311813747, -6536053404712872409,
> -657064600458154610, -6642679518018253513, -6703363561775476294,
> -6813603023891212738, -7015653932296648783, -7020488609840686271,
> -7248283540089772745, -7265001799627949978, -7371221863160971539,
> -7470837949253428813, -753970493467941015, -7605797731905239352,
> -7638681090768243350, -7658436190403077549, -7721020478440393035,
> -7830774292829552628, -785644877496677687, -7901450289858002376,
> -7953180993875092363, -7980943262661327057, -7981701552045704167,
> -8014485551132842663, -8073612852761851092, -8099004733196401366,
> -815259137439171372, -8201266407569073508, -8261821373681618522,
> -8261824041853479809, -8264452060696088464, -8294233980898514345,
> -8295719345766267993, -8306444183055566119, -8365354087983495494,
> -8578338396849763010, -8584421986533251019, -8595208330993249389,
> -8610118725570536756, -8719673249364068073, -8765514864619999629,
> -8867711412759753752, -9022714570113174339, -97168463111051968,
> -992643823885536742, 103401111350079508, 1098046684563309548,
> 1116064460910363751, 1269556821340214559, 1382114657879032291,
> 1409551648971087365, 1432923052293928544, 1451831590138391698,
> 1667198807278553312, 1714578563775513219, 1724834427744873463,
> 1733121060270899927, 1816275040766279028, 1840059893807897428,
> 1913023155823857175, 195277243828082937, 1979246196087587752,
> 200301297066066019, 2008698426415899264, 2042803231721441263,
> 2047533550438932718, 2050856825784637056, 2064290656499319024,
> 213121025126650558, 214439633728304444, 2165701240897113906,
> 2274068307629721744, 2306119966261272640, 2345178334186669963,
> 2481225927798341409, 2547611635580005394, 2588344784891856006,
> 2758649008293201549, 290903536184208878, 2958819420524354519,
> 3016954379998371390, 302993585129741468, 3068147241249357561,
> 3363885282913927889, 3375177664749265904, 3406560488636749813,
> 3479195232624781379, 3502851863946409332, 355322532735198592,
> 3581104725402435736, 3738213911427598992, 399915183127687434,
> 4076446386279184930, 4124691370750365392, 4149959219194417066,
> 4271312604527787259, 4282555400886593414, 4336944915134548537,
> 4352517782510599921, 4526560862588081492, 4631720261239001040,
> 4655003797122040522, 4660653299892312284, 4660806117759856797,
> 4681063987398005507, 4704705389757886, 4714099958809627821,
> 4942326261583566718, 5038840038115684459, 5116560718487113418,
> 5192293443339726151, 5197320623148770553, 5198678819085642648,
> 5216647796402519927, 5318762784242291581, 548102237298584814,
> 5516032145697296898, 5537300847380696554, 5671808055339794572,
> 5838026856894799076, 5914467302764469817, 5979737582239585850,
> 6002935684171782322, 6183277278442270563, 6274234002077193508,
> 628327994281265804, 6366143105084128486, 640371287702003751,
> 6413731220456480711, 642303969378319277, 6438748862911534715,
> 6453079879313518651, 6543156459561565541, 6567994299469490511,
> 6711810555375467895, 6913395222729782487, 6915482028208801992,
> 6942938200005325181, 7027890744582880790, 7038033448014239717,
> 708743534216941239, 7144150880978830327, 7146739070869679978,
> 7162151268089008845, 7194935021860661269, 7456355433732430716,
> 7511651391721659395, 75499855681388248, 755896057514413765,
> 7636130160345515108, 7685970123442213408, 7820288826796701187,
> 7836270959134685972, 7879585666704999924, 7880169475808745523,
> 793785590222886473, 7949368766489042131, 7976203044506196894,
> 7985991214644768626, 8011741962425138795, 8128851225987178936,
> 8193697169105195918, 8291559733449663668, 829228458164868765,
> 8389971640204866551, 8415734786633907310, 8471552947218009491,
> 8520957650031636771, 8580598805860022278, 8613058060995840343,
> 876856792646924272, 878897867859164088, 882833394045503876,
> 8845275519953532196, 8876167442234138908, 8972515271559808263,
> 9057952616826369033, 9084409517486028782, 9086517000577515801,
> 9141905157506385175, 9206457951671373869, 943704698020586505]
>
> INFO 12:27:58,933 Enqueuing flush of Memtable-local@601426957(84/840
>
> serialized/live bytes, 4 ops)
>
> INFO 12:27:58,934 Writing Memtable-local@601426957(84/840
>
> serialized/live bytes, 4 ops)
>
> INFO 12:27:58,946 Completed flushing
>
> /var/lib/cassandra/data/system/local/system-local-jb-8-Data.db (116 bytes)
> for commitlog position ReplayPosition(segmentId=1381647477882,
> position=161586)
>
> INFO 12:27:58,953 Compacting
>
> [SSTableReader(path='/var/lib/cassandra/data/system/local/system-local-jb-
> 6-Data.db'),
> SSTableReader(path='/var/lib/cassandra/data/system/local/system-local-jb-
> 5-Data.db'),
> SSTableReader(path='/var/lib/cassandra/data/system/local/system-local-jb-
> 7-Data.db'),
> SSTableReader(path='/var/lib/cassandra/data/system/local/system-local-jb-
> 8-Data.db')]>
> INFO 12:27:58,987 Enqueuing flush of
> Memtable-local@1620137834(10069/100690
>
> serialized/live bytes, 257 ops)
>
> INFO 12:27:58,987 Writing Memtable-local@1620137834(10069/100690
>
> serialized/live bytes, 257 ops)
>
> INFO 12:27:59,007 Compacted 4 sstables to
>
> [/var/lib/cassandra/data/system/local/system-local-jb-9,]. 6,194 bytes to
> 5,654 (~91% of original) in 52ms = 0.103694MB/s. 4 total rows, 1 unique.
>
> Row merge counts were {1:0, 2:0, 3:0, 4:1, }
> INFO 12:27:59,007 Completed flushing
>
> /var/lib/cassandra/data/system/local/system-local-jb-10-Data.db (5241
> bytes) for commitlog position ReplayPosition(segmentId=1381647477882,
> position=173556)
>
> INFO 12:27:59,067 Node localhost/127.0.0.1 <http://127.0.0.1> state jump to
normal
> INFO 12:27:59,085 Startup completed! Now serving reads.
> INFO 12:27:59,231 Starting listening for CQL clients on
>
> localhost/127.0.0.1:9042...
>
> INFO 12:27:59,288 Using TFramedTransport with a max frame size of
>
> 15728640 bytes.
>
> INFO 12:27:59,289 Binding thrift service to localhost/127.0.0.1:9160
<http://127.0.0.1:9160>
> INFO 12:27:59,299 Using synchronous/threadpool thrift server on localhost
>
> : 9160
>
> INFO 12:27:59,302 Listening for thrift clients...
>
> Upon attempting to connect to localhost/9160 from cassadra client, it
> simply keeps spinning, and i dont get the prompt
> [default@unknown] connect localhost/9160
> ...
> ...
> ...
>
>
>
> Any fix ?
>
> On Sun, Oct 13, 2013 at 12:29 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com
<mailto:deepuj...@gmail.com>>wrote:
>> Thanks.
>>
>> Worked with 1.7
>> $ echo $JAVA_HOME
>> /usr/lib/jvm/java-7-oracle
>>
>> $ java -version
>> java version "1.7.0_40"
>> Java(TM) SE Runtime Environment (build 1.7.0_40-b43)
>> Java HotSpot(TM) 64-Bit Server VM (build 24.0-b56, mixed mode)
>> deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$
<mailto:deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$>
bin/cassandra -f
>>
>> ....
>>
>> ....
>> ...
>>
>> INFO 12:27:59,299 Using synchronous/threadpool thrift server on
>>
>> localhost : 9160
>>
>> INFO 12:27:59,302 Listening for thrift clients...
>>
>> On Sun, Oct 13, 2013 at 11:30 AM, Blair Zajac <bl...@orcaware.com
<mailto:bl...@orcaware.com>> wrote:
>>> You have to use jdk 7, not 6, with Cassandra 2.0.
>>>
>>> Blair
>>>
>>> On Oct 12, 2013, at 10:54 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com
<mailto:deepuj...@gmail.com>> wrote:
>>>
>>> Just started with cassandra
>>>
>>> 1. Unpacked apache-cassandra-2.0.1
>>> 2. Created /var/lib/cassandra/ & /var/log/cassandra//
>>> 3. Modified the owner from root to deepakkv
>>> 4. deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$
<mailto:deepakkv@ubuntu:~/ebay/softwares/apache-cassandra-2.0.1$> java
>>> -version
>>> java version "1.6.0_45"
>>> Java(TM) SE Runtime Environment (build 1.6.0_45-b06)
>>> Java HotSpot(TM) 64-Bit Server VM (build 20.45-b01, mixed mode)
>>> 5. Ubuntu
>>> Linux ubuntu 3.2.0-29-generic #46-Ubuntu SMP Fri Jul 27 17:03:23 UTC
>>> 2012 x86_64 x86_64 x86_64 GNU/Linux
>>> 6. bin/cassandra -f
>>>
>>> xss = -ea -javaagent:bin/../lib/jamm-0.2.5.jar -XX:+UseThreadPriorities
>>> -XX:ThreadPriorityPolicy=42 -Xms2932M -Xmx2932M -Xmn600M
>>> -XX:+HeapDumpOnOutOfMemoryError -Xss256k
>>> Exception in thread "main" java.lang.UnsupportedClassVersionError:
>>> org/apache/cassandra/service/CassandraDaemon : Unsupported major.minor
>>> version 51.0
>>> at java.lang.ClassLoader.defineClass1(Native Method)
>>>
>>> at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
>>>
>>> at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
>>>
>>> at
>>>
>>> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
>>> at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
>>>
>>> at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
>>>
>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
>>>
>>> at java.security.AccessController.doPrivileged(Native Method)
>>>
>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>
>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>
>>> Could not find the main class:
>>> org.apache.cassandra.service.CassandraDaemon. Program will exit.
>>>
>>>
>>> How to fix it ?
>>>
>>> --
>>> Deepak
>>
>> --
>> Deepak
>
> --
> Deepak
--
Deepak
