Support Questions
Find answers, ask questions, and share your expertise

hue__tmp_xxxxx table what is it?

Expert Contributor

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!

2 REPLIES 2

Re: hue__tmp_xxxxx table what is it?

Super Guru

@ebeb,

 

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

Re: hue__tmp_xxxxx table what is it?

Expert Contributor

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.