[jira] [Updated] (PHOENIX-3591) Group by is slower for immutable encoded table

2017-01-11 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-3591: Description: {noformat} select /*+ SERIAL NO_CACHE*/ c0,sum(k1) from $T group by c0 {nofo

[jira] [Updated] (PHOENIX-3591) Group by is slower for immutable encoded table

2017-01-11 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-3591: Assignee: Samarth Jain > Group by is slower for immutable encoded table >

[jira] [Created] (PHOENIX-3591) Group by is slower for immutable encoded table

2017-01-11 Thread Mujtaba Chohan (JIRA)
Mujtaba Chohan created PHOENIX-3591: --- Summary: Group by is slower for immutable encoded table Key: PHOENIX-3591 URL: https://issues.apache.org/jira/browse/PHOENIX-3591 Project: Phoenix Issu

[jira] [Created] (PHOENIX-3590) Filter on value column for mutable encoded table is > 3X slower compared to non encoded table

2017-01-11 Thread Mujtaba Chohan (JIRA)
Mujtaba Chohan created PHOENIX-3590: --- Summary: Filter on value column for mutable encoded table is > 3X slower compared to non encoded table Key: PHOENIX-3590 URL: https://issues.apache.org/jira/browse/PHOENIX-3

[jira] [Created] (PHOENIX-3589) Aggregate query is not blocked when projected columns are not part of group by

2017-01-11 Thread Mujtaba Chohan (JIRA)
Mujtaba Chohan created PHOENIX-3589: --- Summary: Aggregate query is not blocked when projected columns are not part of group by Key: PHOENIX-3589 URL: https://issues.apache.org/jira/browse/PHOENIX-3589

[jira] [Commented] (PHOENIX-3588) Update Phoenix-Spark integration tests to use Spark 2.0 features instead of 1.x deprecated methods

2017-01-11 Thread Nico Pappagianis (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15819114#comment-15819114 ] Nico Pappagianis commented on PHOENIX-3588: --- [~jmahonin] Any objections to swa

[jira] [Created] (PHOENIX-3588) Update Phoenix-Spark integration tests to use Spark 2.0 features instead of 1.x deprecated methods

2017-01-11 Thread Nico Pappagianis (JIRA)
Nico Pappagianis created PHOENIX-3588: - Summary: Update Phoenix-Spark integration tests to use Spark 2.0 features instead of 1.x deprecated methods Key: PHOENIX-3588 URL: https://issues.apache.org/jira/browse/

[jira] [Updated] (PHOENIX-3587) Support FETCH PREV|n ROWS from Cursor

2017-01-11 Thread Biju Nair (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Biju Nair updated PHOENIX-3587: --- Summary: Support FETCH PREV|n ROWS from Cursor (was: Support FETCH PREV|n ROWS from cursor) > Supp

[jira] [Created] (PHOENIX-3587) Support FETCH PREV|n ROWS from cursor

2017-01-11 Thread Biju Nair (JIRA)
Biju Nair created PHOENIX-3587: -- Summary: Support FETCH PREV|n ROWS from cursor Key: PHOENIX-3587 URL: https://issues.apache.org/jira/browse/PHOENIX-3587 Project: Phoenix Issue Type: Sub-task

Re: Re: Why SkipScanFilter can not support OrderBy.REV_ROW_KEY_ORDER_BY?

2017-01-11 Thread James Taylor
Thanks - sounds like you're on to the root cause. Would you mind commenting on the JIRA, please? Patches are most welcome too. Thanks, James On Wed, Jan 11, 2017 at 12:46 AM 程磊 wrote: > > > > > Thank you, James Taylor，I just found this problem when I looked into > PHOENIX-3578，PHOENIX-3578 may b

[jira] [Updated] (PHOENIX-3576) ParallelWriterIndexCommitter should fail fast when writing the local index to the closing table

2017-01-11 Thread ChiaPing Tsai (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ChiaPing Tsai updated PHOENIX-3576: --- Attachment: hbase-root-regionserver-node06.ncku.edu.tw.log This issue requires the support o

[jira] [Commented] (PHOENIX-3578) Incorrect query results when applying inner join and orderby desc

2017-01-11 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15817695#comment-15817695 ] chenglei commented on PHOENIX-3578: --- It can also be reproduced under 4.9.0, it may be

Re:Re: Why SkipScanFilter can not support OrderBy.REV_ROW_KEY_ORDER_BY?

2017-01-11 Thread 程磊
Thank you, James Taylor，I just found this problem when I looked into PHOENIX-3578，PHOENIX-3578 may be caused by the fact that the Join SQL is using SkipScanFilter after dynamic filtering but the sql is also OrderBy.REV_ROW_KEY_ORDER_BY. At 2017-01-10 23:47:08, "James Taylor" wrote: >B