Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Passing date as command line arguments


Copy link to this message
-
Re: Passing date as command line arguments
Hi,

In the command line, you want to wrap 20120709 in double-quotes, as they get stripped when being passed into the hiveconf variable.

Matt

On Aug 3, 2012, at 6:48 PM, Techy Teck <[EMAIL PROTECTED]> wrote:

> 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
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB