[jira] [Created] (PHOENIX-3830) Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10
Sean created PHOENIX-3830: - Summary: Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10 Key: PHOENIX-3830 URL: https://issues.apache.org/jira/browse/PHOENIX-3830 Project: Phoenix Issue Type: Bug Affects Versions: 4.10.0 Reporter: Sean Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10 Dataset: Install the package sample data. Sql: SELECT HOST, DOMAIN, FEATURE, DATE, CORE, DB, ACTIVE_VISITOR FROM WEB_STAT T WHERE CORE> 100 ORDER BY CORE -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (PHOENIX-3830) Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10
[ https://issues.apache.org/jira/browse/PHOENIX-3830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean updated PHOENIX-3830: -- Description: Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10.0-HBase-1.2 Dataset: Install the package sample data. Sql: SELECT HOST, DOMAIN, FEATURE, DATE, CORE, DB, ACTIVE_VISITOR FROM WEB_STAT T WHERE CORE> 100 ORDER BY CORE was: Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10 Dataset: Install the package sample data. Sql: SELECT HOST, DOMAIN, FEATURE, DATE, CORE, DB, ACTIVE_VISITOR FROM WEB_STAT T WHERE CORE> 100 ORDER BY CORE > Phoenix in the condition query and sort, will lead to the query is very slow. > Version: 4.10 > --- > > Key: PHOENIX-3830 > URL: https://issues.apache.org/jira/browse/PHOENIX-3830 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.10.0 >Reporter: Sean > > Phoenix in the condition query and sort, will lead to the query is very slow. > Version: 4.10.0-HBase-1.2 > Dataset: Install the package sample data. > Sql: SELECT HOST, DOMAIN, FEATURE, DATE, CORE, DB, ACTIVE_VISITOR FROM > WEB_STAT T WHERE CORE> 100 ORDER BY CORE -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (PHOENIX-3830) Phoenix in the condition query and sort, will lead to the query is very slow. Version: 4.10
[ https://issues.apache.org/jira/browse/PHOENIX-3830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16005814#comment-16005814 ] Sean commented on PHOENIX-3830: --- I raised this question in version 4.9.0 without this problem. I do not think it is optimization. > Phoenix in the condition query and sort, will lead to the query is very slow. > Version: 4.10 > --- > > Key: PHOENIX-3830 > URL: https://issues.apache.org/jira/browse/PHOENIX-3830 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.10.0 >Reporter: Sean > > Phoenix in the condition query and sort, will lead to the query is very slow. > Version: 4.10.0-HBase-1.2 > Dataset: Install the package sample data. > Sql: SELECT HOST, DOMAIN, FEATURE, DATE, CORE, DB, ACTIVE_VISITOR FROM > WEB_STAT T WHERE CORE> 100 ORDER BY CORE -- This message was sent by Atlassian JIRA (v6.3.15#6346)