Querying composite keys
Hello I have key and columns defined in following fashion: HotelName1:RoomNum1 HotelName2:RoomNum2 HotelName3:RoomNum3 Key1:TimeStamp:VersionNum Is there a way that I can query this schema by only 'key' or 'HotelName' i.e. querying using a part of composite key and not the full key. Thanks and Regards Rishabh Agrawal NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: DataModel Question
Hello, Composite keys are always good and model looks clean to me. Run pilot with around 10 GB or more data and compare it with RDBMS and make changes accordingly. Thanks and Regards Rishabh Agrawal From: Kanwar Sangha [mailto:kan...@mavenir.com] Sent: Wednesday, February 06, 2013 7:10 AM To: user@cassandra.apache.org Subject: DataModel Question Hi - We are designing a Cassandra based storage for the following use cases- * Store SMS messages * Store MMS messages * Store Chat history What would be the ideal was to design the data model for this kind of application ? I am thinking on these lines .. Row-Key : Composite key [ PhoneNum : Day] * Example: 19876543456:05022013 Dynamic Column Families * Composite column key for SMS [SMS:MessageId:TimeUUID] * Composite column key for MMS [MMS:MessageId:TimeUUID] * Composite column key for user I am chatting with [UserId:198765432345] - This can have multiple values since each chat conv can have many messages. Should this be a super column ? 198:05022013 SMS::ttt SMS:xxx12:ttt MMS::ttt :19 198:05022013 1987888:05022013 Thanks, Kanwar NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: getting error for decimal type data
Can you provide specs of the column family using describe. From: Kuldeep Mishra [mailto:kuld.cs.mis...@gmail.com] Sent: Tuesday, January 29, 2013 12:37 PM To: user@cassandra.apache.org Subject: getting error for decimal type data while I an trying to list column family data using cassandra-cli then I am getting following problem for decimal type data, any suggestion will be appreciated. Exception in thread main java.lang.OutOfMemoryError: Java heap space at java.lang.AbstractStringBuilder.init(AbstractStringBuilder.java:45) at java.lang.StringBuilder.init(StringBuilder.java:80) at java.math.BigDecimal.getValueString(BigDecimal.java:2885) at java.math.BigDecimal.toPlainString(BigDecimal.java:2869) at org.apache.cassandra.cql.jdbc.JdbcDecimal.getString(JdbcDecimal.java:72) at org.apache.cassandra.db.marshal.DecimalType.getString(DecimalType.java:62) at org.apache.cassandra.cli.CliClient.printSliceList(CliClient.java:2873) at org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1486) at org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:272) at org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:210) at org.apache.cassandra.cli.CliMain.main(CliMain.java:337) -- Thanks and Regards Kuldeep Kumar Mishra +919540965199 NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: getting error for decimal type data
Did u trt accessing this cf from CQL, I think it must work from there, also try accessing it through any API and see if error persists. Thanks Rishabh Agrawal From: Kuldeep Mishra [mailto:kuld.cs.mis...@gmail.com] Sent: Tuesday, January 29, 2013 2:51 PM To: user@cassandra.apache.org Subject: Re: getting error for decimal type data ColumnFamily: STUDENT Key Validation Class: org.apache.cassandra.db.marshal.LongType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 0.1 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [STUDENT.STUDENT_AGE_idx, STUDENT.STUDENT_BIG_DECIMAL_idx, STUDENT.STUDENT_PERCENTAGE_idx, STUDENT.STUDENT_ROLL_NUMBER_idx, STUDENT.STUDENT_SEMESTER_idx, STUDENT.STUDENT_STUDENT_NAME_idx, STUDENT.STUDENT_UNIQUE_ID_idx] Column Metadata: Column Name: PERCENTAGE Validation Class: org.apache.cassandra.db.marshal.FloatType Index Name: STUDENT_PERCENTAGE_idx Index Type: KEYS Column Name: AGE Validation Class: org.apache.cassandra.db.marshal.IntegerType Index Name: STUDENT_AGE_idx Index Type: KEYS Column Name: SEMESTER Validation Class: org.apache.cassandra.db.marshal.UTF8Type Index Name: STUDENT_SEMESTER_idx Index Type: KEYS Column Name: ROLL_NUMBER Validation Class: org.apache.cassandra.db.marshal.LongType Index Name: STUDENT_ROLL_NUMBER_idx Index Type: KEYS Column Name: UNIQUE_ID Validation Class: org.apache.cassandra.db.marshal.LongType Index Name: STUDENT_UNIQUE_ID_idx Index Type: KEYS Column Name: STUDENT_NAME Validation Class: org.apache.cassandra.db.marshal.UTF8Type Index Name: STUDENT_STUDENT_NAME_idx Index Type: KEYS Column Name: BIG_DECIMAL Validation Class: org.apache.cassandra.db.marshal.DecimalType Index Name: STUDENT_BIG_DECIMAL_idx Index Type: KEYS Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy Compression Options: sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor for value of BIG_DECIMAL is 2.28542855225E-825373481 Thanks Kuldeep On Tue, Jan 29, 2013 at 1:52 PM, Rishabh Agrawal rishabh.agra...@impetus.co.inmailto:rishabh.agra...@impetus.co.in wrote: Can you provide specs of the column family using describe. From: Kuldeep Mishra [mailto:kuld.cs.mis...@gmail.commailto:kuld.cs.mis...@gmail.com] Sent: Tuesday, January 29, 2013 12:37 PM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: getting error for decimal type data while I an trying to list column family data using cassandra-cli then I am getting following problem for decimal type data, any suggestion will be appreciated. Exception in thread main java.lang.OutOfMemoryError: Java heap space at java.lang.AbstractStringBuilder.init(AbstractStringBuilder.java:45) at java.lang.StringBuilder.init(StringBuilder.java:80) at java.math.BigDecimal.getValueString(BigDecimal.java:2885) at java.math.BigDecimal.toPlainString(BigDecimal.java:2869) at org.apache.cassandra.cql.jdbc.JdbcDecimal.getString(JdbcDecimal.java:72) at org.apache.cassandra.db.marshal.DecimalType.getString(DecimalType.java:62) at org.apache.cassandra.cli.CliClient.printSliceList(CliClient.java:2873) at org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1486) at org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:272) at org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:210) at org.apache.cassandra.cli.CliMain.main(CliMain.java:337) -- Thanks and Regards Kuldeep Kumar Mishra +919540965199 NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -- Thanks and Regards Kuldeep Kumar Mishra +919540965199 NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when
RE: Accessing Metadata of Column Familes
I found following issues while working on Cassandra version 1.2, CQL 3 and Thrift protocol 19.35.0. Case 1: Using CQL I created a table t1 with columns col1 and col2 with col1 being my primary key. When I access same data using CLI, I see col1 gets adopted as rowkey and col2 being another column. Now I have inserted value in another column (col3) in same row using CLI. Now when I query same table again from CQL I am unable to find col3. Case 2: Using CLI, I have created table t2. Now I added a row key row1 and two columns (keys) col1 and col2 with some values in each. When I access t2 from CQL I find following resultset with three columns: key | column1 | value row1| col1 | val1 row1| col2 | val2 This behavior raises certain questions: * What is the reason for such schema anomaly or is this a problem? * Which schema should be deemed as correct or consistent? * How to access meta data on the same? Thanks and Regards Rishabh Agrawal From: Harshvardhan Ojha [mailto:harshvardhan.o...@makemytrip.com] Sent: Monday, January 28, 2013 12:57 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes You can get storage attributes from /data/system/ keyspace. From: Rishabh Agrawal [mailto:rishabh.agra...@impetus.co.in] Sent: Monday, January 28, 2013 12:42 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes Thank for the reply. I do not want to go by API route. I wish to access files and column families which store meta data information From: Harshvardhan Ojha [mailto:harshvardhan.o...@makemytrip.com] Sent: Monday, January 28, 2013 12:25 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes Which API are you using? If you are using Hector use ColumnFamilyDefinition. Regards Harshvardhan OJha From: Rishabh Agrawal [mailto:rishabh.agra...@impetus.co.in] Sent: Monday, January 28, 2013 12:16 PM To: user@cassandra.apache.org Subject: Accessing Metadata of Column Familes Hello, I wish to access metadata information on column families. How can I do it? Any ideas? Thanks and Regards Rishabh Agrawal NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. The contents of this email, including the attachments, are PRIVILEGED AND CONFIDENTIAL to the intended recipient at the email address to which it has been addressed. If you receive it in error, please notify the sender immediately by return email and then permanently delete it from your system. The unauthorized use, distribution, copying or alteration of this email, including the attachments, is strictly forbidden. Please note that neither MakeMyTrip nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of MakeMyTrip by means of email communications. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. The contents of this email, including the attachments, are PRIVILEGED AND CONFIDENTIAL to the intended recipient at the email address to which it has been addressed. If you receive it in error, please notify the sender immediately by return email and then permanently delete it from your system. The unauthorized use, distribution, copying or alteration of this email, including the attachments, is strictly forbidden. Please note that neither MakeMyTrip nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of MakeMyTrip by means of email communications. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant
RE: Accessing Metadata of Column Familes
Any points on the same. - Rishabh - Reply message - From: Rishabh Agrawal rishabh.agra...@impetus.co.in To: user@cassandra.apache.org user@cassandra.apache.org Subject: Accessing Metadata of Column Familes Date: Mon, Jan 28, 2013 5:56 pm I found following issues while working on Cassandra version 1.2, CQL 3 and Thrift protocol 19.35.0. Case 1: Using CQL I created a table t1 with columns col1 and col2 with col1 being my primary key. When I access same data using CLI, I see col1 gets adopted as rowkey and col2 being another column. Now I have inserted value in another column (col3) in same row using CLI. Now when I query same table again from CQL I am unable to find col3. Case 2: Using CLI, I have created table t2. Now I added a row key row1 and two columns (keys) col1 and col2 with some values in each. When I access t2 from CQL I find following resultset with three columns: key | column1 | value row1| col1 | val1 row1| col2 | val2 This behavior raises certain questions: * What is the reason for such schema anomaly or is this a problem? * Which schema should be deemed as correct or consistent? * How to access meta data on the same? Thanks and Regards Rishabh Agrawal From: Harshvardhan Ojha [mailto:harshvardhan.o...@makemytrip.com] Sent: Monday, January 28, 2013 12:57 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes You can get storage attributes from /data/system/ keyspace. From: Rishabh Agrawal [mailto:rishabh.agra...@impetus.co.in] Sent: Monday, January 28, 2013 12:42 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes Thank for the reply. I do not want to go by API route. I wish to access files and column families which store meta data information From: Harshvardhan Ojha [mailto:harshvardhan.o...@makemytrip.com] Sent: Monday, January 28, 2013 12:25 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes Which API are you using? If you are using Hector use ColumnFamilyDefinition. Regards Harshvardhan OJha From: Rishabh Agrawal [mailto:rishabh.agra...@impetus.co.in] Sent: Monday, January 28, 2013 12:16 PM To: user@cassandra.apache.org Subject: Accessing Metadata of Column Familes Hello, I wish to access metadata information on column families. How can I do it? Any ideas? Thanks and Regards Rishabh Agrawal NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. The contents of this email, including the attachments, are PRIVILEGED AND CONFIDENTIAL to the intended recipient at the email address to which it has been addressed. If you receive it in error, please notify the sender immediately by return email and then permanently delete it from your system. The unauthorized use, distribution, copying or alteration of this email, including the attachments, is strictly forbidden. Please note that neither MakeMyTrip nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of MakeMyTrip by means of email communications. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. The contents of this email, including the attachments, are PRIVILEGED AND CONFIDENTIAL to the intended recipient at the email address to which it has been addressed. If you receive it in error, please notify the sender immediately by return email and then permanently delete it from your system. The unauthorized use, distribution, copying or alteration of this email, including the attachments, is strictly forbidden. Please note that neither MakeMyTrip nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of MakeMyTrip by means of email communications. NOTE: This message may contain information that is confidential, proprietary, privileged
Accessing Metadata of Column Familes
Hello, I wish to access metadata information on column families. How can I do it? Any ideas? Thanks and Regards Rishabh Agrawal NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Accessing Metadata of Column Familes
Thank for the reply. I do not want to go by API route. I wish to access files and column families which store meta data information From: Harshvardhan Ojha [mailto:harshvardhan.o...@makemytrip.com] Sent: Monday, January 28, 2013 12:25 PM To: user@cassandra.apache.org Subject: RE: Accessing Metadata of Column Familes Which API are you using? If you are using Hector use ColumnFamilyDefinition. Regards Harshvardhan OJha From: Rishabh Agrawal [mailto:rishabh.agra...@impetus.co.in] Sent: Monday, January 28, 2013 12:16 PM To: user@cassandra.apache.org Subject: Accessing Metadata of Column Familes Hello, I wish to access metadata information on column families. How can I do it? Any ideas? Thanks and Regards Rishabh Agrawal NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. The contents of this email, including the attachments, are PRIVILEGED AND CONFIDENTIAL to the intended recipient at the email address to which it has been addressed. If you receive it in error, please notify the sender immediately by return email and then permanently delete it from your system. The unauthorized use, distribution, copying or alteration of this email, including the attachments, is strictly forbidden. Please note that neither MakeMyTrip nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of MakeMyTrip by means of email communications. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: triggers(newbie)
I don't think that is possible in Cassandra. Others please correct me if I am wrong. Thanks and Regards Rishabh -Original Message- From: davuk...@veleri.hr [mailto:davuk...@veleri.hr] Sent: Monday, November 05, 2012 11:00 PM To: user@cassandra.apache.org Subject: triggers(newbie) Hello! I was wondering if someone could help me a bit with triggers in cassandra. I am doing a school project with this DBMS, and i would be very happy if you could send me a simple example/explanation of a trigger. Thank you!! :) Impetus Ranked in the Top 50 India’s Best Companies to Work For 2012. Impetus webcast ‘Designing a Test Automation Framework for Multi-vendor Interoperable Systems’ available at http://lf1.me/0E/. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
Nodetool: Cfstats
Hello, I am using cfstats of nodetool I have following doubts: 1) What is the difference between size (live) and size (total) 2) Number of keys in column family is 100 but cfstats shoes 128. (Tried compaction, cleanup and scrub but same result ). Kindly help Thanks and Regards Rishabh Impetus Ranked in the Top 50 India's Best Companies to Work For 2012. Impetus webcast 'Designing a Test Automation Framework for Multi-vendor Interoperable Systems' available at http://lf1.me/0E/. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Query over secondary indexes
Try making user_name a primary key in combination with some other unique column and see if results are improving. -Rishabh From: Vivek Mishra [mailto:mishra.v...@gmail.com] Sent: Friday, October 05, 2012 2:35 PM To: user@cassandra.apache.org Subject: Query over secondary indexes I have a column family User which is having a indexed column user_name. My schema is having around 0.1 million records only and user_name is duplicated across all rows. Now when i am trying to retrieve it as: get User where user_name = 'Vivek', it is taking ages to retrieve that data. Is there anything i am doing wrong? Also, i tried get_indexed_slices via Thrift API by setting IndexClause.setCount(1), still no luck, it got hang and not even returning a single result. I believe 0.1 million is not a huge amount of data. Cassandra version : 1.1.2 Any idea? -Vivek Impetus Ranked in the Top 50 India's Best Companies to Work For 2012. Impetus webcast 'Designing a Test Automation Framework for Multi-vendor Interoperable Systems' available at http://lf1.me/0E/. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Can not find auto bootstrap property in cassandra.yaml for Cassandra 1.1.0
Hello, Auto bootstrap, as an attribute, is not present in latest versions of Cassandra (1.0 and later). You can add 'auto_bootstrap: true' or keep initial_token to be blank to make it happen. As I have noticed by default it remains true Regards Rishabh Agrawal From: Prakrati Agrawal [mailto:prakrati.agra...@mu-sigma.com] Sent: Sunday, June 03, 2012 10:58 PM To: user@cassandra.apache.org Subject: Can not find auto bootstrap property in cassandra.yaml for Cassandra 1.1.0 Dear all I am trying to add a new node to the Cassandra cluster. In all the documentations available on net it says to set the auto bootstrap property in cassandra.yaml to true but I am not finding the property in the file. Please help me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.comhttp://www.mu-sigma.com This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which it is addressed. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may be illegal. If you received this in error, please contact the sender and delete the message from your system. Mu Sigma takes all reasonable steps to ensure that its electronic communications are free from viruses. However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. Register for Impetus webinar 'User Experience Design for iPad Applications' June 8(10:00am PT). http://lf1.me/f9/ Impetus' Head of Labs to present on 'Integrating Big Data technologies in your IT portfolio' at Cloud Expo, NY (June 11-14). Contact us for a complimentary pass.Impetus also sponsoring the Yahoo Summit 2012. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Query
If you are using Java try out Kundera or Hector, both are good and have good documentation available. From: MOHD ARSHAD SALEEM [mailto:marshadsal...@tataelxsi.co.in] Sent: Monday, June 04, 2012 2:37 AM To: user@cassandra.apache.org Subject: Query Hi all, I wanted to know how to read and write data using cassandra API's . is there any link related to sample program . Regards Arshad Register for Impetus webinar 'User Experience Design for iPad Applications' June 8(10:00am PT). http://lf1.me/f9/ Impetus' Head of Labs to present on 'Integrating Big Data technologies in your IT portfolio' at Cloud Expo, NY (June 11-14). Contact us for a complimentary pass.Impetus also sponsoring the Yahoo Summit 2012. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: repair
Hello, As far as my knowledge goes, it works per node basis. So you have to run on different nodes. I would suggest you to not to execute it simultaneously on all nodes in a production environment. Regards Rishabh Agrawal From: Tamar Fraenkel [mailto:ta...@tok-media.com] Sent: Monday, June 04, 2012 4:25 AM To: user@cassandra.apache.org Subject: repair Hi! I apologize if for this naive question. When I run nodetool repair, is it enough to run on one of the nodes, or do I need to run on each one of them? Thanks Tamar Fraenkel Senior Software Engineer, TOK Media [Inline image 1] ta...@tok-media.commailto:ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 Register for Impetus webinar 'User Experience Design for iPad Applications' June 8(10:00am PT). http://lf1.me/f9/ Impetus' Head of Labs to present on 'Integrating Big Data technologies in your IT portfolio' at Cloud Expo, NY (June 11-14). Contact us for a complimentary pass.Impetus also sponsoring the Yahoo Summit 2012. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. inline: image001.png
RE: Issue with SStable loader.
I don't understand config for sstableloader. I thought sstableloader just takes cassandra.yaml file and does it. pleae throw some more light on same. From: aaron morton [aa...@thelastpickle.com] Sent: 10 April 2012 11:37 PM To: user@cassandra.apache.org Subject: Re: Issue with SStable loader. Did you update the config for sstableloader ? Are their any data files in the data directory pointed to by the sstableloader config ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 10/04/2012, at 11:56 PM, Rishabh Agrawal wrote: Hello, I had three node cluster which I converted to 4 node one. Later I decommissioned one of them and load balanced the data on remaining 3. I removed decommissioned node from ‘seed list’ . I restarted all nodes and performed compaction. After that when I am using sstable loader it is trying to connect to that decommissioned node and hence failing. Can someone provide me solution to same. Regards Rishabh Agrawal Register for the Impetus webinar on Mobile Testing Automation : Best Practices - Apr 13 (10:00 am PT). http://bit.ly/Hb4YOq Impetus’ expert to present on ‘Streamlining Cloud Based Performance Testing’ at STAREAST 2012, FL - Apr 15 -20. Know more about our IP Enabled Solutions for Load Testing Mobile Test Automation at the event. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Register for the Impetus webinar on Mobile Testing Automation : Best Practices - Apr 13 (10:00 am PT). http://bit.ly/Hb4YOq Impetus’ expert to present on ‘Streamlining Cloud Based Performance Testing’ at STAREAST 2012, FL - Apr 15 -20. Know more about our IP Enabled Solutions for Load Testing Mobile Test Automation at the event. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Listen and RPC address
Thanks, it just worked. Though I am able to load sstables but I get following error: ERROR 15:44:23,557 Error in ThreadPoolExecutor java.lang.IllegalArgumentException: Unknown CF 1000 what could be the reason. From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Monday, April 09, 2012 3:30 PM To: user@cassandra.apache.org Subject: Re: Listen and RPC address Background: Configuration section http://www.datastax.com/dev/blog/bulk-loading I *think* you can get by with changing the rpc_port and storage_port for the bulkl loader config. If that does not work create another loop back interface and bind the bulk loader to it... sudo ifconfig lo0 alias 127.0.0.2 up Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 9/04/2012, at 8:31 PM, Rishabh Agrawal wrote: Hello, I have three nodes cluster with having listen address as xxx.xx.1.101, xxx.xx.1.102, xxx.xx.1.103 and Rpc address to be xxx.xx.1.111, xxx.xx.1.112, xxx.xx.1.113. rpc_port and storage_port are 9160 and 7000 respectively. Now when I run sstableloader tool I get following error: org.apache.cassandra.config.ConfigurationException: /xxx.xx.1.101:7000 is in use by another process. Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other service. Can someone help me with what am I missing in configuration. Thanks and Regards Rishabh Agarawal Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-à-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-à-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Using Thrift
I didn't fine slf4j files in distribution. So I downloaded them can you help me how to configure it. From: Dave Brosius [mailto:dbros...@mebigfatguy.com] Sent: Monday, April 02, 2012 6:28 PM To: user@cassandra.apache.org Subject: Re: Using Thrift For a thrift client, you need the following jars at a minimum apache-cassandra-clientutil-*.jar apache-cassandra-thrift-*.jar libthrift-*.jar slf4j-api-*.jar slf4j-log4j12-*.jar all of these jars can be found in the cassandra distribution. On 04/02/2012 07:40 AM, Rishabh Agrawal wrote: Any suggestions From: Rishabh Agrawal Sent: Monday, April 02, 2012 4:42 PM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Using Thrift Hello, I have just started exploring Cassandra from java side and using wish to use thrift as my api. The problem is whenever is I try to compile my java code I get following error : package org.slf4j does not exist Can anyone help me with this. Thanks and Regards Rishabh Agrawal Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-à-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-à-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-à-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
Regarding nodetool tpstats
Hello I am new to Cassandra and when I run tpstats on my node (Cassandra 1.0.7) I get following output: Pool NameActive Pending Completed Blocked All time blocked ReadStage 0 0 12 0 0 RequestResponseStage 0 0 20 0 0 MutationStage 0 0 14 0 0 ReadRepairStage 0 0 14 0 0 ReplicateOnWriteStage 0 0 0 0 0 GossipStage 0 0 273665 0 0 AntiEntropyStage 0 0 0 0 0 MigrationStage0 0119 0 0 MemtablePostFlusher 0 0 13 0 0 StreamStage 0 0 0 0 0 FlushWriter 0 0 13 0 0 MiscStage 0 0 0 0 0 InternalResponseStage 0 0318 0 0 HintedHandoff 0 0 2 0 0 Can anyone help with what each pool name stands for? Thanks and Regards Rishabh Agrawal Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-?-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Adding nodes to cluster (Cassandra 1.0.8)
After clearing the system files I was able to successfully join the node. thanks. From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Thursday, March 15, 2012 2:13 PM To: user@cassandra.apache.org Subject: Re: Adding nodes to cluster (Cassandra 1.0.8) There have been two similar reports in the last few days. The joining node is unable to discover the cluster information it needs to find the correct place to join. However there code appears to have checks in place to prevent that from happening. If you have time can you please try to reproduce the fault ? * set logging to DEBUG on /etc/cassandra/log4j-server.properties * clear all files from /var/lib/cassandra/data/system * start the node I *think* if you restart the node it will work as it will used stored load data. But I'm unsure if it will bootstrap as that only happens once, you may want to run a repair. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/03/2012, at 4:04 AM, Maki Watanabe wrote: Try: % telnet seed_node 7000 on the 3rd node and see what it says. maki 2012/3/14 Rishabh Agrawal rishabh.agra...@impetus.co.inmailto:rishabh.agra...@impetus.co.in: I am using storage port 7000 (deafult) across all nodes. -Original Message- From: Maki Watanabe [mailto:watanabe.m...@gmail.com]mailto:[mailto:watanabe.m...@gmail.com] Sent: Wednesday, March 14, 2012 3:42 PM To: user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: Adding nodes to cluster (Cassandra 1.0.8) Do you use same storage_port across 3 nodes? Can you access to the storage_port of the seed node from the last (failed) node? 2012/3/14 Rishabh Agrawal rishabh.agra...@impetus.co.inmailto:rishabh.agra...@impetus.co.in: I was able to successfully join a node to already existing one-node cluster (without giving any intital_token), but when I add another machine with identical settings (with changes in listen broadcast and rpc address). I am unable to join it to the cluster and it gives me following error: INFO 17:50:35,555 JOINING: schema complete, ready to bootstrap INFO 17:50:35,556 JOINING: getting bootstrap token ERROR 17:50:35,557 Exception encountered during startup java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper. java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.ja va:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.j ava:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageServi ce.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCas sandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(Abstract CassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java: 107) java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper. java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.ja va:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.j ava:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageServi ce.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCas sandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(Abstract CassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java: 107) Exception encountered during startup: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted
Adding nodes to cluster (Cassandra 1.0.8)
I was able to successfully join a node to already existing one-node cluster (without giving any intital_token), but when I add another machine with identical settings (with changes in listen broadcast and rpc address). I am unable to join it to the cluster and it gives me following error: INFO 17:50:35,555 JOINING: schema complete, ready to bootstrap INFO 17:50:35,556 JOINING: getting bootstrap token ERROR 17:50:35,557 Exception encountered during startup java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper.java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.java:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.java:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageService.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:107) java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper.java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.java:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.java:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageService.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:107) Exception encountered during startup: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. INFO 17:50:35,571 Waiting for messaging service to quiesce INFO 17:50:35,571 MessagingService shutting down server thread. Now when I put some interger value to intial_token the Cassandra starts working but is not able to connect to the main cluster which became evident from the command Nodetool -h ip of this node ring. It displayed itself with 100% ownership. Kindly help me with it asap. Regards Rishabh Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-?-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Adding nodes to cluster (Cassandra 1.0.8)
I am using storage port 7000 (deafult) across all nodes. -Original Message- From: Maki Watanabe [mailto:watanabe.m...@gmail.com] Sent: Wednesday, March 14, 2012 3:42 PM To: user@cassandra.apache.org Subject: Re: Adding nodes to cluster (Cassandra 1.0.8) Do you use same storage_port across 3 nodes? Can you access to the storage_port of the seed node from the last (failed) node? 2012/3/14 Rishabh Agrawal rishabh.agra...@impetus.co.in: I was able to successfully join a node to already existing one-node cluster (without giving any intital_token), but when I add another machine with identical settings (with changes in listen broadcast and rpc address). I am unable to join it to the cluster and it gives me following error: INFO 17:50:35,555 JOINING: schema complete, ready to bootstrap INFO 17:50:35,556 JOINING: getting bootstrap token ERROR 17:50:35,557 Exception encountered during startup java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper. java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.ja va:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.j ava:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageServi ce.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCas sandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(Abstract CassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java: 107) java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper. java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.ja va:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.j ava:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageServi ce.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService. java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCas sandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(Abstract CassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java: 107) Exception encountered during startup: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. INFO 17:50:35,571 Waiting for messaging service to quiesce INFO 17:50:35,571 MessagingService shutting down server thread. Now when I put some interger value to intial_token the Cassandra starts working but is not able to connect to the main cluster which became evident from the command Nodetool –h ip of this node ring. It displayed itself with 100% ownership. Kindly help me with it asap. Regards Rishabh Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis On-premise’ available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been
Adding a new node to already existing single-node-cluster cassandra
Hello, I have been trying to add a node to single node cluster of Cassandra (1.0.8) but I always get following error: INFO 17:50:35,555 JOINING: schema complete, ready to bootstrap INFO 17:50:35,556 JOINING: getting bootstrap token ERROR 17:50:35,557 Exception encountered during startup java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper.java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.java:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.java:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageService.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:107) java.lang.RuntimeException: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. at org.apache.cassandra.dht.BootStrapper.getBootstrapSource(BootStrapper.java:168) at org.apache.cassandra.dht.BootStrapper.getBalancedToken(BootStrapper.java:150) at org.apache.cassandra.dht.BootStrapper.getBootstrapToken(BootStrapper.java:145) at org.apache.cassandra.service.StorageService.joinTokenRing(StorageService.java:565) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:484) at org.apache.cassandra.service.StorageService.initServer(StorageService.java:395) at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:234) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:356) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:107) Exception encountered during startup: No other nodes seen! Unable to bootstrap.If you intended to start a single-node cluster, you should make sure your broadcast_address (or listen_address) is listed as a seed. Otherwise, you need to determine why the seed being contacted has no knowledge of the rest of the cluster. Usually, this can be solved by giving all nodes the same seed list. INFO 17:50:35,571 Waiting for messaging service to quiesce INFO 17:50:35,571 MessagingService shutting down server thread. Kindly help me asap. Regards Rishabh Agrawal Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know more about our Big Data quick-start program at the event. New Impetus webcast 'Cloud-enabled Performance Testing vis-?-vis On-premise' available at http://bit.ly/z6zT4L. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: cli question
I faced the same issue some time back. Solution which fit my bill is as follows: CREATE COLUMN FAMILY aaa with comparator = 'CompositeType(UTF8Type,UTF8Type)' and default_validation_class = 'UTF8Type' and key_validation_class = 'CompositeType(UTF8Type,UTF8Type,UTF8Type,)'; notice I have mentioned three datatypes or validators in key_validation_class under CompositeType. Now if I have to insert with key aaa:bbb:ccc it will work smoothly and even if I wish to insert with just aaa:bbb it will work just fine. Do let me know if it solves your problem. Regards RIshabh Agrawal From: Tamar Fraenkel [mailto:ta...@tok-media.com] Sent: Monday, March 05, 2012 1:19 PM To: cassandra-u...@incubator.apache.org Subject: cli question Hi! I have CF with the following deffinition: CREATE COLUMN FAMILY a_b_indx with comparator = 'CompositeType(LongType,UUIDType)' and default_validation_class = 'UTF8Type' and key_validation_class = 'CompositeType(UTF8Type,UTF8Type)'; Where the key may be a composite of the following two strings: 'AAA' and 'BBB:CCC' Notice, that the second string has ':' in it. I try to query for rows I know exist in the CF but can't. I tried those and many more :) * get a_b_indx ['AAA:BBB:CCC']; * get a_b_indx ['AAA:BBB\:CCC']; * get a_b_indx [utf8('AAA'):utf8('BBB:CCC')]; Is it possible? Does anyone know how? Thanks, Tamar Fraenkel Senior Software Engineer, TOK Media [Inline image 1] ta...@tok-media.commailto:ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 Impetus' Head of Innovation labs, Vineet Tyagi will be presenting on 'Big Data Big Costs?' at the Strata Conference, CA (Feb 28 - Mar 1) http://bit.ly/bSMWd7. Listen to our webcast 'Hybrid Approach to Extend Web Apps to Tablets Smartphones' available at http://bit.ly/yQC1oD. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. inline: image001.png
RE: Doubt regarding CQL
Thanks for the reply I installed 0.8.0 drift package. But still problem persists. -Original Message- From: Mateusz Korniak [mailto:mateusz-li...@ant.gliwice.pl] Sent: Wednesday, February 22, 2012 1:47 PM To: user@cassandra.apache.org Subject: Re: Doubt regarding CQL On Wednesday 22 of February 2012, Rishabh Agrawal wrote: I have installed CQL drivers for python. When I try execute cqlsh I get following error cql-1.0.3$ cqlsh localhost 9160 (...) File /usr/local/lib/python2.7/dist-packages/cql/cassandra/ttypes.py, line 7, in module from thrift.Thrift import * ImportError: No module named thrift.Thrift Seems you do not have installed python thrift module. In my distro (PLD) it is: Package:python-thrift-0.5.0-4.i686 /usr/lib/python2.7/site-packages: Thrift-0.1-py2.7.egg-info, /usr/lib/python2.7/site-packages/thrift: TSCons.pyc, TSCons.pyo, TSerialization.pyc, TSerialization.pyo, Thrift.pyc, Thrift.pyo, __init__.pyc, __init__.pyo, /usr/lib/python2.7/site-packages/thrift/protocol: TBinaryProtocol.pyc, TBinaryProtocol.pyo, TCompactProtocol.pyc, TCompactProtocol.pyo, TProtocol.pyc, TProtocol.pyo, __init__.pyc, __init__.pyo, fastbinary.so /usr/lib/python2.7/site-packages/thrift/server: THttpServer.pyc, THttpServer.pyo, TNonblockingServer.pyc, TNonblockingServer.pyo, TServer.pyc, TServer.pyo, __init__.pyc, __init__.pyo /usr/lib/python2.7/site-packages/thrift/transport: THttpClient.pyc, THttpClient.pyo, TSocket.pyc, TSocket.pyo, TTransport.pyc, TTransport.pyo, TTwisted.pyc, TTwisted.pyo, __init__.pyc, __init__.pyo Regards, -- Mateusz Korniak Impetus’ Head of Innovation labs, Vineet Tyagi will be presenting on ‘Big Data Big Costs?’ at the Strata Conference, CA (Feb 28 - Mar 1) http://bit.ly/bSMWd7. Listen to our webcast ‘Hybrid Approach to Extend Web Apps to Tablets Smartphones’ available at http://bit.ly/yQC1oD. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
RE: Doubt regarding CQL
FYI .. I am using 1.0.7 version on Ubuntu 11.10 Need help asap From: Rishabh Agrawal Sent: Wednesday, February 22, 2012 11:49 AM To: user@cassandra.apache.org Subject: Doubt regarding CQL Hello I have installed CQL drivers for python. When I try execute cqlsh I get following error cql-1.0.3$ cqlsh localhost 9160 Traceback (most recent call last): File /usr/local/bin/cqlsh, line 33, in module import cql File /usr/local/lib/python2.7/dist-packages/cql/__init__.py, line 22, in module import connection File /usr/local/lib/python2.7/dist-packages/cql/connection.py, line 18, in module from cursor import Cursor File /usr/local/lib/python2.7/dist-packages/cql/cursor.py, line 24, in module from cql.cassandra.ttypes import ( File /usr/local/lib/python2.7/dist-packages/cql/cassandra/ttypes.py, line 7, in module from thrift.Thrift import * ImportError: No module named thrift.Thrift Kindly help me with that asap. Thanks and Regards Rishabh Agrawal Impetus' Head of Innovation labs, Vineet Tyagi will be presenting on 'Big Data Big Costs?' at the Strata Conference, CA (Feb 28 - Mar 1) http://bit.ly/bSMWd7. Listen to our webcast 'Hybrid Approach to Extend Web Apps to Tablets Smartphones' available at http://bit.ly/yQC1oD. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Impetus' Head of Innovation labs, Vineet Tyagi will be presenting on 'Big Data Big Costs?' at the Strata Conference, CA (Feb 28 - Mar 1) http://bit.ly/bSMWd7. Listen to our webcast 'Hybrid Approach to Extend Web Apps to Tablets Smartphones' available at http://bit.ly/yQC1oD. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.