SemanticException [Error 10027]: Invalid path in hive import

Big Data Apache Hive
#1

Not able to import the data in hive table from exported path. I am trying to import the data in hive table from exported path.

Why droping the table in hive is deleting the hdfs file from where we have loaded the file
#2

@satya_prakash_gaurav its better to share your code and error to troubleshoot easily.

#3

Hi Ravi,
The code is given below.
import table sath3 from ‘/user/satya/sat.txt/’.
Note:- i have created a new table with same structure of sat.txt file and stored as textfile.when i have checked the path it exist and file was also there but i was not able to import it, However i was able to load it.

#4

Hope for the export and import you do not need to mention the absolute end file name- rather the directory which contains the actual file.
In your case:

Assuming you have exported file to the location:

export table sat to ‘/user/satya’;

If yes, then please try : import table sath3 from ‘/user/satya’

Looks like you are also trying to change the table name while importing. Try without import rename option and if it works all well, then add import table rename mechanism [ the one you are using ]