When hive is used as cache target data source, using a different data source for cache_status/cache_tracking is recommended.

Hive does not support data types BLOB, CLOB. Hence when using Hive as a cache target, tables with these data types cannot be cached.