hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: Passing date as command line arguments
Date Sat, 04 Aug 2012 06:41:42 GMT
Thanks Vijay for the suggestion. I also tried that and it still didn't
worked for me.

Any thoughts why it is not working?




On Fri, Aug 3, 2012 at 11:32 PM, Vijay <techvd@gmail.com> wrote:

> There can't be a space in the variable name. Try this:
> ${hiveconf:start_date}
>
> On Fri, Aug 3, 2012 at 11:06 PM, Techy Teck <comptechgeeky@gmail.com>
> wrote:
> > Can anyone help me out on this?
> >
> > I am stuck on this and I have no clue what wrong I am doing?
> >
> >
> >
> >
> > On Fri, Aug 3, 2012 at 3:48 PM, Techy Teck <comptechgeeky@gmail.com>
> 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
> >>
> >>
> >
>

Mime
View raw message