question Re: Hive: Temporary table created automatically in Archives of Support Questions (Read Only)

Hive: Temporary table created automatically

ashsskum — Wed, 07 Dec 2016 04:40:56 GMT

For Hive table of type TEXTFILE, a temporary table gets automatically created like below (for each table that we create), at the time when you try to do an INSERT. Can you please advise if this is an expected behavior and the temp table should be left untouched?

values__tmp__table__1

values__tmp__table__2

values__tmp__table__3

Re: Hive: Temporary table created automatically

gkeys — Wed, 07 Dec 2016 05:02:16 GMT

Temp tables like these are created when hive needs to manage intermediate data during an operation. This is normal. They should automatically delete when the operation is over. See these links for more:

If this is what you are looking for, let me know by accepting the answer; else, let me know of any gaps or followup questions.

Re: Hive: Temporary table created automatically

ashsskum — Wed, 07 Dec 2016 07:20:45 GMT

I noticed that those tables were present until I stayed within the hive session. After disconnecting and re-establishing the hive session, I didn't find those tables.

Note:

The above links seems to correspond to user creating temporary table with syntax "CREATE TEMPORARY TABLE". However, my inquiry was related to the tables created automatically by Hive.

Re: Hive: Temporary table created automatically

ekoifman — Thu, 08 Dec 2016 02:28:43 GMT

These tables are created by insert statement using VALUES clause - it's part of internal implementation logic. They are temp tables and are session scoped and as you've noticed will go away when the session ends.