I am S from the analytics team. Are you all familiar with BigQuery's text generation AI functions? These are new functions released about half a year ago, and since there is still little knowledge ...
hllpp_init_string UDTF HLL_COUNT.INIT(STRING) (VARCHAR) → TABLE(sketch BINARY) hllpp_init_long UDTF HLL_COUNT.INIT(INT64) (NUMBER) → TABLE(sketch BINARY) hllpp_init_bytes UDTF HLL_COUNT.INIT(BYTES) ...