Viewing search index schema and config

Search index schema and config are stored internally in the database. When you modify a search index schema or config, the changes are pending.

Use the RELOAD SEARCH INDEX command to apply the pending changes to the active (in use) search index.

DataStax recommends using CQL to view the pending or active (in use) schema or config.

Use the cqlsh DESCRIBE command

Use the CQL shell command DESCRIBE SEARCH INDEX to view active and pending schemas and configs.

Show the active index config:
```
DESCRIBE ACTIVE SEARCH INDEX CONFIG ON demo.health_data;
```
The results are shown in XML. For an example and information about the config elements, see Search index configuration.

Show the pending search index config or schema before it is active.

For example, to view the pending index schema for demo.health_data:

DESCRIBE PENDING SEARCH INDEX SCHEMA ON demo.health_data;

The results are shown in XML.

Result

<?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>

Alternate ways to view the schema

Other ways to view the search index schema and config in XML include the following:

dsetool: View the pending (uploaded) or active (in use) schema or config.
- dsetool get_core_config
- dsetool get_core_schema
Solr Admin: View only the last uploaded (pending) resource.

Viewing search index schema and config

Use the cqlsh DESCRIBE command

Alternate ways to view the schema

Was this helpful?

Give Feedback