Re: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-21 Thread Stamatis Zampetakis
ft.com.invalid; sank...@apache.org; > u...@hive.apache.org; David > *Subject:* Re: [EXTERNAL] Re: Move Date and Timestamp parsing from > ResolverStyle.LENIENT to ResolverStyle.STRICT > > > > Hi all, > > > > I also feel that adding more config doesn't make sense in t

RE: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-20 Thread Sankar Hariappan
To: dev@hive.apache.org Cc: sankar.hariap...@microsoft.com.invalid; sank...@apache.org; u...@hive.apache.org; David Subject: Re: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT Hi all, I also feel that adding more config doesn't make sen

Re: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-20 Thread Ashish Sharma
> wrote: > > > >> I'm supporting this change to return "NULL" for invalid date/timestamp. > >> In the interest of backward compatibility, can we make all these changes > >> under a flag which can be enabled by default? > >> >

Re: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-13 Thread Stamatis Zampetakis
p. >> In the interest of backward compatibility, can we make all these changes >> under a flag which can be enabled by default? >> >> >> Thanks, >> Sankar >> -Original Message- >> From: David >> Sent: 10 July 2021 07:35 >&

Re: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-13 Thread David
021 07:35 > To: dev > Cc: sank...@apache.org; Stamatis Zampetakis > Subject: [EXTERNAL] Re: Move Date and Timestamp parsing from > ResolverStyle.LENIENT to ResolverStyle.STRICT > > Hello, > > I too would be in favor of this. It drastically cuts down on the test > matrix fo

RE: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-13 Thread Sankar Hariappan
: dev Cc: sank...@apache.org; Stamatis Zampetakis Subject: [EXTERNAL] Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT Hello, I too would be in favor of this. It drastically cuts down on the test matrix for Hive if we can clamp down on timestamp formats. With

Re: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-09 Thread David
Hello, I too would be in favor of this. It drastically cuts down on the test matrix for Hive if we can clamp down on timestamp formats. With that being said, I've tried this and it's a big effort. I put it down without getting consensus or buy-in or engagement on the effort. Please check out my w

Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-09 Thread Ashish Sharma
Hi, When casting incorrect date or timestamp literals to DATE or TIMESTAMP data type hive returns wrong values hive> select cast('2020-20-20' as date); OK 2021-08-20 Time taken: 4.436 seconds, Fetched: 1 row(s) I have created a solution draft. Please review the draft and provide your valuabl

[jira] [Created] (HIVE-25306) Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT

2021-07-05 Thread Ashish Sharma (Jira)
Ashish Sharma created HIVE-25306: Summary: Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT Key: HIVE-25306 URL: https://issues.apache.org/jira/browse/HIVE-25306