Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Load Hive table using Hiveconf Variable

Solved Go to solution
Highlighted

Load Hive table using Hiveconf Variable

Rising Star

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

Accepted Solutions

Re: Load Hive table using Hiveconf Variable

Rising Star

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

View solution in original post

2 REPLIES 2

Re: Load Hive table using Hiveconf Variable

Rising Star

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

View solution in original post

Highlighted

Re: Load Hive table using Hiveconf Variable

Glad that it got resolved.

Don't have an account?
Coming from Hortonworks? Activate your account here