Re: Support HBase Increment and CheckAndMutate API

2016-05-03 Thread James Taylor
Hi William, I'd recommend looking at supporting these HBase features through the standard SQL merge statement where they compile down to these native calls when possible. Also, with our transaction support, you can already do an increment atomically and retry if a conflict occurs. Thanks, James On

Re: Question on aggregate function

2016-05-03 Thread James Taylor
Hi Swapna, All our aggregate functions allow expressions as arguments and it wouldn't make sense to have these new ones be different. A reference to a column is also an expression. It doesn't change the HBase data model being sparse. I think the next step should be for you to submit a patch that t

Re: Question on aggregate function

2016-05-03 Thread Swapna Swapna
Hi James, Thanks for your swift response. I wouldn't be able to use the expression in the below query rather I would have to provide the columns (as arguments) which I'm interested in to perform the aggregation on respective provided columns. myaggFunc(col1,col2) the reason being, the hbase dat

Support HBase Increment and CheckAndMutate API

2016-05-03 Thread William
Hi all, I am trying to support hbase Increment and checkAndPut/checkAndDelete in phoenix and have done with Increment by introducing a new statement INCREMENT. Grammar: INCREMENT tableName (column defs) VALUES() where expressions Because all increment operations can be stored in a sin

Re: [ANNOUNCE] Ankit Singhal joins Phoenix PMC

2016-05-03 Thread rajeshb...@apache.org
Congratulations Ankit!!! Nice work. On Wed, May 4, 2016 at 8:54 AM, Jesse Yates wrote: > Congrats Ankit! > > On Tue, May 3, 2016, 8:01 PM Nick Dimiduk wrote: > > > Nice work Ankit, congrats! > > > > On Tuesday, May 3, 2016, James Taylor wrote: > > > > > On behalf of the Apache Phoenix PMC, I'm

Re: [ANNOUNCE] Ankit Singhal joins Phoenix PMC

2016-05-03 Thread Jesse Yates
Congrats Ankit! On Tue, May 3, 2016, 8:01 PM Nick Dimiduk wrote: > Nice work Ankit, congrats! > > On Tuesday, May 3, 2016, James Taylor wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Ankit > > Singhal has accepted our invitation to become a member of the Apache >

Re: [ANNOUNCE] Ankit Singhal joins Phoenix PMC

2016-05-03 Thread Nick Dimiduk
Nice work Ankit, congrats! On Tuesday, May 3, 2016, James Taylor wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Ankit > Singhal has accepted our invitation to become a member of the Apache > Phoenix project management committee (PMC). Recently he's implemented two > o

Re: [ANNOUNCE] Ankit Singhal joins Phoenix PMC

2016-05-03 Thread Josh Elser
Congrats and well deserved, Ankit! James Taylor wrote: On behalf of the Apache Phoenix PMC, I'm pleased to announce that Ankit Singhal has accepted our invitation to become a member of the Apache Phoenix project management committee (PMC). Recently he's implemented two of the most asked for feat

Re: Question on aggregate function

2016-05-03 Thread James Taylor
Hi Swapna, The return type is typically derived from looking at the return types of each of the input arguments and choosing what'll work without losing precision. For example, take a look at this loop in ExpressionCompiler that determines this for expressions that are added together: new

[jira] [Commented] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15270017#comment-15270017 ] James Taylor commented on PHOENIX-2874: --- +1. Looks good, [~an...@apache.org]. Most

A detail in LimitNodeCompiler

2016-05-03 Thread William
Hi all, I have a very small question. In LimitNodeCompiler.LimitParseNodeVisitor#visit(BindParseNode), For BindParseNode, it creates a LiteralParseNode and visit it again. Why? Why not handle it directly? I don't realy understand what the comments said: // Resolve the bind value, create a Li

[jira] [Commented] (PHOENIX-2874) Delete schemas also during clean up after test

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

