> and there isn't an obvious way to get more than 100 nodes per table

By node you mean partition, and a partition is limited to 10GB. Store more than 1TB and you will have at least 100 partitions