Yes that query gives me the result back correctly.
How can I see the hive log Bejoy? Basically I am not sure which hive log
and what is the path where I can see that thing?
On Fri, Aug 3, 2012 at 11:52 PM, Bejoy Ks <bejoy...@yahoo.com> wrote:
> Hi Techy
>
> Are you getting the results for the same query directly from CLI, I mean
> does the below query return correct results
> select * from lip_data_quality where dt = '20120709';
>
> If the above query returns results, can you check the hive logs and see
> what is the actual query being executed?
>
> Regards,
> Bejoy KS
>
> ------------------------------
> *From:* Techy Teck <comptechge...@gmail.com>
> *To:* user@hive.apache.org
> *Cc:* Vijay Dirisala <tec...@gmail.com>
> *Sent:* Saturday, August 4, 2012 12:11 PM
> *Subject:* Re: Passing date as command line arguments
>
> 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 <tec...@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 <comptechge...@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 <comptechge...@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
> >>
> >>
> >
>
>
>
>
>
