cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <mdione....@orange.com>
Subject Bad Request: No indexed columns present in by-columns clause with "equals" operator
Date Mon, 23 Apr 2012 12:39:25 GMT

 I understand the error message, but I don't understand why I get it. 
Here's the CF:

cqlsh:avatars> describe columnfamily HBX_FILE;

CREATE COLUMNFAMILY HBX_FILE (
  KEY blob PRIMARY KEY,
  HBX_FIL_DATE text,
  HBX_FIL_LARGE ascii,
  HBX_FIL_MEDIUM ascii,
  HBX_FIL_SMALL ascii,
  HBX_FIL_STATUS text,
  HBX_FIL_TINY ascii
) WITH
  comment='' AND
  comparator=text AND
  read_repair_chance=1.000000 AND
  gc_grace_seconds=864000 AND
  default_validation=blob AND
  min_compaction_threshold=4 AND
  max_compaction_threshold=32 AND
  replicate_on_write=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 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 output for the same CF:

[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 sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period in seconds / keys to save : 0.0/0/all
      Row Cache Provider: org.apache.cassandra.cache.ConcurrentLinkedHashCacheProvider
      Key cache size / save period in seconds: 200000.0/14400
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: true
      Bloom Filter FP chance: default
      Built indexes: []
      Column Metadata:
        Column Name: HBX_FIL_DATE
          Validation Class: org.apache.cassandra.db.marshal.UTF8Type
        Column Name: HBX_FIL_LARGE
          Validation Class: org.apache.cassandra.db.marshal.AsciiType
        Column Name: HBX_FIL_MEDIUM
          Validation Class: org.apache.cassandra.db.marshal.AsciiType
        Column Name: HBX_FIL_SMALL
          Validation Class: org.apache.cassandra.db.marshal.AsciiType
        Column Name: HBX_FIL_STATUS
          Validation Class: org.apache.cassandra.db.marshal.UTF8Type
          Index Name: HBX_FILE_HBX_FIL_STATUS_idx
          Index Type: KEYS
        Column Name: HBX_FIL_TINY
          Validation Class: org.apache.cassandra.db.marshal.AsciiType
      Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy

  And the same error, with other words, in the CLI:

[default@avatars] get HBX_FILE where HBX_FIL_STATUS = 'actif';
No indexed columns present in index clause with operator EQ

  Am I missing something? Might as well be that I'm too tired...

--
Marcos Dione
SysAdmin
Astek Sud-Est
pour FT/TGPF/OPF/PORTAIL/DOP/HEBEX @ Marco Polo
04 97 12 62 45 - mdione.ext@orange.com



_________________________________________________________________________________________________________________________

Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees
et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par
erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant
susceptibles d'alteration,
France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou
falsifie. Merci.

This message and its attachments may contain confidential or privileged information that may
be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete this message
and its attachments.
As emails may be altered, France Telecom - Orange is not liable for messages that have been
modified, changed or falsified.
Thank you.


Mime
View raw message