Load Hive table using Hiveconf Variable

[#1]

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

[#2 · Accepted solution]

This Problem has been solved.THere was an extra space between my_var1and $Var.

[#3]

Glad that it got resolved.