[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982344#comment-15982344 ] Lars Hofhansl commented on PHOENIX-3806: [~vincentpoon], in your case we should only be doing

[jira] [Commented] (PHOENIX-3811) Ignore index write failure and let client deal with failure

2017-04-24 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982342#comment-15982342 ] Lars Hofhansl commented on PHOENIX-3811: I think this should be configurable per index or at

[jira] [Created] (PHOENIX-3811) Ignore index write failure and let client deal with failure

2017-04-24 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3811: - Summary: Ignore index write failure and let client deal with failure Key: PHOENIX-3811 URL: https://issues.apache.org/jira/browse/PHOENIX-3811 Project: Phoenix

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982243#comment-15982243 ] James Taylor commented on PHOENIX-3806: --- How about we limit the number of versions we consider to

[jira] [Commented] (PHOENIX-3173) Store views in a separate hbase table from physical tables

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982237#comment-15982237 ] James Taylor commented on PHOENIX-3173: --- The valid point was raised on PHOENIX-2431, that we may

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread Vincent Poon (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982230#comment-15982230 ] Vincent Poon commented on PHOENIX-3806: --- What I find is that if I create 100 versions of a row,

[jira] [Commented] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982204#comment-15982204 ] James Taylor commented on PHOENIX-3710: --- Thanks for the patch, [~sergey.soldatov]. Who would be

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982197#comment-15982197 ] James Taylor commented on PHOENIX-3806: --- IMHO, we'd want to change the code such that we add all

[jira] [Commented] (PHOENIX-3715) Calcite-Phoenix exceptions do not match error code or specific SQLException sub-classes

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982192#comment-15982192 ] James Taylor commented on PHOENIX-3715: --- That's fine, [~maryannxue]. We can consider going with

[jira] [Commented] (PHOENIX-3809) CURRENT_DATE() (with parentheses) is illegal in Calcite

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15982190#comment-15982190 ] James Taylor commented on PHOENIX-3809: --- I think having a version that allows parentheses would

[jira] [Updated] (PHOENIX-3809) CURRENT_DATE() (with parentheses) is illegal in Calcite

2017-04-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated PHOENIX-3809: - Summary: CURRENT_DATE() (with parentheses) is illegal in Calcite (was: CURRENT_DATE() (with

[jira] [Updated] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-3710: - Attachment: test.sql test.sh > Cannot use lowername data table name

[jira] [Commented] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981928#comment-15981928 ] Sergey Soldatov commented on PHOENIX-3710: -- Actually index tool has problems with low case

[jira] [Updated] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-3710: - Attachment: PHOENIX-3710.patch > Cannot use lowername data table name with indextool >

[jira] [Assigned] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov reassigned PHOENIX-3710: Assignee: Sergey Soldatov > Cannot use lowername data table name with indextool

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981864#comment-15981864 ] Samarth Jain commented on PHOENIX-3806: --- The above suggestion won't work since we support point in

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

2017-04-24 Thread Akshita Malhotra (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981853#comment-15981853 ] Akshita Malhotra edited comment on PHOENIX-3744 at 4/24/17 8:41 PM:

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

2017-04-24 Thread Akshita Malhotra (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981853#comment-15981853 ] Akshita Malhotra edited comment on PHOENIX-3744 at 4/24/17 8:41 PM:

[jira] [Commented] (PHOENIX-3809) CURRENT_DATE() (with paranthesis) is illegal in calcite

2017-04-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981745#comment-15981745 ] Julian Hyde commented on PHOENIX-3809: -- Your call, [~jamestaylor]. {{CURRENT_DATE}} (without

[jira] [Commented] (PHOENIX-3572) Support FETCH NEXT| n ROWS from Cursor

2017-04-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981733#comment-15981733 ] ASF GitHub Bot commented on PHOENIX-3572: - Github user bijugs commented on a diff in the pull

[GitHub] phoenix pull request #229: PHOENIX-3572 Support FETCH NEXT|n ROWS query on c...

2017-04-24 Thread bijugs
Github user bijugs commented on a diff in the pull request: https://github.com/apache/phoenix/pull/229#discussion_r113034318 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/CursorWithRowValueConstructorIT.java --- @@ -0,0 +1,687 @@ +/* + * Licensed to the

[GitHub] phoenix pull request #239: Phoenix-3744: Support snapshot scanners for MR-ba...

2017-04-24 Thread akshita-malhotra
GitHub user akshita-malhotra opened a pull request: https://github.com/apache/phoenix/pull/239 Phoenix-3744: Support snapshot scanners for MR-based queries - Parallel Scan grouper is extended to differentiate the functionality for getting region boundaries - Added

[jira] [Commented] (PHOENIX-3572) Support FETCH NEXT| n ROWS from Cursor

2017-04-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981724#comment-15981724 ] ASF GitHub Bot commented on PHOENIX-3572: - Github user bijugs commented on a diff in the pull

[GitHub] phoenix pull request #229: PHOENIX-3572 Support FETCH NEXT|n ROWS query on c...

2017-04-24 Thread bijugs
Github user bijugs commented on a diff in the pull request: https://github.com/apache/phoenix/pull/229#discussion_r113033881 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/CursorWithRowValueConstructorIT.java --- @@ -0,0 +1,687 @@ +/* + * Licensed to the

[jira] [Commented] (PHOENIX-3572) Support FETCH NEXT| n ROWS from Cursor

2017-04-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981712#comment-15981712 ] ASF GitHub Bot commented on PHOENIX-3572: - Github user bijugs commented on a diff in the pull

[GitHub] phoenix pull request #229: PHOENIX-3572 Support FETCH NEXT|n ROWS query on c...

2017-04-24 Thread bijugs
Github user bijugs commented on a diff in the pull request: https://github.com/apache/phoenix/pull/229#discussion_r113032806 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/compile/QueryPlan.java --- @@ -59,6 +60,8 @@ * Returns projector used to formulate

[jira] [Commented] (PHOENIX-3572) Support FETCH NEXT| n ROWS from Cursor

2017-04-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981704#comment-15981704 ] ASF GitHub Bot commented on PHOENIX-3572: - Github user bijugs commented on a diff in the pull

[GitHub] phoenix pull request #229: PHOENIX-3572 Support FETCH NEXT|n ROWS query on c...

2017-04-24 Thread bijugs
Github user bijugs commented on a diff in the pull request: https://github.com/apache/phoenix/pull/229#discussion_r113032237 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/iterate/CursorResultIterator.java --- @@ -0,0 +1,75 @@ +/* + * Licensed to the Apache

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981699#comment-15981699 ] Samarth Jain commented on PHOENIX-3806: --- If there is a util to convert from a data table row to a

[jira] [Commented] (PHOENIX-3806) IndexUpdateManager spending a lot of time sorting mutations on Index rebuild

2017-04-24 Thread Vincent Poon (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981677#comment-15981677 ] Vincent Poon commented on PHOENIX-3806: --- Some more detail on this issue: What we found was that

[jira] [Created] (PHOENIX-3810) index_disable_timestamp not set by ALTER INDEX DISABLE

2017-04-24 Thread Vincent Poon (JIRA)
Vincent Poon created PHOENIX-3810: - Summary: index_disable_timestamp not set by ALTER INDEX DISABLE Key: PHOENIX-3810 URL: https://issues.apache.org/jira/browse/PHOENIX-3810 Project: Phoenix

[jira] [Commented] (PHOENIX-3778) Local Index - Writes get exponentially slower as batch size increases

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981591#comment-15981591 ] James Taylor commented on PHOENIX-3778: --- Duplicate of PHOENIX-3796. If writes are still

[jira] [Resolved] (PHOENIX-3778) Local Index - Writes get exponentially slower as batch size increases

2017-04-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-3778. --- Resolution: Duplicate > Local Index - Writes get exponentially slower as batch size

[jira] [Commented] (PHOENIX-3715) Calcite-Phoenix exceptions do not match error code or specific SQLException sub-classes

2017-04-24 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981557#comment-15981557 ] Maryann Xue commented on PHOENIX-3715: -- Still I think what Rajesh has committed is useful, for it

[jira] [Commented] (PHOENIX-3710) Cannot use lowername data table name with indextool

2017-04-24 Thread Csaba Skrabak (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981088#comment-15981088 ] Csaba Skrabak commented on PHOENIX-3710: Workaround should work: {noformat} --data-table

[jira] [Commented] (PHOENIX-3809) CURRENT_DATE() (with paranthesis) is illegal in calcite

2017-04-24 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15981065#comment-15981065 ] Ankit Singhal commented on PHOENIX-3809: [~jamestaylor]/[~julianhyde], what can we do here? >

[jira] [Updated] (PHOENIX-3809) CURRENT_DATE() (with paranthesis) is illegal in calcite

2017-04-24 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3809: --- Description: Calcite doesn't allow system functions to be specified with parenthesis who

[jira] [Created] (PHOENIX-3809) CURRENT_DATE() (with paranthesis) is illegal in calcite

2017-04-24 Thread Ankit Singhal (JIRA)
Ankit Singhal created PHOENIX-3809: -- Summary: CURRENT_DATE() (with paranthesis) is illegal in calcite Key: PHOENIX-3809 URL: https://issues.apache.org/jira/browse/PHOENIX-3809 Project: Phoenix