.ge...@memorylane.com
> To: user@hive.apache.org
> Subject: Re: Passing date as hive configuration variable
> Date: Thu, 10 May 2012 18:39:10 +
>
> Another option is to do it all in the shell:
>
> #/bin/sh
> somedate=$(date -d '2 day ago' +"%Y-%m-%d")
> ec
nalyst
>Walt Disney Parks and Resorts Online
>Ph: 407-566-2545
>Tie: 8-296-2545
>
>CONFIDENTIAL
>
>-Original Message-
>From: Saurabh S [mailto:saurab...@live.com]
>Sent: Thursday, May 10, 2012 2:06 PM
>To: user@hive.apache.org
>Subject: Passing date as hive co
NFIDENTIAL
-Original Message-
From: Saurabh S [mailto:saurab...@live.com]
Sent: Thursday, May 10, 2012 2:06 PM
To: user@hive.apache.org
Subject: Passing date as hive configuration variable
I'm having a hard time passing a date as a hive environment variable.
The setting is t
I think you have to put quotes around the variable to tell give that you
are comparing against a string...
Ashish
On May 10, 2012 2:06 PM, "Saurabh S" wrote:
>
> I'm having a hard time passing a date as a hive environment variable.
>
> The setting is this: The table I'm querying is partitioned o
I'm having a hard time passing a date as a hive environment variable.
The setting is this: The table I'm querying is partitioned on a date column,
say, local_dt. I wish to query on last two days' worth of data. Unfortunately
there seems to be no way of getting the current date without either sc