Text Analysis in Database Queries

the {{ocienthyperscaledatawarehouse}} enables search and analysis of textual data you can run queries efficiently using indexes in the ocient hyperscale data warehouse to perform text analysis the database supports different types of indexes the n gram index is a type of secondary index that enables text analysis cluster key indexes define cluster key (ck) indexes when you create the table 176,123,240,125 true left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type secondary indexes you can create or drop secondary indexes at any time 126,86,284,141 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type n gram indexes support text analysis by providing an efficient search of textual data this type of index works by tokenizing the pattern in the string, and then pruning and transforming the tokens you can create n gram indexes at any time for details about creating an n gram index, see docid\ n7zyxmwfavae6fnmv2uvw there are other ways to perform text analysis for details, see the syntax for docid\ nw9vavkey2v75moxm muo and docid\ nw9vavkey2v75moxm muo related links docid\ nw9vavkey2v75moxm muo docid\ a5odjf1wlmeacsfrr8k4m