Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Content-Type: multipart/alternative;
 boundary="----sinikael-?=_1-14698286608450.33429141715168953"
From: Andrew Sears <andrew.sears@analyticsdream.com>
To: user@hive.apache.org
In-Reply-To: 
 <CACPr96gKYoyjtqfEXSsvGe+vqd=XaTz3j-gaNkCYRASybW8v9A@mail.gmail.com>
References: 
 <CACPr96gKYoyjtqfEXSsvGe+vqd=XaTz3j-gaNkCYRASybW8v9A@mail.gmail.com>
Subject: Re: Some dates add/less a day...
Message-Id: <b98f61bf-6cea-4f03-b95b-c418c4f419fb@analyticsdream.com>
Date: Fri, 29 Jul 2016 17:44:20 -0400
MIME-Version: 1.0
archived-at: Fri, 29 Jul 2016 21:44:42 -0000

------sinikael-?=_1-14698286608450.33429141715168953
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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=C3=A1n Arocena < jarocena@temperies.=
com [jarocena@temperies.com] > wrote:
Hi,
I=C2=B4m 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
------sinikael-?=_1-14698286608450.33429141715168953
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Hi there,</p>
<p dir=3D"ltr">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.</p>
<p dir=3D"ltr">Cheers,<br>
Andrew</p>
<div id=3D'cm_signature'></div><div class=3D"cm_quote" style=3D" color: =
#787878">On Fri, Jul 29, 2016 at 4:37 PM, Juli=C3=A1n Arocena &lt;<a =
href=3D"mailto:jarocena@temperies.com">jarocena@temperies.com</a>&gt; =
wrote:</div><br><div id=3D"oldcontent" style=3D"background: rgb(255, 255, =
255);"><blockquote style=3D""><div dir=3D"ltr">Hi, <div><br></div><div>I=
=C2=B4m having a problem with some dates using external tables to a text =
file. Let me give you an example:</div><div><br></div><div>file =
content:</div><div><blockquote style=3D"margin:0px 0px 0px =
40px;border:none;padding:0px"><div><div><b>1946-10-01</b></div><div>1946-10=
-02</div></div></blockquote><br></div><div>table:</div><blockquote =
style=3D"margin:0px 0px 0px 40px;border:none;padding:0px"><div><div>create =
external table date_issue_test</div></div><div><div>(</div></div><div><div>=
<br></div></div><div><div>date_test     Date</div></div><div><div><br></div=
></div><div><div>)</div></div><div><div>ROW FORMAT DELIMITED</div></div><di=
v><div>FIELDS TERMINATED BY '\001'</div></div><div><div>LINES TERMINATED BY=
 '\n'</div></div><div><div>STORED AS TEXTFILE</div></div><div><div>LOCATION=
 '/user/hive/test';</div></div></blockquote><div><br></div><div>Select * =
from date_issue_test;</div><div><br></div><blockquote style=3D"margin:0 0 0=
 40px;border:none;padding:0px"><div><div>OK</div></div><div><div><b>1946-10=
-02</b></div></div><div><div>1946-10-02</div></div></blockquote><div><br></=
div><div>As you can see in this case it adds a day, there are a few cases =
like this.</div><div><br></div><div>Also I tried with a CAST and a fixed =
date as bellow :</div><div><br></div><blockquote style=3D"margin:0 0 0 =
40px;border:none;padding:0px"><div><div>hive&gt; select CAST('1946-10-01' =
as date) from date_issue_test limit 1;</div></div><div><div>OK</div></div><=
div><div>1946-10-02</div></div></blockquote><div><br></div><div>Any idea to=
 help me?</div><div><br></div><div>Thank you so much!=
</div><div><br></div><div><div><div class=3D"gmail_signature"><div =
dir=3D"ltr"><div dir=3D"ltr"><div style=3D"font-size:small"><p =
style=3D"margin:10px 0pt 0pt"><b>Julian</b></p></div><div =
style=3D"font-size:small"><div></div><div><br></div></div><b =
style=3D"font-size:12.8px"></b></div></div></div></div>
</div></div>
</blockquote></div>
------sinikael-?=_1-14698286608450.33429141715168953--