hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-12092) SARGS: UDFLike prefix cases needs to be translated into >= sargs
Date Wed, 04 Nov 2015 20:22:27 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14990328#comment-14990328
] 

Sergey Shelukhin edited comment on HIVE-12092 at 11/4/15 8:21 PM:
------------------------------------------------------------------

{noformat}
+      if (constValue != null) {
+      }
{noformat} should return something.

Also as far as I understand it doesn't take care of double backslash correctly. State machine
with substring at the end might be better.

Also perhaps there's a better way than a static method with type check to call searchArgument.
Perhaps it can just be callable on GenericUDF, null by default, and the Bridge would delegate
to UDFLike if the class is correct? Or something.
Or, I wonder if it could just be done when creating SARG from UDF, so that SARG-specific code
stays SARG-specific without Hive making assumptions about what SARG can and cannot do? There
may be a good reason to not do it this way, I just wonder if there is


was (Author: sershe):
{noformat}
+      if (constValue != null) {
+      }
{noformat} should return something.

Also as far as I understand it doesn't take care of double backslash correctly. State machine
with substring at the end might be better.

Also perhaps there's a better way than a static method with type check to call searchArgument.
Perhaps it can just be callable on GenericUDF, null by default, and the Bridge would delegate
to UDFLike if the class is correct? Or something.
Or, I wonder if it could just be done when creating SARG from UDF, so that SARG-specific code
stays SARG-specific without Hive making assumptions about what SARG can and cannot do? There
may be a good reason to not do it this way, I just wonder.

> SARGS: UDFLike prefix cases needs to be translated into >= sargs
> ----------------------------------------------------------------
>
>                 Key: HIVE-12092
>                 URL: https://issues.apache.org/jira/browse/HIVE-12092
>             Project: Hive
>          Issue Type: Improvement
>          Components: Logical Optimizer
>    Affects Versions: 1.3.0, 2.0.0
>            Reporter: Gopal V
>            Assignee: Gopal V
>         Attachments: HIVE-12092.1.patch
>
>
> A query which follows the following format
> {{select * from table where access_url like "https:%" ;}}
> needs to rewrite SARGs as 
> {{access_url >= 'https:'}}
> to get a significant hit-rate on a simple expression.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message