DataStax Support Forums » User Favorites: mailme365

DataStax Support Forums » User Favorites: mailme365 mailme365 Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 15:55:51 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php mailme365 on "Why cassandra's cluster doesn't work?" http://www.datastax.com/support-forums/topic/why-cassandras-cluster-doesnt-work#post-8470 Thu, 17 Jan 2013 03:10:19 +0000 mailme365 8470@http://www.datastax.com/support-forums/ Thank you khahn, I guess this is the root cause, since I'm using the virtual machine, so there is no DNS, I will try to try again in the real machine with DNS. Thanks a lot for your answer. khahn on "Why cassandra's cluster doesn't work?" http://www.datastax.com/support-forums/topic/why-cassandras-cluster-doesnt-work#post-8454 Wed, 16 Jan 2013 14:13:53 +0000 khahn 8454@http://www.datastax.com/support-forums/ Your problem sounds like it might be related to these things: <a href="http://www.jointhegrid.com/highperfcassandra/?p=140" rel="nofollow">http://www.jointhegrid.com/highperfcassandra/?p=140</a> <a href="http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/what-other-ports-than-7199-need-to-be-open-for-nodetool-to-work-td7407319.html" rel="nofollow">http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/what-other-ports-than-7199-need-to-be-open-for-nodetool-to-work-td7407319.html</a> mailme365 on "Why cassandra's cluster doesn't work?" http://www.datastax.com/support-forums/topic/why-cassandras-cluster-doesnt-work#post-8448 Wed, 16 Jan 2013 06:26:52 +0000 mailme365 8448@http://www.datastax.com/support-forums/ Could anyone help on this? I'm still unable to run nodetool , get error "Failed to connect to '127.0.0.1:7199': Connection refused" mailme365 on "Why cassandra's cluster doesn't work?" http://www.datastax.com/support-forums/topic/why-cassandras-cluster-doesnt-work#post-8385 Sun, 13 Jan 2013 16:16:19 +0000 mailme365 8385@http://www.datastax.com/support-forums/ It's so weird, the cluster doesn't work in the past days, but it's working now, from the log file of each cluster machine, I find they joined cluster, and I did some test to create table , they are visible from all the nodes. However, when I execute nodetool ring, or nodetool -h 127.0.0.1 ring, or nodetool -h 192.168.0.103 ring, they all report connection error. And, I still don't understand why it doesn't work days ago(I didn't change anything today, and I'm very sure that cluster doesn't work days ago). mailme365 on "Why cassandra's cluster doesn't work?" http://www.datastax.com/support-forums/topic/why-cassandras-cluster-doesnt-work#post-8384 Sun, 13 Jan 2013 15:35:45 +0000 mailme365 8384@http://www.datastax.com/support-forums/ Hi All, I setup 4 virtual machines by virtualbox, all the four machines installed ubuntu linux server edition with Cassandra 1.2.0, and they all adopt bridge network. The problem I get is that these four machines could start in cluster mode when I'm working in office , but they don't work when I'm working from home. Since the four machines use bridge mode, the IP addresses in Company are different with those when I'm working from home. I have to change the IP addresses when I switch the ENV in cassandra.yaml configuration files in them. Since the ENV in company works, I only list the configuration in my home. Below is the list for the configuration items I changed for my home CLUSTER ENV: initial_token: 0 (all the four machines have different token, I use the token tool to generate token for them) listen_address: 192.168.0.103 (all the other machines set their own address, 192.168.0.104,192.168.105, 192.168.0.106) - class_name: org.apache.cassandra.locator.SimpleSeedProvider parameters: - seeds: "192.168.0.103" partitioner: org.apache.cassandra.dht.RandomPartitioner rpc_address: 0.0.0.0 When, I startup the cassandra on these machines (I start the seed machine first), there is no error reported, however, they are running in their own local mode, whatever I created such as column family, it will be invisible to other nodes. And when I execute nodetool ring in those machines, I get error message: ~/software/java/apache-cassandra-1.2.0/conf$ nodetool ring Failed to connect to '127.0.0.1:7199': Connection refused This is really weird, because when I'm working from home, after I changing the IP addresses in the cassandra.yaml file, the cluster ENV does work, does anyone could help on this? Thanks a lot! mailme365 on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6533 Mon, 17 Sep 2012 14:21:38 +0000 mailme365 6533@http://www.datastax.com/support-forums/ Thank you Srini, I updated code following the link you provided, it worked. Thanks. Srini on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6477 Fri, 14 Sep 2012 10:56:16 +0000 Srini 6477@http://www.datastax.com/support-forums/ Already answered here, <a href="http://stackoverflow.com/questions/7732651/how-to-use-cql-queries-to-get-different-datatypes-out-of-cassandra-with-java-cli" rel="nofollow">http://stackoverflow.com/questions/7732651/how-to-use-cql-queries-to-get-different-datatypes-out-of-cassandra-with-java-cli</a> mailme365 on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6475 Fri, 14 Sep 2012 09:14:12 +0000 mailme365 6475@http://www.datastax.com/support-forums/ Hi All, Following Hector's cql code examples, I created an example and I could execute this example successfully. However, when reviewing the source code, I have a question for it. Here is the source code I created: Cluster tutorialCluster = HFactory.getOrCreateCluster("TutorialCluster", "16.158.81.59:9160"); ConfigurableConsistencyLevel ccl = new ConfigurableConsistencyLevel(); ccl.setDefaultReadConsistencyLevel(HConsistencyLevel.ONE); Keyspace keyspace = HFactory.createKeyspace("Tutorial", tutorialCluster, ccl); CqlQuery<String,String,String> cqlQuery = new CqlQuery<String,String,String>(keyspace, se, se, se); cqlQuery.setQuery("select * from testcql"); QueryResult<CqlRows<String,String,String>> result = cqlQuery.execute(); CqlRows<String,String,String> rows = result.get(); System.out.println("size is: " + rows.getList().size()); And here is the testcql column family I created for this example: create column family testcql with comparator = 'UTF8Type' and default_validation_class = 'UTF8Type' and key_validation_class = 'UTF8Type'; As I said, the code could run successfully, and I'm able to get the total rows for the column family testcql. However, I'm very confused with "CqlQuery<String,String,String>" declaration, I know the three <String> is for the key type, value name type and value type, but if I create a column family with multiple column name type and column value type, then, how do I declare CqlQuery? For example, when I create a table using cqlsh as below: create table temptest (id int, value1 varchar, value2 int, primary key (id)); And I describe the table in cassandra-cli: [default@demodb] describe temptest; ColumnFamily: temptest Key Validation Class: org.apache.cassandra.db.marshal.Int32Type Default column value validator: org.apache.cassandra.db.marshal.UTF8Type 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: [] Column Metadata: Column Name: value2 Validation Class: org.apache.cassandra.db.marshal.Int32Type Column Name: value1 Validation Class: org.apache.cassandra.db.marshal.UTF8Type Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy Compression Options: sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor For this table(column family), how do we declare CqlQuery since the value could be a number or a String ? Thanks. mailme365 on "Questions for dynamic column family" http://www.datastax.com/support-forums/topic/questions-for-dynamic-column-family#post-6400 Tue, 11 Sep 2012 02:22:57 +0000 mailme365 6400@http://www.datastax.com/support-forums/ Thank you Srini, you are right, I tested using cli command line, and I noticed that it's dynamic table when I create in cli. Thanks. Srini on "Questions for dynamic column family" http://www.datastax.com/support-forums/topic/questions-for-dynamic-column-family#post-6362 Sat, 08 Sep 2012 18:34:05 +0000 Srini 6362@http://www.datastax.com/support-forums/ That's not possible with CQL v3. It was supported until v2. You would have to use CLI for creating dynamic column. mailme365 on "Questions for dynamic column family" http://www.datastax.com/support-forums/topic/questions-for-dynamic-column-family#post-6360 Sat, 08 Sep 2012 13:43:32 +0000 mailme365 6360@http://www.datastax.com/support-forums/ Hi All, I'm a newbie to Cassandra, according to the doc link <a href="http://www.datastax.com/docs/1.0/ddl/column_family" rel="nofollow">http://www.datastax.com/docs/1.0/ddl/column_family</a>, Cassandra does support dynamic column family and this is a very useful feature. However, I don't know how to create the dynamic columns using CQL via "Create Table" statement? Does any one knows about it or any clue on this? And one more question, I guess I could probably get the answer from the demo project "<install_location>/demos/portfolio_manager", however, I could not find the folder named demos when extracting the mac version package. Does anyone know where to get this demo? mailme365 on "How to create dynamic column family via CQL?" http://www.datastax.com/support-forums/topic/how-to-create-dynamic-column-family-via-cql-1#post-6353 Sat, 08 Sep 2012 01:53:59 +0000 mailme365 6353@http://www.datastax.com/support-forums/ Hi All, I'm a newbie to Cassandra, according to the doc link <a href="http://www.datastax.com/docs/1.0/ddl/column_family" rel="nofollow">http://www.datastax.com/docs/1.0/ddl/column_family</a>, Cassandra does support dynamic column family and this is a very useful feature. However, I don't know how to create the dynamic columns using CQL via "Create Table" statement? Does any one knows about it or any clue on this? And one more question, I guess I could probably get the answer from the demo project "<install_location>/demos/portfolio_manager", however, I could not find the folder named demos when extracting the mac version package. Does anyone know where to get this demo? Thanks a lot in advance.