Hi David,
Thanks for reply.
What type of full reproduction script you want? you mean to say mappings or settings or content?
DELETE testindex
PUT testindex
PUT testindex/_mapping
{
"properties": {
"filename": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
POST testindex/_doc
{
"filename": "704140-0001 FIT TO P1.pdf"
}
POST testindex/_doc
{
"filename": "704140 FIT TO P4 MARCH 1994 DATA SUBMITTLE -0051.pdf"
}
POST testindex/_doc
{
"filename": "704140 FIT TO P1 OCTOBER 2003 POINT OF FIT -0001.pdf"
}
POST _sql?format=txt
{
"query":""" SELECT filename FROM testindex WHERE QUERY('(filename:("704140"))')"""
}
it gives perfect exact match result.
POST _sql?format=txt
{
"query":""" SELECT filename FROM testindex WHERE QUERY('(filename:(70414*))')"""
}
it gives partial match result for single word.
POST _sql?format=txt
{
"query":""" SELECT filename FROM testindex WHERE QUERY('(filename:("704140-0001"))')"""
}
it gives perfect exact match result.
POST _sql?format=txt
{
"query":""" SELECT filename FROM testindex WHERE QUERY('(filename:(704140-00*))')"""
}
it gives no result.
I want partial match search. how it is possible?
Can you please help me?
Thanks