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 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 work here: https://issues.apache.org/jira/plugins/servlet/mobile#issue/HIVE-24814 On Fri, Jul 9, 2021, 9:49 PM Ashish Sharma wrote: > 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 > valuable feedback on the same. > > > > https://docs.google.com/document/d/1YTTPlNq3qyzlKfYVkSl3EFhVQ6-wa9WFRdkdIeCoc1Y/edit?usp=sharing > > > https://issues.apache.org/jira/browse/HIVE-25306 > > > Thank you > > Ashish Sharma >
Move Date and Timestamp parsing from ResolverStyle.LENIENT to ResolverStyle.STRICT
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 valuable feedback on the same. https://docs.google.com/document/d/1YTTPlNq3qyzlKfYVkSl3EFhVQ6-wa9WFRdkdIeCoc1Y/edit?usp=sharing https://issues.apache.org/jira/browse/HIVE-25306 Thank you Ashish Sharma
[jira] [Created] (HIVE-25321) [HMS] Alter table drop partition doesn't advance Write ID
Kishen Das created HIVE-25321: - Summary: [HMS] Alter table drop partition doesn't advance Write ID Key: HIVE-25321 URL: https://issues.apache.org/jira/browse/HIVE-25321 Project: Hive Issue Type: Sub-task Reporter: Kishen Das All DDLs should advance the write ID, so that we can provide consistent data from the cache, based on the validWriteIds. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25320) Remove hive.optimize.sort.dynamic.partition
David Mollitor created HIVE-25320: - Summary: Remove hive.optimize.sort.dynamic.partition Key: HIVE-25320 URL: https://issues.apache.org/jira/browse/HIVE-25320 Project: Hive Issue Type: Improvement Components: HiveServer2 Reporter: David Mollitor {{hive.optimize.sort.dynamic.partition}} has been replace with {{hive.optimize.sort.dynamic.partition.threshold}} . It has been marked as "deprecated", but it's actually totally defunct in the current code base. Deprecation would allow an admin to continue to use it (maybe as an alias to {{threadshold}} = 0/-1), but that is not the case here. Remove all references to "hive.optimize.sort.dynamic.partition" in the q tests and remove {{HIVEOPTSORTDYNAMICPARTITION}} all together. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25319) Allow HiveDecimalWritable to Accept Java BigDecimal
David Mollitor created HIVE-25319: - Summary: Allow HiveDecimalWritable to Accept Java BigDecimal Key: HIVE-25319 URL: https://issues.apache.org/jira/browse/HIVE-25319 Project: Hive Issue Type: Improvement Components: storage-api Reporter: David Mollitor Add support for {{set}} in {{HiveDecimalWritable}} of a Java BigDecimal value. Also, the unit tests in {{TestHiveDecimalWritable}} are really lacking. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25318) Number of initiator hosts metric should ignore manually initiated compactions
Karen Coppage created HIVE-25318: Summary: Number of initiator hosts metric should ignore manually initiated compactions Key: HIVE-25318 URL: https://issues.apache.org/jira/browse/HIVE-25318 Project: Hive Issue Type: Sub-task Affects Versions: 4.0.0 Reporter: Karen Coppage Assignee: Karen Coppage -- This message was sent by Atlassian Jira (v8.3.4#803005)