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*
>
>
