2010YOUY01 commented on issue #11752: URL: https://github.com/apache/datafusion/issues/11752#issuecomment-2308176932
Do we have tickets for regexp binary operators? (like `~`, `!~`...) https://datafusion.apache.org/user-guide/sql/operators.html#op-re-match I noticed stringview is not supported on them yet and they have separate implementation than regexp functions <details><summary>Details</summary> <p> ``` /*DML*/CREATE TABLE t0(v0 DOUBLE, v1 DOUBLE, v2 BOOLEAN, v3 BOOLEAN, v4 BOOLEAN, v5 STRING); /*DML*/INSERT INTO t0(v1, v5, v2) VALUES (0.7183242196192607, 'Tn', true); /*DML*/CREATE TABLE t0_stringview AS SELECT v0, v1, v2, v3, v4, arrow_cast(v5, 'Utf8View') as v5 FROM t0; > select v5 ~ 'foo' from t0_stringview; Internal error: Data type Utf8View not supported for binary_string_array_flag_op_scalar operation 'regexp_is_match' on string array. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker > select regexp_match(v5, 'foo') from t0_stringview; +--------------------------------------------+ | regexp_match(t0_stringview.v5,Utf8("foo")) | +--------------------------------------------+ | | +--------------------------------------------+ 1 row(s) fetched. Elapsed 0.034 seconds. ``` </p> </details> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
