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>