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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438318#comment-15438318 ] Samarth Jain edited comment on PHOENIX-3201 at 8/26/16 2:25 AM: --

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438318#comment-15438318 ] Samarth Jain commented on PHOENIX-3201: --- Like the patch would need to be rebased a

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438300#comment-15438300 ] James Taylor commented on PHOENIX-3201: --- Would you mind committing on behalf of Pr

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

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

[jira] [Created] (PHOENIX-3211) Support running UPSERT SELECT asynchronously

2016-08-25 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3211: - Summary: Support running UPSERT SELECT asynchronously Key: PHOENIX-3211 URL: https://issues.apache.org/jira/browse/PHOENIX-3211 Project: Phoenix Issue Type

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

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

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

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

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

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

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438199#comment-15438199 ] Samarth Jain commented on PHOENIX-3036: --- I am not able to apply the patch for mast

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

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

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3036: -- Attachment: PHOENIX-3036_v2.patch Patch that I am going to commit for 4.x-98 branch. > Modify

[jira] [Commented] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

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

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

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

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

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

[jira] [Commented] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438125#comment-15438125 ] James Taylor commented on PHOENIX-3203: --- +1. Thanks, [~tdsilva]! > Tenant cache l

[jira] [Commented] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

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

[jira] [Updated] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

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

