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;
>
>
>
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
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
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
%.
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-tp7597077p7597091.html
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
://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.
a index to the
search column, but seems not working.
Thanks.
--
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
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-incubator-apache-org.3065146.n2.nabble.com/CQL-query-regarding-indexes-tp7595122.html
Sent
thanks for ur reply.
On Fri, May 3, 2013 at 11:45 PM, Jabbar Azam aja...@gmail.com 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 ramya.1...@gmail.com wrote:
Can you tell me how to
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
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,
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 aja...@gmail.com 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
Kuldeep
On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra
kuld.cs.mis...@gmail.com wrote:
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
,
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
--
Thanks and Regards
Kuldeep Kumar Mishra
+919540965199
--
Thanks
on is column name .
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
kuld.cs.mis...@gmail.com wrote:
Hi ,
Following cql query not returning any result
...@gmail.comwrote:
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
--
Thanks and Regards
Kuldeep Kumar Mishra
+919540965199
,
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
kuld.cs.mis...@gmail.comwrote:
Hi ,
Following cql query not returning any result
cqlsh:KunderaExamples select * from DOCTOR where key='kuldeep';
I
.
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
kuld.cs.mis...@gmail.comwrote:
Hi ,
Following cql query not returning any result
cqlsh:KunderaExamples select
name .
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 kuld.cs.mis...@gmail.com
wrote:
Hi ,
Following cql query not returning any result
problem. How did you
created that table?
--
Sylvain
Thanks and Regards
Kuldeep
On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra
kuld.cs.mis...@gmail.com wrote:
Hi ,
Following cql query not returning any result
cqlsh:KunderaExamples select * from DOCTOR where key='kuldeep
,
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
--
Thanks and Regards
Kuldeep Kumar Mishra
+919540965199
--
Thanks and Regards
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
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 mishra.v...@gmail.com wrote:
Thank you i am able to solve this one.
If i am trying as :
SELECT * FROM CompositeUser WHERE userId='mevivs' LIMIT
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 mishra.v...@gmail.com wrote:
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
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 aa...@thelastpickle.com:
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;)
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-apache-org.3065146.n2.nabble.com/CQL-query-issue-when-fetching-data-from-Cassandra-tp7290072p7290072.html
Sent from
please help me to solve the above issues? Thanks.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-query-issue-when-fetching-data-from-Cassandra-tp7290072p7290072.html
Sent from the cassandra-u...@incubator.apache.org mailing list
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-apache-org.3065146.n2.nabble.com/CQL-query-issue-when-fetching-data-from-Cassandra-tp7290072p7290072.html
Sent from
-
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
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
derek.dee...@digitalinsight.com 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.
35 matches
Mail list logo