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.
@satya_prakash_gaurav its better to share your code and error to troubleshoot easily.
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.
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 ]