http://www.datastax.com/support-forums/topic/cql-question Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 18:38:45 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cql-question#post-1663 Tue, 17 Apr 2012 21:16:04 +0000 thepaul 1663@http://www.datastax.com/support-forums/ <p>The version of the Thrift library in use (Thrift.php and friends) is more important, and is not necessarily the same as the version of Thrift you used to compile your interface.</p> <p>Are you using cassandra-pdo for your CQL queries, or some other library? What version? </p> http://www.datastax.com/support-forums/topic/cql-question#post-1646 Tue, 17 Apr 2012 08:03:57 +0000 Anonymous 1646@http://www.datastax.com/support-forums/ <p>We running with an interface compiled from Thrift 0.7.0 </p> http://www.datastax.com/support-forums/topic/cql-question#post-1629 Mon, 16 Apr 2012 16:41:41 +0000 thepaul 1629@http://www.datastax.com/support-forums/ <p>Hmm. I'm guessing that must be some sort of shortcoming in the PHP implementation of Thrift. I've just tested with a query string in excess of 2^20 bytes (1 MiB) through the Python thrift interface, and it worked fine.</p> <p>I asked around, and it sounds like the more recent versions of PHP Thrift should have a higher maximum frame size. What version are you using? </p> http://www.datastax.com/support-forums/topic/cql-question#post-1628 Mon, 16 Apr 2012 10:00:57 +0000 Anonymous 1628@http://www.datastax.com/support-forums/ <p>Hi there, we are just switching to CQL for some of our data analysis (we were using direct thrift queries) and I have a question which I'm guessing must have come up before. I have a large amount of user data in a super column so I have written a (PHP) script to read that data and push it into a wide column suitable for CQL.</p> <p>At the moment I have a loop that looks something like this:</p> <p>Read a chunk of keys from the super-column like so<br /> $cCQLResult = $this-&gt;ExecuteCQL($cCQLDatasource, "SELECT KEY FROM PlayrUserData WHERE KEY &gt;= '$StartKey' AND KEY &lt; '$FinishKey'");</p> <p>Now for that chunk build a list of keys that I wish to write (using a thrift query into the super column)</p> <p>For those keys that pass a simple test write them all into a wide column family:<br /> $this-&gt;ExecuteCQL($cCQLDatasource, "UPDATE MarketingCohortCache SET '000001.Facebook.1517061723'='1','000020.Facebook.100003474181964'='1', .. 'WHERE KEY=LapsedUser_1330560000");</p> <p>The problem appears to be that I am attempting to UPDATE MarketingCohortCache with a pretty long list (about 5000 keys) and it appears to be choking the thrift interface with: TSocket: Could not write 194718 bytes (the length of the Update string).</p> <p>Is there a recommended way to write a large quantity of data to a wide column? Do I need to loop through with multiple updates? If so how long can I let the update string get?</p> <p>May thanks for reading. </p>