You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2021/11/04 02:11:49 UTC

[GitHub] [pinot] ashishkf opened a new issue #7701: Support NOT operator

ashishkf opened a new issue #7701:
URL: https://github.com/apache/pinot/issues/7701


   Filing this issue based on slack discussion with @Jackie-Jiang.
   
   Pinot does not support REGEXP_NOT_LIKE - w/o NOT operator it is hard to write queries that filter out rows that match a given REGEXP.


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961227861


   We should not target specific operators for NOT -- rather, have a generic NOT operator which can apply the inverse predicate.
   
   @Jackie-Jiang Does that make sense?


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-969965539


   JFYI, I will be working on this


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] mcvsubbu commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
mcvsubbu commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961320567


   > I don't think this is specific to regexp indices
   
   Ah ok


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] mcvsubbu commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
mcvsubbu commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961251642


   With support for text index, does it make sense for adding more features to the regexp functionality?


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] mcvsubbu commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
mcvsubbu commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961251642






-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris closed issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris closed issue #7701:
URL: https://github.com/apache/pinot/issues/7701


   


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961239622


   Ack. Shall I take a shot at this?


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961310506


   I don't think this is specific to regexp indices


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] mcvsubbu commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
mcvsubbu commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961320567


   > I don't think this is specific to regexp indices
   
   Ah ok


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961227861






-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] atris commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
atris commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-1031856452


   https://github.com/apache/pinot/pull/8148


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] ashishkf commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
ashishkf commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-1031842477


   > JFYI, I will be working on this
   
   Any timeline for this?


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] Jackie-Jiang commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961237810


   @atris Yes. I think the purpose of this issue is to add the generic NOT operator (similar to AND/OR). The lack of REGEXP_NOT_LIKE is the trigger of the issue.


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


[GitHub] [pinot] Jackie-Jiang commented on issue #7701: Support NOT operator

Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #7701:
URL: https://github.com/apache/pinot/issues/7701#issuecomment-961237810


   @atris Yes. I think the purpose of this issue is to add the generic NOT operator (similar to AND/OR). The lack of REGEXP_NOT_LIKE is the trigger of the issue.


-- 
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: commits-unsubscribe@pinot.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org