[GitHub] [arrow-datafusion] Dandandan edited a comment on pull request #508: add expr::like and expr::notlike to pruning logic

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

Dandandan edited a comment on pull request #508:
URL: https://github.com/apache/arrow-datafusion/pull/508#issuecomment-855260595


   @nevi-me 
   
   I did some checking with data from TPC-H:
   
   Before:
   
   ```
   CREATE EXTERNAL TABLE T STORED AS PARQUET LOCATION '../benchmarks/parquet/lineitem';
   select l_orderkey from T where l_comment like '1%';
   0 rows in set. Query took 150 milliseconds.
   > 
   select l_orderkey from T where l_comment like '{%';
   0 rows in set. Query took 143 milliseconds.
   ```
   
   After:
   ```
   CREATE EXTERNAL TABLE T STORED AS PARQUET LOCATION '../benchmarks/parquet/lineitem';
   select l_orderkey from T where l_comment like '1%';
   0 rows in set. Query took 148 milliseconds.
   > 
   select l_orderkey from T where l_comment like '{%';
   0 rows in set. Query took 43 milliseconds.
   ```
   
   So looks like 👍


-- 
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.

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