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

ASF GitHub Bot commented on PHOENIX-514:
----------------------------------------

Github user JamesRTaylor commented on a diff in the pull request:

    https://github.com/apache/phoenix/pull/34#discussion_r23670722
  
    --- Diff: 
phoenix-core/src/main/java/org/apache/phoenix/expression/Expression.java ---
    @@ -88,4 +88,9 @@
          * @return
          */
         boolean requiresFinalEvaluation();
    +    
    +    /**
    +     * @return the estimated size in bytes of the expression when 
serialized
    +     */
    +    int getEstimatedByteSize();
    --- End diff --
    
    I think this may not be worth adding, as the more methods we have here, the 
higher the burden of adding new expressions. The only place we use this is for 
the IndexMaintainer to serialize it's bytes (true?), but we'll likely move 
toward Protobufs in the next major release. Could we have a crude estimate 
instead? Maybe based on total number of expressions in the tree (which we could 
track in ExpressionCompiler in this method (by just have a totalNodeCount 
member variable, incrementing it here by one, and resetting it to zero in 
reset()):
    
         @Override
        public void addElement(List<Expression> l, Expression element) {
            nodeCount--;
            l.add(element);
        }
    
    Thoughts? 


> Support functional indexes
> --------------------------
>
>                 Key: PHOENIX-514
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-514
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>            Assignee: Thomas D'Silva
>              Labels: enhancement
>
> Instead of only defining the set of columns from the data table that make up 
> an index, you should be able to use expressions.  For example:
>       CREATE INDEX upper_last_name_idx ON person (UPPER(last_name))
> Then in queries that use UPPER(last_name), we can replace them with column 
> references to the index table.



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

Reply via email to