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

2016-08-01 Thread Julián Arocena
Thank you so much! I´m testing it. Best regards, *Arocena Julian* | Developer jaroc...@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

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

2016-07-30 Thread Andrew Sears
It is HIVE-13948.https://github.com/apache/hive/commit/da3ed68eda10533f3c50aae19731ac6d059cda87https://issues.apache.org/jira/browse/HIVE-13948Regards,AndrewOn July 29, 2016 at 6:44 PM Julián Arocena wrote:Hey, thank you so much! I was going crazy, you can image it :)Please let me know if you hav

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

2016-07-29 Thread Gopal Vijayaraghavan
> 1946-10-01 ... > Any idea to help me? What timezone is this? The years between 1946 and 1966 are extremely strange for timezones for the US/Canada (the period between "WW II Time" ending and the Uniform Time Act of 1966). Cheers, Gopal

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

2016-07-29 Thread Julián Arocena
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" escribió: > Hi there, > > This is a critical bug fixed by a JIRA, will see if I can get the number > for

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

2016-07-29 Thread Andrew Sears
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 [jaroc...@temperies.com] > wrote: Hi, I´m having a problem with some dates

Some dates add/less a day...

2016-07-29 Thread Julián Arocena
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' STOR