CREATE INDEX

Syntax

CREATE INDEX index_name '(' column_name ')' ON [MAPPING] mapping_name [includeColumns] [IF bool_expr]

includeColumns:
    INCLUDE '(' column_name [, ...] ')'

Description

Creates named index on column_name in table referenced my mapping_name.

  • Additional columns can be included in the index table (for use in server-side filter on index table) using the includeColumns clause.

Example

        HConnection conn = HConnectionManager.newConnection();
        conn.execute("CREATE INDEX fooidx ON fooMapping (family1:col1) INCLUDE (family1:col2, family1:col3)");