[HIVE-9505] explain extended insert into table foo values(4,5,6) leaks temp tables

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Assignee: Unassigned
• Reporter: Eugene Koifman
• Created: 29/Jan/15 01:41
• Updated: 29/Jan/15 01:41

Description

do

show tables;
explain extended insert into table foo values(4,5,6);
show tables;

you'll notice that 2nd 'show tables' will includes something like 'values_tmptable_19' which is the temp table shown in 'ABSTRACT SYNTAX TREE' portion of the plan

quit and restart Hive CLI and this table disappears as is expected for temp tables.