abhijit Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 08:28:24 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10564 Thu, 02 May 2013 09:30:58 +0000 Abhijit 10564@http://www.datastax.com/support-forums/ <p>He is talking about DSE v 3.0.1</p> <p>-Abhijit </p> http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10545 Wed, 01 May 2013 22:21:17 +0000 raihan26 10545@http://www.datastax.com/support-forums/ <p>@alexliu, What's the version of DSE release you are talking about that it doesn't supports binary protocol yet? </p> http://www.datastax.com/support-forums/topic/whitespace-character-in-parameter-substitution-in-pig-script-not-working-properly-in-dse#post-10537 Wed, 01 May 2013 13:30:36 +0000 Abhijit 10537@http://www.datastax.com/support-forums/ <p>Thanks for the response @Sven. </p> <p>Yes the standard pig version 0.9.2 is working fine. Some issues with DSE pig (may be some packaging)</p> <p>-Abhijit </p> http://www.datastax.com/support-forums/topic/whitespace-character-in-parameter-substitution-in-pig-script-not-working-properly-in-dse#post-10525 Tue, 30 Apr 2013 14:11:49 +0000 Sven 10525@http://www.datastax.com/support-forums/ <p>We are going to look into this. A Jira has been created... if the standard pig works fine, so should the DSE pig. </p> http://www.datastax.com/support-forums/topic/whitespace-character-in-parameter-substitution-in-pig-script-not-working-properly-in-dse#post-10428 Fri, 26 Apr 2013 16:02:24 +0000 Abhijit 10428@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>I am looking for functionality in pig script "parameter substitution in script including white space character". But some how was not able to do that, though from pig JIRA issues, it can be said that they are supporting it since 0.9 series. To investigate further i posted the question in pig user group as well as in stack overflow (<a href="http://stackoverflow.com/questions/16229364/whitespace-character-in-case-of-parameter-substitution)" rel="nofollow">http://stackoverflow.com/questions/16229364/whitespace-character-in-case-of-parameter-substitution)</a>. According to one of the user in SO, it might be a problem with DSE distribution. So basically want to confirm whether if it is problem related pig packaging or something else. And yes i am using DSE3.0 i.e pig 0.9.2</p> <p>-Abhijit </p> http://www.datastax.com/support-forums/topic/latest-pig-support-in-dse#post-10218 Mon, 22 Apr 2013 20:11:45 +0000 Sven 10218@http://www.datastax.com/support-forums/ <p>There are no immediate plans to upgrade to that version of pig. There is already a request filed for upgrading pig, so it is being discussed/prioritized, no timeline at this point though. </p> http://www.datastax.com/support-forums/topic/latest-pig-support-in-dse#post-10217 Mon, 22 Apr 2013 20:11:41 +0000 Sven 10217@http://www.datastax.com/support-forums/ <p>There are no immediate plans to upgrade to that version of pig. There is already a request filed for upgrading pig, so it is being discussed/prioritized, no timeline at this point though. </p> http://www.datastax.com/support-forums/topic/latest-pig-support-in-dse#post-10216 Mon, 22 Apr 2013 19:30:15 +0000 Abhijit 10216@http://www.datastax.com/support-forums/ <p>Hi Forum,</p> <p>For some time i was looking for CASE QUERY support in pig, and recently they have started supporting it (<a href="https://issues.apache.org/jira/browse/PIG-3268)" rel="nofollow">https://issues.apache.org/jira/browse/PIG-3268)</a>. Well now just want to know by what time DSE will be going to use that version of pig, as we are using DSE solution in our product.</p> <p>-Abhijit </p> http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10214 Mon, 22 Apr 2013 18:54:27 +0000 alexliu 10214@http://www.datastax.com/support-forums/ <p>Current DSE release doesn't support binary protocol, so you need wait for the following release to use CQL3 java-driver as a client for your application. </p> http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10213 Mon, 22 Apr 2013 18:52:21 +0000 alexliu 10213@http://www.datastax.com/support-forums/ <p>Cassandra introduces CQL 3, which is an abstract layer to make the query more like traditional SQL language. Netflix client(Astyanax client) doesn't support it yet, so you need continuously use the old way to define KS and CF.</p> <p>This link explains the under hood of CQL<br /> <a href="http://www.datastax.com/dev/blog/schema-in-cassandra-1-1" rel="nofollow">http://www.datastax.com/dev/blog/schema-in-cassandra-1-1</a></p> <p>You can use cqlsh to create schema, make it as "WITH COMPACT STORAGE" to be backward compatible.</p> <p>You can also check this reference <a href="http://www.datastax.com/docs/1.1/references/cql/index" rel="nofollow">http://www.datastax.com/docs/1.1/references/cql/index</a></p> <p>If you want to switch to CQL 3 client like <a href="https://github.com/datastax/java-driver" rel="nofollow">https://github.com/datastax/java-driver</a> which works exclusively with the Cassandra Query Language version 3 (CQL3) and Cassandra's binary protocol.</p> <p>For your example</p> <p>CREATE TABLE profile (<br /> id text PRIMARY KEY,<br /> account text,<br /> advertising text,<br /> behavior text,<br /> info text<br /> )<br /> WITH COMPACT STORAGE; </p> http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10119 Fri, 19 Apr 2013 01:55:55 +0000 raihan26 10119@http://www.datastax.com/support-forums/ <p>I have started working with Cassandra database. I am planning to use Datastax API to upsert/read into/from cassandra database. I am totally new to this Datastax API (which uses new Binary protocol) and I am not able to find lot of documentations as well which have some proper examples.</p> <p>When I was working with Cassandra CLI using the Netflix client(Astyanax client), then I created the column family like this-</p> <pre><code>create column family profile with key_validation_class = &#039;UTF8Type&#039; and comparator = &#039;UTF8Type&#039; and default_validation_class = &#039;UTF8Type&#039; and column_metadata = [ {column_name : crd, validation_class : &#039;DateType&#039;} {column_name : lmd, validation_class : &#039;DateType&#039;} {column_name : account, validation_class : &#039;UTF8Type&#039;} {column_name : advertising, validation_class : &#039;UTF8Type&#039;} {column_name : behavior, validation_class : &#039;UTF8Type&#039;} {column_name : info, validation_class : &#039;UTF8Type&#039;} ];</code></pre> <p>Now I was trying to do the same thing using Datastax API. So to start working with Datastax API, do I need to create the column family in some different way as mentioned above? Or the above column familiy will work fine whenever I will try to insert data into Cassandra database using Datastax API.</p> <p>If the above column family will not work then-</p> <p>First of all I have created the KEYSPACE like below-</p> <p><code>CREATE KEYSPACE USERS WITH strategy_class = &#039;SimpleStrategy&#039; AND strategy_options:replication_factor = &#039;1&#039;;</code></p> <p>Now I am confuse how to create the table? I am not sure which is the right way to do that?</p> <p>Should I create like this?</p> <pre><code>CREATE TABLE profile ( id varchar, account varchar, advertising varchar, behavior varchar, info varchar, PRIMARY KEY (id) );</code></pre> <p>or should I create like this?</p> <pre><code>CREATE COLUMN FAMILY profile ( id varchar, account varchar, advertising varchar, behavior varchar, info varchar, PRIMARY KEY (id) );</code></pre> <p>And also how to add-</p> <p><code>crd as DateType</code><br /> <code>lmd as DateType</code></p> <p>in above table or column family while working with Datastax API?</p> <p>Any help will be appreciated. </p> http://www.datastax.com/support-forums/topic/datastax-opscenter-not-reflecting-cassandra-data#post-9880 Thu, 11 Apr 2013 17:19:38 +0000 Abhijit 9880@http://www.datastax.com/support-forums/ <p>Nick,</p> <p>Thanks for the clarification.</p> <p>-Abhijit </p> http://www.datastax.com/support-forums/topic/datastax-opscenter-not-reflecting-cassandra-data#post-9873 Thu, 11 Apr 2013 13:49:19 +0000 nickmbailey 9873@http://www.datastax.com/support-forums/ <p>Abhijit,</p> <p>This is because OpsCenter does not currently detect and display column families created with CQL3. This is a known issue and should be fixed in an upcoming release of OpsCenter.</p> <p>-Nick </p> http://www.datastax.com/support-forums/topic/datastax-opscenter-not-reflecting-cassandra-data#post-9863 Thu, 11 Apr 2013 10:03:49 +0000 Abhijit 9863@http://www.datastax.com/support-forums/ <p>I have installed Datastax community edition 1.2.3 and Opscenter 3.0 in one of server machine where I have created some column families using CQL, but i am unable to see them via opscenter. But if i create any column family using the opscenter then its is getting reflected with ease. </p> <p>See the <code><a href="http://166.78.10.41:8888/opscenter/index.html" rel="nofollow">http://166.78.10.41:8888/opscenter/index.html</a></code>. In my <code>ipdr</code> keyspace i have already a CF named <code>events</code> created from api and that one <code>test</code>, which we can see in opscenter is being created manually. </p> http://www.datastax.com/support-forums/topic/unable-to-access-the-cfs-in-analytic-mode#post-9021 Thu, 14 Feb 2013 18:27:35 +0000 Piotr Kołaczkowski 9021@http://www.datastax.com/support-forums/ <p>Your URIs are wrong.<br /> The correct URI syntax is:<br /> [cfs://[host][:port]]/[path]</p> <p>The cfs://user/ URI splits into the following components:</p> <p>scheme = cfs<br /> host = user<br /> path = /</p> <p>This is very likely not what you wanted and that's why it has connection problems.</p> <p>The following will work:</p> <p>dse hadoop fs -ls /user<br /> dse hadoop fs -ls cfs:///user<br /> dse hadoop fs -ls cfs://localhost/user</p> <p>dse hadoop fs -cat info.csv<br /> dse hadoop fs -cat cfs:///info.csv<br /> dse hadoop fs -cat cfs://localhost/info.csv </p>