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

error while importing table on hive

error while importing table on hive

Contributor

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