Currently, the tiered hook disables tiered storage for tables created key_format=r, that is, column store.  There's no architectural reason for this, but enabling it causes some tests to fail, which would need to be diagnosed and fixed.  See the FIXME in hook_tiered.py.