ryoudelman Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 20:56:37 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/system-requirements-for-opscenter-master#post-8811 Wed, 30 Jan 2013 20:00:12 +0000 mbulman 8811@http://www.datastax.com/support-forums/ <p>We highly recommend running opscenterd on its own machine, so that no resources are taken from your actual Cassandra nodes. That being said, there is no technical reason it cannot be run on one of the nodes.</p> <p>The minimum requirements for the opscenterd machine are fairly lightweight. We don't have exact numbers, but a decently fast machine with 1GB of ram should do just fine. The main factor to consider is how many nodes and clusters you are managing. </p> http://www.datastax.com/support-forums/topic/system-requirements-for-opscenter-master#post-8801 Wed, 30 Jan 2013 15:18:00 +0000 ryoudelman 8801@http://www.datastax.com/support-forums/ <p>What is the best practice for setting up the opscenter master? Can it run on one of the cassandra nodes or does it need its own machine? If it needs its own hardware, what are the requirements?</p> <p>Thanks. </p> http://www.datastax.com/support-forums/topic/sstable-loader-and-bulkoutput-format-with-composite-columns#post-7987 Mon, 17 Dec 2012 11:58:06 +0000 hjarraya 7987@http://www.datastax.com/support-forums/ <p>Having the same issue, it would be great if you can provide and example.</p> <p>Thanks,</p> <p>H </p> http://www.datastax.com/support-forums/topic/sstable-loader-and-bulkoutput-format-with-composite-columns#post-7976 Fri, 14 Dec 2012 20:50:29 +0000 ryoudelman 7976@http://www.datastax.com/support-forums/ <p>Does the bulkoutputformat and sstable table loader support composite columns? If so, can you provide an example.</p> <p>Thanks. </p> http://www.datastax.com/support-forums/topic/expanding-range-search-on-composite-columns#post-3278 Thu, 19 Jul 2012 13:51:27 +0000 ryoudelman 3278@http://www.datastax.com/support-forums/ <p>Are there any plans to expand the range search capability of composite columns to allow range searches across multiple components at the same time? For example, if I had a composite of </p> <p>State:City</p> <p>I might want to search where State starts with M and City starts with Bo at the same time. </p> http://www.datastax.com/support-forums/topic/rangesuperslicesquery-for-composite-columns#post-3237 Wed, 18 Jul 2012 20:18:50 +0000 ryoudelman 3237@http://www.datastax.com/support-forums/ <p>Ignore this post. </p> http://www.datastax.com/support-forums/topic/rangesuperslicesquery-for-composite-columns#post-3230 Wed, 18 Jul 2012 14:53:07 +0000 ryoudelman 3230@http://www.datastax.com/support-forums/ <p>Is there a way to do RangeSuperSlicesQuery for composite columns? Using the setup below(which I can change), I want to be able to do a range scan on the key, the a subsequent scan on the composite type. This would resolve a query like</p> <p>select * from LastNameFirstNameZip<br /> where lName like 'You%'<br /> and FName like 'Regin%'<br /> and Zip like '300%'</p> <p>Which i would expect to return:</p> <p>-------------------<br /> RowKey: Youdelman_123<br /> =&gt; (column=Regina:30082, value=123, timestamp=1342618064598000)<br /> -------------------<br /> RowKey: Youdelman_125<br /> =&gt; (column=Regin:30080, value=125, timestamp=1342618064623001)</p> <p>Column Family definition:</p> <p> create column family LastNameFirstNameZip<br /> with comparator = 'CompositeType(UTF8Type,UTF8Type)'<br /> and key_validation_class = 'UTF8Type'<br /> and default_validation_class = 'UTF8Type';</p> <p>data:<br /> -------------------<br /> RowKey: Youdelman_123<br /> =&gt; (column=Regina:30082, value=123, timestamp=1342618064598000)<br /> -------------------<br /> RowKey: Youdelman_124<br /> =&gt; (column=Reggie:30082, value=124, timestamp=1342618064623000)<br /> -------------------<br /> RowKey: Youdelman_125<br /> =&gt; (column=Regin:30080, value=125, timestamp=1342618064623001)<br /> -------------------<br /> RowKey: Youdelman_126<br /> =&gt; (column=Ella:30080, value=126, timestamp=1342618064623002) </p> http://www.datastax.com/support-forums/topic/loading-multiple-column-families-using-bulkoutputformat#post-2830 Mon, 09 Jul 2012 18:40:41 +0000 ryoudelman 2830@http://www.datastax.com/support-forums/ <p>I have multiple column families I wish to populate in cassandra from hadoop. My column families are couple together through keys and I would like to maintain some integrity by updating the column families for a given key at the same time. Can you do multiple column families using the BulkOutputFormat class? </p> http://www.datastax.com/support-forums/topic/problem-connecting-to-agents-with-simple-security-turned-on#post-2414 Tue, 26 Jun 2012 19:55:34 +0000 ryoudelman 2414@http://www.datastax.com/support-forums/ <p>User error on my part. I didn't realize the agent keystore was specific to the opscenter install. Once I corrected that the agent could properly communicate and opscenter could authenticate. Thanks. </p> http://www.datastax.com/support-forums/topic/problem-connecting-to-agents-with-simple-security-turned-on#post-2411 Tue, 26 Jun 2012 18:48:33 +0000 ryoudelman 2411@http://www.datastax.com/support-forums/ <p>Yes, i can do a list on the rollups60 cf and get the first hundred rows of data back. </p> http://www.datastax.com/support-forums/topic/problem-connecting-to-agents-with-simple-security-turned-on#post-2410 Tue, 26 Jun 2012 18:38:55 +0000 tupton 2410@http://www.datastax.com/support-forums/ <p>Listing the column families does not necessarily guarantee that authorization is set up correctly. Can you read/write to those column families via the cli?</p> <p>Changes to access.properties also require Cassandra to be restarted to take effect, if you haven't already done so.</p> <p>EDIT: access.properties does *not* require a restart; it is read on every access. </p> http://www.datastax.com/support-forums/topic/problem-connecting-to-agents-with-simple-security-turned-on#post-2408 Tue, 26 Jun 2012 18:30:42 +0000 ryoudelman 2408@http://www.datastax.com/support-forums/ <p>Interesting enough I can use cassandra-cli and authenticate as myUser. I can then do a list on the columnfamilies under the OpsCenter keyspace. </p> http://www.datastax.com/support-forums/topic/problem-connecting-to-agents-with-simple-security-turned-on#post-2406 Tue, 26 Jun 2012 17:39:39 +0000 ryoudelman 2406@http://www.datastax.com/support-forums/ <p>I have a poc cluster setup which uses the basic file security. I am seeing the following error in my logs and the agent is unable to report in:</p> <p>2012-06-26 13:33:02-0400 [] Error fetching metric data:<br /> Traceback (most recent call last):<br /> Failure: telephus.cassandra.ttypes.InvalidRequestException: InvalidRequestException(why='#&lt;User myUser groups=[]&gt; does not have permission READ for /cassandra/keyspaces/OpsCenter/rollups60'</p> <p>I tried modifying my access.properties file to include the column families but am still getting the error:</p> <p>&lt;modify-keyspaces&gt;=myUser </p> <p># Access to Keyspace1 (add/remove column families, etc).<br /> #Keyspace1.&lt;ro&gt;=jsmith,Elvis Presley<br /> #Keyspace1.&lt;rw&gt;=dilbert<br /> OpsCenter.&lt;rw&gt;=myUser </p> <p># Access to Standard1 (keyspace Keyspace1)<br /> #Keyspace1.Standard1.&lt;rw&gt;=jsmith,Elvis Presley,dilbert<br /> OpsCenter.rollups60.&lt;rw&gt;=myUser<br /> OpsCenter.events.&lt;rw&gt;=myUser<br /> OpsCenter.pdps.&lt;rw&gt;=myUser<br /> OpsCenter.events-history.&lt;rw&gt;=myUser<br /> OpsCenter.rollsups300.&lt;rw&gt;=myUser<br /> OpsCenter.rollsups72000.&lt;rw&gt;=myUser<br /> OpsCenter.events-timeline.&lt;rw&gt;=myUser<br /> OpsCenter.settings.&lt;rw&gt;=myUser </p> http://www.datastax.com/support-forums/topic/columnfamily-design#post-2379 Mon, 25 Jun 2012 19:02:01 +0000 ryoudelman 2379@http://www.datastax.com/support-forums/ <p>Thanks. </p> http://www.datastax.com/support-forums/topic/owns-in-nodetool#post-2378 Mon, 25 Jun 2012 18:59:04 +0000 xedin 2378@http://www.datastax.com/support-forums/ <p>In addition you can use 'nodetool move' command to set a new token to the node without deleting the data, data delete is required because token is stored into the system keyspace after the first start. </p>