IMO this is the best simple option right now. For sorted data you only need the relevant row groups which can be tunable to sensible sizes for your data and ac

IMO this is the best simple option right now. For sorted data you only need the relevant row groups which can be tunable to sensible sizes for your data and access pattern.