Skip to main content
Koffi
Gold ⭐️
June 27, 2019
Solved

error while importing table on hive

HI

I have exported a table from a hadoop envrionment using the following command:

export table department to 'hdfs_exports_location/department';


I tried to import the same table into another hadoop environment using the command:

import from 'hdfs_exports_location/department';


i get the following error:

Error: Error while compiling statement: FAILED: SemanticException [Error 10027]: Invalid path (state=42000,code=10027)


i tried using

import table imported_dept from 'hdfs_exports_location/department';


i get the following error:

Error: Error while compiling statement: FAILED: SemanticException [Error 10324]: Import Semantic Analyzer Error (state=42000,code=10324)


Any idea what could be the issue?


i am using hive 3.1.0.3.0.1.0-187.


Thank you

cloud9
cloud9Answer
Gold ⭐️
September 16, 2021

Check the permissions for your user on the hdfs_export_location. 

1 reply

cloud9
cloud9Answer
Gold ⭐️
September 16, 2021

Check the permissions for your user on the hdfs_export_location. 

Translate