Support Questions

Find answers, ask questions, and share your expertise

Load Hive table using Hiveconf Variable

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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

View solution in original post

2 REPLIES 2

avatar
Expert Contributor

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

avatar

Glad that it got resolved.