comments search index

Modifying the configuration and schema on the comments table search index.

// SOURCE 'comments-table.cql';

// START-create
CREATE SEARCH INDEX IF NOT EXISTS
ON cycling.comments 
WITH COLUMNS record_id { excluded:true }, * {excluded:false};
// END-create

// **CHANGING the CONFIG**

// START-directoryFactory
ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET directoryFactory = 'encrypted';
// END-directoryFactory

// START-active
RELOAD SEARCH INDEX
ON cycling.comments;
// END-active

// START-rebuild
RELOAD SEARCH INDEX
ON cycling.comments;

REBUILD SEARCH INDEX
ON cycling.comments;
// END-rebuild

// START-cache
ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET autoCommitTime = 10000;
// END-cache

// START-requesth
ALTER SEARCH INDEX CONFIG
ON cycling.comments 
ADD requestHandler[@name='/elevate',@class='solr.SearchHandler', @startup='lazy'] 
WITH $$ {"defaults":[{"echoParams":"explicit"}],"last-components":["elevator"]} $$;
// END-requesth

// Policy to merge large segements due to deletes
// START-delete
ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET indexConfig.mergePolicyFactory[@class='org.apache.solr.index.AutoExpungeDeletesTieredMergePolicyFactory'].bool[@name='mergeSingleSegments'] = true;

ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET indexConfig.mergePolicyFactory[@class='org.apache.solr.index.AutoExpungeDeletesTieredMergePolicyFactory'].int[@name='maxMergedSegmentMB'] = 1005;

ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET indexConfig.mergePolicyFactory[@class='org.apache.solr.index.AutoExpungeDeletesTieredMergePolicyFactory'].int[@name='forceMergeDeletesPctAllowed'] = 25;
// END-delete

// START-commit
COMMIT SEARCH INDEX
ON cycling.comments;
// END-commit

// **CHANGING the SCHEMA**

// START-add_string_field
ALTER SEARCH INDEX SCHEMA
ON cycling.comments 
ADD fields.field[@name='fieldname', @type='StrField', @multiValued = 'false', @indexed='true'];
// END-add_string_field

// START-column_name
ALTER SEARCH INDEX SCHEMA
ON cycling.comments 
ADD FIELD record_id;
// END-column_name

// START-rename
ALTER SEARCH INDEX SCHEMA
ON cycling.comments 
SET field[@name='fieldname']@name = 'anotherFieldName';
// END-rename

// START-type
ALTER SEARCH INDEX SCHEMA
ON cycling.comments 
SET field[@name='fieldname']@type = 'UUIDField';
// END-type

// START-drop_another
ALTER SEARCH INDEX SCHEMA
ON cycling.comments 
DROP field anotherFieldName;
// END-drop_another

// **CHANGING the CONFIG **
// START-autocommit
ALTER SEARCH INDEX CONFIG
ON cycling.comments 
SET autoCommitTime = 1000;
// END-autocommit

// START-add_text_field
ALTER SEARCH INDEX SCHEMA
ON cycling.comments
SET types.fieldType[@name='TextField']@class='org.apache.solr.schema.TextField';

ALTER SEARCH INDEX SCHEMA
ON cycling.comments
SET fields.field[@name='comment']@type='TextField';
// END-add_text_field

// START-drop_text_field
ALTER SEARCH INDEX SCHEMA
ON cycling.comments
DROP field comment;

ALTER SEARCH INDEX SCHEMA
ON cycling.comments
DROP types.fieldType[@name='TextField'];
// END-drop_text_field

// START-add_dynamic_text_field
ALTER SEARCH INDEX SCHEMA
ON cycling.comments
ADD types.fieldType[@class='org.apache.solr.schema.TextField', @name='TextField']
WITH '{"analyzer":{"class":"org.apache.lucene.analysis.standard.StandardAnalyzer"}}';

ALTER SEARCH INDEX SCHEMA
ON cycling.comments
ADD dynamicField[@name='*fieldname', @type='TextField'];
// END-add_dynamic_text_field

RELOAD SEARCH INDEX
ON cycling.comments;

REBUILD SEARCH INDEX
ON cycling.comments;