Hi,
I am doing a simple export and import test from one database in Hive to another database in the same Hive instance. I thought this would have been straight forward. hive> use asehadoop; OK Time taken: 0.35 seconds hive> export table t to '/export/t'; Copying data from file:/tmp/hive/af07f3eb-e2d2-4393-9aac-c3d1a83f2398/hive_2015-11-12_21-19-44 _375_659453881906265295-1/-local-10000/_metadata Copying file: file:/tmp/hive/af07f3eb-e2d2-4393-9aac-c3d1a83f2398/hive_2015-11-12_21-19-44 _375_659453881906265295-1/-local-10000/_metadata Copying data from hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000055_0000055 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000056_0000056 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000057_0000057 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000058_0000058 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000059_0000059 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000060_0000060 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000061_0000061 Copying file: hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000062_0000062 OK Time taken: 22.529 seconds hive> use test; OK Time taken: 0.011 seconds hive> import from '/export/t'; Copying data from hdfs://rhes564:9000/export/t/data Copying file: hdfs://rhes564:9000/export/t/data/delta_0000055_0000055 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000056_0000056 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000057_0000057 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000058_0000058 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000059_0000059 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000060_0000060 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000061_0000061 Copying file: hdfs://rhes564:9000/export/t/data/delta_0000062_0000062 Loading data to table test.t Failed with exception checkPaths: hdfs://rhes564:9000/tmp/hive/hduser/af07f3eb-e2d2-4393-9aac-c3d1a83f2398/hiv e_2015-11-12_21-20-43_538_674567030614000538-1/-ext-10000 has nested directoryhdfs://rhes564:9000/tmp/hive/hduser/af07f3eb-e2d2-4393-9aac-c3d1a83 f2398/hive_2015-11-12_21-20-43_538_674567030614000538-1/-ext-10000/delta_000 0055_0000055 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Mich Talebzadeh Sybase ASE 15 Gold Medal Award 2008 A Winning Strategy: Running the most Critical Financial Data on ASE 15 <http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908 .pdf> http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908. pdf Author of the books "A Practitioner's Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7. co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4 Publications due shortly: Complex Event Processing in Heterogeneous Environments, ISBN: 978-0-9563693-3-8 Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly <http://talebzadehmich.wordpress.com/> http://talebzadehmich.wordpress.com NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Technology Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility.