https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163782#M45247 <P>This Problem has been solved.THere was an extra space between my_var1and $Var.</P> Fri, 04 Nov 2016 00:31:28 GMT kumarvaibhav199 2016-11-04T00:31:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163781#M45246 <P>Hi All,</P><P>I have something like </P><P>Myarray.sh</P><P> hive -S -hiveconf MY_VAR1 =$Var -f /home/vaibhav/Desktop/my_script.hql</P><P>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.</P><P>My_Script.hql</P><P> loAD DATA LOCAL INPATH '/home/vaibhav/Desktop/'${hiveconf:MY_VAR1}' ' OVERWRITE INTO TABLE xyz</P><P>When i'm trying to execute the above scenerio i'm getting error like :</P><P> FAILED: SemanticException Line 1:23 Invalid path ''/home/vaibhav/Desktop/=mydata.csv'': No files matching path file:/home /vaibhav/Desktop/=mydata.csv</P> Thu, 03 Nov 2016 23:36:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163781#M45246 kumarvaibhav199 2016-11-03T23:36:53Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163782#M45247 <P>This Problem has been solved.THere was an extra space between my_var1and $Var.</P> Fri, 04 Nov 2016 00:31:28 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163782#M45247 kumarvaibhav199 2016-11-04T00:31:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163783#M45248 <P>Glad that it got resolved.</P> Fri, 04 Nov 2016 01:09:00 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-Hive-table-using-Hiveconf-Variable/m-p/163783#M45248 pardeep_kumar 2016-11-04T01:09:00Z