pinot icon indicating copy to clipboard operation
pinot copied to clipboard

Published 20 hours ago • verified publisher icon apache

Proper support for filter in SELECT clause, IS TRUE/FALSE, and use boolean expression as predicate

Open nizarhejazi opened this issue 2 years ago • 4 comments

  1. NOT IN. select * from job where id not in ('') -- This query already works select id not in ('') from job -- This query does not work

  2. NOT BETWEEN a AND b

  3. IS NOT TRUE, IS NOT FALSE Note: This requires supporting IS TRUE, and IS FALSE

  4. NOT boolean_function. Examples: NOT STARTSWITH(...)

nizarhejazi avatar Aug 15 '22 19:08 nizarhejazi

We already have NOT operator support (introduced in #7701). Some fixes (#8366, #8331) are not released yet, but with the current master it should work.

The ask in this ticket is not really about NOT operator, but:

  1. Filter in select clause (udf that returns boolean)
  2. Already supported
  3. IS TRUE/FALSE support
  4. Use boolean expression as the predicate

Jackie-Jiang avatar Aug 15 '22 21:08 Jackie-Jiang

Updated issue title.

nizarhejazi avatar Aug 15 '22 21:08 nizarhejazi

  1. Use boolean expression as the predicate

I believe we already have support for this in filter through https://github.com/apache/pinot/pull/8518 Am I missing something @Jackie-Jiang ?

vvivekiyer avatar Aug 15 '22 22:08 vvivekiyer

@vvivekiyer Thanks for reminding me! Yes, it should already be handled

Jackie-Jiang avatar Aug 15 '22 23:08 Jackie-Jiang