Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

error while importing table on hive

error while importing table on hive

Explorer

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

Don't have an account?
Coming from Hortonworks? Activate your account here