[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: PHOENIX-3199_v1.patch > ServerCacheClient would send cache to all regions unnecessarily on

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: (was: PHOENIX-3199.patch) > ServerCacheClient would send cache to all regions unnecess

[jira] [Updated] (PHOENIX-3148) Reduce size of PTable so that more tables can be cached in the metada cache.

2016-08-23 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-3148: Fix Version/s: 4.9.0 > Reduce size of PTable so that more tables can be cached in the meta

[jira] [Resolved] (PHOENIX-3148) Reduce size of PTable so that more tables can be cached in the metada cache.

2016-08-23 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva resolved PHOENIX-3148. - Resolution: Fixed > Reduce size of PTable so that more tables can be cached in the metad

[jira] [Commented] (PHOENIX-1751) Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

2016-08-23 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15434206#comment-15434206 ] Samarth Jain commented on PHOENIX-1751: --- Patch looks good, [~jamestaylor]. +1. >

[jira] [Updated] (PHOENIX-2743) HivePhoenixHandler for big-big join with predicate push down

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2743: -- Assignee: Sergey Soldatov > HivePhoenixHandler for big-big join with predicate push down > ---

[jira] [Updated] (PHOENIX-2743) HivePhoenixHandler for big-big join with predicate push down

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2743: -- Assignee: (was: Sergey Soldatov) > HivePhoenixHandler for big-big join with predicate push

Re: [DISCUSS] Drop HBase 1.0 support for 4.9

2016-08-23 Thread James Taylor
How about the 4.x-1.1 branch? Do we need that? Also, will we do patch releases for the 4.8-1.0 branch? On Tue, Aug 23, 2016 at 8:59 PM, wrote: > I'll take this as a vote. If you feel we need an "official" vote thread, > speak up now.If I do not hear anything I'll remove the 4.x-1.0 branch in >

Re: [DISCUSS] Drop HBase 1.0 support for 4.9

2016-08-23 Thread larsh
I'll take this as a vote. If you feel we need an "official" vote thread, speak up now.If I do not hear anything I'll remove the 4.x-1.0 branch in the next few days. Thanks. -- Lars From: Josh Elser To: dev@phoenix.apache.org Sent: Monday, August 22, 2016 7:54 AM Subject: Re: [DISCUSS

[jira] [Commented] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15434028#comment-15434028 ] James Taylor commented on PHOENIX-3201: --- Take a look at PHOENIX-1846 for a guide.

[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3201: -- Assignee: prakul agarwal > Implement DAYOFWEEK and DAYOFYEAR built-in functions >

[jira] [Created] (PHOENIX-3202) Error trying to remove Hash Cache - Followed by CallQueueTooBigException

2016-08-23 Thread Nithin (JIRA)
Nithin created PHOENIX-3202: --- Summary: Error trying to remove Hash Cache - Followed by CallQueueTooBigException Key: PHOENIX-3202 URL: https://issues.apache.org/jira/browse/PHOENIX-3202 Project: Phoenix

[jira] [Commented] (PHOENIX-3189) HBase/ZooKeeper connection leaks when providing principal/keytab in JDBC url

2016-08-23 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433847#comment-15433847 ] Josh Elser commented on PHOENIX-3189: - Alright, just pushed an update to the pull re

[jira] [Commented] (PHOENIX-2991) Add missing documentation for functions

2016-08-23 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433846#comment-15433846 ] Josh Elser commented on PHOENIX-2991: - Thanks for the feedback, James. I need to fin

[jira] [Updated] (PHOENIX-3200) Error trying to remove Hash Cache

2016-08-23 Thread Nithin (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nithin updated PHOENIX-3200: Summary: Error trying to remove Hash Cache (was: Error trying to remove hash cache) > Error trying to re

[jira] [Commented] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-08-23 Thread Ted Yu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433837#comment-15433837 ] Ted Yu commented on PHOENIX-2995: - {code} Iterator>> mutationsIterator = ph

[jira] [Created] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-23 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3201: - Summary: Implement DAYOFWEEK and DAYOFYEAR built-in functions Key: PHOENIX-3201 URL: https://issues.apache.org/jira/browse/PHOENIX-3201 Project: Phoenix Is

[jira] [Commented] (PHOENIX-2991) Add missing documentation for functions

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433812#comment-15433812 ] James Taylor commented on PHOENIX-2991: --- Thanks for checking on this, [~elserj].

[jira] [Updated] (PHOENIX-930) duplicated columns cause query exception and drop table exception

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-930: - Fix Version/s: 4.9.0 > duplicated columns cause query exception and drop table exception > --

[jira] [Commented] (PHOENIX-930) duplicated columns cause query exception and drop table exception

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433767#comment-15433767 ] James Taylor commented on PHOENIX-930: -- Thanks for the patches, [~yhxx511] and [~kal

[jira] [Updated] (PHOENIX-3200) Error trying to remove hash cache

2016-08-23 Thread Nithin (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nithin updated PHOENIX-3200: Description: Data Set Consists of 500 Million Rows with each row consisting of 132 Columns (With various

[jira] [Created] (PHOENIX-3200) Error trying to remove hash cache

2016-08-23 Thread Nithin (JIRA)
Nithin created PHOENIX-3200: --- Summary: Error trying to remove hash cache Key: PHOENIX-3200 URL: https://issues.apache.org/jira/browse/PHOENIX-3200 Project: Phoenix Issue Type: Bug Affects Versi

Re: Issues while Running Apache Phoenix against TPC-H data

2016-08-23 Thread John Leach
So to load a TB of data would take around 2 days? Does that seem right to you? Regards, John > On Aug 23, 2016, at 3:07 PM, Mujtaba Chohan wrote: > > Since there are 100 files on which this 600M row data is split. 5 separate > psql script running in parallel on single machine ran that loaded d

[jira] [Commented] (PHOENIX-1751) Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

2016-08-23 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433608#comment-15433608 ] Hadoop QA commented on PHOENIX-1751: {color:red}-1 overall{color}. Here are the res

Re: Issues while Running Apache Phoenix against TPC-H data

2016-08-23 Thread Mujtaba Chohan
Since there are 100 files on which this 600M row data is split. 5 separate psql script running in parallel on single machine ran that loaded data from files 1-20, 21-40, 41-60, 61-80, 81-100. Performance get affected as keys are in sequence in these files which lead to hot-spotting of RS, for this

[jira] [Commented] (PHOENIX-3148) Reduce size of PTable so that more tables can be cached in the metada cache.

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433477#comment-15433477 ] James Taylor commented on PHOENIX-3148: --- +1. Looks good, [~tdsilva]. I think this

Re: Issues while Running Apache Phoenix against TPC-H data

2016-08-23 Thread John Leach
Mujtaba, Not following the import process. The 5 parallel psql clients means that you manually split the data into 5 buckets/files/directories and then run 5 import scripts simultaneously? If we wanted to benchmark import performance, what would be the right model for that? Thanks this is v

[jira] [Updated] (PHOENIX-1751) Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1751: -- Attachment: PHOENIX-1751_v4.patch Basically a version of [~lhofhansl]'s rebased patch, but wit

[jira] [Updated] (PHOENIX-1751) Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1751: -- Assignee: Lars Hofhansl (was: James Taylor) > Perform aggregations, sorting, etc, in the preS

[jira] [Updated] (PHOENIX-3148) Reduce size of PTable so that more tables can be cached in the metada cache.

2016-08-23 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-3148: Attachment: PHOENIX-3148-v4.patch [~jamestaylor] Thanks for the review, I have attached a

[jira] [Updated] (PHOENIX-1751) Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

2016-08-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1751: -- Summary: Perform aggregations, sorting, etc, in the preScannerNext instead of postScannerOpen

Re: Issues while Running Apache Phoenix against TPC-H data

2016-08-23 Thread Mujtaba Chohan
FYI re-loaded with Phoenix 4.8/HBase 0.98.20 on a 8 node cluster with 64G total/12G HBase heap. *Data Load* * 5.5 hours for 600M rows * Method: Direct CSV load using psql.py script * # client machines: 1 * Batch size 1K * Key order: *Sequential* * 5 parallel psql clients * No missing rows due to d

[jira] [Commented] (PHOENIX-930) duplicated columns cause query exception and drop table exception

2016-08-23 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433388#comment-15433388 ] Hudson commented on PHOENIX-930: SUCCESS: Integrated in Jenkins build Phoenix-master #136

[jira] [Commented] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433285#comment-15433285 ] Hadoop QA commented on PHOENIX-3199: {color:red}-1 overall{color}. Here are the res

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Attachment: PHOENIX-3199.patch > ServerCacheClient would send cache to all regions unnecessarily once

[jira] [Commented] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433206#comment-15433206 ] ASF GitHub Bot commented on PHOENIX-3199: - GitHub user comnetwork opened a pull

[GitHub] phoenix pull request #194: PHOENIX-3199

2016-08-23 Thread comnetwork
GitHub user comnetwork opened a pull request: https://github.com/apache/phoenix/pull/194 PHOENIX-3199 You can merge this pull request into a Git repository by running: $ git pull https://github.com/comnetwork/phoenix master Alternatively you can review and apply these changes

[jira] [Commented] (PHOENIX-2900) Unable to find hash cache once a salted table 's first region has split

2016-08-23 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15433203#comment-15433203 ] ASF GitHub Bot commented on PHOENIX-2900: - Github user comnetwork closed the pul

[GitHub] phoenix pull request #180: PHOENIX-2900

2016-08-23 Thread comnetwork
Github user comnetwork closed the pull request at: https://github.com/apache/phoenix/pull/180 --- 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

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Description: In the addServerCache method of org.apache.phoenix.cache.ServerCacheClient class, once

[jira] [Updated] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3199: -- Description: In the addServerCache method of org.apache.phoenix.cache.ServerCacheClient class, once

[jira] [Created] (PHOENIX-3199) ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region

2016-08-23 Thread chenglei (JIRA)
chenglei created PHOENIX-3199: - Summary: ServerCacheClient would send cache to all regions unnecessarily once it should send cache to the first region Key: PHOENIX-3199 URL: https://issues.apache.org/jira/browse/PHOEN

[jira] [Created] (PHOENIX-3198) Join may not free hash cache all the time

2016-08-23 Thread Ankit Singhal (JIRA)
Ankit Singhal created PHOENIX-3198: -- Summary: Join may not free hash cache all the time Key: PHOENIX-3198 URL: https://issues.apache.org/jira/browse/PHOENIX-3198 Project: Phoenix Issue Type:

[jira] [Updated] (PHOENIX-2930) Cannot resolve columns aliased to its own name

2016-08-23 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2930: --- Attachment: PHOENIX-2930.patch [~jamestaylor], please review(not sure if this is the right w

[jira] [Assigned] (PHOENIX-2930) Cannot resolve columns aliased to its own name

2016-08-23 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal reassigned PHOENIX-2930: -- Assignee: Ankit Singhal > Cannot resolve columns aliased to its own name > --

[jira] [Commented] (PHOENIX-3195) Slight safety improvement for using DistinctPrefixFilter

2016-08-23 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15432312#comment-15432312 ] Hudson commented on PHOENIX-3195: - FAILURE: Integrated in Jenkins build Phoenix-master #