Skip to content

Secondary Index Mapping in Cassandra

chhavigangwal edited this page Nov 6, 2013 · 5 revisions
@Entity
@Table
@IndexCollection(columns = { @Index(name = "likedBy"), @Index(name = "income"), @Index(name = "settlementDate"),
        @Index(name = "dateSet"), @Index(name = "and"), @Index(name = "between"), @Index(name = "or") })
public class Property
{
    @Id
    private String id;

    @Column
    private String likedBy;

    @Column
    private String income;

    @Column
    private String settlementDate;

    @Column
    private String dateSet;

    @Column
    private String and;

    @Column
    private String between;

    @Column
    private String or;

    @Column
    private String set;
CREATE TABLE tests (
  key text PRIMARY KEY,
  "and" text,
  between text,
  "dateSet" text,
  income text,
  "likedBy" text,
  or text,
  "set" text,
  "settlementDate" text
);

CREATE INDEX Property_and_idx ON tests ("and");
CREATE INDEX Property_between_idx ON tests (between);
CREATE INDEX Property_dateSet_idx ON tests ("dateSet");
CREATE INDEX Property_income_idx ON tests (income);
CREATE INDEX Property_likedBy_idx ON tests ("likedBy");
CREATE INDEX Property_or_idx ON tests (or);
CREATE INDEX Property_settlementDate_idx ON tests ("settlementDate");

Clone this wiki locally