Previous Next JavaScript must be enabled to correctly display this content

## CREATE FULL TEXT INDEX

To create a text index on that table that indexes the category and txt columns, use `CREATE FULLTEXT INDEX` statement:

    CREATE FULLTEXT INDEX [if not exists] <index-name> ON <table-name>
    (<field-name> [ <mapping-spec> ], ...)
    [ES_SHARDS = <n>] [ES_REPLICAS = <n>]

For example:

    kv-> execute 'CREATE FULLTEXT INDEX JokeIndex
    ON Joke (category, txt)'
    Statement completed successfully

While creating index, `CREATE FULLTEXT INDEX` statement uses the `OVERRIDE` flag, which allows to delete any index existing in Elasticsearch by the same name as would be created by the command.

    CREATE FULLTEXT INDEX [IF NOT EXISTS] index_name ON table_name
       (field_name [{mapping_spec}] [, field_name [{mapping_spec}]]...)
       [ES_SHARDS = value] [ES_REPLICAS = value]
       [OVERRIDE] [COMMENT comment]

For example:

    CREATE INDEX JokeIndex on  Joke (category, txt) OVERRIDE

For more information, see Creating Full Text Index and Mapping a Full Text Index Field to an Elasticsearch Field in the Integrations Guide.