Hi Chuck,
On Thu, May 7, 2020 at 10:14 AM Check Peck wrote:
> I have a scylla table as shown below:
>
(Please note that this is the Apache Cassandra users mailing list. Of
course, the feature is the same, so let me answer it here.)
>
> cqlsh:sampleks> describe table test;
>
>
> CREATE
In your schema case, for each client_id you will get a single 'when'
row. Just one. Even when there are multiple rows (clustering keys)
On Thu, May 7, 2020 at 12:14 AM Check Peck wrote:
>
> I have a scylla table as shown below:
>
>
> cqlsh:sampleks> describe table test;
>
>
> CREATE TABLE
I have a scylla table as shown below:
cqlsh:sampleks> describe table test;
CREATE TABLE test (
client_id int,
when timestamp,
process_ids list,
md text,
PRIMARY KEY (client_id, when) ) WITH CLUSTERING ORDER BY (when DESC)
AND bloom_f
I have two queries. One that gives me the first page from a cassandra table,
and another one that retrieves the successive pages. The fist one is like :
select * from images_by_user where token(iduser) = token(5) limit 10 allow
filtering;
The successive ones are :
select * from images_
If it is of the same cause, does that mean I should switch to
SizeTieredCompactionStrategy?
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-query-throws-TombstoneOverwhelmingException-against-a-LeveledCompactionStrategy-table-tp7597077p759709
amount of records have
30 day TTL.
Now a simple CQL query like “select * from event_index limit 1” won’t run
and Cassandra log says
ERROR [ReadStage:68] 2014-10-01 15:40:14,751 SliceQueryFilter.java (line
200) Scanned over 10 tombstones in event_index; query aborted (see
Use senttime as part of primary key
CREATE TABLE services.messagepayload_by_date (
record_date timestamp
partition_id uuid,
messageid bigint,
senttime timestamp,
PRIMARY KEY (record_date, senttime )
)
Partition id itself should be chronological say a date. Then you put
partition id in yo
ALLOW FILTERING;
>
> com.datastax.driver.core.exceptions.InvalidQueryException: No indexed
> columns present in by-columns clause with Equal operator
>
> Could someone can explain what's going on? I have create a index to the
> search column, but seems not working.
>
> Th
xed
> columns present in by-columns clause with Equal operator
>
> Could someone can explain what's going on? I have create a index to the
> search column, but seems not working.
>
> Thanks.
>
>
>
> --
> View this message in context:
> http://cassandra-user-i
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-query-regarding-indexes-tp7595122.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
thanks for ur reply.
On Fri, May 3, 2013 at 11:45 PM, Jabbar Azam wrote:
> Sorry Sri, I've never used hector. How ever it's straightforward in
> astyanax. There are examples on the github page.
> On 3 May 2013 18:50, "Sri Ramya" wrote:
>
>> Can you tell me how to do this in hector. Can you gi
Sorry Sri, I've never used hector. How ever it's straightforward in
astyanax. There are examples on the github page.
On 3 May 2013 18:50, "Sri Ramya" wrote:
> Can you tell me how to do this in hector. Can you give me some example.
>
> On Fri, May 3, 2013 at 10:29 AM, Sri Ramya wrote:
>
>> than
Can you tell me how to do this in hector. Can you give me some example.
On Fri, May 3, 2013 at 10:29 AM, Sri Ramya wrote:
> thank you very much. i will try and let you know whether its working or not
>
>
>
> On Thu, May 2, 2013 at 7:04 PM, Jabbar Azam wrote:
>
>> Hello Sri,
>>
>> As far as I kn
thank you very much. i will try and let you know whether its working or not
On Thu, May 2, 2013 at 7:04 PM, Jabbar Azam wrote:
> Hello Sri,
>
> As far as I know you can if name and age are part of your partition key
> and timestamp is the cluster key e.g.
>
> create table columnfamily (
> n
Hello Sri,
As far as I know you can if name and age are part of your partition key and
timestamp is the cluster key e.g.
create table columnfamily (
name varchar,
age varchar,
tstamp timestamp,
partition key((name, age), tstamp)
);
Thanks
Jabbar Azam
On 2 May 2013 11:45, Sri
hi
Can some body tell me is it possible to to do multiple query on cassandra
like "Select * from columnfamily where name='foo' and age ='21' and
timestamp >= 'unixtimestamp' ";
Please tell me some guidence for these kind of queries
Thank you
>>>>> client.system_add_column_family(user_Def);
>>>>>
>>>>>
>>>>> Thanks
>>>>> KK
>>>>>
>>>>>
>>>>> On Fri, Mar 15, 2013 at 4:24 PM, Sylvain Lebresne <
>>>>> sylv...@dat
PM, Sylvain Lebresne >>> > wrote:
>>>>
>>>>> On Fri, Mar 15, 2013 at 11:43 AM, Kuldeep Mishra <
>>>>> kuld.cs.mis...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>> Is it possi
gt;>>>
>>>>> Hi,
>>>>> Is it possible in Cassandra to make multiple column with same name ?,
>>>>> like in this particular scenario I have two column with same name as
>>>>> "key",
>&
>>>> Is it possible in Cassandra to make multiple column with same name ?,
>>>> like in this particular scenario I have two column with same name as "key",
>>>> first one is rowkey and second on is column name .
>>>>
>>>>
>&
>
>>> Hi,
>>> Is it possible in Cassandra to make multiple column with same name ?,
>>> like in this particular scenario I have two column with same name as "key",
>>> first one is rowkey and second on is column name .
>>>
>>>
>&
like in this particular scenario I have two column with same name as "key",
>> first one is rowkey and second on is column name .
>>
>>
> No, it shouldn't be possible and that is your problem. How did you created
> that table?
>
> --
> Sylvain
&
No, it shouldn't be possible and that is your problem. How did you created
that table?
--
Sylvain
>
> Thanks and Regards
> Kuldeep
>
>
> On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra
> wrote:
>
>>
>> Hi ,
>> Following cql query not returnin
t; first one is rowkey and second on is column name .
>
>
> Thanks and Regards
> Kuldeep
>
>
> On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra
> wrote:
>
>>
>> Hi ,
>> Following cql query not returning any result
>> cqlsh:KunderaExam
e:
>
> Hi ,
> Following cql query not returning any result
> cqlsh:KunderaExamples> select * from "DOCTOR" where key='kuldeep';
>
>I have enabled secondary indexes on both column.
>
> Screen shot is attached
>
> Please help
>
This is not an issue of Cassandra. In particular
http://cassandra.apache.org/doc/cql3/CQL.html#selectStmt is up to date.
It is an issue of the datastax documentation however. I'll see with them
that this gets resolved.
On Tue, Mar 5, 2013 at 3:26 PM, Vivek Mishra wrote:
> Somebody in group, ple
Somebody in group, please confirm if it is an issue or that needs rectified
for select syntax.
-Vivek
On Tue, Mar 5, 2013 at 5:31 PM, Vivek Mishra wrote:
> Thank you i am able to solve this one.
> If i am trying as :
>
> SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' LIMIT 100 ALLOW
> F
Thank you i am able to solve this one.
If i am trying as :
SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' LIMIT 100 ALLOW
FILTERING
it works. Somehow got confused by
http://www.datastax.com/docs/1.2/cql_cli/cql/SELECT, which states as :
SELECT select_expression
FROM *keyspace_name.*tab
The reason for the error was that I opened the connection to the database wrong.
I did:
con = cql.connect(host, port, keyspace)
but correct is:
con = cql.connect(host, port, keyspace, cql_version='3.0.0')
Now it works fine. Thanks for reading.
2013/1/24 aaron morton :
> How did you create the t
How did you create the table?
Anyways that looks like a bug, I *think* they should go here
http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/issues/list
Cheers
-
Aaron Morton
Freelance Cassandra Developer
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 24
I try to access my local cassandra database via python. Therefore I
installed db-api 2.0 and thrift for accessing the database. Opening
and closing a connection works fine. But a simply query is not
working:
The script looks like this:
c = conn.cursor()
c.execute("""select * from users;""
FROM TestCF WHERE status IN ('Failed', 'Success')
> 2) The "OR" operator 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 do
#x27; 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 "L
status='Failed' AND status='Success'
4) Is there any thing similar to "LIKE" in CQL? I want to search data based
on some part of string.
Could someone please help me to solve the above issues? Thanks.
--
View this message in context:
http://cassandra-user-incubator-
-
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, De
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
wrote:
> 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
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
37 matches
Mail list logo
