Can ClickHouse replaced Full Text Search like Sphinx/Manticore Search or Solr?

[Eric Chua]

Clickhouse has fast speed, I wonder can it provide similar or better full text search like Sphinx/Manticore or Solr? Like weight, ranking, %..% infix (single character, etc). Anyone tried using ClickHouse for full text search purpose?

I think this case study, the company migrated from manticore search to clickhouse

https://cdn2.hubspot.net/hubfs/4536206/Case%20study_Ivinco.pdf

[Stefán Baxter]

Hi Eric,

I have used both extensively and would like to say NO, you can and should not do that.

If you need full-text search then you use a full-text search system

if you need a real-time analytics store then you use a real-time analytics store.

I would love to go into details if you insist but please, please, please, just use the appropriate tools for the job.

Regards,

 - Stefán 

--
You received this message because you are subscribed to the Google Groups "ClickHouse" group.
To unsubscribe from this group and stop receiving emails from it, send an email to clickhouse+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/ba4851ec-fd2c-4aaa-a3d3-e446a45c6d44o%40googlegroups.com.

[Eric Chua]

Hi Stefán,

Thanks for your reply.

When you said this "if you need a real-time analytics store then you use a real-time analytics store"

I presume you mean ClickHouse is suitable for real-time analytics.

A few questions.

1. Since Clickhouse is about INSERTS, why is it a good use case for real time analytics?

2. Since Clickhouse is about Batch INSERTS... 

For 1 and 2.. I know it makes sense for use case like monitor audit logs, traffic logs or track user behavior clicks on a website where it's always new records.

a. I presume Clickhouse is suitable for such use case as mentioned above?

b. Is ClickHouse not suitable to push in real time INSERTS (not batch). I mean when a new insert happens in database, will insert into Clickhouse directly.

3. How about use case where real time analytics of sales orders?

a. New orders

b. Abandoned cart orders 

c. Successful orders 

where it needs INSERTS & UPDATES (or maybe DELETE)?

For point 3, is ClickHouse not suitable for such real time analytics?

Mind to share. Thanks.

On Thursday, July 30, 2020 at 5:54:02 PM UTC+8, Stefán Baxter wrote:

Hi Eric,

I have used both extensively and would like to say NO, you can and should not do that.

If you need full-text search then you use a full-text search system

if you need a real-time analytics store then you use a real-time analytics store.

I would love to go into details if you insist but please, please, please, just use the appropriate tools for the job.

Regards,

 - Stefán 

On Thu, Jul 30, 2020 at 9:50 AM Eric Chua <ericc...@gmail.com> wrote:

Clickhouse has fast speed, I wonder can it provide similar or better full text search like Sphinx/Manticore or Solr? Like weight, ranking, %..% infix (single character, etc). Anyone tried using ClickHouse for full text search purpose?

I think this case study, the company migrated from manticore search to clickhouse

https://cdn2.hubspot.net/hubfs/4536206/Case%20study_Ivinco.pdf

--
You received this message because you are subscribed to the Google Groups "ClickHouse" group.

To unsubscribe from this group and stop receiving emails from it, send an email to click...@googlegroups.com.