Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

error while importing table on hive

avatar
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

avatar
New Contributor

Check the permissions for your user on the hdfs_export_location. 

View solution in original post

1 REPLY 1

avatar
New Contributor

Check the permissions for your user on the hdfs_export_location.