>> {column_name: birth_year, validation_class: LongType, index_type: KEYS},
>> {column_name: state, validation_class: UTF8Type, index_type: KEYS}];
>>
>> And I am using CQL driver-1.1.1 with Cassandra server-1.1.1. Once I try
>> to execute the following query, it
.1. Once I try to
> execute the following query, it gives an exception saying 'No indexed
> columns present in by-columns clause with "equals" operator'.
>
> CQL :
> select * from users where birth_year<1965
>
> Caus
ndexed
columns present in by-columns clause with "equals" operator'.
CQL :
select * from users where birth_year<1965
Caused by: java.sql.SQLSyntaxErrorException: No indexed columns present in
by-columns clause with "equals" operator
at
org.apache.ca
Hey Aaron,
I am able to sort out the problem. Thanks anyways.
Regards,
Abhijit
Like the exception says:
> Bad Request: No indexed columns present in by-columns clause with "equals"
> operator
> Same with other relational operators(<,>=,<=)
You must include an equality operator in the where clause:
That is why
> SELECT * FROM STEST WHERE VAL
tion
Bad Request: No indexed columns present in by-columns clause with "equals"
operator
Same with other relational operators(<,>=,<=)
these are the datas available in my columnfamily
ROW_KEY | VALUE1 | VALUE2
+--+
3 | 100 |
Check there is a single schema version on the cluster, in the cassandra-cli use
describe cluster;
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 26/04/2012, at 3:33 AM, mdione@orange.com wrote:
> De : mdione@orange.com [mailto:md
De : mdione@orange.com [mailto:mdione@orange.com]
> Should I understand that when the indexes are finished being built a)
> the «Built indexes» list should be empty and b) there should be no pending
> compactions? Because that's exactly what I have now but I still can't
> use the column H
De : aaron morton [mailto:aa...@thelastpickle.com]
> The secondary index will be build using the compaction features,
> you can check the progress with nodetool compactionstats
>
> When they are build the output from describe. will list the build indexes.
>
> Built indexes: []
Should I unders
The secondary index will be build using the compaction features, you can check
the progress with nodetool compactionstats
When they are build the output from describe… will list the build indexes…
> Built indexes: []
Hope that helps.
-
Aaron Morton
Freelance Developer
@aaronmor
I read a while ago that a "compaction" would rebuild the index. You can
trigger this by running "repair" with the nodetool.
2012/4/24
> De : mdione@orange.com [mailto:mdione@orange.com]
> > [default@avatars] describe HBX_FILE;
> > ColumnFamily: HBX_FILE
> > Key Validation Class
De : mdione@orange.com [mailto:mdione@orange.com]
> [default@avatars] describe HBX_FILE;
> ColumnFamily: HBX_FILE
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator:
> org.apache.cassandra.db.marshal.BytesType
> Columns s
De : mdione@orange.com [mailto:mdione@orange.com]
> De : Dave Brosius [mailto:dbros...@mebigfatguy.com]
> > Works for me on trunk... what version are you using?
>
> Beh, I forgot that detail: 1.0.9.
I also forgot to mention: the index was recently created, after the database
was popu
De : Dave Brosius [mailto:dbros...@mebigfatguy.com]
> Works for me on trunk... what version are you using?
Beh, I forgot that detail: 1.0.9.
--
Marcos Dione
SysAdmin
Astek Sud-Est
pour FT/TGPF/OPF/PORTAIL/DOP/HEBEX @ Marco Polo
04 97 12 62 45 - mdione@orange.com
___
S='actif';
Bad Request: No indexed columns present in by-columns clause with "equals"
operator
A query that works:
cqlsh:avatars> SELECT HBX_FIL_STATUS FROM HBX_FILE WHERE KEY=1;
HBX_FIL_STATUS
Actif
Just in case, here's cli's o
ite=True;
CREATE INDEX HBX_FILE_HBX_FIL_STATUS_idx ON HBX_FILE (HBX_FIL_STATUS);
The query and the error:
cqlsh:avatars> SELECT HBX_FIL_SMALL FROM HBX_FILE WHERE KEY=1 AND
HBX_FIL_STATUS='actif';
Bad Request: No indexed columns present in by-columns clause with "equals"
operator
A query tha
16 matches
Mail list logo
