Request: line 1:45 mismatched input 'OR' expecting EOF
3) If I use AND operator, it also not sending data. Query doesn't have
issues, but result set is null.
SELECT * FROM TestCF WHERE status='Failed' AND status='Success'
cqlsh:dev SELECT * FROM TestCF WHERE status='Failed' AND status
is not fetching data.
SELECT * FROM TestCF WHERE status='Failed' OR status='Success'
3) If I use AND operator, it also not sending data. Query doesn't have
issues, but result set is null.
SELECT * FROM TestCF WHERE status='Failed' AND status='Success'
4) Is there any thing similar to LIKE in CQL? I
At Netflix we rotate the major compactions around the cluster, don't
run them all at once. We also either take that node out of client
traffic so it doesn't get used as a coordinator or use the Astyanax
client that is latency and token aware to steer traffic to the other
replicas.
We are running
it be able
to
answer any read request? And is it wise to write anything to a cluster
while it's doing major compaction?
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Can-you-query-Cassandra-while-it-s-doing-major-compaction
If every node in the cluster is running major compaction, would it be able to
answer any read request? And is it wise to write anything to a cluster
while it's doing major compaction?
Compaction is something that is supposed to be continuously running in
the background. As noted, it will have
.
Hector code:
RangeSlicesQueryTileKey,Byte,byte[] query =
HFactory.createRangeSlicesQuery(keyspace, keySerializer,
columnNameSerializer, BytesArraySerializer
.get());
query.setColumnFamily(overlay).setKeys(keyStart,
keyEnd).setColumnNames((byte)2);
query.execute();
The execution log
:
RangeSlicesQueryTileKey,Byte,byte[] query =
HFactory.createRangeSlicesQuery(keyspace, keySerializer,
columnNameSerializer, BytesArraySerializer
.get());
query.setColumnFamily(overlay).setKeys(keyStart, keyEnd).setColumnNames((
byte)2);
query.execute();
The execution log shows
1359 [main] INFO
=03, timestamp=1326750723416000)
4 Rows Returned.
Hector code:
RangeSlicesQueryTileKey,Byte,byte[] query =
HFactory.createRangeSlicesQuery(keyspace, keySerializer,
columnNameSerializer, BytesArraySerializer
.get());
query.setColumnFamily(overlay).setKeys(keyStart, keyEnd).setColumnNames
Hello everyone!
I have a strange problem with Cassandra (v1.0.5, one node, 8GB, 2xCPU):
a query asking for each key from a certain (super) CF results in timeout
and almost dead cassandra after that (it's somewhat alive, but does not
return any data - has to be restarted).
CF details
You've got at least one row over 1GB, compacted !
Have you checked whether you are running out of heap ?
2011/12/12 Wojtek Kulik wojtek.ku...@futureful.com
Hello everyone!
I have a strange problem with Cassandra (v1.0.5, one node, 8GB, 2xCPU): a
query asking for each key from a certain
Hello,
I'm running the same query repeatedly. It's a secondary index query,
done from a Pycassa client. I see that when I iterate the result object,
I get slightly different number of entries when running the test serially.
There is no deletions in the database, and no writes, it's static
From: Riyad Kalla [mailto:rka...@gmail.com]
Sent: Monday, November 07, 2011 4:31 PM
To: user@cassandra.apache.org
Subject: Re: Secondary index issue, unable to query for records that should be
there
Nate, is this all against a single Cassandra server, or do you have a ring
setup? If you do have
]
*Sent:* Monday, November 07, 2011 4:31 PM
*To:* user@cassandra.apache.org
*Subject:* Re: Secondary index issue, unable to query for records that
should be there
** **
Nate, is this all against a single Cassandra server, or do you have a ring
setup? If you do have a ring setup, what
results.
However a CQL query to find that same record fails:
[default@Test] get IndexTest where year=2011 and month=1 and day=8 and hour=18
and minute=30;
0 Row Returned.
[default@Test] get IndexTest where year=2011 and month=1 and day=8 and hour=18;
0 Row Returned.
[default@Test] get IndexTest
I restarted with logging turned up to DEBUG, and after quite a bit of logging
during startup, I re-ran a query:
get IndexTest where year=2011 and month=1 and day=14 and hour=18 and minute=49;
produced the following in the following:
DEBUG [pool-2-thread-3] 2011-11-08 10:19:21,823
Note that I had identical behavior using a fresh download of Cassandra 1.0.2 as
of today.
Thanks,
-nate
From: Nate Sammons [mailto:nsamm...@ften.com]
Sent: Tuesday, November 08, 2011 10:20 AM
To: user@cassandra.apache.org
Subject: RE: Secondary index issue, unable to query for records
To: user@cassandra.apache.org
Subject: RE: Secondary index issue, unable to query for records that should be
there
Note that I had identical behavior using a fresh download of Cassandra 1.0.2 as
of today.
Thanks,
-nate
From: Nate Sammons [mailto:nsamm...@ften.com]mailto:[mailto:nsamm
, validation_class:IntegerType, index_type:
KEYS},
... other non-indexed columns defined
];
So when I insert data, I calculate a year/month/day/hour/minute and set these
values on a Hector ColumnFamilyUpdater instance and update that way. Then
later I can query from the command line
/hour/minute and set
these values on a Hector ColumnFamilyUpdater instance and update that way.
Then later I can query from the command line with CQL such as:
** **
get MyTest where messageYear=2011 and messageMonth=6 and
messageDay=1 and messageHour=13 and messageMinute=44
is there such a thing? a query that runs against a SC family and
returns a subset of subcolumns from a set of super-columns?
is there a way to have eg a slice query (or super slice query) only
return the column names, rather than the value as well?
@cassandra.apache.org
Date: Thu, 27 Oct 2011 06:34:08 -0400
To: user@cassandra.apache.orgmailto:user@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: super sub slice query?
is there such a thing? a query that runs against a SC family and returns a
subset of subcolumns
Does not matter to much but are you looking to get all the columns for some
know keys (get_slice, multiget_slice) ? Or are you getting the columns for keys
within a range (get_range_slices)?
If you provide do a reversed query the server will skip to the end of the
column range. Here is some
/jira/browse/CASSANDRA-749. For example,
Jonathan writes:
quote
Is it worth creating a secondary index that only contains local data, versus
a distributed secondary index (a normal ColumnFamily?)
I think my initial reasoning was wrong here. I was anti-local-indexes
because we have to query
was wrong here. I was anti-local-indexes
because we have to query the full cluster for any index lookup, since
we are throwing away our usual partitioning scheme.
Which is true, but it ignores the fact that, in most cases, you will
have to query the full cluster to get the actual matching rows, b/c
on a question from February 2011. In
short, I wonder why one won't have to query all Cassandra nodes when
doing a secondary index lookup -- although each node only indexes data
that it holds locally.
The question and answer was:
( http://www.mail-archive.com/user@cassandra.apache.org/msg10506.html
Hi,
(This is the 2nd time I'm sending this message. I sent it the first
time a few days ago but it does not appear in the archives.)
I have a follow up question on a question from February 2011. In
short, I wonder why one won't have to query all Cassandra nodes when
doing a secondary index
Hi,
I have a standard CF that has column start and end. I need to query its
rows using condition start10 and end100. Is there any better way to do it?
Using native secondary index or creating a specific CF for the search. I do not
know which one is better. If the late is preferred to, how
if you
have duplicate values.
2011/8/29 Guofeng Zhang guof...@radvision.com:
Hi,
I have a standard CF that has column “start” and “end”. I need to query its
rows using condition “start10 and end100”. Is there any better way to do
it? Using native secondary index or creating a specific CF
-
From: Jonathan Ellis [mailto:jbel...@gmail.com]
Sent: Monday, August 15, 2011 7:37 PM
To: user@cassandra.apache.org
Subject: Re: CQL query using 'OR' in WHERE clause
Disjunctions are not yet supported and probably will not be until after 1.0.
On Mon, Aug 15, 2011 at 6:45 PM, Deeter, Derek
Hi,
We are using CQL to obtain data from Cassandra 0.8.1 using Hector and
getting an error when using 'OR' on a secondary index. I get the same
error when using CQL 1.0.3. All the items in the WHERE clause are
secondary indices and they are all UTF8Type validation. The query works
when leaving
. I get the same error
when using CQL 1.0.3. All the items in the WHERE clause are secondary
indices and they are all UTF8Type validation. The query works when leaving
out everything from ‘OR’ onwards. Example:
cqlsh SELECT '.id' , '.ipAddress' , '.userProduct' , '.offeringId' ,
'.appId
?
-Ursprüngliche Nachricht-
Von: Roland Gude [mailto:roland.g...@yoochoose.com]
Gesendet: Donnerstag, 28. Juli 2011 11:22
An: user@cassandra.apache.org
Betreff: AW: results of index slice query
Created https://issues.apache.org/jira/browse/CASSANDRA-2964
-Ursprüngliche Nachricht-
Von: Jonathan
Created https://issues.apache.org/jira/browse/CASSANDRA-2964
-Ursprüngliche Nachricht-
Von: Jonathan Ellis [mailto:jbel...@gmail.com]
Gesendet: Mittwoch, 27. Juli 2011 17:35
An: user@cassandra.apache.org
Betreff: Re: results of index slice query
Sounds like a Cassandra bug to me
Hi,
I was just experiencing that when i do an IndexSliceQuery with the index column
not in the slicerange the index column will be returned anyways. Is this
behavior intended or is it a bug (if so - is it a Cassandra bug or a hector
bug)?
I am using Cassandra 0.7.7 and hector 0.7-26
Greetings,
Sounds like a Cassandra bug to me.
On Wed, Jul 27, 2011 at 6:44 AM, Roland Gude roland.g...@yoochoose.com wrote:
Hi,
I was just experiencing that when i do an IndexSliceQuery with the index
column not in the slicerange the index column will be returned anyways. Is
this behavior intended or
, Jul 15, 2011 at 12:04 PM, Eric Evans eev...@rackspace.com wrote:
On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote:
I am trying to range-query a column family on which the keys are
epochs (similar to the output of System.currentTimeMillis() in Java).
In CQL (Cassandra 0.8.1 with JDBC
I haven't used CQL functionality much, but thirft client
I think what I encounter is exactly this problem!
If you want to query over key, you can index keys to other CF, get the
column names (that is key of other CF ). and then query actual CF with keys.
switch away from the random partitioner
by lexicographic rules?
Thanks
On Fri, Jul 15, 2011 at 12:04 PM, Eric Evans eev...@rackspace.com wrote:
On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote:
I am trying to range-query a column family on which the keys are
epochs (similar to the output of System.currentTimeMillis() in Java
On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote:
I am trying to range-query a column family on which the keys are
epochs (similar to the output of System.currentTimeMillis() in Java).
In CQL (Cassandra 0.8.1 with JDBC driver):
SELECT * FROM columnFamily WHERE KEY '130920500
:
I am trying to range-query a column family on which the keys are
epochs (similar to the output of System.currentTimeMillis() in Java).
In CQL (Cassandra 0.8.1 with JDBC driver):
SELECT * FROM columnFamily WHERE KEY '130920500';
I can't get to have a result that make sense, it always
range and
by-column clauses in a SELECT);
in
http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
This operation is exactly what I want - query by column then filter by
key. I want to know why this query is not supported, and what's the good
Currently these are two different types of query, using a key range is
equivalent to the get_range_slices() API function and column clauses is a
get_indexed_slices() call. So you would be asking for a potentially painful
join between.
Creating a column with the same value as the key sounds
of columns = 0). The same query works if we
switch the number of columns to 1. Is there a new mechanism for getting
key-only? We can’t use CQL yet since we’re using .NET for our development.
Cheers,
Steve
like key-only
queries are broken (number of columns = 0). The same query works if we switch
the number of columns to 1. Is there a new mechanism for getting key-only? We
can’t use CQL yet since we’re using .NET for our development.
Cheers,
Steve
Hi,
when I am issuing some query, that returns a HashMap, does the whole HashMap
have to be in memory? If so, it can easily use up all memory? Is there some
cursor or paging provisions?
Thank you very much.
Mark
On Thu, Jun 9, 2011 at 9:50 PM, Mark Kerzner markkerz...@gmail.com wrote:
Hi,
when I am issuing some query, that returns a HashMap, does the whole HashMap
have to be in memory?
Yes.
If so, it can easily use up all memory? Is there some
cursor or paging provisions?
Yes, that is what all
Thanks a bunch.
Mark
On Thu, Jun 9, 2011 at 10:26 PM, Jonathan Ellis jbel...@gmail.com wrote:
On Thu, Jun 9, 2011 at 9:50 PM, Mark Kerzner markkerz...@gmail.com
wrote:
Hi,
when I am issuing some query, that returns a HashMap, does the whole
HashMap
have to be in memory?
Yes.
If so
a slice means a range of columns.
a range query refers to a query to retrieve a range of rows whereas
a slice range queyr refers to a query to retrieve range of columns within a
row.
i may be talking about total nonsense but i really am more confused after
reading this portion of the book
http
understanding is
a range as in a mathematical range to define a subset from an ordered set
of elements,
in cassandra typically means a range of rows whereas
a slice means a range of columns.
a range query refers to a query to retrieve a range of rows whereas
a slice range queyr refers
,
in cassandra typically means a range of rows whereas
a slice means a range of columns.
a range query refers to a query to retrieve a range of rows whereas
a slice range queyr refers to a query to retrieve range of columns within a row.
i may be talking about total nonsense but i really am more
a
single query you will be returned all the rows where the returned row key's md5
is between the md5 of the start row key and stop row key.
Reference:
http://wiki.apache.org/cassandra/FAQ - Why aren't range slices/sequential
scans giving me the expected results?
Robert Jackson
what you would
expect.
With the RandomPartitioner you can iterate over the complete list by using the
last row key as the start for subsequent requests, but if you are using a
single query you will be returned all the rows where the returned row key's md5
is between the md5 of the start row
, it is my understanding that if you are not using
OrderPreservingPartitioner a get_range_slices may not return what you would
expect.
With the RandomPartitioner you can iterate over the complete list by using
the last row key as the start for subsequent requests, but if you are using
a single query
Hello,
I am unclear on Why deleting a row in Cassandra does not delete a row key?
Is an empty row never deleted from Column Family?
It would be of great help if someone can elaborate on this.
Thanks,
Anuya
Sorry, a typo in title corrected for same previous post
Hello,
I am unclear on Why deleting a row in Cassandra does not delete a row key?
Is an empty row never deleted from Column Family?
It would be of great help if someone can elaborate on this.
Thanks,
Anuya
http://wiki.apache.org/cassandra/FAQ#range_ghosts
On Mon, May 9, 2011 at 9:24 PM, anuya joshi anu...@gmail.com wrote:
Hello,
I am unclear on Why deleting a row in Cassandra does not delete a row key?
Is an empty row never deleted from Column Family?
It would be of great help if someone can
Can we do count like this?
/count cf[startKey:endKey] where column = value/
--
Donal Zang
Computing Center, IHEP
19B YuquanLu, Shijingshan District,Beijing, 100049
zan...@ihep.ac.cn
86 010 8823 6018
No.
You could build a custom secondary index where column=value is the key and
startKey and endKey are column names. Then call get_count() with a
SlicePredicate that specifies the startKey and endKey as the start and finish
column names.
Aaron
On 5 Apr 2011, at 01:45, Donal Zang wrote:
Hi!
I would like to query all the rows having a specific column defined, with
Hector
For example:
- CF is a column family
- rows 1 and 3 contain columns A and B
- rows 2 and 4 contain column A only
as a result of a query column A I would like to get rows 1-4, with column
A inside
as a result
control the
ordering of colums. If possible i would suggest using the random
partitioner.
Could you provide examples of how you are doing the queries using
pycassa we may be able to help.
My initial guess is that the ranges you specify for the query are not
correct when using ASCII
I checked out #2212 and was able to reproduce the problem.
Thanks for investigating this and putting together a good script to
reproduce!
- Tyler
For example,
Order[ 100 ][ 20031210022059/190209-20031210-4476885-s/ ]
is a super column.
Because we want to scan them in the latest-first order, range slice
query with reversed order is used. (Partitioner is
ByteOrderedPartitioner).
In some supercolumns in my cassandra instance, reversed query
.
Could you provide examples of how you are doing the queries using pycassa
we may be able to help.
My initial guess is that the ranges you specify for the query are not
correct when using ASCII ordering for column names, e,g,
20031210 20031210022059/190209-20031210-4476885-s/z is true
Is there any way to specify on per query basis(like we specify the
Consistency level), what rows be cached while you're reading them,
from a row_cache enabled CF. I believe, this could lead to much more
efficient use of the cache space!!( if you use same data for different
features/ parts in your
Currently there is not.
On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew ertio...@gmail.com wrote:
Is there any way to specify on per query basis(like we specify the
Consistency level), what rows be cached while you're reading them,
from a row_cache enabled CF. I believe, this could lead to much
Is this under consideration for future releases ? or being thought about!?
On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis jbel...@gmail.com wrote:
Currently there is not.
On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew ertio...@gmail.com wrote:
Is there any way to specify on per query basis
, 2011 at 12:56 AM, Jonathan Ellis jbel...@gmail.com wrote:
Currently there is not.
On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew ertio...@gmail.com wrote:
Is there any way to specify on per query basis(like we specify the
Consistency level), what rows be cached while you're reading them,
from
...@gmail.com wrote:
Is there any way to specify on per query basis(like we specify the
Consistency level), what rows be cached while you're reading them,
from a row_cache enabled CF. I believe, this could lead to much more
efficient use of the cache space!!( if you use same data for different
consideration for future releases ? or being thought
about!?
On Thu, Feb 10, 2011 at 12:56 AM, Jonathan Ellis jbel...@gmail.com
wrote:
Currently there is not.
On Wed, Feb 9, 2011 at 12:04 PM, Ertio Lew ertio...@gmail.com wrote:
Is there any way to specify on per query basis(like we specify
On Wed, Jan 5, 2011 at 3:37 AM, Narendra Sharma
narendra.sha...@gmail.com wrote:
What I am looking for is:
1. Some way to send requests for keys whose token fall between 0-25 to B and
never to C even though C will have the data due to it being replica of B.
2. Only when B is down or not
1. Some way to send requests for keys whose token fall between 0-25 to B and
never to C even though C will have the data due to it being replica of B.
If your data set is large, be mindful of the fact that this will cause
C to be completely cold in terms of caches. I.e., when B does go down,
C
Hi list,
I am recently working with Casandra. Through my little affort I got this java
ClientOnlyExample.java file. (This file come along with Cassandra code check
out). I am using this Client because this do not make socket call with
Cassandra .
As per comment written in the file, this file
at 8:35 AM, Roshan Dawrani roshandawr...@gmail.comwrote:
I had seen RangeSlicesQuery, but I didn't notice that I could also give a
key range there.
How does a KeyRange work? Doesn't it need some sort from the partitioner -
whether that is order preserving or not?
I couldn't be sure of a query
Hi all,
I really like the second index feature that has been added to 0.7 release.
My question is, Is it possible to query using wildcards in cassandra 0.7?
Thanks for the insights.
Kind regards,
Joshua.
--
http://twitter.com/jpartogi http://twitter.com/scrum8
Hi,
Using EmbeddedCassandra Serivce inside Junit Tests(BEFORECLASS) and tests are
running fine and no issues. Code to start the cassandra is something like the
following:
BUT the issue is when i try to get the data using cassandra-cli, i am not
getting any results. the data cleanup happens
. And one thing that we can do with BigTable is
query data using GQL. I tried looking for information about query language
that is built on top of cassandra and ends with no luck. The only way we can
query over data is either using Range query or Hadoop Map-Reduce. CMIIW. Now
with range query
Hi,
I am still new with cassandra and from what I know so far cassandra is based
on Google BigTables model. And one thing that we can do with BigTable is
query data using GQL. I tried looking for information about query language
that is built on top of cassandra and ends with no luck. The only
the request to another machine, which threw the logged exception and
thus did not reply.
You're doing an illegal query; token-based queries have to be on
non-wrapping ranges (left token right token), or a wrapping range of
(mintoken, mintoken). This was changed as part of the range scan
fixes
Hi
Problem:
Call - client.get_range_slices(). Using tokens (not keys), fails with
TimedoutException which I think is misleading (Read on)
Server : Works with 6.5 server, but not with 6.6 or 6.8
Client: have tried both 6.5 and 6.6
I am getting a TimedoutException when I do a
TimedOutException means the host that your client is talking to sent
the request to another machine, which threw the logged exception and
thus did not reply.
You're doing an illegal query; token-based queries have to be on
non-wrapping ranges (left token right token), or a wrapping range
should I
be doing instead?
On Mon, Nov 15, 2010 at 5:34 PM, Jonathan Ellis jbel...@gmail.com wrote:
TimedOutException means the host that your client is talking to sent
the request to another machine, which threw the logged exception and
thus did not reply.
You're doing an illegal query
-Cheng Chen
cc...@evidentsoftware.com wrote:
Not sure if this the intended behavior of the indexed query.
I created a column family and added index on column A,B,C.
Now I insert three rows.
row1 : A=123, B=456, C=789
row2 : A=123, C=789
row3 : A=123, B=789, C=789
Now if I perform
Not sure if this the intended behavior of the indexed query.
I created a column family and added index on column A,B,C.
Now I insert three rows.
row1 : A=123, B=456, C=789
row2 : A=123, C=789
row3 : A=123, B=789, C=789
Now if I perform an indexed query for A=123 and B=456, both row1 and row2
It's working as written, but I think you're right that it makes more
sense to fail the expression when the column doesn't exist.
On Thu, Nov 11, 2010 at 7:04 AM, Ching-Cheng Chen
cc...@evidentsoftware.com wrote:
Not sure if this the intended behavior of the indexed query.
I created a column
Has any one used sstable2json on 0.6.5 and noticed the issue I described in
my email below? This doesn't look like data corruption issue as sstablekeys
shows the keys.
Thanks,
Naren
On Tue, Oct 5, 2010 at 8:09 PM, Narendra Sharma
narendra.sha...@gmail.comwrote:
0.6.5
-Naren
On Tue, Oct
can you tar.gz the filter/index/data files for this sstable and attach
it to a ticket so we can debug?
if you can't make the data public you can send it to me off list and I
can have a look.
On Wed, Oct 6, 2010 at 11:37 AM, Narendra Sharma
narendra.sha...@gmail.com wrote:
Has any one used
Hi,
I am using sstable2json to extract row data for debugging some application
issue. I first ran sstablekeys to find the list of keys in the sstable. Then
I use the key to fetch row from sstable. The sstable is from Lucandra
deployment. I get following.
-bash-3.2$ ./sstablekeys
0.6.5
-Naren
On Tue, Oct 5, 2010 at 6:56 PM, Jonathan Ellis jbel...@gmail.com wrote:
Version?
On Tue, Oct 5, 2010 at 7:28 PM, Narendra Sharma
narendra.sha...@gmail.com wrote:
Hi,
I am using sstable2json to extract row data for debugging some
application
issue. I first ran
, if Name_Address(name, address) is just an index, we can redirect
the query to ID_Address(Id, address) , Name_ID(name, id) without the cost of
maintenance.
Does it make sense?
Alvin
2010/9/16 Rock, Paul paul.r...@teamaol.com
Alvin - assuming I understand what you're after correctly, why
two CFs.
First, we see this index as a CF/SCF. The difference is I don't materialise it.
Assume we have two tables:
ID_Address(Id, address) , Name_ID(name, id)
Then,the index is: Name_Address(name, address)
When the application tries to query on Name_Address, the value of name is
given
Hello,
I am going to build an index to join two CFs.
First, we see this index as a CF/SCF. The difference is I don't materialise
it.
Assume we have two tables:
ID_Address(*Id*, address) , Name_ID(*name*, id)
Then,the index is: Name_Address(*name*, address)
When the application tries to query
...@gmail.com wrote:
Hi All,
I have a query related to deleting a column inside a super column
The following is my cassandra schema
[cache_pages_key_hash] = Array
(
[hash_1] = Array
(
[1] = 4c330e95195f9
,
I have a query related to deleting a column inside a super column
The following is my cassandra schema
[cache_pages_key_hash] = Array
(
[hash_1] = Array
(
[1] = 4c330e95195f9
[2] = 4c330e951f18b
: Query on delete a column inside a super column
Hi,
Thanks for the reply,
The remove method
$cassandraInstance-remove('cache_pages_key_hash', 'hash_1' )
which will remove the whole key, But I don't want to do that, I need to remove
one column inside that key
Can you please tell me how to use
Hi All,
I have a query related to deleting a column inside a super column
The following is my cassandra schema
[cache_pages_key_hash] = Array
(
[hash_1] = Array
(
[1] = 4c330e95195f9
[2] = 4c330e951f18b
Hi Mike
AFAIK cassandra queries only on keys and not on column names, please verify.
On Tue, May 11, 2010 at 11:06 AM, Mike Malone m...@simplegeo.com wrote:
On Mon, May 10, 2010 at 9:00 PM, Shuge Lee shuge@gmail.com wrote:
Hi all:
How to write WHERE ... LIKE query ?
For examples
, Shuge Lee shuge@gmail.com wrote:
Hi all:
How to write WHERE ... LIKE query ?
For examples(described in Python):
Schema:
# columnfamily name
resources = [
# key
'foo': {
# columns and value
'url': 'foo.com',
'pushlier': 'foo
where the key equals
mmalone).
See the get_range_slices() method in the thrift service.
Mike
On Tue, May 11, 2010 at 11:06 AM, Mike Malone m...@simplegeo.com
wrote:
On Mon, May 10, 2010 at 9:00 PM, Shuge Lee shuge@gmail.com
wrote:
Hi all:
How to write WHERE ... LIKE query
Hi all:
How to write WHERE ... LIKE query ?
For examples(described in Python):
Schema:
# columnfamily name
resources = [
# key
'foo': {
# columns and value
'url': 'foo.com',
'pushlier': 'foo',
},
'oof': {
'url': 'oof.com',
'pushlier': 'off
filters ( like show me
only likes from a given user). This would include range query to support
pagination. So this would mean indices on a few columns like the feed id,
feed type etc.
2. We have around 3 machines with 4GB RAM for this purpose and thinking
of having replication factor
1001 - 1100 of 1112 matches
Mail list logo