troubleshooting

Can RisingWave + ElasticSearch fulfill text pattern matching requirements without deploying ElasticSearch?

Rick Otten is exploring ways to do text pattern matching across multiple PostgreSQL fields using RisingWave without deploying ElasticSearch. Yingjun suggested the possibility of using RisingWave with ElasticSearch to fulfill the requirements, but Rick is looking for a solution without deploying ElasticSearch. Rayees Pasha also mentioned that adding ElasticSearch may overcomplicate the solution. Rick is currently close to having RisingWave stable in the dev environment and is considering different options for text pattern matching.

Ri

Rick Otten

Asked on Oct 12, 2023

  • RisingWave does not currently support Full Text Search capabilities like PostgreSQL.
  • Adding ElasticSearch to RisingWave may overcomplicate the solution.
  • Rick Otten is exploring options to achieve text pattern matching without deploying ElasticSearch.
  • Yingjun suggested DuckDB as a lightweight alternative for full text search.
  • DuckDB may be efficient for handling text data in a single node, but its design may not be optimal for streaming data ingestion.
Oct 13, 2023Edited by