[CALCITE-6814] Support weekofyear fucntions for Hive #14737

Job	Run time
Windows (JDK 8)	6m 29s
Windows (JDK 17)	6m 29s
Linux (JDK 11, Avatica main)	6m 28s
Linux (JDK 11, Pacific/Chatham Timezone)	3m 57s
ErrorProne (JDK 11, latest Guava)	2m 39s
Linux (JDK 21)	5m 59s
Linux (JDK 23)	4m 8s
Linux (JDK 17)	3m 54s
Linux (JDK 8, oldest Guava, America/New_York Timezone)	4m 15s
Linux (JDK 8, latest Guava, America/New_York Timezone)	4m 16s
macOS (JDK 21)	4m 14s
Windows (JDK 21)	6m 29s
CheckerFramework (JDK 11)	4m 14s
CheckerFramework (JDK 11, oldest Guava)	4m 16s
Druid Tests	4m 15s
Linux (JDK 8) Slow Tests	0s
	1h 12m 2s

Provide feedback