Hive Export/Import ORC table is not working

[#1]

Hi Guys,

I am trying to migrate an ORC table from one cluster to another. The export and import does not throw any error and I could see folders and files getting created. But the imported table does not contain any data. Table is getting created with all the correct columns. The same works properly for table stored as textfile. Hive version is 3.1. Please provide your inputs.

Regards,

Magudeswaran R.

[#2 · Accepted solution]

Hi @Magudeswaran ,

Refer to this KB article.

It is not supported to directly export and import transactional tables. You need to follow the workaround.

Thanks,

Megh