[GitHub] [iceberg] cccs-eric commented on issue #1952: Failure evaluating expressions for NOT + STARTS_WITH predicate

[GitBox <gi...@apache.org>]

cccs-eric commented on issue #1952:
URL: https://github.com/apache/iceberg/issues/1952#issuecomment-983573754


   I ran into the same issue while trying to run a SQL query using Spark against an Iceberg table.  It crashed with the same error: `IllegalArgumentException: No negation for operation: STARTS_WITH`.  I ran the following query in a Jupyter Notebook:
   ```
   %%sparksql --view bug --cache
   SELECT
       *
   FROM
       namespace.my_table AS tbl
   WHERE
       tbl.aDate > CURRENT_DATE() - INTERVAL 10 DAYS
       AND tbl.activityDisplayName = 'Update user'
       AND rawJSON LIKE '%SourceAnchor%'
       AND displayName NOT LIKE 'Sync%'
   ```
   
   If I create a temporary table in Spark using one or some of the table data files and issue the same query, it works.  So it really is when Iceberg is in play.


-- 
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: issues-unsubscribe@iceberg.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org