Search index schema

Reference information about the schema that defines the relationship between data in a table and a search index.

Search index schema reference information to use for creating and altering a search index schema:
  • DataStax recommends CQL CREATE SEARCH INDEX and ALTER SEARCH INDEX SCHEMA commands.
  • dsetool commands can also be used to manage search indexes.

The schema defines the relationship between data in a table and a search index. See and for details and examples.

A sample search index schema XML:

Sample XML

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<schema name="autoSolrSchema" version="1.5">
  <types>
    <fieldType class="org.apache.solr.schema.TextField" name="TextField">
      <analyzer>
        <tokenizer class="solr.StandardTokenizerFactory"/>
        <filter class="solr.LowerCaseFilterFactory"/>
      </analyzer>
    </fieldType>
    <fieldType class="org.apache.solr.schema.TrieIntField" name="TrieIntField"/>
  </types>
  <fields>
    <field indexed="true" multiValued="false" name="grade_completed" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_thyroid_disease" type="TextField"/>
    <field indexed="true" multiValued="false" name="pets" type="TextField"/>
    <field indexed="true" multiValued="false" name="secondary_smoke" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_lupus" type="TextField"/>
    <field indexed="true" multiValued="false" name="gender" type="TextField"/>
    <field indexed="true" multiValued="false" name="birthplace" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="income_group" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="marital_status" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="age_months" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="bird" type="TextField"/>
    <field indexed="true" multiValued="false" name="hay_fever" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_hay_fever" type="TextField"/>
    <field indexed="true" multiValued="false" name="routine_medical_coverage" type="TextField"/>
    <field indexed="true" multiValued="false" name="annual_income_20000" type="TextField"/>
    <field indexed="true" multiValued="false" name="exam_status" type="TextField"/>
    <field indexed="true" multiValued="false" name="other_pet" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_stroke" type="TextField"/>
    <field indexed="true" multiValued="false" name="employer_paid_plan" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="family_sequence" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="diagnosed_cataracts" type="TextField"/>
    <field indexed="true" multiValued="false" name="major_medical_coverage" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_gout" type="TextField"/>
    <field indexed="true" multiValued="false" name="age_unit" type="TextField"/>
    <field indexed="true" multiValued="false" name="goiter" type="TextField"/>
    <field indexed="true" multiValued="false" name="chronic_bronchitis" type="TextField"/>
    <field indexed="true" multiValued="false" name="county" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="num_smokers" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="screening_month" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_emphysema" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_other_cancer" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="id" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="dental_coverage" type="TextField"/>
    <field indexed="true" multiValued="false" name="health_status" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="monthly_income_total" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="fish" type="TextField"/>
    <field indexed="true" multiValued="false" name="dog" type="TextField"/>
    <field indexed="true" multiValued="false" name="asthma" type="TextField"/>
    <field indexed="true" multiValued="false" name="ethnicity" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="age" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="diagnosed_asthma" type="TextField"/>
    <field indexed="true" multiValued="false" name="race_ethnicity" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_congestive_heart_failure" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="family_size" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="race" type="TextField"/>
    <field indexed="true" multiValued="false" name="thyroid_disease" type="TextField"/>
    <field indexed="true" multiValued="false" name="bronchitis" type="TextField"/>
    <field docValues="true" indexed="true" multiValued="false" name="household_size" type="TrieIntField"/>
    <field indexed="true" multiValued="false" name="cat" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_goiter" type="TextField"/>
    <field indexed="true" multiValued="false" name="diagnosed_skin_cancer" type="TextField"/>
    <field indexed="true" multiValued="false" name="fips" type="TextField"/>
  </fields>
  <uniqueKey>(id,age)</uniqueKey>
</schema>