[CALCITE-6241] Enable a few existing functions to hive library #13503

Job	Run time
Windows (JDK 17)	14m 47s
Windows (JDK 8)	16m 29s
Linux (JDK 8), oldest Guava, America/New_York Timezone	10m 49s
Windows (JDK 21)	13m 51s
Linux (JDK 11), Pacific/Chatham Timezone	10m 25s
Linux (JDK 21)	12m 18s
Linux (JDK 17)	10m 11s
Linux (JDK 8), latest Guava, America/New_York Timezone	11m 55s
Error Prone (JDK 11), latest Guava	4m 13s
Linux (JDK 11), Avatica main	12m 26s
CheckerFramework (JDK 11)	10m 49s
CheckerFramework (JDK 11), oldest Guava	10m 46s
Linux (JDK 22)	10m 16s
macOS (JDK 21)	37m 59s
Druid Tests	6m 52s
Linux (JDK 8) Slow Tests	0s
	3h 14m 6s

Provide feedback