[jira] [Commented] (PHOENIX-1062) A SQL Trimmer for log sql execute times

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-1062:
---------------------------------------

Can you explain the use case for needing a tool to convert statements in this way?

> A SQL Trimmer for log sql execute times
> ---------------------------------------
>
>                 Key: PHOENIX-1062
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1062
>             Project: Phoenix
>          Issue Type: New Feature
>    Affects Versions: 3.0.0
>            Reporter: jay wong
>            Priority: Critical
>             Fix For: 3.1
>
>         Attachments: SQLTrimmer.java
>
>
> If we need a statistics that which sql execute times
> just like : select a,b,c from table1 where d=13 and e='abc' limit 20;
> but the condition value is not needed because of overlap
> so the will be trim as : select a,b,c from table1 where d=? and e=? limit ?;
> Now the tool fix it



--
This message was sent by Atlassian JIRA
(v6.2#6252)