You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "SimonSchneider (via GitHub)" <gi...@apache.org> on 2023/04/06 11:42:02 UTC

[GitHub] [arrow-datafusion] SimonSchneider opened a new issue, #5893: like and ilike not supported for `LargeUtf8`

SimonSchneider opened a new issue, #5893:
URL: https://github.com/apache/arrow-datafusion/issues/5893

   ### Describe the bug
   
   I'm trying to run an SQL query using ilike/like but it gives me the following error:
   ```
   Data type LargeUtf8 not supported for scalar operation 'like' 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
   ```
   The error seems to originate [here](https://github.com/apache/arrow-datafusion/blob/5c0fe0d7ebe0b205ce10c2b07ee2230ff3df6cba/datafusion/physical-expr/src/expressions/like.rs#L210)
   
   
   
   ### To Reproduce
   
   given a table `test` with a column `a` of type `LargeUtf8` the following SQL query will fail
   ```sql
   SELECT a FROM test WHERE "a" like '%something%';
   
   SELECT a FROM test WHERE "a" ilike '%something%';
   ```
   
   ### Expected behavior
   
   I'd expect to be able to do an ilike query on a `LargeUtf8` column.
   
   ### Additional context
   
   _No response_


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] jackwener closed issue #5893: like and ilike not supported for `LargeUtf8`

Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener closed issue #5893: like and ilike not supported for `LargeUtf8`
URL: https://github.com/apache/arrow-datafusion/issues/5893


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] jackwener commented on issue #5893: like and ilike not supported for `LargeUtf8`

Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on issue #5893:
URL: https://github.com/apache/arrow-datafusion/issues/5893#issuecomment-1499141819

   ```sql
   select arrow_cast('foo', 'LargeUtf8') like '%foo%';
   ```


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org