Questions tagged [phpcassa]

phpcassa is a PHP client library (port of pycassa) for Apache Cassandra

phpcassa is a PHP client library for Apache Cassandra.

  • Compatible with Cassandra 0.7, 0.8, 1.0, and 1.1
  • Optional C extension for improved performance

phpcassa is compatible with PHP 5.3+

phpcassa is open source under the MIT license.

95 questions
3
votes
1 answer

phpcassa TException:TSocket: Could not connect on high traffic website

I'm trying to use phpcassa on high-traffic website (using AWS), there is about 50 requests per seconds, but sometimes I'm getting the following error: An attempt was made to connect to every server twice, but all attempts failed. The last error was:…
sasa
  • 2,443
  • 5
  • 23
  • 35
3
votes
2 answers

Cassandra is not retrieving the correct integer value

I am using cql 3.0.0 I have executed the query: INSERT INTO emp (empID, deptID, first_name, last_name) VALUES (104, 15, 'jane', 'smith') On retrieving this record, I get the following values: empid = h deptid = (blank value) first_name =…
user1058797
  • 867
  • 3
  • 10
  • 19
2
votes
1 answer

cassandra: query with index expression doesn't work

I'm trying to get data from Cassandra with this query: $cf=new…
Undrooleek
  • 223
  • 4
  • 12
2
votes
1 answer

getting data from cassandra using clauses

Is there any way to get data from cassandra through phpcassa using a clauses? I need to select all rows where sum<10. For example the function in phpcassa get_range() selects only rows which equals certain values.
Undrooleek
  • 223
  • 4
  • 12
2
votes
1 answer

batch_mutate for counters

Is it possible to use batch_mutate for counters in php? From what I've seen, it should be possible to increment counters in general, but I can't seem to find any working examples in any language. Thanks
miki
  • 695
  • 3
  • 8
2
votes
1 answer

phpcassa describe keyspace call on new CF object

Is this call really made every time a new ColumnFamily object is created? If I cache the response, what would be consequences - assuming the schema does not change?
miki
  • 695
  • 3
  • 8
2
votes
2 answers

Show all keys with phpcassa

I'm fairly new to cassandra but i have making good progress so far. $conn = new ConnectionPool('Cluster'); $User = new ColumnFamily($conn, 'User'); $index_exp = CassandraUtil::create_index_expression('email', 'John@dsaads.com'); $index_clause =…
Writecoder
  • 613
  • 2
  • 8
  • 27
2
votes
2 answers

Cassandra update column

how can i update column in cassandra database?? columnfam{ username{ name:edds, surname:surname, email:mymail@rrr.com } } for example i need update surname?? im using php client PHPCASSA. thanx
Edmhs
  • 3,645
  • 27
  • 39
2
votes
1 answer

Pruning Columns in Cassandra

I'm thinking about using Cassandra for a large data project. The data will be sourced from a traditional data warehouse. Cassandra will host the data formated in a way my application can correctly read it. I don't quite understand how I will prune…
Gary Richardson
  • 16,081
  • 10
  • 53
  • 48
2
votes
1 answer

Connecting to Cassandra Database Using PHP

I am trying to develop both an Android application and a web front end that will allow me to connect to and query a Cassandra database running on my local host. I currently have Cassandra 2.0.5, Thrift 1.0.0, JRE 7u51, PHP 5.3.10, Apache 2.2.22 I…
user2737686
  • 33
  • 1
  • 4
2
votes
1 answer

How to execute cassandra query in PHP using phpcassa?

I am trying to execute cassandra query in php using this script, but it throws me an error.can any one help me to figure the problem in code ?
2
votes
1 answer

Cassandra timeseries datamodel

Let assume 10 devices(dev01,dev02,dev03..etc). It send data with some interval time,we collect those data,so our data schema is dev01 :int signalname :string signaltime :date/time[with YY-MM-DD HHMMSS.mm] Extradata :String I want to push…
kannadhasan
  • 339
  • 4
  • 17
2
votes
1 answer

Cassandra schema for timelines

I want to design a Cassandra schema for my timeline: I have users and every user has a timeline, each timeline value is an string. Since every user has a timeline of strings I need to populate each users timeline from the end as quickly as…
Ata
  • 12,126
  • 19
  • 63
  • 97
2
votes
0 answers

How to save DateType in phpcassa?

I am trying to save a DateType to cassandra database using phpcassa. This is what I do: $date = new DateTime(); $column_family_commentByPost = new ColumnFamily($pool, 'commentByPost'); $column_family_commentByPost->insert($my_uuid_string1,…
pixie
  • 151
  • 2
  • 10
2
votes
0 answers

parallel get_range() phpcassa

I am trying to made something similar to map reduce, but without hadoop. I plane to use several php processes, each doing $cf->get_range($begin, $end) and to iterate every row. But because of random partitioner, the data does not come sorted. This…
Nick
  • 9,962
  • 4
  • 42
  • 80