Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

1 ACCEPTED SOLUTION

New Contributor

Check the permissions for your user on the hdfs_export_location. 

View solution in original post

1 REPLY 1

New Contributor

Check the permissions for your user on the hdfs_export_location.