[GitHub] phoenix issue #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on the issue: https://github.com/apache/phoenix/pull/177 Thanks for the PR @Boruch28 . Had a look at the PR and added some comments. I fear that the data for mid term evaluation ended by June 27 UTC. The PR submission was late in my opinion and

where are we at with the RC?

2016-06-27 Thread James Taylor
What are the outstanding JIRAs? Would it be possible to update this daily so we can zero in on getting an RC up? If folks could commit there outstanding patches (or find a committer to do it for you), that be much appreciated. Thanks, James

[jira] [Commented] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

2016-06-27 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352402#comment-15352402 ] James Taylor commented on PHOENIX-2724: --- [~samarthjain], [~mujtabachohan] - I think the reason is

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700861 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/expression/function/DistinctSumAggregateFunction.java --- @@ -0,0 +1,148 @@ +/* + *

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700652 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/NumberSumDistinctAggregator.java --- @@ -0,0 +1,117 @@ +/* + *

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700606 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/DecimalSumDistinctAggregator.java --- @@ -0,0 +1,105 @@ +/* + *

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700578 --- Diff: docs/phoenix.csv --- @@ -844,9 +844,10 @@ MIN(NAME) " "Functions (Aggregate)","SUM"," -SUM( { numericTerm } ) +SUM( [

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700634 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/DoubleSumDistinctAggregator.java --- @@ -0,0 +1,100 @@ +/* + *

[GitHub] phoenix pull request #177: Support DISTINCT for SUM

2016-06-27 Thread ramkrish86
Github user ramkrish86 commented on a diff in the pull request: https://github.com/apache/phoenix/pull/177#discussion_r68700601 --- Diff: docs/phoenix.csv --- @@ -844,9 +844,10 @@ MIN(NAME) " "Functions (Aggregate)","SUM"," -SUM( { numericTerm } ) +SUM( [

[jira] [Updated] (PHOENIX-3033) forbid full scan on specified table on condition

2016-06-27 Thread jinzuan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jinzuan updated PHOENIX-3033: - Description: hbase cluster is often over load because of a careless phoenix full scan. We can set up a

[jira] [Created] (PHOENIX-3033) forbid full scan on specified table on condition

2016-06-27 Thread jinzuan (JIRA)
jinzuan created PHOENIX-3033: Summary: forbid full scan on specified table on condition Key: PHOENIX-3033 URL: https://issues.apache.org/jira/browse/PHOENIX-3033 Project: Phoenix Issue Type: New

[jira] [Commented] (PHOENIX-3028) StatisticsWriter shouldn't fail compaction in case of errors

2016-06-27 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352356#comment-15352356 ] James Taylor commented on PHOENIX-3028: --- +1 to the patch. We wrote the commit timestamp previously

[jira] [Commented] (PHOENIX-2990) Ensure documentation on "time/date" datatypes/functions acknowledge lack of JDBC compliance

2016-06-27 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352323#comment-15352323 ] James Taylor commented on PHOENIX-2990: --- LGTM. Thanks, [~elserj]. Would be great to fix this in

[jira] [Commented] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

2016-06-27 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352243#comment-15352243 ] Lars Hofhansl commented on PHOENIX-2724: Can we "simply" combine consecutive guide posts into

[jira] [Commented] (PHOENIX-3025) CsvBulkloadTool is failing with java.lang.IncompatibleClassChangeError

2016-06-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352230#comment-15352230 ] Hudson commented on PHOENIX-3025: - SUCCESS: Integrated in Phoenix-master #1296 (See

[jira] [Updated] (PHOENIX-3028) StatisticsWriter shouldn't fail compaction in case of errors

2016-06-27 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3028: -- Attachment: PHOENIX-3028.patch Patch that moves the commit stats time call so that it is run

[jira] [Commented] (PHOENIX-3002) Upgrading to 4.8 doesn't recreate local indexes

2016-06-27 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352125#comment-15352125 ] Samarth Jain commented on PHOENIX-3002: --- +1, [~rajeshbabu]. Minor nit to fix on commit: please

[jira] [Commented] (PHOENIX-3025) CsvBulkloadTool is failing with java.lang.IncompatibleClassChangeError

2016-06-27 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352124#comment-15352124 ] Sergey Soldatov commented on PHOENIX-3025: -- [~elserj], [~jamestaylor] Thank you for the

[jira] [Reopened] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

2016-06-27 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan reopened PHOENIX-2724: - This is also a performance regression from 4.7. Comparing with current [head of

[jira] [Commented] (PHOENIX-2990) Ensure documentation on "time/date" datatypes/functions acknowledge lack of JDBC compliance

2016-06-27 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352009#comment-15352009 ] Josh Elser commented on PHOENIX-2990: - [~jamestaylor], any thoughts? > Ensure documentation on

[jira] [Created] (PHOENIX-3032) Support ALTER INDEX ... REBUILD ASYNC

2016-06-27 Thread Tongzhou Wang (JIRA)
Tongzhou Wang created PHOENIX-3032: -- Summary: Support ALTER INDEX ... REBUILD ASYNC Key: PHOENIX-3032 URL: https://issues.apache.org/jira/browse/PHOENIX-3032 Project: Phoenix Issue Type:

Re: URIException with PhoenixHBaseLoader

2016-06-27 Thread Prashant Kommireddi
Agreed. This method call isn't needed for phoenix loader (or any such non-direct-fs loaders). You should allow a config to handle it. On Mon, Jun 27, 2016 at 12:14 PM, Siddhi Mehta wrote: > Hello All, > > I am getting a URISyntaxException when I try to execute my pig script

[jira] [Commented] (PHOENIX-3031) Rename TestMRJobSubmitter so it is executed as a unit test

2016-06-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351679#comment-15351679 ] Hudson commented on PHOENIX-3031: - SUCCESS: Integrated in Phoenix-master #1295 (See

[jira] [Commented] (PHOENIX-2966) Implement mechanism to build async indexes when running locally

2016-06-27 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351644#comment-15351644 ] James Taylor commented on PHOENIX-2966: --- Looking good, [~singamteja]. A couple of issues with the

URIException with PhoenixHBaseLoader

2016-06-27 Thread Siddhi Mehta
Hello All, I am getting a URISyntaxException when I try to execute my pig script using PHoenixHBaseLoader. Traced attached below. Looking through the code Pig splits multiple paths provided to it based on comma(',') and during the query parsing step QueryParserUtils.setHdfsServers(absolutePath,

[jira] [Commented] (PHOENIX-3030) ALTER SESSION missing from 4.x-HBase-0.98

2016-06-27 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351617#comment-15351617 ] Samarth Jain commented on PHOENIX-3030: --- Ah, my bad. For some reason I remembered that we have an

[jira] [Resolved] (PHOENIX-3030) ALTER SESSION missing from 4.x-HBase-0.98

2016-06-27 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla resolved PHOENIX-3030. -- Resolution: Won't Fix [~samarthjain] as part of alter session at

[jira] [Commented] (PHOENIX-3023) Slow performance when limit queries are executed in parallel by default

2016-06-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351516#comment-15351516 ] Hudson commented on PHOENIX-3023: - FAILURE: Integrated in Phoenix-master #1294 (See

[jira] [Resolved] (PHOENIX-3031) Rename TestMRJobSubmitter so it is executed as a unit test

2016-06-27 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain resolved PHOENIX-3031. --- Resolution: Fixed Fix Version/s: 4.8.0 > Rename TestMRJobSubmitter so it is executed

[jira] [Commented] (PHOENIX-3031) Rename TestMRJobSubmitter so it is executed as a unit test

2016-06-27 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351481#comment-15351481 ] Samarth Jain commented on PHOENIX-3031: --- FYI, [~rvaleti] - to be able to execute tests as unit

[jira] [Created] (PHOENIX-3031) Rename TestMRJobSubmitter so it is executed as a unit test

2016-06-27 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-3031: - Summary: Rename TestMRJobSubmitter so it is executed as a unit test Key: PHOENIX-3031 URL: https://issues.apache.org/jira/browse/PHOENIX-3031 Project: Phoenix

Re: RC today (Fri 6/24)?

2016-06-27 Thread Samarth Jain
I am working on PHOENIX-3028. We noticed in our internal testing that there is still some code path in our stats collection that is executing synchronously on the compaction thread (which could cause compaction to fail in case of network partition/hbase misconfiguration etc). Also another blocker

[jira] [Created] (PHOENIX-3030) ALTER SESSION missing from 4.x-HBase-0.98

2016-06-27 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-3030: - Summary: ALTER SESSION missing from 4.x-HBase-0.98 Key: PHOENIX-3030 URL: https://issues.apache.org/jira/browse/PHOENIX-3030 Project: Phoenix Issue Type:

[jira] [Commented] (PHOENIX-2966) Implement mechanism to build async indexes when running locally

2016-06-27 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351435#comment-15351435 ] Hadoop QA commented on PHOENIX-2966: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-2996) Process name of PQS should indicate its role

2016-06-27 Thread Ted Yu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Yu updated PHOENIX-2996: Description: Currently we have: {code} * A query server for Phoenix over Calcite's Avatica. */ public

