[Epic] A Collection of Additional UTF8View support tickets

[alamb]

Is your feature request related to a problem or challenge?

@Omega359 / @timsaucer have found that there are still some functions / workloads that don't work with Utf8View. This ticket is an attempt to organize them

Tasks

• Update REGEXP_MATCH scalar function to support Utf8View #11911
• Regression in 43.0.0: coalesce no longer works between Utf8 and Utf8View columns #13568
• String sqllogictest error when running the test with complete #12752
• feat: Support Utf8View for get_wider_type + binary_to_string_coercion functions #13370
• fix: Support Utf8View in numeric_string_coercion #13366
• Add support for Utf8View to crypto functions #13407
• Read string as Utf8View in sqllogictest #13408
• Support Utf8View for string function bit_length() #13221
• add support for utf8view type to NullIf function #13379
• Add support for string view to a few functions #13330
• Add support for Utf8View to string_to_array and array_to_string #13403
• get_wider_type in binary.rs does not support utf8view #13360
• Fix concat simplifier for Utf8View types #13346

[Omega359]

Related arrow-rs tickets:

• Support Temporal -> Utf8View casting arrow-rs#6734
• Support Numeric -> Utf8View casting arrow-rs#6714
• Support Utf8View <=> boolean casting arrow-rs#6713
• implement regexp_match, regexp_scalar_match and regexp_array_match for StringViewArray arrow-rs#6717
• Add support for Utf8View -> numeric in can_cast_types arrow-rs#6715

[alamb]

I will put those on my list to review shortly

[alamb]

Update here is that many of these remaining issues seem to be waiting on an upgrade to arrow-rs. Hopefully we'll get a fix out in the next week or two

[alamb]

BTW these items can be worked around if you disable the following config setting:

https://datafusion.apache.org/user-guide/configs.html

datafusion.execution.parquet.schema_force_view_types