Re: Some dates add/less a day...

[Julián Arocena <ja...@temperies.com>]

Thank you so much!

I´m testing it.

Best regards,

*Arocena Julian* | Developer


jarocena@temperies.com


+54 249 4437 972
9 de Julio 509 | Tandil | Buenos Aires | Argentina

+1 (408)524-3071 I (650)704-7915

440 N. Wolfe Road, Sunnyvale CA 94085 | San Francisco | USA

www.temperies.com


2016-07-30 8:47 GMT-03:00 Andrew Sears <an...@analyticsdream.com>:

> It is HIVE-13948.
>
>
> https://github.com/apache/hive/commit/da3ed68eda10533f3c50aae19731ac6d059cda87
>
> https://issues.apache.org/jira/browse/HIVE-13948
>
> Regards,
>
> Andrew
>
> On July 29, 2016 at 6:44 PM Julián Arocena <ja...@temperies.com> wrote:
>
> Hey, thank you so much! I was going crazy, you can image it :)
>
> Please let me know if you have it.
>
> I will have a nice weekend with this news
>
> Best regards,
> El 29/7/2016 18:44, "Andrew Sears" <an...@analyticsdream.com>
> escribió:
>
> Hi there,
>
> This is a critical bug fixed by a JIRA, will see if I can get the number
> for you. It involves patching lib/hive-* files.
>
> Cheers,
> Andrew
>
> On Fri, Jul 29, 2016 at 4:37 PM, Julián Arocena <ja...@temperies.com>
> wrote:
>
> Hi,
>
> I´m having a problem with some dates using external tables to a text file.
> Let me give you an example:
>
> file content:
>
> *1946-10-01*
> 1946-10-02
>
>
> table:
>
> create external table date_issue_test
> (
>
> date_test Date
>
> )
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\001'
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE
> LOCATION '/user/hive/test';
>
>
> Select * from date_issue_test;
>
> OK
> *1946-10-02*
> 1946-10-02
>
>
> As you can see in this case it adds a day, there are a few cases like this.
>
> Also I tried with a CAST and a fixed date as bellow :
>
> hive> select CAST('1946-10-01' as date) from date_issue_test limit 1;
> OK
> 1946-10-02
>
>
> Any idea to help me?
>
> Thank you so much!
>
> *Julian*
>
>
>