srini Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 10:53:06 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/using-primary-key-columns#post-10018 Mon, 15 Apr 2013 21:40:14 +0000 kkiran1984 10018@http://www.datastax.com/support-forums/ <p>Hi Vlad,</p> <p>Could you please let me know (any syntax/example) how did you create the table using CLI with the primary key column? </p> <p>Regards,<br /> Kiran. </p> http://www.datastax.com/support-forums/topic/can-i-get-some-logs-from-cassandra#post-8970 Thu, 07 Feb 2013 15:35:53 +0000 mariobriceno 8970@http://www.datastax.com/support-forums/ <p>1. You can create a different structure that allows the log include transactional information.</p> <p>example:</p> <p>Date, Time, Hostname, User DB, event, action BD, Rule Associated with the action</p> <p>2. We see the event log contains information such INFO. You can log events such as stock Deny, Accept / Permit, Modify.</p> <p>example:</p> <p>INFO 11:14:21,762 JNA not found. Native methods will be disabled.</p> <p>INFO 11:14:21,770 Loading settings from file :/ opt/apache/apache-cassandra-1.1.6/conf/cassandra.yaml</p> <p>11:14:21,888 INFO DiskAccessMode 'auto' Determined to be mmap, mmap is indexAccessMode</p> <p>3. What is the location of the transaction logs action Deny, Accept / Permit, Modify, Allowing Processing with SIEM tool. </p> http://www.datastax.com/support-forums/topic/etl-tools-to-transfer-data-from-cassandra-into-other-relational-databases#post-8153 Thu, 27 Dec 2012 06:46:11 +0000 cko 8153@http://www.datastax.com/support-forums/ <p>Hi Srini,</p> <p>Thanks for your response.</p> <p>A few months ago, we did try Pentaho briefly. The job caused an OutOfMemoryError in Cassandra. The Cassandra Pentaho plugin does not handle retrieving rows in batches. It was mentioned that the next version of the plugin will address that issue. We will look at it again when it is available.</p> <p>Thanks again.<br /> Chin </p> http://www.datastax.com/support-forums/topic/simpleauthenticator-and-simpleauthority#post-8017 Tue, 18 Dec 2012 18:37:23 +0000 Srini 8017@http://www.datastax.com/support-forums/ <p>Those are demo's to play around, not recommended for production. </p> <p>It is not good to store passwords in a file even if it is encrypted. </p> <p>You can go for LDAP level authentications. </p> http://www.datastax.com/support-forums/topic/cassandra-12-beta-multinode-error-request-did-not-complete-within-rpc_timeout#post-8016 Tue, 18 Dec 2012 18:20:34 +0000 Srini 8016@http://www.datastax.com/support-forums/ <p>What is the corresponding error in the node's log ? </p> http://www.datastax.com/support-forums/topic/etl-tools-to-transfer-data-from-cassandra-into-other-relational-databases#post-8015 Tue, 18 Dec 2012 18:09:37 +0000 Srini 8015@http://www.datastax.com/support-forums/ <p>This should help you. It's just an overview. Drill down more as per your requirement.</p> <p><a href="http://ovum.com/2012/03/08/pentaho-expands-big-data-coverage/" rel="nofollow">http://ovum.com/2012/03/08/pentaho-expands-big-data-coverage/</a></p> <p><a href="http://wiki.pentaho.com/display/DATAMINING/Cassandra+Source+and+Sink+in+Weka" rel="nofollow">http://wiki.pentaho.com/display/DATAMINING/Cassandra+Source+and+Sink+in+Weka</a> </p> http://www.datastax.com/support-forums/topic/multiple-data-center-shows-very-uneven-load#post-8014 Tue, 18 Dec 2012 18:02:19 +0000 Srini 8014@http://www.datastax.com/support-forums/ <p>This doesn't seem to be abnormal as per your strategy options. </p> http://www.datastax.com/support-forums/topic/cassandra-health-check#post-8013 Tue, 18 Dec 2012 17:47:53 +0000 Srini 8013@http://www.datastax.com/support-forums/ <p>These metrics should be helpful Read/Write Count and read/Write Latency</p> <p>This link has detailed doc on various JMX metrics</p> <p><a href="http://www.datastax.com/docs/0.8/operations/monitoring" rel="nofollow">http://www.datastax.com/docs/0.8/operations/monitoring</a> </p> http://www.datastax.com/support-forums/topic/can-i-query-time-series-data-with-cqlsh#post-8012 Tue, 18 Dec 2012 17:40:44 +0000 Srini 8012@http://www.datastax.com/support-forums/ <p>Hope this helps </p> <p><a href="http://www.datastax.com/dev/blog/thrift-to-cql3" rel="nofollow">http://www.datastax.com/dev/blog/thrift-to-cql3</a> </p> http://www.datastax.com/support-forums/topic/cassandra-health-check#post-8005 Tue, 18 Dec 2012 10:12:20 +0000 ynixon 8005@http://www.datastax.com/support-forums/ <p>OpsCenter is good if you have no other central monitor.<br /> We have JMX based monitor<br /> Which metrics/MBeans are recommended ? </p> http://www.datastax.com/support-forums/topic/can-i-query-time-series-data-with-cqlsh#post-7993 Mon, 17 Dec 2012 16:43:36 +0000 troper 7993@http://www.datastax.com/support-forums/ <p>I have created a column family where the row key is a sensor ID, the column name is a timestamp and the cell value is the sensor reading. </p> <p>Is there any way I can perform a timeslice query using CQLSH since I do not know the column names in advance? </p> http://www.datastax.com/support-forums/topic/etl-tools-to-transfer-data-from-cassandra-into-other-relational-databases#post-7972 Fri, 14 Dec 2012 03:13:03 +0000 cko 7972@http://www.datastax.com/support-forums/ <p>We will use Cassandra as logging storage in one of our web application. The application only insert rows into Cassandra but never update or delete any rows. The CF is expected to grow by about 0.5 million rows per day.</p> <p>We need to transfer the data in Cassandra to another relational database daily. Due to the large size of the CF, instead of truncating the relational table and reloading all rows into it each time, we plan to run a job to select the "delta" rows since the last run and insert them into the relational database.</p> <p>We know we can use Java, Pig or Hive to extract the delta rows to a flat file and load the data into the target relational table. We are particularly interested in a process that can extract delta rows without scanning the entire CF.</p> <p>Has anyone used any other ETL tools to do this kind of delta extraction from Cassandra? We appreciate any comments and experience.</p> <p>Thanks,<br /> Chin </p> http://www.datastax.com/support-forums/topic/multiple-data-center-shows-very-uneven-load#post-7931 Tue, 11 Dec 2012 00:40:04 +0000 keithwrightbos 7931@http://www.datastax.com/support-forums/ <p>Hello,</p> <p> I have base Cassandra 1.1.7 (not DataStax) installed in two data centers with 3 nodes each using a PropertyFileSnitch as outlined below. When I run a nodetool ring, I see a very uneven load. Any idea what I could be going on? I have not added/removed any nodes or changed the replication scheme or counts. </p> <p>Thanks!</p> <p>Address DC Rack Status State Load Effective-Ownership Token<br /> 113427455640312821154458202477256070485<br /> 10.56.92.194 WDC RAC1 Up Normal 53.65 GB 66.67% 0<br /> 10.28.91.10 SEA RC1 Up Normal 3.96 GB 66.67% 1<br /> 10.56.92.196 WDC RAC1 Up Normal 673.78 MB 66.67% 56713727820156410577229101238628035242<br /> 10.28.91.8 SEA RC1 Up Normal 670 MB 66.67% 56713727820156410577229101238628035243<br /> 10.56.92.198 WDC RAC1 Up Normal 746.25 MB 66.67% 113427455640312821154458202477256070484<br /> 10.28.91.2 SEA RC1 Up Normal 799.51 MB 66.67% 113427455640312821154458202477256070485 </p> <p>Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy<br /> Durable Writes: true<br /> Options: [WDC:2, SEA:2]</p> <p>Cluster Information:<br /> Snitch: org.apache.cassandra.locator.PropertyFileSnitch<br /> Partitioner: org.apache.cassandra.dht.RandomPartitioner</p> <p>##### WDC<br /> 10.56.92.194=WDC:RAC1<br /> 10.56.92.196=WDC:RAC1<br /> 10.56.92.198=WDC:RAC1</p> <p>#### SEATTLE<br /> 10.28.91.10=SEA:RC1<br /> 10.28.91.8=SEA:RC1<br /> 10.28.91.2=SEA:RC1</p> <p># default for unknown nodes<br /> default=DALLAS:RAC1 </p> http://www.datastax.com/support-forums/topic/timed-out-exception#post-7904 Sat, 08 Dec 2012 14:34:48 +0000 porqpine 7904@http://www.datastax.com/support-forums/ <p>Bumping this thread. I'm seeing some Timed out exceptions as well. I haven't turned on debugging yet, but I might do that shortly.</p> <p>For the stack trace, what are you looking for/where is the stack trace located? The only error I'm currently seeing is coming from pycassa (Python client) reporting: "MaximumRetryException: Retried 1 times. Last failure was timeout: timed out" The retries in this case have to be 1 because they're counters. </p> http://www.datastax.com/support-forums/topic/simpleauthenticator-and-simpleauthority#post-7864 Thu, 06 Dec 2012 21:46:22 +0000 apollo87 7864@http://www.datastax.com/support-forums/ <p>The 'Authentication and Authorization Configuration' page says that the org.apache.cassandra.auth.SimpleAuthenticator and org.apache.cassandra.auth.SimpleAuthorityare not secure. Could someone explain why? Is general design of putting passwords in a file on the conf directory for implementations of the IAuthorization interface to access not secure? What changes would I have to make to them to make it secure? </p>