Cache TableΒΆ

CACHE [LAZY] TABLE [db_name.]table_name

Cache the contents of the table in memory. Subsequent queries on this table will bypass scanning the original files containing its contents as much as possible.

LAZY
Cache the table lazily instead of eagerly scanning the entire table.