Hi
Below insert with union will create sub-directories while executing in Tez.

 set hive.execution.engine=tez;

  insert overwrite table t3
   select * from t1 limit 1
    union
   select * from t2 limit 2 ;

Is there anyway to avoid creating sub-directories while running in tez? Or this 
is by design and can not be changed?

We can have alternate work around has
insert overwrite table t3
 select * from
 (  select * from t1 limit 1
    union
   select * from t2 limit 2) sub;


But above query involves in reading same results Twice. is there any setting, 
which disables directory creation while running in tez.

Thanks in advance.


Reply via email to