error while importing table on hive

Koffi — Thu, 27 Jun 2019 07:51:14 GMT

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

Re: error while importing table on hive

cloud9 — Thu, 16 Sep 2021 14:37:40 GMT

Check the permissions for your user on the hdfs_export_location.