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

2016-08-12 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419808#comment-15419808 ] James Taylor commented on PHOENIX-2995: --- Thanks, [~tdsilva]. Looks very good. Couple of

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419754#comment-15419754 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74678543 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java --- @@ -23,6 +23,7 @@ import static

[jira] [Commented] (PHOENIX-3111) Possible Deadlock/delay while building index, upsert select, delete rows at server

2016-08-12 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419688#comment-15419688 ] Sergey Soldatov commented on PHOENIX-3111: -- [~jamestaylor] [~lhofhansl] we do not prevent

[jira] [Commented] (PHOENIX-2336) Queries with small case column-names return empty result-set when working with Spark Datasource Plugin

2016-08-12 Thread Kalyan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419656#comment-15419656 ] Kalyan commented on PHOENIX-2336: - Please go with '(Kalyan Hadoop)' > Queries with small case

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

2016-08-12 Thread Mujtaba Chohan
Hi Amit, * What's the heap size of each of your region servers? * Do you see huge amount of disk reads when you do a select count(*) from tpch.lineitem? If yes then try setting snappy compression on your table followed by major compaction * Were there any deleted rows in this table? What's the

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

2016-08-12 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419451#comment-15419451 ] Thomas D'Silva commented on PHOENIX-2995: - I also removed the

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

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

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419373#comment-15419373 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74652145 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/index/LocalIndexIT.java --- @@ -76,24 +76,18 @@ import

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419368#comment-15419368 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74651889 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/index/IndexMetadataIT.java --- @@ -354,27 +355,29 @@ public void

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419361#comment-15419361 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74651475 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/index/IndexExpressionIT.java --- @@ -515,22 +531,27 @@ public void

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419359#comment-15419359 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419358#comment-15419358 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74651437 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/index/IndexExpressionIT.java --- @@ -461,14 +472,19 @@ public void

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419353#comment-15419353 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419257#comment-15419257 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74637772 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/UpsertBigValuesIT.java --- @@ -62,7 +62,7 @@ public void testIntegerPK() throws Exception

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419245#comment-15419245 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74636561 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantIdTypeIT.java --- @@ -74,7 +74,8 @@ public TenantIdTypeIT(String dataType, String

[jira] [Commented] (PHOENIX-2336) Queries with small case column-names return empty result-set when working with Spark Datasource Plugin

