Add MATCH and RLIKE functionality for SQL Translate against Person and Company Search APIs
Kade Beem
Given that Elasticsearch has a limitation of conducting LIKE searches against text fields (https://discuss.elastic.co/t/unable-to-run-sql-query-on-multi-fields-using-elastic-search-v-7-3/222321/2) users leveraging SQL as a query language for the Person Search and Company Search API need functionality to conduct searches against unstructured/semi-structured strings like summary, job_title.text, etc
H
Harlequin Panther
open
H
Harlequin Panther
being researched
B
Ben Eisenberg
doing soon
B
Ben Eisenberg
Merged in a post:
Please support regular expressions
S
Silver Roadrunner
Please support RLIKE via Elasticsearch SQL, so we are able to filter/search records more accurately. The same for MATCH.
E.g.
SELECT * FROM person WHERE experience.company.name RLIKE 'google.*'
fails. Also select * from people where MATCH(job_company_name, 'google')
B
Ben Eisenberg
Hey Nelson -- we currently support these using the Elasticsearch query schema and are working on adding support for it in SQL.
B
Ben Eisenberg
being researched