Thanks Gopal. Indeed table t is defined as ORC and transactional. Any reason why this should not work for transactional tables?
Regards, Mich 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. -----Original Message----- From: Gopal Vijayaraghavan [mailto:go...@hortonworks.com] On Behalf Of Gopal Vijayaraghavan Sent: 13 November 2015 00:17 To: user@hive.apache.org Subject: Re: export/import in hive failing with nested directory exception! > 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. Not if ACID transactions are involved. > Copying file: >hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/t/delta_0000056_00 >000 >56 This should be fine for non transactional tables. Cheers, Gopal