I found out that Hive can write into multi-level directory based on the property hive.insert.into.multilevel.dirs
Using set hive.insert.into.multilevel.dirs=true; and then running the query allowed me to create multi-level directory This is available since 0.8.0 . Refer to https://issues.apache.org/jira/browse/HIVE-1975 On Sat, Aug 18, 2012 at 4:24 AM, Vinod Singh <[email protected]> wrote: > Hive can create a directory only one level deep. > > Thanks, > Vinod > > > On Sat, Aug 18, 2012 at 1:06 AM, Himanish Kushary <[email protected]>wrote: > >> Hi, >> >> I am executing the command : insert overwrite directory >> '/feed/daily/2011-07-16' select count(1) from distinctpacks; but am getting >> the error >> >> Failed with exception Unable to rename: ............ >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.MoveTask >> >> According to https://issues.apache.org/jira/browse/HIVE-1975 the issue >> should have been fixed as I am hive version > 0.8.0 >> >> I noticed that the insert overwrite works only for a single nested >> directory for me. >> >> Am I missing something ? >> >> -- >> Thanks & Regards >> Himanish >> > > -- Thanks & Regards Himanish
