[jira] [Resolved] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-24 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-4692. -- Resolution: Fixed > ArrayIndexOutOfBoundsException in ScanRanges.intersectScan > -

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16481382#comment-16481382 ] Maryann Xue commented on PHOENIX-4666: -- Thank you for the update, [~ortutay]! I am

[jira] [Commented] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16481015#comment-16481015 ] Maryann Xue commented on PHOENIX-4692: -- [~jamestaylor] and [~sergey.soldatov], I ha

[jira] [Updated] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4692: - Attachment: PHOENIX-4692_v2.patch > ArrayIndexOutOfBoundsException in ScanRanges.intersectScan >

[jira] [Updated] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4692: - Attachment: (was: PHOENIX-4692_v2.patch) > ArrayIndexOutOfBoundsException in ScanRanges.inte

[jira] [Updated] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4692: - Attachment: PHOENIX-4692_v2.patch > ArrayIndexOutOfBoundsException in ScanRanges.intersectScan >

[jira] [Commented] (PHOENIX-4692) ArrayIndexOutOfBoundsException in ScanRanges.intersectScan

2018-05-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16480275#comment-16480275 ] Maryann Xue commented on PHOENIX-4692: -- So I guess here "dynamic filter" kicked in

[jira] [Comment Edited] (PHOENIX-4724) Efficient Equi-Depth histogram for streaming data

2018-05-09 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16469198#comment-16469198 ] Maryann Xue edited comment on PHOENIX-4724 at 5/9/18 5:57 PM:

[jira] [Commented] (PHOENIX-4724) Efficient Equi-Depth histogram for streaming data

2018-05-09 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16469198#comment-16469198 ] Maryann Xue commented on PHOENIX-4724: -- Yes, I agree with [~jamestaylor] that this

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16445048#comment-16445048 ] Maryann Xue commented on PHOENIX-4666: -- Thank you for the PR, [~ortutay]! Looking a

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16438067#comment-16438067 ] Maryann Xue commented on PHOENIX-4666: -- Sounds good! Please remember to add more te

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16437911#comment-16437911 ] Maryann Xue commented on PHOENIX-4666: -- No, you might wanna do it from the compilat

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16437881#comment-16437881 ] Maryann Xue commented on PHOENIX-4666: -- Thank you for explaining 2! And now it's cl

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16436978#comment-16436978 ] Maryann Xue commented on PHOENIX-4666: -- Thank you very much for your work, [~ortuta

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-04-11 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16434855#comment-16434855 ] Maryann Xue commented on PHOENIX-4666: -- Yes, sure. > Add a subquery cache that per

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

2018-04-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16428009#comment-16428009 ] Maryann Xue commented on PHOENIX-4616: -- [~jamestaylor], I fixed it on master branch

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

2018-04-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16427698#comment-16427698 ] Maryann Xue commented on PHOENIX-4616: -- Sorry that I didn't notice the error. Looki

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

2018-04-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4616: - Fix Version/s: 5.0.0 4.14.0 > Move join query optimization out from QueryComp

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

2018-04-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-4617. -- Resolution: Fixed Fix Version/s: 5.0.0 4.14.0 Fixed by PHOENIX-4616.

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

2018-03-26 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414243#comment-16414243 ] Maryann Xue commented on PHOENIX-4616: -- I tried it, [~jamestaylor], but it did not

[jira] [Commented] (PHOENIX-4666) Add a subquery cache that persists beyond the life of a query

2018-03-21 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16408676#comment-16408676 ] Maryann Xue commented on PHOENIX-4666: -- Here's my initial thought: # As opposed to

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

2018-03-14 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399915#comment-16399915 ] Maryann Xue commented on PHOENIX-4611: -- Thank you very much for reminding me, [~jam

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

2018-03-14 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399053#comment-16399053 ] Maryann Xue commented on PHOENIX-4616: -- As one of the potential improvements I ment

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

2018-03-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16398098#comment-16398098 ] Maryann Xue commented on PHOENIX-4585: -- Done. All 5.x and 4.x branches have been sy

