[jira] [Updated] (HIVE-17038) invalid CAST result

2017-07-05 Thread Jim Hopper (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-17038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jim Hopper updated HIVE-17038:
--
Affects Version/s: 1.2.1
  Component/s: Hive
   CLI

> invalid CAST result
> ---
>
> Key: HIVE-17038
> URL: https://issues.apache.org/jira/browse/HIVE-17038
> Project: Hive
>  Issue Type: Bug
>  Components: CLI, Hive
>Affects Versions: 1.2.1
>Reporter: Jim Hopper
>
> when casting incorrect date literals to DATE data type hive returns wrong 
> values instead of NULL.
> {code}
> SELECT CAST('2017-02-31' AS DATE);
> SELECT CAST('2017-05-31' AS DATE);
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Updated] (HIVE-17038) invalid CAST result

2017-07-05 Thread Jim Hopper (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-17038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jim Hopper updated HIVE-17038:
--
Description: 
when casting incorrect date literals to DATE data type hive returns wrong 
values instead of NULL.

{code}

SELECT CAST('2017-02-31' AS DATE);
SELECT CAST('2017-05-31' AS DATE);

{code}


  was:
when casting incorrect date literals to DATE data type hive returns wrong 
values instead of NULL.

{code}

SELECT CAST('2017-05-31' AS DATE);

{code}



> invalid CAST result
> ---
>
> Key: HIVE-17038
> URL: https://issues.apache.org/jira/browse/HIVE-17038
> Project: Hive
>  Issue Type: Bug
>Reporter: Jim Hopper
>
> when casting incorrect date literals to DATE data type hive returns wrong 
> values instead of NULL.
> {code}
> SELECT CAST('2017-02-31' AS DATE);
> SELECT CAST('2017-05-31' AS DATE);
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)