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 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

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
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

2021-07-09 Thread Kishen Das (Jira)
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

2021-07-09 Thread David Mollitor (Jira)
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

2021-07-09 Thread David Mollitor (Jira)
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

2021-07-09 Thread Karen Coppage (Jira)
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)