You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Julián Arocena <ja...@temperies.com> on 2016/07/29 20:36:54 UTC
Some dates add/less a day...
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*
Re: Some dates add/less a day...
Posted by Gopal Vijayaraghavan <go...@apache.org>.
> 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...
Posted by 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*
>
>
>
Re: Some dates add/less a day...
Posted by Julián Arocena <ja...@temperies.com>.
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*
>
>
Re: Some dates add/less a day...
Posted by Andrew Sears <an...@analyticsdream.com>.
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 < jarocena@temperies.com [jarocena@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