2016-08-12 Thread Josh Mahonin (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419207#comment-15419207 ] Josh Mahonin commented on PHOENIX-2336: --- Looks good to me. Applies cleanly and tests pass. Anyone

[jira] [Updated] (PHOENIX-3164) PhoenixConnection leak in PQS with security enabled

2016-08-12 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-3164: Fix Version/s: 4.9.0 > PhoenixConnection leak in PQS with security enabled >

[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-12 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419199#comment-15419199 ] ASF GitHub Bot commented on PHOENIX-3036: - Github user samarthjain commented on a diff in the

[GitHub] phoenix pull request #189: PHOENIX-3036 Modify phoenix IT tests to extend Ba...

2016-08-12 Thread samarthjain
Github user samarthjain commented on a diff in the pull request: https://github.com/apache/phoenix/pull/189#discussion_r74631717 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/SortMergeJoinMoreIT.java --- @@ -39,10 +39,10 @@ import

[ANNOUNCE] Apache Phoenix 4.8.0 released

2016-08-12 Thread Ankit Singhal
Apache Phoenix enables OLTP and operational analytics for Hadoop through SQL support and integration with other projects in the ecosystem such as Spark, HBase, Pig, Flume, MapReduce and Hive. We're pleased to announce our 4.8.0 release which includes: - Local Index improvements[1] - Integration

[jira] [Commented] (PHOENIX-2336) Queries with small case column-names return empty result-set when working with Spark Datasource Plugin

2016-08-12 Thread Kalyan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419065#comment-15419065 ] Kalyan commented on PHOENIX-2336: - Hi Josh Mahonin , updated patch attached .. please review > Queries

[jira] [Updated] (PHOENIX-2336) Queries with small case column-names return empty result-set when working with Spark Datasource Plugin

2016-08-12 Thread Kalyan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kalyan updated PHOENIX-2336: Attachment: PHOENIX-2336_PHOENIX-2290_PHOENIX-2547_unit_tests.patch PHOENIX-2336, PHOENIX-2290 and

[jira] [Updated] (PHOENIX-2336) Queries with small case column-names return empty result-set when working with Spark Datasource Plugin

2016-08-12 Thread Kalyan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kalyan updated PHOENIX-2336: Attachment: PHOENIX-2336_PHOENIX-2290_PHOENIX-2547_code_changes.patch PHOENIX-2336, PHOENIX-2290 and

[GitHub] phoenix issue #186: cleanup sqlline*.py using python idioms.

2016-08-12 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/186 Sorry for the delay @btbytes, I missed your latest push where you addressed sqlline.py too. Thanks! I think this is looking good. I left one comment for you. I will try to test this out

[GitHub] phoenix pull request #186: cleanup sqlline*.py using python idioms.

2016-08-12 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r74614217 --- Diff: bin/sqlline.py --- @@ -1,4 +1,5 @@ #!/usr/bin/env python +"""sqlline.py""" --- End diff -- Is this a convention I don't

[jira] [Commented] (PHOENIX-3150) Sqlline version 1.1.8 has been Depreciated.

2016-08-12 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419030#comment-15419030 ] Josh Elser commented on PHOENIX-3150: - Hi [~vishnu667], I'm not sure that we're planning to make

[jira] [Updated] (PHOENIX-3158) COUNT(DISTINCT) may return null instead of 0 after PHOENIX-258

2016-08-12 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3158: -- Fix Version/s: (was: 4.8.1) 4.8.0 > COUNT(DISTINCT) may return null

[jira] [Updated] (PHOENIX-3070) Unnecessary use of UUID.randomUUID()

2016-08-12 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3070: -- Fix Version/s: (was: 4.8.1) 4.8.0 > Unnecessary use of

[jira] [Resolved] (PHOENIX-3123) Document new local index implementation and upgrade steps

2016-08-12 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla resolved PHOENIX-3123. -- Resolution: Fixed Thanks for review [~jamestaylor]. Committed the doc

Issues while Running Apache Phoenix against TPC-H data

2016-08-12 Thread Amit Mudgal
> > Hi Dev team, > > I was evaluating Apache Phoenix against the TPC-H data based on the > presentation given at Hadoop summit in june stating that most TPC-H queries > should run. > Here is the setup details i have in my local environment : > > 1. One master node and 3 region servers with

[jira] [Commented] (PHOENIX-3176) Rows will be skipped which are having future timestamp in row_timestamp column

2016-08-12 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15418116#comment-15418116 ] Samarth Jain commented on PHOENIX-3176: --- Also, with Ankit's patch, the test

[jira] [Created] (PHOENIX-3177) Create endpoint coprocessors for write operations instead of piggybacking on region observer

2016-08-12 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3177: - Summary: Create endpoint coprocessors for write operations instead of piggybacking on region observer Key: PHOENIX-3177 URL: https://issues.apache.org/jira/browse/PHOENIX-3177

[jira] [Commented] (PHOENIX-3111) Possible Deadlock/delay while building index, upsert select, delete rows at server

2016-08-12 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15418094#comment-15418094 ] James Taylor commented on PHOENIX-3111: --- Circling back to this now that 4.8.0 is out. We can

[jira] [Updated] (PHOENIX-3178) Row count incorrect for UPSERT SELECT when auto commit is false

2016-08-12 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3178: -- Fix Version/s: 4.8.1 > Row count incorrect for UPSERT SELECT when auto commit is false >