Skip to main content
Magudeswaran
Magudeswaran
Silver ⭐️⭐️
April 5, 2021
Solved

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.

vidanimegh
vidanimeghAnswer
Gold ⭐️
May 6, 2021

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

View in thread

1 reply

vidanimegh
vidanimeghAnswer
Gold ⭐️
May 6, 2021

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

Translate
    Terms & ConditionsAccessibility statement