0

I am aiming at having a clickhouse table that is constantly updating rows and easy to export. I am considering having a Clickhouse table reference a path to a CSV file, similar to how dictionaries can reference an Absolute Path to a file under its source.

Is there a way to have it update accordingly to a CSV file? Instead of having to update rows all the time?

ewcvis
  • 139
  • 2
  • 11
  • consider using the [File table engine](https://clickhouse.com/docs/en/engines/table-engines/special/file/). – vladimir Oct 25 '21 at 23:49
  • it says that 'It will use folder defined by path setting in server configuration.' what setting do I change, also how do I import an existing CSV of data to that folder. I tried but it doesn't seem to actually find it – ewcvis Oct 26 '21 at 00:19
  • `/var/lib/clickhouse/user_files/` ........ `/var/lib/clickhouse/user_files/` – Denny Crane Oct 26 '21 at 03:53
  • what do i do with these file paths? – ewcvis Oct 26 '21 at 18:32

0 Answers0