Support Questions
Find answers, ask questions, and share your expertise

Hive Export/Import ORC table is not working

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.

1 REPLY 1

Re: Hive Export/Import ORC table is not working

Expert Contributor

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