Reply
Contributor
Posts: 44
Registered: ‎09-14-2017

hue__tmp_xxxxx table what is it?

Hi, when I add a table in Hue and import data from a CSV, it automatically creates the actual table along with a temp table named like hue__tmp_xxxx . This temp table remains after the actual table was created. What is this table for and what needs to be done with this table or can it be dropped? Thanks!

Posts: 455
Topics: 1
Kudos: 106
Solutions: 59
Registered: ‎04-22-2014

Re: hue__tmp_xxxxx table what is it?

@ebeb,

 

That sounds pretty strange.  Can you show what you did via screen shot and how the tmp table appears later?

Contributor
Posts: 44
Registered: ‎09-14-2017

Re: hue__tmp_xxxxx table what is it?

Will try and recreate the scenario. It may have been during create hive table using Hue wizard by importing a .csv file in HDFS which maybe failed during the data load. Will do again and see.

Announcements