Re: [jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-03 Thread Sebastiano Ippolito
Hi, I want unsubscribe for this group. Could you delete my account? regards. Sebastiano. 2016-05-03 22:27 GMT+02:00 Ankit Singhal (JIRA) : > > [ > https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1526

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-03 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269512#comment-15269512 ] Ankit Singhal commented on PHOENIX-2862: [~samarthjain], let me know if you have

[jira] [Updated] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2874: --- Attachment: PHOENIX-2874_v3.patch bq. The DROP SCHEMA call should respect the QueryServices.

Re: Question on aggregate function

2016-05-03 Thread Swapna Swapna
Sure, Hbase data that I have is: rowkeyus uk 20161001 34 20161002 12 select myaggFunc(us) from table :// this is returning output as : 4 select myaggFunc(uk) from table :// this is returning output as : 6 In similar to

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-03 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269466#comment-15269466 ] Ankit Singhal commented on PHOENIX-2862: [~samarthjain] bq. It seems like users

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-03 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269436#comment-15269436 ] Samarth Jain commented on PHOENIX-2862: --- [~ankit.singhal] - I am not sure I am und

[ANNOUNCE] Ankit Singhal joins Phoenix PMC

2016-05-03 Thread James Taylor
On behalf of the Apache Phoenix PMC, I'm pleased to announce that Ankit Singhal has accepted our invitation to become a member of the Apache Phoenix project management committee (PMC). Recently he's implemented two of the most asked for features: support for HBase namespaces [1] (a 81 file pull req

[jira] [Commented] (PHOENIX-2845) Timestamp ignores nanos in literal expressions

2016-05-03 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269353#comment-15269353 ] James Taylor commented on PHOENIX-2845: --- +1 on the patch, [~sergey.soldatov]. Woul

[jira] [Comment Edited] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269344#comment-15269344 ] James Taylor edited comment on PHOENIX-2874 at 5/3/16 6:54 PM: ---

[jira] [Commented] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269344#comment-15269344 ] James Taylor commented on PHOENIX-2874: --- bq. I need to keep PhoenixIOException( wr

Re: Question on aggregate function

2016-05-03 Thread James Taylor
Removing user list (please don't cross post) Can you give us a full example of the query you have in mind? Thanks, James On Tue, May 3, 2016 at 11:14 AM, Swapna Swapna wrote: > Hi, > > I'm trying to implement aggregate function on multiple columns (as an > arguments) like: > > myaggFunc(col1,c

Question on aggregate function

2016-05-03 Thread Swapna Swapna
Hi, I'm trying to implement aggregate function on multiple columns (as an arguments) like: myaggFunc(col1,col2) And I would want to return the results by each column after applying aggregate operation. The output would be something like: col1, count ( aggregate of all records for col1) col2, c

[jira] [Commented] (PHOENIX-2874) Delete schemas also during clean up after test

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

[jira] [Updated] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2874: --- Attachment: PHOENIX-2874_v2.patch > Delete schemas also during clean up after test > --

[jira] [Commented] (PHOENIX-2874) Delete schemas also during clean up after test

2016-05-03 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268502#comment-15268502 ] Ankit Singhal commented on PHOENIX-2874: Thanks [~jamestaylor] for the review. b

[jira] [Commented] (PHOENIX-2845) Timestamp ignores nanos in literal expressions

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

[jira] [Commented] (PHOENIX-2845) Timestamp ignores nanos in literal expressions

2016-05-03 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268391#comment-15268391 ] Sergey Soldatov commented on PHOENIX-2845: -- [~jamestaylor] with other DBs there

[jira] [Updated] (PHOENIX-2845) Timestamp ignores nanos in literal expressions

2016-05-03 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2845: - Attachment: PHOENIX-2845-3.patch > Timestamp ignores nanos in literal expressions >

[jira] [Created] (PHOENIX-2876) Using aggregation function in ORDER BY

2016-05-03 Thread Sergey Soldatov (JIRA)
Sergey Soldatov created PHOENIX-2876: Summary: Using aggregation function in ORDER BY Key: PHOENIX-2876 URL: https://issues.apache.org/jira/browse/PHOENIX-2876 Project: Phoenix Issue Type

[jira] [Assigned] (PHOENIX-2876) Using aggregation function in ORDER BY

2016-05-03 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov reassigned PHOENIX-2876: Assignee: Sergey Soldatov > Using aggregation function in ORDER BY >