Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How can I keep a table in memory in hive ?

How can I keep a table in memory in hive ?

New Contributor

Hi ,

I am using HDP 2.6 . I have a hive dimension table size 1 GB and the table is used frequently with another big fact table with join condition .. How Can I keep this dimension table in memory to select faster join with another fact table

With Regards,

KhairulHasan

1 REPLY 1

Re: How can I keep a table in memory in hive ?

Take a look at Hive LLAP

Another good article on the same: https://hortonworks.com/blog/apache-hive-going-memory-computing/