Those links are for Cassandra 0.8 and the OP is on 2.0.1.

http://www.datastax.com/documentation/cql/3.1/webhelp/index.html

Blair

On 10/14/2013 02:17 AM, Santosh Shet wrote:
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


Reply via email to