Limitations of Temporary Tables – Hive

As discussed in the earlier article, A temporary table in Apache Hive, as the name indicates, is a table that works like a regular table but exists only temporarily in Hive’s temp space. It will remain till the user’s session expires. They are most often used to save interim results from batch processing that do not need to be saved permanently.

The limitations of temporary tables are listed below:

  • Partition columns are not supported.
  • No support for creation of indexes.
  • If you create a temporary table with the same name as a permanent table, you won’t be able to access the permanent table until you drop the temporary table or rename it.
  • The temporary table is visible only to the current session, and is dropped automatically when the session is closed.

I hope you found this post useful. Please click the follow button to receive notifications of new postings.

Please read: Apache Hive Temporary Tables

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s