[jira] [Comment Edited] (PHOENIX-2966) Implement mechanism to build async indexes when running locally

2016-06-27 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351390#comment-15351390 ] Loknath Priyatham Teja Singamsetty edited comment on PHOENIX-2966 at 6/27/16 4:50 PM:

[jira] [Updated] (PHOENIX-2966) Implement mechanism to build async indexes when running locally

2016-06-27 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Loknath Priyatham Teja Singamsetty updated PHOENIX-2966: - Attachment: phoenix-2966.patch - Added async

[jira] [Updated] (PHOENIX-3002) Upgrading to 4.8 doesn't recreate local indexes

2016-06-27 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-3002: - Attachment: PHOENIX-3002_addendum.patch Here is the patch upgrades

[jira] [Commented] (PHOENIX-2902) Adjust PhoenixDatabaseMetadata#getSchemas query if namespaces are enabled

2016-06-27 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15351232#comment-15351232 ] James Taylor commented on PHOENIX-2902: --- bq. Is setting properties in hbase-site.xml or passing

Re: Review Request 43811: Include Apache Phoenix support in HBaseStorageHandler

2016-06-27 Thread Svetozar Ivanov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/43811/ --- (Updated June 27, 2016, 7:50 a.m.) Review request for hbase, hive, phoenix,