#x27;s storage system can only optimize certain queries.
>
> On Sun, Feb 3, 2013 at 2:07 PM, Paul van Hoven
> wrote:
>> I'm not sure if I understood your answer.
>>
>>> When you have GB or TB of data any query that adds "WITH FILTERING"
>>> wil
language CQL lets you do some queries
> that "seem fast" when your developing with 10 rows, without this
> clause you would not know if a query is fast because it hits a
> cassandra index, or it is just fast because the results were found in
> the first 10 rows.
>
> Edwa
BE SLOW". It could
> mean the query is not hitting and index and is going to page through
> large amounts of data.
>
> On Sun, Feb 3, 2013 at 9:42 AM, Paul van Hoven
> wrote:
>> After figuring out how to use the ">" operator on an secondary index I
>>
After figuring out how to use the ">" operator on an secondary index I
noticed that in a column family of about 5.5 million datasets I get a
rpc_timeout when trying to read data from this table. In the concrete
situation I want to request data younger than January 1 2013. The
number of rows that sh
ludes an Equal
Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh.
So, this still fails. Therefore I'm not shure whether I missunderstand
the issue or if it does not solve my problem.
2013/2/3 Manu Zhang :
> On Sun 03 Feb 2013 07:36:58 AM CST, Paul van Hoven wrote:
I've got a table that has a column called date. I created an index on
the column date with the following command:
CREATE INDEX date_key ON ola (date);
Now, I can perform the following command:
select * from ola where date = '2013-01-01' limit 10;
The results are correctly displayed.
But the th
Is there some way in cql to get a list of all tables or column
families that belong to a keystore like "show tables" in sql?
onmorton
> http://www.thelastpickle.com
>
> On 24/01/2013, at 7:14 AM, Paul van Hoven
> wrote:
>
> 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
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;""
TH replication = {'class':'' [,'':]};
>
>
>
> On Tue, Jan 22, 2013 at 8:06 PM, Paul van Hoven
> wrote:
>>
>> Okay, that worked. Why is the statement from the tutorial wrong. I
>> mean, why would a company like datastax post somthing like this?
&g
3};
> cqlsh> use demodb;
> cqlsh:demodb>
>
>
> On Tue, Jan 22, 2013 at 7:04 PM, Paul van Hoven
> wrote:
>>
>> CREATE KEYSPACE demodb WITH strategy_class = 'SimpleStrategy'
>> AND strategy_options:replication_factor='1';
>
>
>
I just started with cassandra. Currently I'm reading the following
tutorial about cal:
http://www.datastax.com/docs/1.1/dml/using_cql#use-cql
But I already fail when trying to create a keyspace:
$ ./cqlsh --cql3
Connected to Test Cluster at localhost:9160.
[cqlsh 2.3.0 | Cassandra 1.2.0 | CQL sp
12 matches
Mail list logo
