Clickhouse and full text search

[Baurzhan Tokhtarov]

Hi all!
We are considering switching from sphinx to clickhouse for full text search 

Does this make sense? 

I tried searching a table with 1 million records in CH, and compared the results with sphinx. Sphinx was many times faster 

But I have doubts that maybe I configured CH incorrectly or used inappropriate functions.

when searching for CH, I used functions like:

'position' 

'like' 

'match' 

and various other options Are there any other options for implementing full text search for clickhouse?

[Denis Zhuravlev]

>We are considering switching from sphinx to clickhouse for full text search

>Does this make sense?

No.

>I tried searching a table with 1 million records in CH, and compared the results with sphinx. Sphinx was many times faster

As expected.

>But I have doubts that maybe I configured CH incorrectly or used inappropriate functions.

>when searching for CH, I used functions like:

>'position' 

>'like' 

>'match' 

>and various other options Are there any other options for implementing full text search for clickhouse?

CH does not have full text search functions. Obviously sphinx is much faster and better for full text search.