[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437962#comment-15437962 ] James Taylor commented on PHOENIX-3210: --- Also, [~prakul] - if you could check all

[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread Shehzaad Nakhoda (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437855#comment-15437855 ] Shehzaad Nakhoda commented on PHOENIX-3210: --- [~prakul] once you have an upsert

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

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

[GitHub] phoenix issue #191: PHOENIX-3189 Perform Kerberos login before ConnectionInf...

2016-08-25 Thread JamesRTaylor
Github user JamesRTaylor commented on the issue: https://github.com/apache/phoenix/pull/191 Would an alternative be to not rely on the User.equals method, but instead modify ConnectionInfo.equals to do some other kind of equality check on User? --- If your project is set up for it, y

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

2016-08-25 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437849#comment-15437849 ] Thomas D'Silva commented on PHOENIX-2995: - [~tedyu] Are you referring to the ca

[jira] [Commented] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437848#comment-15437848 ] James Taylor commented on PHOENIX-3203: --- Patch looks good, but can we also change

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

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

[GitHub] phoenix pull request #191: PHOENIX-3189 Perform Kerberos login before Connec...

2016-08-25 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/191#discussion_r76336767 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixEmbeddedDriver.java --- @@ -333,6 +337,55 @@ public ConnectionInfo normalize(ReadOn

[jira] [Updated] (PHOENIX-3203) Tenant cache lookup in Global Cache fails in certain conditions

2016-08-25 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-3203: Attachment: PHOENIX-3203.patch [~jamestaylor] Can you please review? > Tenant cache look

[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread prakul agarwal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437834#comment-15437834 ] prakul agarwal commented on PHOENIX-3210: - I'm on it. > Exception trying to cas

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

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

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437822#comment-15437822 ] James Taylor commented on PHOENIX-3201: --- Thanks for the tip, [~samarthjain]. Would

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437817#comment-15437817 ] Samarth Jain commented on PHOENIX-3201: --- {code} git format-patch --stdout origin >

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437804#comment-15437804 ] James Taylor commented on PHOENIX-3201: --- Still not getting a test run, [~prakul].

[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437756#comment-15437756 ] James Taylor commented on PHOENIX-3210: --- [~prakul] - want to take a crack at this

[jira] [Updated] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3210: -- Assignee: prakul agarwal > Exception trying to cast Double to BigDecimal in UpsertCompiler > -

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

2016-08-25 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437732#comment-15437732 ] Josh Elser commented on PHOENIX-3189: - Hey [~devaraj], do you have a moment to look

[jira] [Updated] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3210: -- Labels: SFDC (was: ) > Exception trying to cast Double to BigDecimal in UpsertCompiler >

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437707#comment-15437707 ] Samarth Jain commented on PHOENIX-3036: --- Yes, passed for me for the last two runs.

[jira] [Updated] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3210: -- Fix Version/s: 4.8.1 4.9.0 > Exception trying to cast Double to BigDecimal

[jira] [Created] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread Shehzaad Nakhoda (JIRA)
Shehzaad Nakhoda created PHOENIX-3210: - Summary: Exception trying to cast Double to BigDecimal in UpsertCompiler Key: PHOENIX-3210 URL: https://issues.apache.org/jira/browse/PHOENIX-3210 Project:

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437660#comment-15437660 ] James Taylor commented on PHOENIX-3036: --- Nice! Great work, [~prakul] & [~samarthja

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

2016-08-25 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-3036: -- Attachment: PHOENIX-3036_addendum.patch Addendum patch to address verification failures we wer

[jira] [Updated] (PHOENIX-2474) Cannot round to a negative precision (to the left of the decimal)

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2474: -- Fix Version/s: 4.8.1 4.9.0 > Cannot round to a negative precision (to the l

[jira] [Issue Comment Deleted] (PHOENIX-2474) Cannot round to a negative precision (to the left of the decimal)

2016-08-25 Thread Kevin Liew (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Liew updated PHOENIX-2474: Comment: was deleted (was: https://github.com/apache/phoenix/pull/198) > Cannot round to a negati

[jira] [Comment Edited] (PHOENIX-2909) Surface checkAndPut through UPDATE statement

2016-08-25 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437596#comment-15437596 ] Andrew Purtell edited comment on PHOENIX-2909 at 8/25/16 8:28 PM:

[jira] [Commented] (PHOENIX-2474) Cannot round to a negative precision (to the left of the decimal)

2016-08-25 Thread Kevin Liew (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437604#comment-15437604 ] Kevin Liew commented on PHOENIX-2474: - https://github.com/apache/phoenix/pull/198 >

[jira] [Commented] (PHOENIX-2474) Cannot round to a negative precision (to the left of the decimal)

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

[GitHub] phoenix pull request #198: PHOENIX-2474 Cannot round to a negative precision...

2016-08-25 Thread kliewkliew
GitHub user kliewkliew opened a pull request: https://github.com/apache/phoenix/pull/198 PHOENIX-2474 Cannot round to a negative precision (to the left of the… … decimal) You can merge this pull request into a Git repository by running: $ git pull https://github.com/kliewkl

[jira] [Commented] (PHOENIX-2909) Surface checkAndPut through UPDATE statement

2016-08-25 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437596#comment-15437596 ] Andrew Purtell commented on PHOENIX-2909: - You might consider implementing count

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

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

Re: high client cpu usage

2016-08-25 Thread Aaron Molitor
1/1 EXPLAIN SELECT SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY FROM TPCH.LINEITEM, TPCH.PART WHERE P_PARTKEY = L_PARTKEY AND P_BRAND = 'BRAND#23' AND P_CONTAINER = 'MED BOX' AND L_QUANTITY < ( SELECT 0.2 * AVG(L_QUANTITY) FROM TPCH.LINEITEM WHERE L_PARTKEY = P_PARTKEY ) ; +

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

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

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

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

Re: high client cpu usage

2016-08-25 Thread Maryann Xue
Hi John, Would you mind sharing the query plan for this query (by running "EXPLAIN ")? Thanks, Maryann On Thu, Aug 25, 2016 at 11:19 AM, John Leach wrote: > Yeah, this query. > > QUERY: > SELECT SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY > FROM > TPCH.LINEITEM, > TPCH.PART > WHERE > P_PARTKE

[jira] [Created] (PHOENIX-3209) Ensure scans run at latest server timestamp for UPSERT SELECT to same table

2016-08-25 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3209: - Summary: Ensure scans run at latest server timestamp for UPSERT SELECT to same table Key: PHOENIX-3209 URL: https://issues.apache.org/jira/browse/PHOENIX-3209 Proje

Re: high client cpu usage

2016-08-25 Thread John Leach
Yeah, this query. QUERY: SELECT SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY FROM TPCH.LINEITEM, TPCH.PART WHERE P_PARTKEY = L_PARTKEY AND P_BRAND = 'BRAND#23' AND P_CONTAINER = 'MED BOX' AND L_QUANTITY < ( SELECT 0.2 * AVG(L_QUANTITY) FROM TPCH.LINEITEM WHERE L_PARTKEY = P_PA

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437434#comment-15437434 ] James Taylor commented on PHOENIX-3201: --- Thanks for the pull - FYI, you'll need to

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

2016-08-25 Thread prakul agarwal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437431#comment-15437431 ] prakul agarwal commented on PHOENIX-3201: - Raising a pull request on github (as

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

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

[GitHub] phoenix pull request #197: PHOENIX-3201 Implement DAYOFWEEK and DAYOFYEAR bu...

2016-08-25 Thread prakul
GitHub user prakul opened a pull request: https://github.com/apache/phoenix/pull/197 PHOENIX-3201 Implement DAYOFWEEK and DAYOFYEAR built-in functions You can merge this pull request into a Git repository by running: $ git pull https://github.com/prakul/phoenix phoe-3201 Alte

[jira] [Resolved] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2, 4.8-HBase-1.1 and 4.8-HBase-1.0 branches after PHOENIX-3148

2016-08-25 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva resolved PHOENIX-3207. - Resolution: Fixed [~jamestaylor] Sorry about that, I ran mvn package on the 4.x branche

Re: high client cpu usage

2016-08-25 Thread James Taylor
The client typically does a merge sort when combining results from paralllel scans. Not sure if this would explain the CPU/memory usage you're seeing. Can you narrow it down to a particular query that's causing the issue? Thanks, James On Thu, Aug 25, 2016 at 6:49 AM, John Leach wrote: > Can an

[jira] [Updated] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2, 4.8-HBase-1.1 and 4.8-HBase-1.0 branches after PHOENIX-3148

2016-08-25 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-3207: Summary: Fix compilation failure on 4.8-HBase-1.2, 4.8-HBase-1.1 and 4.8-HBase-1.0 branche

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437363#comment-15437363 ] James Taylor commented on PHOENIX-3201: --- Patch looks good, pending a test run. Nic

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

2016-08-25 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437351#comment-15437351 ] Josh Elser commented on PHOENIX-2991: - Thanks, [~maryannxue]! > Add missing documen

[jira] [Updated] (PHOENIX-3207) Fix compilation failure on 4.8-* branches after PHOENIX-3148

2016-08-25 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-3207: Summary: Fix compilation failure on 4.8-* branches after PHOENIX-3148 (was: Fix compilati

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

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

[jira] [Commented] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

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

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

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

Phoeinix tracing server Issue

2016-08-25 Thread Onkar Kadam
Hi Phoenix developers/users , We are trying to use the phoenix tracing server in our environment but we are facing issue while accessing the web application. We get HTTP ERROR 404 Problem accessing /webapp/. Reason: Not Found While accessing http://dev02-slv-01.neura-local.com:8864/webapp

[jira] [Updated] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3208: -- Attachment: PHOENIX-3208.patch > MutationState.toMutations method would throw a exception if multiple

[jira] [Updated] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenglei updated PHOENIX-3208: -- Description: MutationState.toMutations method is to return the current uncommitted table's mu

[jira] [Created] (PHOENIX-3208) MutationState.toMutations method would throw a exception if multiple tables are upserted

2016-08-25 Thread chenglei (JIRA)
chenglei created PHOENIX-3208: - Summary: MutationState.toMutations method would throw a exception if multiple tables are upserted Key: PHOENIX-3208 URL: https://issues.apache.org/jira/browse/PHOENIX-3208

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437108#comment-15437108 ] James Taylor commented on PHOENIX-1751: --- Filed HBASE-16503 with a simple test that

Re: high client cpu usage

2016-08-25 Thread John Leach
Can anyone explain why the client would be burning so much CPU and memory if the result is a single row? I suspect we configured something wrong on Phoenix but we are having a hard time figuring it out. Thanks in advance. Regards, John > On Aug 24, 2016, at 9:54 AM, Aaron Molitor wrote:

[jira] [Commented] (PHOENIX-2648) Phoenix Spark Integration does not allow Dynamic Columns to be mapped

2016-08-25 Thread Xiaopeng Liao (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15436825#comment-15436825 ] Xiaopeng Liao commented on PHOENIX-2648: Initially the ":" is used to indicate t

[jira] [Commented] (PHOENIX-2648) Phoenix Spark Integration does not allow Dynamic Columns to be mapped

2016-08-25 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15436743#comment-15436743 ] ASF GitHub Bot commented on PHOENIX-2648: - GitHub user xiaopeng-liao opened a pu

[GitHub] phoenix pull request #196: [PHOENIX-2648] Add dynamic column support for spa...

2016-08-25 Thread xiaopeng-liao
GitHub user xiaopeng-liao opened a pull request: https://github.com/apache/phoenix/pull/196 [PHOENIX-2648] Add dynamic column support for spark integration It supports both RDD and Dataframe read /write, Things needed consideration == When loading from Dataframe, the

Re: [DISCUSS] which 4.8 branches will be active?

2016-08-25 Thread Andrew Purtell
According to the responses received so far on our version usage survey, HBase 1.1 is the most popular, followed by 1.2, then 0.98. > On Aug 25, 2016, at 12:43 AM, James Taylor wrote: > > I propose we only continue releases for HBase 0.98 and 1.2, both for 4.8 > patch releases as well as 4.9 mi

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

2016-08-25 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15436461#comment-15436461 ] Andrew Purtell commented on PHOENIX-1751: - A delay longer than RPC timeout cause

[DISCUSS] which 4.8 branches will be active?

2016-08-25 Thread James Taylor
I propose we only continue releases for HBase 0.98 and 1.2, both for 4.8 patch releases as well as 4.9 minor releases. Thoughts?

[jira] [Updated] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2 and 4.8-HBase-1.1 branch after PHOENIX-3148

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3207: -- Summary: Fix compilation failure on 4.8-HBase-1.2 and 4.8-HBase-1.1 branch after PHOENIX-3148

[jira] [Updated] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2 branch after PHOENIX-3148

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3207: -- Fix Version/s: 4.8.1 > Fix compilation failure on 4.8-HBase-1.2 branch after PHOENIX-3148 > --

[jira] [Updated] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2 branch after PHOENIX-3148

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3207: -- Priority: Blocker (was: Major) > Fix compilation failure on 4.8-HBase-1.2 branch after PHOENI

[jira] [Created] (PHOENIX-3207) Fix compilation failure on 4.8-HBase-1.2 branch after PHOENIX-3148

2016-08-25 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3207: - Summary: Fix compilation failure on 4.8-HBase-1.2 branch after PHOENIX-3148 Key: PHOENIX-3207 URL: https://issues.apache.org/jira/browse/PHOENIX-3207 Project: Phoen

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

2016-08-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15436407#comment-15436407 ] James Taylor commented on PHOENIX-1751: --- It appears that in 0.98, a delay > rpcTim