error while importing table on hive

[#1]

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

[#2 · Accepted solution]

Check the permissions for your user on the hdfs_export_location.