/* | |
* Description : Notice the query hint to avoid using any secondary index to evaluate the predicate in the where clause | |
* Expected Res : Success | |
* Date : 21th December 2013 | |
*/ | |
drop dataverse test if exists; | |
create dataverse test; | |
use dataverse test; | |
create type DBLPType as closed { | |
id: int32, | |
dblpid: string, | |
title: string, | |
authors: string, | |
misc: string | |
} | |
create dataset DBLP(DBLPType) primary key id; | |
create index ngram_index on DBLP(title) type ngram(3); | |
write output to nc1:"rttest/inverted-index-basic_ngram-contains.adm"; | |
for $o in dataset('DBLP') | |
where /*+ skip-index */ contains($o.title, "Multimedia") | |
order by $o.id | |
return $o |