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

[Andrew Sears]

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 <jaroc...@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" <andrew.se...@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 <jaroc...@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