[jira] [Commented] (PHOENIX-3128) Remove extraneous operations during upsert with local immutable index

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15403476#comment-15403476 ] James Taylor commented on PHOENIX-3128: --- It only fails for a LOCAL INDEX on testTa

[jira] [Updated] (PHOENIX-3128) Remove extraneous operations during upsert with local immutable index

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3128: -- Attachment: PHOENIX-3128_v5.patch Patch that passes all but one test, DistinctPrefixFilterIT.t

[jira] [Commented] (PHOENIX-1488) Calcite Integration

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15403417#comment-15403417 ] James Taylor commented on PHOENIX-1488: --- I've marked the filter as sharable by eve

[jira] [Created] (PHOENIX-3134) varbinary fields bulk load difference between MR and psql.

2016-08-01 Thread Sergey Soldatov (JIRA)
Sergey Soldatov created PHOENIX-3134: Summary: varbinary fields bulk load difference between MR and psql. Key: PHOENIX-3134 URL: https://issues.apache.org/jira/browse/PHOENIX-3134 Project: Phoenix

[jira] [Commented] (PHOENIX-3131) improve "order by " performance with aggregated query

2016-08-01 Thread tu nguyen khac (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15403336#comment-15403336 ] tu nguyen khac commented on PHOENIX-3131: - this is query plan of second query (

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

2016-08-01 Thread btbytes
Github user btbytes commented on the issue: https://github.com/apache/phoenix/pull/186 1. I have added what I think is cross-platform way of handling zombie? child processes. However, I realise there are more than one such call in each program. I'll have atleast one more push to addre

[jira] [Commented] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402981#comment-15402981 ] Lars Hofhansl commented on PHOENIX-3133: We have a fix now in HBASE-16296 (thank

[jira] [Commented] (PHOENIX-1488) Calcite Integration

2016-08-01 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402976#comment-15402976 ] Cody Marcel commented on PHOENIX-1488: -- [~jamestaylor] That search is still marked

[jira] [Commented] (PHOENIX-3131) improve "order by " performance with aggregated query

2016-08-01 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402939#comment-15402939 ] Samarth Jain commented on PHOENIX-3131: --- [~tuyuri] - can you post explain plans fo

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402865#comment-15402865 ] Josh Elser commented on PHOENIX-3126: - Let me take a closer look at things. Andrew's

[jira] [Commented] (PHOENIX-3120) AsyncIndexRebuilderTask fails for transactional tables

2016-08-01 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402808#comment-15402808 ] Hudson commented on PHOENIX-3120: - FAILURE: Integrated in Phoenix-master #1349 (See [ht

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread Enis Soztutar (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402802#comment-15402802 ] Enis Soztutar commented on PHOENIX-3126: There is {{UserProvider.getCurrent()}}

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread Enis Soztutar (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402796#comment-15402796 ] Enis Soztutar commented on PHOENIX-3126: +1 for 4.8. This looks like a serious e

[jira] [Assigned] (PHOENIX-3130) Ignore ASYNC and build indexes synchronously based on config property

2016-08-01 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva reassigned PHOENIX-3130: --- Assignee: Thomas D'Silva > Ignore ASYNC and build indexes synchronously based on co

[jira] [Commented] (PHOENIX-3130) Ignore ASYNC and build indexes synchronously based on config property

2016-08-01 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402704#comment-15402704 ] Thomas D'Silva commented on PHOENIX-3130: - Sure. > Ignore ASYNC and build index

[jira] [Updated] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3133: -- Description: We need to workaround HBASE-16296 because users of Phoenix won't see the fix unt

[jira] [Resolved] (PHOENIX-2231) Support CREATE SEQUENCE in Phoenix/Calcite Integration

2016-08-01 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-2231. -- Resolution: Fixed Assignee: Maryann Xue > Support CREATE SEQUENCE in Phoenix/Calcite Int

[jira] [Resolved] (PHOENIX-2741) Support DROP SEQUENCE in Phoenix/Calcite Integration

2016-08-01 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-2741. -- Resolution: Fixed Assignee: Maryann Xue > Support DROP SEQUENCE in Phoenix/Calcite Integ

[jira] [Updated] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3133: -- Description: We need to workaround HBASE-16296 because users of Phoenix won't see the fix unti

[jira] [Commented] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402681#comment-15402681 ] James Taylor commented on PHOENIX-3133: --- Would you mind taking a look at this one

[jira] [Updated] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3133: -- Description: We need to workaround (was: [~an...@apache.org] - mind taking a look at this on

[jira] [Resolved] (PHOENIX-3121) Queries with filter and reverse scan failing when limit is a multiple of scanner cache size

2016-08-01 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain resolved PHOENIX-3121. --- Resolution: Fixed > Queries with filter and reverse scan failing when limit is a multiple of

[jira] [Created] (PHOENIX-3133) Investigate why offset queries with reverse scan take a long time

2016-08-01 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-3133: - Summary: Investigate why offset queries with reverse scan take a long time Key: PHOENIX-3133 URL: https://issues.apache.org/jira/browse/PHOENIX-3133 Project: Phoeni

[jira] [Commented] (PHOENIX-3120) AsyncIndexRebuilderTask fails for transactional tables

2016-08-01 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402665#comment-15402665 ] Thomas D'Silva commented on PHOENIX-3120: - Sorry about that, I have committed a

[jira] [Commented] (PHOENIX-3121) Queries with filter and reverse scan failing when limit is a multiple of scanner cache size

2016-08-01 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402666#comment-15402666 ] Samarth Jain commented on PHOENIX-3121: --- The patch didn't help for the case with o

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402647#comment-15402647 ] James Taylor commented on PHOENIX-3126: --- I'm starting to think we should get this

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402639#comment-15402639 ] Andrew Purtell commented on PHOENIX-3126: - Different users can't share a connect

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

2016-08-01 Thread btbytes
Github user btbytes commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73030368 --- Diff: bin/sqlline-thin.py --- @@ -18,64 +18,58 @@ # limitations under the License. # #

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

2016-08-01 Thread btbytes
Github user btbytes commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73028883 --- Diff: bin/sqlline-thin.py --- @@ -18,64 +18,58 @@ # limitations under the License. # #

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

2016-08-01 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/186 > quite a bit of this script is to poke the environment .. which is I/O. Unit testing may not yield much. But, i'll take a fresh look. Yeah, I can understand where you're coming from. It

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

2016-08-01 Thread btbytes
Github user btbytes commented on the issue: https://github.com/apache/phoenix/pull/186 I'd definitely love add unit tests by breaking up the functionality into testable parts. I have couple of concerns: 1. the use of globals, esp in the common module -- `phoenix_utils`. If we

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

2016-08-01 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/186 Left a few comments for you inline. Overall, I like the changes. Would love to see corresponding ones made for sqlline.py initially (we tend to make changes to one in the other as well). I don't t

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

2016-08-01 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73025653 --- Diff: bin/sqlline-thin.py --- @@ -18,64 +18,58 @@ # limitations under the License. # ###

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

2016-08-01 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73024725 --- Diff: bin/sqlline-thin.py --- @@ -18,64 +18,58 @@ # limitations under the License. # ###

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

2016-08-01 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73024268 --- Diff: bin/sqlline-thin.py --- @@ -86,73 +80,83 @@ def get_serialization(): return default_serialization return stdout -i

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

2016-08-01 Thread joshelser
Github user joshelser commented on a diff in the pull request: https://github.com/apache/phoenix/pull/186#discussion_r73024052 --- Diff: bin/sqlline-thin.py --- @@ -18,64 +18,58 @@ # limitations under the License. # ###

[jira] [Commented] (PHOENIX-3132) cleanup sqlline-*.py using python idioms

2016-08-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402532#comment-15402532 ] ASF GitHub Bot commented on PHOENIX-3132: - Github user joshelser commented on th

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

2016-08-01 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/186 Great! I've given you karma and assigned PHOENIX-3132 to you. > I was waiting for a response do this PR before I took on more refactoring ;) Hah! Smart :) > I have teste

[jira] [Updated] (PHOENIX-3132) cleanup sqlline-*.py using python idioms

2016-08-01 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-3132: Assignee: Pradeep Gowda > cleanup sqlline-*.py using python idioms > -

[jira] [Commented] (PHOENIX-3132) cleanup sqlline-*.py using python idioms

2016-08-01 Thread Pradeep Gowda (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402458#comment-15402458 ] Pradeep Gowda commented on PHOENIX-3132: PR on github: https://github.com/apache

[jira] [Commented] (PHOENIX-3132) cleanup sqlline-*.py using python idioms

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

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

2016-08-01 Thread btbytes
Github user btbytes commented on the issue: https://github.com/apache/phoenix/pull/186 1. Issue - https://issues.apache.org/jira/browse/PHOENIX-3132 2. I was waiting for a response do this PR before I took on more refactoring ;) 3. I have tested in so far as the output of the

[jira] [Created] (PHOENIX-3132) cleanup sqlline-*.py using python idioms

2016-08-01 Thread Pradeep Gowda (JIRA)
Pradeep Gowda created PHOENIX-3132: -- Summary: cleanup sqlline-*.py using python idioms Key: PHOENIX-3132 URL: https://issues.apache.org/jira/browse/PHOENIX-3132 Project: Phoenix Issue Type:

[jira] [Commented] (PHOENIX-3069) Test-only async index builder should not requires tests to run in own mini cluster

2016-08-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402380#comment-15402380 ] Loknath Priyatham Teja Singamsetty commented on PHOENIX-3069: ---

[jira] [Resolved] (PHOENIX-3069) Test-only async index builder should not requires tests to run in own mini cluster

2016-08-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Loknath Priyatham Teja Singamsetty resolved PHOENIX-3069. -- Resolution: Fixed > Test-only async index buil

[jira] [Commented] (PHOENIX-3126) The driver implementation should take into account the context of the user

2016-08-01 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402377#comment-15402377 ] Josh Elser commented on PHOENIX-3126: - This is almost rather scary, but I think any

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

2016-08-01 Thread joshelser
Github user joshelser commented on the issue: https://github.com/apache/phoenix/pull/186 Hi @btbytes! Thanks for the changes so far. A couple of things: 1. Have you opened a JIRA issue which captures the changes you'd like to make? We want to make sure that JIRA is the source

[jira] [Commented] (PHOENIX-2084) Support loading json data using apache phoenix flume plugin

2016-08-01 Thread Kalyan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402064#comment-15402064 ] Kalyan commented on PHOENIX-2084: - as per previous comments .. i updated the code . now

[jira] [Commented] (PHOENIX-3120) AsyncIndexRebuilderTask fails for transactional tables

2016-08-01 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402002#comment-15402002 ] Ankit Singhal commented on PHOENIX-3120: can you please check the below failure

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

2016-08-01 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15401979#comment-15401979 ] Hudson commented on PHOENIX-3111: - FAILURE: Integrated in Phoenix-master #1348 (See [ht

[jira] [Commented] (PHOENIX-3121) Queries with filter and reverse scan failing when limit is a multiple of scanner cache size

2016-08-01 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15401940#comment-15401940 ] Ankit Singhal commented on PHOENIX-3121: is this a blocker for 4.8? > Queries

[jira] [Created] (PHOENIX-3131) improve "order by " performance with aggregated query

2016-08-01 Thread tu nguyen khac (JIRA)
tu nguyen khac created PHOENIX-3131: --- Summary: improve "order by " performance with aggregated query Key: PHOENIX-3131 URL: https://issues.apache.org/jira/browse/PHOENIX-3131 Project: Phoenix

Useless Delete operations in global index update

2016-08-01 Thread William
Hi all, I found an interesting problem in global secondary index update. I am using Phoenix 4.6.1. See the following SQLs: create table tt (pk1 integer not null, pk2 varchar not null, cf.a integer, cf.b varchar constraint pk primary key (pk1, pk2)); create index tta on tt(cf.a); cre