hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahender bigdata <Mahender.BigD...@outlook.com>
Subject Anyway to avoid creating subdirectories by "Insert with union”
Date Wed, 24 Feb 2016 00:37:30 GMT
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.



Mime
View raw message