Hi Team, Below insert with union-all will create sub-directories: set hive.execution.engine=tez; create table h1_passwords_target like h1_passwords;
insert overwrite table h1_passwords_target select * from (select * from h1_passwords limit 1 union all select * from h1_passwords limit 2 ) sub; [root@h1 h1_passwords_target]# ls -altr total 2 drwxrwxrwx 115 xxx xxx 113 Aug 19 21:24 .. drwxr-xr-x 2 xxx xxx 1 Aug 19 21:25 2 drwxr-xr-x 2 xxx xxx 1 Aug 19 21:25 1 drwxr-xr-x 4 xxx xxx 2 Aug 19 21:25 . Is there anyway to avoid creating sub-directories? Or this is by design and can not be changed? Because non-Tez query by default they can not work fine since hive.mapred.supports.subdirectories=false. -- Thanks, www.openkb.info (Open KnowledgeBase for Hadoop/Database/OS/Network/Tool)
