[jira] [Commented] (PHOENIX-3344) Indicate local index usage in explain plan
[ https://issues.apache.org/jira/browse/PHOENIX-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15707695#comment-15707695 ] Rajeshbabu Chintaguntla commented on PHOENIX-3344: -- [~jamestaylor] Last week discussed about this with [~gabriel.reid]. Will do it in Phoenix as well. > Indicate local index usage in explain plan > -- > > Key: PHOENIX-3344 > URL: https://issues.apache.org/jira/browse/PHOENIX-3344 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Rajeshbabu Chintaguntla >Priority: Minor > Fix For: 4.10.0 > > > The query plan is not clear at all that a local indexes is being used: > {code} > WAY RANGE SCAN OVER my_table [1, 'foo'] > {code} > Instead, we should show something like this: > {code} > WAY RANGE SCAN OVER LOCAL INDEX my_local_index ON my_table [1, 'foo'] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (PHOENIX-3344) Indicate local index usage in explain plan
[ https://issues.apache.org/jira/browse/PHOENIX-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15707235#comment-15707235 ] James Taylor commented on PHOENIX-3344: --- Re-ping. [~rajeshbabu]? > Indicate local index usage in explain plan > -- > > Key: PHOENIX-3344 > URL: https://issues.apache.org/jira/browse/PHOENIX-3344 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Rajeshbabu Chintaguntla >Priority: Minor > Fix For: 4.10.0 > > > The query plan is not clear at all that a local indexes is being used: > {code} > WAY RANGE SCAN OVER my_table [1, 'foo'] > {code} > Instead, we should show something like this: > {code} > WAY RANGE SCAN OVER LOCAL INDEX my_local_index ON my_table [1, 'foo'] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (PHOENIX-3344) Indicate local index usage in explain plan
[ https://issues.apache.org/jira/browse/PHOENIX-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15688253#comment-15688253 ] James Taylor commented on PHOENIX-3344: --- Ping, [~rajeshbabu] - would it be possible to do this one, coordinated with the work that [~gabriel.reid] is doing on PHOENIX-3471? > Indicate local index usage in explain plan > -- > > Key: PHOENIX-3344 > URL: https://issues.apache.org/jira/browse/PHOENIX-3344 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Rajeshbabu Chintaguntla >Priority: Minor > Fix For: 4.10.0 > > > The query plan is not clear at all that a local indexes is being used: > {code} > WAY RANGE SCAN OVER my_table [1, 'foo'] > {code} > Instead, we should show something like this: > {code} > WAY RANGE SCAN OVER LOCAL INDEX my_local_index ON my_table [1, 'foo'] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (PHOENIX-3344) Indicate local index usage in explain plan
[ https://issues.apache.org/jira/browse/PHOENIX-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543106#comment-15543106 ] James Taylor commented on PHOENIX-3344: --- WDYT, [~chrajeshbab...@gmail.com]? If changing explain plans in all tests is too painful, you can add a config that's off for tests (but on otherwise), similar to what we did with {{phoenix.explain.displayChunkCount}}. > Indicate local index usage in explain plan > -- > > Key: PHOENIX-3344 > URL: https://issues.apache.org/jira/browse/PHOENIX-3344 > Project: Phoenix > Issue Type: Improvement >Reporter: James Taylor >Assignee: Rajeshbabu Chintaguntla >Priority: Minor > Fix For: 4.9.0 > > > The query plan is not clear at all that a local indexes is being used: > {code} > WAY RANGE SCAN OVER my_table [1, 'foo'] > {code} > Instead, we should show something like this: > {code} > WAY RANGE SCAN OVER LOCAL INDEX my_local_index ON my_table [1, 'foo'] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)