[ 
https://issues.apache.org/jira/browse/IMPALA-14655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18082818#comment-18082818
 ] 

ASF subversion and git services commented on IMPALA-14655:
----------------------------------------------------------

Commit 7dfcd667d53b35e1ac04be112a19bb8f5f4b6203 in impala's branch 
refs/heads/master from Pranav Lodha
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=7dfcd667d ]

IMPALA-14655: Set Postgres DateStyle for JDBC test data load

This patch explicitly pass DateStyle=ISO,MDY to the psql
session used for JDBC test data COPY to avoid locale-dependent
date parsing failures. In non-US environments (e.g. IST/EU),
Postgres defaults to DMY and fails on values like 01/13/09
with “date/time field value out of range”.

This change makes the JDBC test data load consistent
across timezones and locales.

Change-Id: Ia80464c9a15da37583ae09ab1cf23b2436a65721
Reviewed-on: http://gerrit.cloudera.org:8080/23821
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Set Postgres DateStyle for JDBC test data load
> ----------------------------------------------
>
>                 Key: IMPALA-14655
>                 URL: https://issues.apache.org/jira/browse/IMPALA-14655
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Pranav Yogi Lodha
>            Priority: Major
>
> Postgres defaults to DMY and fails on values like 01/13/09 with “date/time 
> field value out of range”. Need to explicitly set postgres datestyle.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to