How to get fuzzy matches

[samanth...@gmail.com]

Hi Eric,

I have the below requirement:

Ex:-

Indexed Data:  (one lakh records)

id, company_name, country, city, state

Input

company_name: "wipro software services technologies ltd"

I need to find fuzzy matches for given Input company_name against Indexed Data.

Can you please help me here?

Thanks,

Samanth

[Eric Ridge]

Hi Samanth. We may have different definitions of "fuzzy", but read this section of the docs and see if it helps. If not, you might need to be more specific:

https://github.com/zombodb/zombodb/blob/master/SYNTAX.md#wildcards

eric

--
You received this message because you are subscribed to the Google Groups "ZomboDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to zombodb+u...@googlegroups.com.
To post to this group, send email to zom...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/zombodb/8ad754bf-e458-4cb8-b957-e78169d5dbb3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[samanth...@gmail.com]

Hi Eric,

I understand and tried some sample fuzzy. It is working partially to satisfy my requirement. But it is taking more time every time when I hit the database.

And also, I tried to hit the elasticsearch directly. I was not able to get the results. 

Is there any way to get the results from elasticsearch directly instead of zombo db?

Thanks,

Samanth

[Eric Ridge]

Hey Samanth!  I hope 2017 has been treating you well so far!

Can you give me some examples of the queries you're executing and details around timings?

Querying Elasticsearch directly isn't really a thing that's exactly supported by ZDB, but if you're using the latest v3.1.4, there are some things you can do via ZDB's query syntax to directly pass in JSON Elasticsearch query parts.

I'm happy to help but just need some more details.

eric

To view this discussion on the web visit https://groups.google.com/d/msgid/zombodb/c9c6e912-0710-4104-8d0a-8ee872466b31%40googlegroups.com.

[samanth...@gmail.com]

Hi Eric,

Please find the below example elasticsearch query that I want to search directly on elasticsearch:

elasticsearch sample query:

"query" : {

"bool" : {

"must" : [{

"wildcard" : {

"email" : "*wipro*"

}

}

]

}

}

Thanks,

Samanth

[Eric Ridge]

Well, that particular formulation is just a simple wildcard query:

  SELECT * FROM table WHERE zdb('table', ctid) ==> 'email:*wipro*';

Take a minute to go over the query syntax documentation -- it might help clear things up:  https://github.com/zombodb/zombodb/blob/master/SYNTAX.md

eric

To view this discussion on the web visit https://groups.google.com/d/msgid/zombodb/db9f095e-5e66-4dc2-b191-e845404860ff%40googlegroups.com.

[Eric Ridge]

Hi again, Samanth!  I meant to also link you the docs for the SQL function named "zdb_dump_query()".  It will show you what ES QueryDSL ZDB will generate for a given user query:

https://github.com/zombodb/zombodb/blob/master/SQL-API.md#function-zdb_dump_querytable_name-regclass-query-text-returns-text

Using your example, it returns this:

# select zdb_dump_query('so_posts', 'email:*wipro*');     
    zdb_dump_query       
-------------------------
{                      +
  "wildcard" : {       +
    "email" : "*wipro*"+
  }                    +
}
(1 row)

You might find this helpful.

eric