hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Passing date as command line arguments
Date Fri, 03 Aug 2012 22:48:49 GMT
I have my below query in *test1.hql file. *I am trying to pass the date *
(dt)* as the command line argument.


*select * from lip_data_quality where dt = '${hiveconf: start_date}';*


So whenever I try to run the above *test1.hql file like this-*
*
*
* hive -f hivetest1.hql -hiveconf start_date=20120709*
*
*
I get zero records back. But the data is there in that table for that date.
Why is it so? Something wrong I am doing?

Can anyone help me out here? I was following Bejoy's Article here
http://kickstarthadoop.blogspot.com/2011/10/include-values-during-execution-time-in.html

Mime
View raw message