[jira] [Updated] (PHOENIX-3822) Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN

[ https://issues.apache.org/jira/browse/PHOENIX-3822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3822: -- Attachment: PHOENIX-3822_v3.patch > Surface byte and row estimates in a machine readable way w

[jira] [Updated] (PHOENIX-3822) Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN

[ https://issues.apache.org/jira/browse/PHOENIX-3822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3822: -- Attachment: (was: PHOENIX-3822_v3.patch) > Surface byte and row estimates in a machine rea

[jira] [Resolved] (PHOENIX-3353) Paged Queries: use of LIMIT + OFFSET with ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-3353. Resolution: Duplicate > Paged Queries: use of LIMIT + OFFSET with ORDER BY > -

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117405732 --- Diff: phoenix-queryserver/src/main/java/org/apache/phoenix/queryserver/register/Registry.java --- @@ -0,0 +1,31 @@ +/** + * + * Licensed

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117402547 --- Diff: phoenix-queryserver/src/main/java/org/apache/phoenix/queryserver/register/ZookeeperRegistry.java --- @@ -0,0 +1,73 @@ +/** + * + *

[GitHub] phoenix pull request #236: Loadbalancer

Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117391916 --- Diff: phoenix-queryserver/pom.xml --- @@ -147,6 +147,14 @@ commons-logging commons-logging + + org.apa

[GitHub] phoenix pull request #236: Loadbalancer

Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117391613 --- Diff: phoenix-load-balancer/src/main/java/org/apache/phoenix/loadbalancer/service/PhoenixQueryServerNode.java --- @@ -0,0 +1,79 @@ +/** + *

[jira] [Commented] (PHOENIX-3744) Support snapshot scanners for MR-based queries

[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016719#comment-16016719 ] Hadoop QA commented on PHOENIX-3744: {color:red}-1 overall{color}. Here are the res

[jira] [Commented] (PHOENIX-3868) Pherf - Create sync/async index as part of a scenario

[ https://issues.apache.org/jira/browse/PHOENIX-3868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016714#comment-16016714 ] Mujtaba Chohan commented on PHOENIX-3868: - Will be adding some more tests later

[jira] [Updated] (PHOENIX-3868) Pherf - Create sync/async index as part of a scenario

[ https://issues.apache.org/jira/browse/PHOENIX-3868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-3868: Attachment: PHOENIX-3868.patch > Pherf - Create sync/async index as part of a scenario > -

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117377225 --- Diff: pom.xml --- @@ -953,6 +962,30 @@ joda-time ${jodatime.version} + +org.apache.curator

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117377275 --- Diff: pom.xml --- @@ -127,6 +128,9 @@ UTF-8 UTF-8 + --- End diff -- removed. --- If your project is set

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016647#comment-16016647 ] Mujtaba Chohan commented on PHOENIX-3853: - Talked offline with [~jamestaylor]. T

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117376467 --- Diff: phoenix-queryserver/pom.xml --- @@ -147,6 +147,14 @@ commons-logging commons-logging + + org.apa

[jira] [Updated] (PHOENIX-3822) Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN

[ https://issues.apache.org/jira/browse/PHOENIX-3822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3822: -- Attachment: PHOENIX-3822_v3.patch Thanks for the reviews, [~jamestaylor]. Attached is the upda

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117372183 --- Diff: phoenix-load-balancer/src/main/java/org/apache/phoenix/loadbalancer/service/LoadBalancerConfiguration.java --- @@ -0,0 +1,91 @@ +/** +

[GitHub] phoenix pull request #236: Loadbalancer

Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117372190 --- Diff: phoenix-load-balancer/src/main/java/org/apache/phoenix/loadbalancer/service/LoadBalancerConfiguration.java --- @@ -0,0 +1,91 @@ +/** +

[GitHub] phoenix pull request #236: Loadbalancer

Github user rahulsIOT commented on a diff in the pull request: https://github.com/apache/phoenix/pull/236#discussion_r117371944 --- Diff: phoenix-load-balancer/src/main/java/org/apache/phoenix/loadbalancer/service/LoadBalancerConfiguration.java --- @@ -0,0 +1,91 @@ +/** +

[GitHub] phoenix issue #239: PHOENIX-3744: Support snapshot scanners for MR-based Non...

Github user akshita-malhotra commented on the issue: https://github.com/apache/phoenix/pull/239 @JamesRTaylor - Changed ParallelScanGrouper classes as per the review - Changes to BaseTest were to avoid the following error: "Restore directory cannot be a sub directory of HBa

[jira] [Commented] (PHOENIX-3744) Support snapshot scanners for MR-based queries

[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016588#comment-16016588 ] ASF GitHub Bot commented on PHOENIX-3744: - Github user akshita-malhotra commente

[jira] [Updated] (PHOENIX-3744) Support snapshot scanners for MR-based queries

[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Akshita Malhotra updated PHOENIX-3744: -- Attachment: PHOENIX-3744.patch PHOENIX-3744: Support snapshot scanners for MR-based No

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016562#comment-16016562 ] James Taylor commented on PHOENIX-3853: --- [~lhofhansl] - we don't use the thread po

[jira] [Commented] (PHOENIX-3863) Document DAYOFWEEK, DAYOFYEAR, and any other missing functions

[ https://issues.apache.org/jira/browse/PHOENIX-3863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016557#comment-16016557 ] Peter Conrad commented on PHOENIX-3863: --- Perfect. I'll put this on my stack. > D

[jira] [Updated] (PHOENIX-3866) COUNT(col) should scan along required column families only

[ https://issues.apache.org/jira/browse/PHOENIX-3866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lars Hofhansl updated PHOENIX-3866: --- Priority: Minor (was: Major) > COUNT(col) should scan along required column families only >

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016532#comment-16016532 ] Lars Hofhansl commented on PHOENIX-3853: bq. Here the tests performed in single

[jira] [Commented] (PHOENIX-3355) Register Phoenix built-in functions as Calcite functions

[ https://issues.apache.org/jira/browse/PHOENIX-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016505#comment-16016505 ] ASF GitHub Bot commented on PHOENIX-3355: - Github user lomoree closed the pull r

[GitHub] phoenix pull request #222: PHOENIX-3355 Register Phoenix built-in functions ...

Github user lomoree closed the pull request at: https://github.com/apache/phoenix/pull/222 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is en

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016468#comment-16016468 ] Mujtaba Chohan commented on PHOENIX-3853: - 2X performance degradation for local

[jira] [Updated] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-3853: Attachment: after_3858.png > Local Index - Writes to local index are twice as slow as glob

[jira] [Commented] (PHOENIX-3858) Index maintenance not required for local indexes of table with immutable rows

[ https://issues.apache.org/jira/browse/PHOENIX-3858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016418#comment-16016418 ] Hudson commented on PHOENIX-3858: - SUCCESS: Integrated in Jenkins build Phoenix-master #

[jira] [Resolved] (PHOENIX-3858) Index maintenance not required for local indexes of table with immutable rows

[ https://issues.apache.org/jira/browse/PHOENIX-3858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-3858. --- Resolution: Fixed > Index maintenance not required for local indexes of table with immutable

[jira] [Commented] (PHOENIX-3734) Refactor Phoenix to use TAL instead of direct calls to Tephra

[ https://issues.apache.org/jira/browse/PHOENIX-3734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016207#comment-16016207 ] Ohad Shacham commented on PHOENIX-3734: --- Thanks [~giacomotaylor] and [~samarthjai

[jira] [Commented] (PHOENIX-3858) Index maintenance not required for local indexes of table with immutable rows

[ https://issues.apache.org/jira/browse/PHOENIX-3858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016203#comment-16016203 ] Rajeshbabu Chintaguntla commented on PHOENIX-3858: -- +1 [~jamestaylor].

[jira] [Comment Edited] (PHOENIX-3822) Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN

[ https://issues.apache.org/jira/browse/PHOENIX-3822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016184#comment-16016184 ] James Taylor edited comment on PHOENIX-3822 at 5/18/17 6:11 PM: --

[jira] [Commented] (PHOENIX-3822) Surface byte and row estimates in a machine readable way when doing EXPLAIN PLAN

[ https://issues.apache.org/jira/browse/PHOENIX-3822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016184#comment-16016184 ] James Taylor commented on PHOENIX-3822: --- Looking good, [~samarthjain]. Here's some

[jira] [Commented] (PHOENIX-3734) Refactor Phoenix to use TAL instead of direct calls to Tephra

[ https://issues.apache.org/jira/browse/PHOENIX-3734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016163#comment-16016163 ] James Taylor commented on PHOENIX-3734: --- Looks like 0.98 Jenkins builds are passin

[jira] [Assigned] (PHOENIX-3863) Document DAYOFWEEK, DAYOFYEAR, and any other missing functions

[ https://issues.apache.org/jira/browse/PHOENIX-3863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor reassigned PHOENIX-3863: - Assignee: Peter Conrad > Document DAYOFWEEK, DAYOFYEAR, and any other missing functions

[jira] [Commented] (PHOENIX-3863) Document DAYOFWEEK, DAYOFYEAR, and any other missing functions

[ https://issues.apache.org/jira/browse/PHOENIX-3863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016158#comment-16016158 ] James Taylor commented on PHOENIX-3863: --- Thanks, [~pconrad]! Best would be to star

[jira] [Updated] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3853: -- Attachment: PHOENIX-3853_test_only.patch [~mujtabachohan] - here's a patch you can apply for t

[jira] [Assigned] (PHOENIX-3858) Index maintenance not required for local indexes of table with immutable rows

[ https://issues.apache.org/jira/browse/PHOENIX-3858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor reassigned PHOENIX-3858: - Assignee: James Taylor (was: Rajeshbabu Chintaguntla) > Index maintenance not required

[jira] [Updated] (PHOENIX-3858) Index maintenance not required for local indexes of table with immutable rows

[ https://issues.apache.org/jira/browse/PHOENIX-3858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3858: -- Attachment: PHOENIX-3858_v2.patch Patch that ensures scans aren't done to lookup old row value

[jira] [Assigned] (PHOENIX-3868) Pherf - Create sync/async index as part of a scenario

[ https://issues.apache.org/jira/browse/PHOENIX-3868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan reassigned PHOENIX-3868: --- Assignee: Mujtaba Chohan Fix Version/s: 4.11.0 > Pherf - Create sync/async

[jira] [Created] (PHOENIX-3868) Pherf - Create sync/async index as part of a scenario

Mujtaba Chohan created PHOENIX-3868: --- Summary: Pherf - Create sync/async index as part of a scenario Key: PHOENIX-3868 URL: https://issues.apache.org/jira/browse/PHOENIX-3868 Project: Phoenix

[jira] [Commented] (PHOENIX-3729) Phoenix 4.7 integration issue with Spark 2.1.0

[ https://issues.apache.org/jira/browse/PHOENIX-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016106#comment-16016106 ] Josh Mahonin commented on PHOENIX-3729: --- Can you confirm that you're seeing the sa

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016090#comment-16016090 ] Mujtaba Chohan commented on PHOENIX-3853: - [~jamestaylor] After initial tests I'

[jira] [Commented] (PHOENIX-3729) Phoenix 4.7 integration issue with Spark 2.1.0

[ https://issues.apache.org/jira/browse/PHOENIX-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016081#comment-16016081 ] shekhar reddy commented on PHOENIX-3729: Hi Josh Mahonin, Before I do changes,

[jira] [Commented] (PHOENIX-3863) Document DAYOFWEEK, DAYOFYEAR, and any other missing functions

[ https://issues.apache.org/jira/browse/PHOENIX-3863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015920#comment-16015920 ] Peter Conrad commented on PHOENIX-3863: --- Absolutely! Who should I reach out to, to

[jira] [Commented] (PHOENIX-3853) Local Index - Writes to local index are twice as slow as global and get exponentially slower with PHOENIX-3827_v2 patch

[ https://issues.apache.org/jira/browse/PHOENIX-3853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015907#comment-16015907 ] James Taylor commented on PHOENIX-3853: --- Might the cause be that the writes are pa

[jira] [Comment Edited] (PHOENIX-3864) PhoenixConsumerIT is timing out frequently in 4.x-HBase-0.98

[ https://issues.apache.org/jira/browse/PHOENIX-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015880#comment-16015880 ] James Taylor edited comment on PHOENIX-3864 at 5/18/17 2:56 PM: --

[jira] [Commented] (PHOENIX-3864) PhoenixConsumerIT is timing out frequently in 4.x-HBase-0.98

[ https://issues.apache.org/jira/browse/PHOENIX-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015880#comment-16015880 ] James Taylor commented on PHOENIX-3864: --- b.q. I'd guess there's some terrible depe

[jira] [Comment Edited] (PHOENIX-3729) Phoenix 4.7 integration issue with Spark 2.1.0

[ https://issues.apache.org/jira/browse/PHOENIX-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015807#comment-16015807 ] Josh Mahonin edited comment on PHOENIX-3729 at 5/18/17 2:14 PM: --

[jira] [Commented] (PHOENIX-3729) Phoenix 4.7 integration issue with Spark 2.1.0

[ https://issues.apache.org/jira/browse/PHOENIX-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015807#comment-16015807 ] Josh Mahonin commented on PHOENIX-3729: --- [~shekharreddy...@gmail.com] The JAR copy

[jira] [Commented] (PHOENIX-3864) PhoenixConsumerIT is timing out frequently in 4.x-HBase-0.98

[ https://issues.apache.org/jira/browse/PHOENIX-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015791#comment-16015791 ] Josh Mahonin commented on PHOENIX-3864: --- Nothing off the top of my head, though if

[jira] [Created] (PHOENIX-3867) nth_value returns valid values for non-existing rows

Loknath Priyatham Teja Singamsetty created PHOENIX-3867: Summary: nth_value returns valid values for non-existing rows Key: PHOENIX-3867 URL: https://issues.apache.org/jira/browse/PHOENIX-

[jira] [Commented] (PHOENIX-3861) Add function DAYOFWEEK(date/datetime)

[ https://issues.apache.org/jira/browse/PHOENIX-3861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015595#comment-16015595 ] Lucas Shen commented on PHOENIX-3861: - Thanks for the answer. > Add function DAYOF

[jira] [Commented] (PHOENIX-3826) Exception stack trace is being logged in info mode when new phoenix connection is created

[ https://issues.apache.org/jira/browse/PHOENIX-3826?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16015453#comment-16015453 ] Loknath Priyatham Teja Singamsetty commented on PHOENIX-3826: ---