[jira] [Commented] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-03-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16398099#comment-16398099 ] Maryann Xue commented on PHOENIX-1556: -- Done. All 5.x and 4.x branches have been sy

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

2018-03-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16398095#comment-16398095 ] Maryann Xue commented on PHOENIX-4611: -- Done. All 5.x and 4.x branches have been sy

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

2018-03-07 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16390795#comment-16390795 ] Maryann Xue commented on PHOENIX-4616: -- Thank you very much for the review, [~james

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

2018-02-23 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4616: - Attachment: PHOENIX-4616.patch > Move join query optimization out from QueryCompiler into QueryO

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

2018-02-23 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4616: - Attachment: (was: PHOENIX-4616.patch) > Move join query optimization out from QueryCompiler

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

2018-02-23 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4616: - Attachment: PHOENIX-4616.patch > Move join query optimization out from QueryCompiler into QueryO

[jira] [Commented] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2018-02-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369776#comment-16369776 ] Maryann Xue commented on PHOENIX-4437: -- Thank you, [~rajeshbabu], for reminding me!

[jira] [Commented] (PHOENIX-3050) Handle DESC columns in child/parent join optimization

2018-02-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369775#comment-16369775 ] Maryann Xue commented on PHOENIX-3050: -- Thank you, [~rajeshbabu], for reminding me!

[jira] [Commented] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369777#comment-16369777 ] Maryann Xue commented on PHOENIX-1556: -- Thank you, [~rajeshbabu], for reminding me!

[jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2018-02-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369774#comment-16369774 ] Maryann Xue commented on PHOENIX-4322: -- Thank you, [~rajeshbabu], for reminding me!

[jira] [Commented] (PHOENIX-4288) Indexes not used when ordering by primary key

2018-02-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16369773#comment-16369773 ] Maryann Xue commented on PHOENIX-4288: -- Thank you, [~rajeshbabu], for reminding me.

[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 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] [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=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 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] [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] [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] [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] [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-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-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] [Updated] (PHOENIX-4585) Prune local index regions used for join queries

2018-02-15 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4585: - Attachment: PHOENIX-4585.patch > Prune local index regions used for join queries > -

[jira] [Created] (PHOENIX-4614) Make HashJoinPlan.iterator() runnable in connectionless tests

2018-02-15 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4614: Summary: Make HashJoinPlan.iterator() runnable in connectionless tests Key: PHOENIX-4614 URL: https://issues.apache.org/jira/browse/PHOENIX-4614 Project: Phoenix

[jira] [Updated] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-12 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1556: - Attachment: PHOENIX-1556.patch > Base hash versus sort merge join decision on cost > ---

[jira] [Updated] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-12 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1556: - Attachment: (was: PHOENIX-1556.patch) > Base hash versus sort merge join decision on cost >

[jira] [Created] (PHOENIX-4599) Push LIMIT down to sort-merge-join's preserved side

2018-02-12 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4599: Summary: Push LIMIT down to sort-merge-join's preserved side Key: PHOENIX-4599 URL: https://issues.apache.org/jira/browse/PHOENIX-4599 Project: Phoenix Issue

[jira] [Created] (PHOENIX-4598) Refine cost for limit

2018-02-12 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4598: Summary: Refine cost for limit Key: PHOENIX-4598 URL: https://issues.apache.org/jira/browse/PHOENIX-4598 Project: Phoenix Issue Type: Sub-task Re

[jira] [Commented] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-12 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16361456#comment-16361456 ] Maryann Xue commented on PHOENIX-1556: -- bq. One thing with PageFilter is that it re

[jira] [Commented] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-09 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16359048#comment-16359048 ] Maryann Xue commented on PHOENIX-1556: -- {quote}Should UNION_DISTINCT_FACTOR be 1.0

[jira] [Updated] (PHOENIX-4586) UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-07 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4586: - Attachment: PHOENIX-4586.patch > UPSERT SELECT doesn't take in account comparison operators for

[jira] [Assigned] (PHOENIX-4586) UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-07 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue reassigned PHOENIX-4586: Assignee: Maryann Xue > UPSERT SELECT doesn't take in account comparison operators for su

[jira] [Commented] (PHOENIX-4586) UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16354794#comment-16354794 ] Maryann Xue commented on PHOENIX-4586: -- I'll take a look, [~sergey.soldatov] > UPS

[jira] [Comment Edited] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352053#comment-16352053 ] Maryann Xue edited comment on PHOENIX-1556 at 2/5/18 8:31 AM:

[jira] [Updated] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1556: - Attachment: PHOENIX-1556.patch > Base hash versus sort merge join decision on cost > ---

[jira] [Updated] (PHOENIX-1556) Base hash versus sort merge join decision on cost

2018-02-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1556: - Summary: Base hash versus sort merge join decision on cost (was: Base hash versus sort merge jo

[jira] [Commented] (PHOENIX-3941) Filter regions to scan for local indexes based on data table leading pk filter conditions

2018-02-02 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16351017#comment-16351017 ] Maryann Xue commented on PHOENIX-3941: -- [~jamestaylor], Unlike the single queries,

[jira] [Updated] (PHOENIX-4508) Order-by not optimized in sort-merge-join on salted tables

2018-01-08 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4508: - Summary: Order-by not optimized in sort-merge-join on salted tables (was: Wrong query plan gene

[jira] [Updated] (PHOENIX-4508) Wrong query plan generation

2018-01-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4508: - Attachment: PHOENIX-4508.patch > Wrong query plan generation > --- > >

[jira] [Assigned] (PHOENIX-4508) Wrong query plan generation

2018-01-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue reassigned PHOENIX-4508: Assignee: Maryann Xue > Wrong query plan generation > --- > >

[jira] [Commented] (PHOENIX-4508) Wrong query plan generation

2018-01-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16314833#comment-16314833 ] Maryann Xue commented on PHOENIX-4508: -- Thanks to the DDLs you have provided, [~f.p

[jira] [Commented] (PHOENIX-4508) Wrong query plan generation

2018-01-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16314332#comment-16314332 ] Maryann Xue commented on PHOENIX-4508: -- Thank you, [~f.pompermaier]! Just to confir

[jira] [Commented] (PHOENIX-4508) Wrong query plan generation

2018-01-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16314097#comment-16314097 ] Maryann Xue commented on PHOENIX-4508: -- It is important because a table is ordered

[jira] [Commented] (PHOENIX-4508) Wrong query plan generation

2018-01-05 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16313849#comment-16313849 ] Maryann Xue commented on PHOENIX-4508: -- [~f.pompermaier], could you please share DD

[jira] [Updated] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-21 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4437: - Attachment: PHOENIX-4437.patch > Make QueryPlan.getEstimatedBytesToScan() independent of getExpl

[jira] [Updated] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-21 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4437: - Attachment: (was: PHOENIX-4437.patch) > Make QueryPlan.getEstimatedBytesToScan() independent

[jira] [Commented] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-20 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16299608#comment-16299608 ] Maryann Xue commented on PHOENIX-4437: -- Can I go ahead and check-in with added code

[jira] [Commented] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-19 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16297962#comment-16297962 ] Maryann Xue commented on PHOENIX-4437: -- bq. Can you add a comment here on when opti

[jira] [Updated] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4437: - Attachment: PHOENIX-4437.patch > Make QueryPlan.getEstimatedBytesToScan() independent of getExpl

[jira] [Updated] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4437: - Attachment: (was: PHOENIX-4437.patch) > Make QueryPlan.getEstimatedBytesToScan() independent

[jira] [Commented] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16296255#comment-16296255 ] Maryann Xue commented on PHOENIX-4437: -- [~jamestaylor] Could you please review this

[jira] [Updated] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4437: - Attachment: PHOENIX-4437.patch > Make QueryPlan.getEstimatedBytesToScan() independent of getExpl

[jira] [Assigned] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-18 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue reassigned PHOENIX-4437: Assignee: Maryann Xue > Make QueryPlan.getEstimatedBytesToScan() independent of getExplai

[jira] [Updated] (PHOENIX-3050) Handle DESC columns in child/parent join optimization

2017-12-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-3050: - Attachment: PHOENIX-3050.patch Added assert query plan to make sure "DYNAMIC SERVER FILTER" for

[jira] [Updated] (PHOENIX-3050) Handle DESC columns in child/parent join optimization

2017-12-06 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-3050: - Attachment: (was: PHOENIX-3050.patch) > Handle DESC columns in child/parent join optimizatio

[jira] [Created] (PHOENIX-4437) Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan()

2017-12-05 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4437: Summary: Make QueryPlan.getEstimatedBytesToScan() independent of getExplainPlan() and pull optimize() out of getExplainPlan() Key: PHOENIX-4437 URL: https://issues.apache.org/jira

[jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-12-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16277298#comment-16277298 ] Maryann Xue commented on PHOENIX-4322: -- [~jamestaylor] Can I go ahead check in the

[jira] [Updated] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-11-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4322: - Attachment: PHOENIX-4322.patch > DESC primary key column with variable length does not work in S

[jira] [Commented] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16273270#comment-16273270 ] Maryann Xue commented on PHOENIX-4288: -- [~jamestaylor], looks like the test failure

[jira] [Updated] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-29 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4288: - Attachment: (was: PHOENIX-4288.patch) > Indexes not used when ordering by primary key >

[jira] [Updated] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-29 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4288: - Attachment: PHOENIX-4288.patch > Indexes not used when ordering by primary key > ---

[jira] [Updated] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-29 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4288: - Attachment: PHOENIX-4288.patch > Indexes not used when ordering by primary key > ---

[jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-11-27 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16268177#comment-16268177 ] Maryann Xue commented on PHOENIX-4322: -- Yes, I tried with changes in RVC.evaluate a

[jira] [Commented] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-21 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16261353#comment-16261353 ] Maryann Xue commented on PHOENIX-4288: -- [~jamestaylor] Could you please review my c

[jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-11-14 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16252194#comment-16252194 ] Maryann Xue commented on PHOENIX-4322: -- [~jamestaylor] Did you have time to take a

[jira] [Commented] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-07 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242961#comment-16242961 ] Maryann Xue commented on PHOENIX-4288: -- Could you please take a look at https://git

[jira] [Comment Edited] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-07 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16242961#comment-16242961 ] Maryann Xue edited comment on PHOENIX-4288 at 11/7/17 9:45 PM: ---

[jira] [Assigned] (PHOENIX-4288) Indexes not used when ordering by primary key

2017-11-03 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue reassigned PHOENIX-4288: Assignee: Maryann Xue > Indexes not used when ordering by primary key > -

[jira] [Updated] (PHOENIX-3050) Handle DESC columns in child/parent join optimization

2017-10-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-3050: - Attachment: PHOENIX-3050.patch This patch will work after PHOENIX-4322 gets in. Existing test {

[jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-10-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16226282#comment-16226282 ] Maryann Xue commented on PHOENIX-4322: -- Sorry, [~jamestaylor], for checking that in

[jira] [Updated] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-10-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-4322: - Fix Version/s: 4.13.0 > DESC primary key column with variable length does not work in SkipScanFi

[jira] [Resolved] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-10-30 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-4322. -- Resolution: Fixed > DESC primary key column with variable length does not work in SkipScanFilt

[jira] [Commented] (PHOENIX-3050) Handle DESC columns in child/parent join optimization

2017-10-26 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16221363#comment-16221363 ] Maryann Xue commented on PHOENIX-3050: -- [~jamestaylor], it turns out to be a bug in

[jira] [Created] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter

2017-10-25 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-4322: Summary: DESC primary key column with variable length does not work in SkipScanFilter Key: PHOENIX-4322 URL: https://issues.apache.org/jira/browse/PHOENIX-4322 Projec

[jira] [Commented] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

2017-10-23 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16216078#comment-16216078 ] Maryann Xue commented on PHOENIX-3999: -- [~jamestaylor], it would still be a hash jo

[jira] [Commented] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

2017-10-23 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16215785#comment-16215785 ] Maryann Xue commented on PHOENIX-3999: -- I think the purpose of the above client log

  1   2   3   4   5   6   7   8   9   10   >