[jira] [Commented] (PHOENIX-4585) Prune local index regions used for join queries

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367616#comment-16367616 ] James Taylor commented on PHOENIX-4585: --- Thanks for the patch, [~maryannxue]. Here

[jira] [Commented] (PHOENIX-3837) Unable to set property on an index with Alter statement

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367619#comment-16367619 ] James Taylor commented on PHOENIX-3837: --- FYI, [~rajeshbabu] & [~elserj] - I notice

[jira] [Created] (PHOENIX-4615) Anonymous derived table causes NPE in join queries

2018-02-16 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4615: Summary: Anonymous derived table causes NPE in join queries Key: PHOENIX-4615 URL: https://issues.apache.org/jira/browse/PHOENIX-4615 Project: Phoenix Issue

[jira] [Commented] (PHOENIX-4585) Prune local index regions used for join queries

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367713#comment-16367713 ] Maryann Xue commented on PHOENIX-4585: -- {quote}How about adding a UNION ALL test to

[jira] [Created] (PHOENIX-4616) Move join query optimization out from QueryCompiler into QueryOptimizer

2018-02-16 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4616: Summary: Move join query optimization out from QueryCompiler into QueryOptimizer Key: PHOENIX-4616 URL: https://issues.apache.org/jira/browse/PHOENIX-4616 Project: Ph

[jira] [Commented] (PHOENIX-3837) Unable to set property on an index with Alter statement

2018-02-16 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367725#comment-16367725 ] Ethan Wang commented on PHOENIX-3837: - [~jamestaylor] [~elserj] Let me know if we w

[jira] [Commented] (PHOENIX-3837) Unable to set property on an index with Alter statement

2018-02-16 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367734#comment-16367734 ] Josh Elser commented on PHOENIX-3837: - [~aertoria], [~jamestaylor], thanks for the p

[jira] [Commented] (PHOENIX-4585) Prune local index regions used for join queries

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367771#comment-16367771 ] Maryann Xue commented on PHOENIX-4585: -- {quote}Not a huge deal, but do you think it

[jira] [Updated] (PHOENIX-4617) Make sure QueryPlan.getSourceRefs() get all data table refs for join queries and sub-queries

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4617: - Issue Type: Bug (was: Improvement) > Make sure QueryPlan.getSourceRefs() get all data table ref

[jira] [Created] (PHOENIX-4617) Make sure QueryPlan.getSourceRefs() get all data table refs for join queries and sub-queries

2018-02-16 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4617: Summary: Make sure QueryPlan.getSourceRefs() get all data table refs for join queries and sub-queries Key: PHOENIX-4617 URL: https://issues.apache.org/jira/browse/PHOENIX-4617

[jira] [Commented] (PHOENIX-4592) BaseResultIterators.getStatsForParallelizationProp() should use retry looking up the table without tenantId if cannot find the table using the tenantId

2018-02-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367888#comment-16367888 ] Hudson commented on PHOENIX-4592: - FAILURE: Integrated in Jenkins build Phoenix-4.x-HBas

[jira] [Commented] (PHOENIX-4592) BaseResultIterators.getStatsForParallelizationProp() should use retry looking up the table without tenantId if cannot find the table using the tenantId

2018-02-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367936#comment-16367936 ] Hudson commented on PHOENIX-4592: - FAILURE: Integrated in Jenkins build Phoenix-4.x-HBas

[jira] [Commented] (PHOENIX-4585) Prune local index regions used for join queries

2018-02-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367937#comment-16367937 ] Hudson commented on PHOENIX-4585: - FAILURE: Integrated in Jenkins build Phoenix-4.x-HBas

[jira] [Updated] (PHOENIX-4333) Incorrect estimate when stats are updated on a tenant specific view

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4333: -- Labels: stats (was: ) > Incorrect estimate when stats are updated on a tenant specific view >

[jira] [Updated] (PHOENIX-4333) Incorrect estimate when stats are updated on a tenant specific view

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4333: -- Labels: SFDC stats (was: stats) > Incorrect estimate when stats are updated on a tenant speci

[jira] [Updated] (PHOENIX-4333) Incorrect estimate when stats are updated on a tenant specific view

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4333: -- Summary: Incorrect estimate when stats are updated on a tenant specific view (was: Stats - In

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367998#comment-16367998 ] Maryann Xue commented on PHOENIX-4611: -- I don't think that commit would do any actu

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368018#comment-16368018 ] James Taylor commented on PHOENIX-4611: --- bq. BTW, do we have any test facility tha

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368026#comment-16368026 ] Maryann Xue commented on PHOENIX-4611: -- Sorry, [~jamestaylor], I made a mistake in

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368034#comment-16368034 ] James Taylor commented on PHOENIX-4611: --- Yes, it'd be expected that the GROUP BY k

[jira] [Created] (PHOENIX-4618) Optimize out order-by on sort-merge-join when possible

2018-02-16 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4618: Summary: Optimize out order-by on sort-merge-join when possible Key: PHOENIX-4618 URL: https://issues.apache.org/jira/browse/PHOENIX-4618 Project: Phoenix Is

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368052#comment-16368052 ] Maryann Xue commented on PHOENIX-4611: -- Sorry for the confusion, [~jamestaylor]. No

[jira] [Comment Edited] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368052#comment-16368052 ] Maryann Xue edited comment on PHOENIX-4611 at 2/17/18 1:41 AM: ---

[jira] [Commented] (PHOENIX-4611) Not nullable column impact on join query plans

2018-02-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16368133#comment-16368133 ] Hudson commented on PHOENIX-4611: - FAILURE: Integrated in Jenkins build Phoenix-4.x-HBas