Created 11-03-2016 04:36 PM
Hi All,
I have something like
Myarray.sh
hive -S -hiveconf MY_VAR1 =$Var -f /home/vaibhav/Desktop/my_script.hql
Where $Var is the name of the file coming from an array from the shell script .the above line is also defined in that shell script only.
My_Script.hql
loAD DATA LOCAL INPATH '/home/vaibhav/Desktop/'${hiveconf:MY_VAR1}' ' OVERWRITE INTO TABLE xyz
When i'm trying to execute the above scenerio i'm getting error like :
FAILED: SemanticException Line 1:23 Invalid path ''/home/vaibhav/Desktop/=mydata.csv'': No files matching path file:/home /vaibhav/Desktop/=mydata.csv
Created 11-03-2016 05:31 PM
This Problem has been solved.THere was an extra space between my_var1and $Var.
Created 11-03-2016 05:31 PM
This Problem has been solved.THere was an extra space between my_var1and $Var.
Created 11-03-2016 06:09 PM
Glad that it got resolved.