Hi,
While you can configure multiple paths for data on each node, these are treated equally, so to distinguish between classes of storage you will need multiple nodes, but nothing prevents you from running multiple CrateDB logical nodes on the same “physical” machine.
Once you got CrateDB nodes with different classes of storage you can do something along the lines of Building a hot and cold storage data retention policy in CrateDB with Apache Airflow - Tutorials - CrateDB Community
I hope this helps.
1 Like