DataStax Support Forums » User Favorites: xedin

DataStax Support Forums » User Favorites: xedin xedin Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 08:46:18 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php shayhassidim on "How to cache HttpSession Objects using Cassandra ?" http://www.datastax.com/support-forums/topic/how-to-cache-httpsession-objects-using-cassandra#post-9216 Thu, 28 Feb 2013 23:38:41 +0000 shayhassidim 9216@http://www.datastax.com/support-forums/ You can use GigaSpaces HTTP session caching and configure it to use Cassandra as the backend DB. <a href="http://wiki.gigaspaces.com/wiki/display/XAP91/Global+HTTP+Session+Sharing" rel="nofollow">http://wiki.gigaspaces.com/wiki/display/XAP91/Global+HTTP+Session+Sharing</a> <a href="http://wiki.gigaspaces.com/wiki/display/XAP91/Cassandra+Space+Persistency" rel="nofollow">http://wiki.gigaspaces.com/wiki/display/XAP91/Cassandra+Space+Persistency</a> Shay chandu on "Cassandra - loading csv using sstableloader" http://www.datastax.com/support-forums/topic/cassandra-loading-csv-using-sstableloader/page/3#post-8882 Sat, 02 Feb 2013 23:59:11 +0000 chandu 8882@http://www.datastax.com/support-forums/ Hello Group, I am using bulkoutputformat to load from HadoopToCassandra. We changed configuration like rpc port to 9161 & storage port to 7002. How to i pass storage port number from Hadoop Driver. thanks chandu umermk3 on "Can't start cassandra node" http://www.datastax.com/support-forums/topic/cant-start-cassandra-node#post-8317 Mon, 07 Jan 2013 23:27:20 +0000 umermk3 8317@http://www.datastax.com/support-forums/ Warning: This will *delete* your old Cassandra data. On OSX or Linux, delete the previous Cassandra folder like this: <code>$ sudo rm -fr /var/lib/cassandra</code> Depending on your permission, you might not need to use <code>sudo</code>. It is because the new default partitioner is now Murm3r, instead of RandomPartitioner. That's how it worked for me. Srini on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6730 Sun, 30 Sep 2012 16:10:43 +0000 Srini 6730@http://www.datastax.com/support-forums/ There is bug fix for similar issue. Check out <a href="https://issues.apache.org/jira/browse/CASSANDRA-4219" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-4219</a> kannanspec on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6722 Fri, 28 Sep 2012 18:01:20 +0000 kannanspec 6722@http://www.datastax.com/support-forums/ Hi, I created new column family with CQL3 option. but when i load the data using the SSTableLoader , which i used for cql2.0, i recieve below error on the column family, any idea? cqlsh:xynergy> select * from seen_ships; TSocket read 0 bytes cqlsh:xynergy> vs on "Crash in Cassandra-CLI" http://www.datastax.com/support-forums/topic/crash-in-cassandra-cli#post-6674 Wed, 26 Sep 2012 12:30:11 +0000 vs 6674@http://www.datastax.com/support-forums/ C:\Development\apache-cassandra-1.1.3\bin -- The bin directory Cassandra.yaml in C:\Development\apache-cassandra-1.1.3\conf xedin on "Crash in Cassandra-CLI" http://www.datastax.com/support-forums/topic/crash-in-cassandra-cli#post-6673 Wed, 26 Sep 2012 12:25:21 +0000 xedin 6673@http://www.datastax.com/support-forums/ That's weird, where do you keep your cassandra.yaml config? Could be a packaging issue... vs on "Crash in Cassandra-CLI" http://www.datastax.com/support-forums/topic/crash-in-cassandra-cli#post-6671 Wed, 26 Sep 2012 12:20:35 +0000 vs 6671@http://www.datastax.com/support-forums/ I observe a similar behavior with CQLsh spec 2.0 as well which is a bit strange. A get query in Cassandra-CLI works fine after adding the index on column 'age' from CQLsh: [default@usertable] get users where age=30; Somehow, the combined use of CQLsh and CLI doesn't seem to be getting along fine. Just curious to know if someone else has tried this and observed a similar behavior. I tried running Cassandra-CLI from root directory, still the same! Thanks, VS xedin on "Crash in Cassandra-CLI" http://www.datastax.com/support-forums/topic/crash-in-cassandra-cli#post-6670 Wed, 26 Sep 2012 12:08:38 +0000 xedin 6670@http://www.datastax.com/support-forums/ Hi, there is incompatibility between CQL3 and Thrift (which CLI uses) because CQL3 defined ColumnFamilies don't share some of the information to Thrift interface (e.g. component_index field of column which is essential for building a correct column name). But your exception is different - can you try running cassandra-cli from the cassandra root dir like ./bin/cassandra-cli ? vs on "Crash in Cassandra-CLI" http://www.datastax.com/support-forums/topic/crash-in-cassandra-cli#post-6669 Wed, 26 Sep 2012 12:03:49 +0000 vs 6669@http://www.datastax.com/support-forums/ Hi, I created a table in CQLsh -3.0 and inserted values into it. create table users ( Id uuid PRIMARY KEY, Name varchar, Age int ); insert into users(Id, Name, Age) values ('001', 'XYZ', '30'); : : cqlsh:usertable> select * from users; id | age | name --------------------------------------+-----+-------- 1381b530-1dd2-11b2-0000-242d50cf1ffd | 30 | XYZ 13816710-1dd2-11b2-0000-242d50cf1ffd | 28 | ABC 13818e20-1dd2-11b2-0000-242d50cf1ffd | 30 | PQR However, when I attempt to insert new rows into this table from Cassandra-CLI interface, it crashes: [default@unknown] use usertable; Authenticated to keyspace: usertable [default@usertable] [default@usertable] set users['005']['name'] = 'MNO'; log4j:WARN No appenders could be found for logger (org.apache.cassandra.config.DatabaseDescriptor). log4j:WARN Please initialize the log4j system properly. log4j:WARN See <a href="http://logging.apache.org/log4j/1.2/faq.html#noconfig" rel="nofollow">http://logging.apache.org/log4j/1.2/faq.html#noconfig</a> for more info. Cannot locate cassandra.yaml Fatal configuration error; unable to start server. See log for stacktrace. C:\Development\apache-cassandra-1.1.3\bin> Has anyone else observed a similar behavior.? Is there some incompatibility between CQLsh 3.0 and Cassandra-CLI? Thanks, VS xedin on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6622 Fri, 21 Sep 2012 20:47:58 +0000 xedin 6622@http://www.datastax.com/support-forums/ I think you will have to re-create your ColumnFamily with CQL3 to use it properly and include "Date" field into PRIMARY KEY, because CQL3 makes use of composite comparators, e.g. CREATE COLUMNFAMILY "OM_CDMA_SECTOR_DATA_MAIN" ( id <something>, day timestamp, PRIMARY KEY (id, day) ); kannanspec on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6621 Fri, 21 Sep 2012 20:33:51 +0000 kannanspec 6621@http://www.datastax.com/support-forums/ Yes i have below indexed columns set up already, is there anything missing CREATE INDEX IDX1 ON OM_CDMA_SECTOR_DATA_MAIN (Day); thanks Kannan xedin on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6620 Fri, 21 Sep 2012 20:32:13 +0000 xedin 6620@http://www.datastax.com/support-forums/ Right, because you have to set up indexed columns before doing any operations :) kannanspec on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6619 Fri, 21 Sep 2012 20:21:21 +0000 kannanspec 6619@http://www.datastax.com/support-forums/ Hi, I used CQL 3.0 but i still get the below error which i get in 2.0 cqlsh:xynergy> select "Day" from "OM_CDMA_SECTOR_DATA_MAIN" where "Day" > '7/29/2012'; Bad Request: No indexed columns present in by-columns clause with Equal operator Thanks Kannan xedin on "cql 3.0" http://www.datastax.com/support-forums/topic/cql-30#post-6618 Fri, 21 Sep 2012 19:46:25 +0000 xedin 6618@http://www.datastax.com/support-forums/ To fix that you will have to double-quote ColumnFamily names in mixed case like this select * from "OM_CDMA_SECTOR_NEW1";