Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Dumindu Buddhika
Thank you all :-) .

On Sat, Sep 19, 2015 at 5:46 AM, Mujtaba Chohan  wrote:

> Welcome onboard Dumindu!!
>
> On Friday, September 18, 2015, Nick Dimiduk  wrote:
>
> > Nice work Dumindu!
> >
> > On Thu, Sep 17, 2015 at 9:18 PM, Vasudevan, Ramkrishna S <
> > ramkrishna.s.vasude...@intel.com > wrote:
> >
> > > Hi All
> > >
> > > Please welcome our newest committer Dumindu Buddhika to the Apache
> > Phoenix
> > > team.  Dumindu,  a student and an intern in the GSoC  program, has
> > > contributed lot of new functionalities related to the PHOENIX ARRAY
> > feature
> > > and also has involved himself in lot of critical bug fixes even after
> the
> > > GSoC period was over.
> > > He is a quick learner and a very young blood eager to contribute to
> > > Phoenix and its roadmap.
> > >
> > > All the best and congratulations, Dumindu  Welcome on board !!!
> > >
> > > Regards
> > > Ram
> > >
> >
>


[jira] [Commented] (PHOENIX-2205) Group by a divided value (e.g., time/10) returns NULL.

2015-09-18 Thread Dumindu Buddhika (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876921#comment-14876921
 ] 

Dumindu Buddhika commented on PHOENIX-2205:
---

[~jamestaylor] - I will commit this.

> Group by a divided value (e.g., time/10) returns NULL.
> --
>
> Key: PHOENIX-2205
> URL: https://issues.apache.org/jira/browse/PHOENIX-2205
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Rafit Izhak Ratzin
>Assignee: Dumindu Buddhika
> Attachments: PHOENIX-2205.patch
>
>
> Running with an environment that includes:  phoenix version 4.5.0,  HBase 
> version 0.98, Cloudera 5.2
> When I group by a divided value (e.g., time/10) the divided value will return 
> as NULL.
> Please see the simple examples below,
> Thanks in advance, 
> --Rafit
>  create table test(time integer not null, hostname varchar not null,usage 
> float constraint pk PRIMARY KEY(time, hostname));
> upsert into test values(1439853441,'qa8',3.28);
> upsert into test values(1439853449,'qa8',3.28);
> upsert into test values(1439853459,'qa8',3.28);
> upsert into test values(1439853458,'qa8',3.27);
> upsert into test values(1439853457,'qa8',6.27);
> upsert into test values(1439853462,'qa8',8.27);
> upsert into test values(1439853462,'qa9',8.27);
> upsert into test values(1439853457,'qa9',6.27);
> 0: jdbc:phoenix:localhost> select * from test;
> +--+--++
> |   TIME | HOSTNAME|  
> USAGE   |
> +--+--++
> | 1439853441 | qa8
>   | 3.28 |
> | 1439853449 | qa8
>   | 3.28 |
> | 1439853457 | qa8
>   | 6.27 |
> | 1439853457 | qa9
>   | 6.27 |
> | 1439853458 | qa8
>   | 3.27 |
> | 1439853459 | qa8
>   | 3.28 |
> | 1439853462 | qa8
>   | 8.27 |
> | 1439853462 | qa9
>   | 8.27 |
> +--+--++
> 0: jdbc:phoenix:localhost> select time/10, hostname, usage from test;
> ++--+--+
> |  (TIME / 10)   | HOSTNAME|  
> USAGE  |
> ++--+--+
> | 143985344 | qa8 
>  | 3.28   |
> | 143985344 | qa8 
>  | 3.28   |
> | 143985345 | qa8 
>  | 6.27   |
> | 143985345 | qa9 
>  | 6.27   |
> | 143985345 | qa8 
>  | 3.27   |
> | 143985345 | qa8 
>  | 3.28   |
> | 143985346 | qa8 
>  | 8.27   |
> | 143985346 | qa9 
>  | 8.27   |
> ++--+--+
> 0: jdbc:phoenix:localhost> select time/10 as tm, hostname, avg(usage) from 
> test group by hostname, tm;
> ++--+--+
> |   TM  | HOSTNAME|   

Re: [RESULT][VOTE] Release of Apache Phoenix 4.5.2-HBase-1.1 RC1

2015-09-18 Thread Ayola Jayamaha
+1

On Thu, Sep 17, 2015 at 3:19 AM, James Taylor 
wrote:

> The vote for the release of Apache Phoenix 4.5.2-HBase-1.1 RC1 is now
> closed and has passed with 4 binding +1s and no 0 or -1s:
>
> Mujtaba Chohan*
> Samarth Jain*
> Maryann Xue*
> James Taylor*
>
> *=binding
>
> We'll push out the new release soon. Thanks to those who voted.
>
> James (on behalf of the Apache Phoenix team)
>
> On Wed, Sep 16, 2015 at 2:25 PM, James Taylor 
> wrote:
>
> > +1
> >
> > On Wed, Sep 16, 2015 at 12:59 PM, Mujtaba Chohan 
> > wrote:
> >
> >> +1.
> >>
> >> Verified hash/signatures/utests.
> >>
> >> On Wed, Sep 16, 2015 at 9:38 AM, Samarth Jain 
> wrote:
> >>
> >> > +1
> >> >
> >> > On Tue, Sep 15, 2015 at 10:14 AM, Maryann Xue 
> >> > wrote:
> >> >
> >> > > +1
> >> > >
> >> > > On Fri, Sep 11, 2015 at 7:40 PM, James Taylor <
> jamestay...@apache.org
> >> >
> >> > > wrote:
> >> > >
> >> > > > Hi Everyone,
> >> > > >
> >> > > > This is a call for a vote on Apache Phoenix 4.5.2-HBase-1.1 RC1.
> >> This
> >> > is
> >> > > a
> >> > > > patch release of Phoenix 4, compatible with the 1.1 branch of
> Apache
> >> > > HBase.
> >> > > > The release includes both a source-only release and a convenience
> >> > binary
> >> > > > release. The previous RC was sunk due to PHOENIX-2252.
> >> > > >
> >> > > > The source tarball, including signatures, digests, etc can be
> found
> >> at:
> >> > > >
> >> > > >
> >> > >
> >> >
> >>
> https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.5.2-HBase-1.1-rc1/src/
> >> > > >
> >> > > > The binary artifacts can be found at:
> >> > > >
> >> > > >
> >> > >
> >> >
> >>
> https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.5.2-HBase-1.1-rc1/bin/
> >> > > >
> >> > > > For a complete list of changes, see:
> >> > > >
> >> > > >
> >> > >
> >> >
> >>
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=1239
> >> > > >
> >> > > > Release artifacts are signed with the following key:
> >> > > > https://people.apache.org/keys/committer/mujtaba.asc
> >> > > >
> >> > > > KEYS file available here:
> >> > > > https://dist.apache.org/repos/dist/release/phoenix/KEYS
> >> > > >
> >> > > > The hash and tag to be voted upon:
> >> > > >
> >> > > >
> >> > >
> >> >
> >>
> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=24cd96d9a70b0ad4a21e2517b9b0cbb822ff1a0a
> >> > > >
> >> > > >
> >> > >
> >> >
> >>
> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=tag;h=refs/tags/v4.5.2-HBase-1.1-rc1
> >> > > >
> >> > > > Vote will be open for at least 72 hours. Please vote:
> >> > > >
> >> > > > [ ] +1 approve
> >> > > > [ ] +0 no opinion
> >> > > > [ ] -1 disapprove (and reason why)
> >> > > >
> >> > > > Thanks,
> >> > > > The Apache Phoenix Team
> >> > > >
> >> > >
> >> >
> >>
> >
> >
>



-- 
Best Regards,
Nishani Jayamaha
http://ayolajayamaha.blogspot.com/


Re: [jira] [Reopened] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information

2015-09-18 Thread Ayola Jayamaha
ok sure.


On Fri, Sep 18, 2015 at 11:41 PM, Nick Dimiduk (JIRA) 
wrote:

>
>  [
> https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
> ]
>
> Nick Dimiduk reopened PHOENIX-1118:
> ---
>
> Please don't resolve an umbrella issue for which all subtasks have not
> been completed.
>
> > Provide a tool for visualizing Phoenix tracing information
> > --
> >
> > Key: PHOENIX-1118
> > URL: https://issues.apache.org/jira/browse/PHOENIX-1118
> > Project: Phoenix
> >  Issue Type: New Feature
> >Reporter: James Taylor
> >Assignee: Nishani
> >  Labels: Java, SQL, Visualization, gsoc2015, mentor
> > Fix For: 4.6.0
> >
> > Attachments: MockUp1-TimeSlider.png, MockUp2-AdvanceSearch.png,
> MockUp3-PatternDetector.png, MockUp4-FlameGraph.png, Screenshot of
> dependency tree.png, Screenshot-loading-trace-list.png,
> m1-mockUI-tracedistribution.png, m1-mockUI-tracetimeline.png, screenshot of
> tracing timeline.png, screenshot of tracing web app.png, timeline.png
> >
> >
> > Currently there's no means of visualizing the trace information provided
> by Phoenix. We should provide some simple charting over our metrics tables.
> Take a look at the following JIRA for sample queries:
> https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151
> > The tool need to provide visualization over SYSTEM.TRACING_STATS table.
>
>
>
> --
> This message was sent by Atlassian JIRA
> (v6.3.4#6332)
>



-- 
Best Regards,
Nishani Jayamaha
http://ayolajayamaha.blogspot.com/


[jira] [Assigned] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  reassigned PHOENIX-2273:
-

Assignee: Nishani 

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>Assignee: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876895#comment-14876895
 ] 

Nishani  edited comment on PHOENIX-2273 at 9/19/15 5:29 AM:


Hi [~maryannxue] ,

The required information is added. If you need more details please mention them.

Thanks


was (Author: nishani):
[~maryannxue]
Hi [~maryannxue]
The required information is added. If you need more details please mention them.

Thanks

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876895#comment-14876895
 ] 

Nishani  edited comment on PHOENIX-2273 at 9/19/15 5:28 AM:


[~maryannxue]
Hi [~maryannxue]
The required information is added. If you need more details please mention them.

Thanks


was (Author: nishani):
The required information is added. If you need more details please mention them.

Thanks

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876895#comment-14876895
 ] 

Nishani  commented on PHOENIX-2273:
---

The required information is added. If you need more details please mention them.

Thanks

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876890#comment-14876890
 ] 

Nishani  commented on PHOENIX-2273:
---

The Environmental and System Matrices are given below.

jdk1.8.0_45
hbase-0.94.27
zookeeper-3.4.6
phoenix-3.3.1

OS - Linux Mint 17.1 "Rebecca"

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876887#comment-14876887
 ] 

Nishani  commented on PHOENIX-2273:
---

I have followed http://phoenix.apache.org/joins.html in creating a join query. 
But it fails to give any results even after hours of waiting.
The size and schema of the tables are given in the screenshots.

Thank you.

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  updated PHOENIX-2273:
--
Attachment: ScreenshotOfOrders&CustomersTables.png
ScreenShotOfJoinquery.png

The Tables CUSTOMERS & ORDERS used for join query.

create table ORDERS (id integer not null primary key, item varchar, customerid 
varchar);

create table CUSTOMERS (id integer not null primary key, name varchar);

SELECT O.ID, C.Name, O.Item FROM Orders AS O INNER JOIN Customers AS C ON 
O.CustomerID = C.ID;

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
> Attachments: ScreenShotOfJoinquery.png, 
> ScreenshotOfOrders&CustomersTables.png
>
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


Re: [DISCUSS] discontinue 4-x HBase 1.0 releases?

2015-09-18 Thread anil gupta
We use HDP at TrueCar. Currently, it ships with HBase1.1
And previous version of HDP shipped with HBase0.98.

On Fri, Sep 18, 2015 at 5:53 PM, James Taylor 
wrote:

> +user list
>
> Please let us know if you're counting on HBase 1.0 support given that we
> have HBase 1.1 support.
>
> Thanks,
> James
>
> On Fri, Sep 18, 2015 at 4:11 PM, Nick Dimiduk  wrote:
>
> > Seems like a better question for the users mailing list. Probably it
> > depends on where the vendors are going, if there will be a long-running
> > 1.0.x release line, we should keep it around. From Apache perspective,
> it's
> > probably fine to drop 1.0.x in favor of 1.1.x. HBase 1.2 is right around
> > the corner too...
> >
> > On Thu, Sep 17, 2015 at 4:42 PM, James Taylor 
> > wrote:
> >
> > > Given that we have Phoenix support for HBase 1.1, does anyone feel like
> > we
> > > need to continue with Phoenix releases for HBase 1.0?
> > >
> > > Thanks,
> > > James
> > >
> >
>



-- 
Thanks & Regards,
Anil Gupta


Re: problem creating user defined function

2015-09-18 Thread James Taylor
Hi Prathamesh,
What version of Phoenix are you using? I suspect you're using a pre-4.4.0
release, as UDFs are only supported from 4.4.0 onward.
Thanks,
James

On Fri, Sep 18, 2015 at 5:05 AM, Prathamesh Junnarkar <
prathames...@cybage.com> wrote:

> Hi Team,
>
> I want to create custom function in apache phoenix.
> But I am facing problems while running command to create function.
> Command:
> > CREATE FUNCTION ADDNUM(INTEGER,INTEGER) returns INTEGER as
> 'phoenix.udf.AddNumber'
>
> Exception:
>
> SQL Error [601] [42P00]: ERROR 601 (42P00): Syntax error. Encountered
> "FUNCTION" at line 1, column 8.
> ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column
> 8.
> org.antlr.runtime.NoViableAltException: NoViableAltException
>
> Can you please help me how can I proceed with creating UDF.
>
> Regards,
> Prathamesh Junnarkar
>
>
> "Legal Disclaimer: This electronic message and all contents contain
> information from Cybage Software Private Limited which may be privileged,
> confidential, or otherwise protected from disclosure. The information is
> intended to be for the addressee(s) only. If you are not an addressee, any
> disclosure, copy, distribution, or use of the contents of this message is
> strictly prohibited. If you have received this electronic message in error
> please notify the sender by reply e-mail to and destroy the original
> message and all copies. Cybage has taken every reasonable precaution to
> minimize the risk of malicious content in the mail, but is not liable for
> any damage you may sustain as a result of any malicious content in this
> e-mail. You should carry out your own malicious content checks before
> opening the e-mail or attachment." www.cybage.com
>


Re: [DISCUSS] discontinue 4-x HBase 1.0 releases?

2015-09-18 Thread Jesse Yates
Along the same lines as HBase, it seems fine to discontinue old code lines
until such point as there is someone willing to maintain a given line - a
new RM. Essentially, its the same as an RM stepping down from managing a
release and no releases happening until someone cares enough to make a new
one.

That said, if there are any users who want to step up and help maintain a
release that is no longer managed (ie. b/c you are running an older version
and can't upgrade) that would be fantastic.

On Fri, Sep 18, 2015 at 5:53 PM James Taylor  wrote:

> +user list
>
> Please let us know if you're counting on HBase 1.0 support given that we
> have HBase 1.1 support.
>
> Thanks,
> James
>
> On Fri, Sep 18, 2015 at 4:11 PM, Nick Dimiduk  wrote:
>
> > Seems like a better question for the users mailing list. Probably it
> > depends on where the vendors are going, if there will be a long-running
> > 1.0.x release line, we should keep it around. From Apache perspective,
> it's
> > probably fine to drop 1.0.x in favor of 1.1.x. HBase 1.2 is right around
> > the corner too...
> >
> > On Thu, Sep 17, 2015 at 4:42 PM, James Taylor 
> > wrote:
> >
> > > Given that we have Phoenix support for HBase 1.1, does anyone feel like
> > we
> > > need to continue with Phoenix releases for HBase 1.0?
> > >
> > > Thanks,
> > > James
> > >
> >
>


Re: [DISCUSS] discontinue 4-x HBase 1.0 releases?

2015-09-18 Thread James Taylor
+user list

Please let us know if you're counting on HBase 1.0 support given that we
have HBase 1.1 support.

Thanks,
James

On Fri, Sep 18, 2015 at 4:11 PM, Nick Dimiduk  wrote:

> Seems like a better question for the users mailing list. Probably it
> depends on where the vendors are going, if there will be a long-running
> 1.0.x release line, we should keep it around. From Apache perspective, it's
> probably fine to drop 1.0.x in favor of 1.1.x. HBase 1.2 is right around
> the corner too...
>
> On Thu, Sep 17, 2015 at 4:42 PM, James Taylor 
> wrote:
>
> > Given that we have Phoenix support for HBase 1.1, does anyone feel like
> we
> > need to continue with Phoenix releases for HBase 1.0?
> >
> > Thanks,
> > James
> >
>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Mujtaba Chohan
Welcome onboard Dumindu!!

On Friday, September 18, 2015, Nick Dimiduk  wrote:

> Nice work Dumindu!
>
> On Thu, Sep 17, 2015 at 9:18 PM, Vasudevan, Ramkrishna S <
> ramkrishna.s.vasude...@intel.com > wrote:
>
> > Hi All
> >
> > Please welcome our newest committer Dumindu Buddhika to the Apache
> Phoenix
> > team.  Dumindu,  a student and an intern in the GSoC  program, has
> > contributed lot of new functionalities related to the PHOENIX ARRAY
> feature
> > and also has involved himself in lot of critical bug fixes even after the
> > GSoC period was over.
> > He is a quick learner and a very young blood eager to contribute to
> > Phoenix and its roadmap.
> >
> > All the best and congratulations, Dumindu  Welcome on board !!!
> >
> > Regards
> > Ram
> >
>


Re: [DISCUSS] discontinue 4-x HBase 1.0 releases?

2015-09-18 Thread Nick Dimiduk
Seems like a better question for the users mailing list. Probably it
depends on where the vendors are going, if there will be a long-running
1.0.x release line, we should keep it around. From Apache perspective, it's
probably fine to drop 1.0.x in favor of 1.1.x. HBase 1.2 is right around
the corner too...

On Thu, Sep 17, 2015 at 4:42 PM, James Taylor 
wrote:

> Given that we have Phoenix support for HBase 1.1, does anyone feel like we
> need to continue with Phoenix releases for HBase 1.0?
>
> Thanks,
> James
>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Nick Dimiduk
Nice work Dumindu!

On Thu, Sep 17, 2015 at 9:18 PM, Vasudevan, Ramkrishna S <
ramkrishna.s.vasude...@intel.com> wrote:

> Hi All
>
> Please welcome our newest committer Dumindu Buddhika to the Apache Phoenix
> team.  Dumindu,  a student and an intern in the GSoC  program, has
> contributed lot of new functionalities related to the PHOENIX ARRAY feature
> and also has involved himself in lot of critical bug fixes even after the
> GSoC period was over.
> He is a quick learner and a very young blood eager to contribute to
> Phoenix and its roadmap.
>
> All the best and congratulations, Dumindu  Welcome on board !!!
>
> Regards
> Ram
>


[jira] [Commented] (PHOENIX-2254) zookeeper.znode.parent value is not taking affect in MR integration job

2015-09-18 Thread Nick Dimiduk (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876520#comment-14876520
 ] 

Nick Dimiduk commented on PHOENIX-2254:
---

Patch looks alright to me, but would be nice to have some test coverage here. 
Maybe you can add something to PhoenixEmbeddedDriverTest, as was done in 
PHOENIX-2005 ?

> zookeeper.znode.parent value is not taking affect in MR integration job
> ---
>
> Key: PHOENIX-2254
> URL: https://issues.apache.org/jira/browse/PHOENIX-2254
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.4.0, 4.5.2
>Reporter: Rajeshbabu Chintaguntla
>Assignee: Rajeshbabu Chintaguntla
> Fix For: 4.6.0
>
> Attachments: PHOENIX-2254.patch
>
>
> MR jobs considering default value of zookeeper.znode.parent always even if we 
> pass different value.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-2274) Sort-merge join could not optimize out the sort on the right table

2015-09-18 Thread Maryann Xue (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maryann Xue updated PHOENIX-2274:
-
Attachment: PHOENIX-2274.patch

> Sort-merge join could not optimize out the sort on the right table
> --
>
> Key: PHOENIX-2274
> URL: https://issues.apache.org/jira/browse/PHOENIX-2274
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.5.2
>Reporter: Maryann Xue
>Assignee: Maryann Xue
>Priority: Minor
> Attachments: PHOENIX-2274.patch
>
>
> {code}
> CREATE TABLE t (
> mypk VARCHAR(100) NOT NULL PRIMARY KEY,
> mycol VARCHAR(200));
> SELECT * FROM t t1 JOIN t t2 ON t1.mypk = t2.mypk;
> {code}
> would produce a plan like:
> {code}
> SORT-MERGE-JOIN (INNER) TABLES
> CLIENT PARALLEL 1-WAY FULL SCAN OVER T
> AND
> CLIENT PARALLEL 1-WAY FULL SCAN OVER T
> SERVER SORTED BY [MYPK]
> CLIENT MERGE SORT
> {code}
> , while it should have generated a plan like:
> {code}
> SORT-MERGE-JOIN (INNER) TABLES
> CLIENT PARALLEL 1-WAY FULL SCAN OVER T
> AND
> CLIENT PARALLEL 1-WAY FULL SCAN OVER T
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Reopened] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information

2015-09-18 Thread Nick Dimiduk (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nick Dimiduk reopened PHOENIX-1118:
---

Please don't resolve an umbrella issue for which all subtasks have not been 
completed.

> Provide a tool for visualizing Phoenix tracing information
> --
>
> Key: PHOENIX-1118
> URL: https://issues.apache.org/jira/browse/PHOENIX-1118
> Project: Phoenix
>  Issue Type: New Feature
>Reporter: James Taylor
>Assignee: Nishani 
>  Labels: Java, SQL, Visualization, gsoc2015, mentor
> Fix For: 4.6.0
>
> Attachments: MockUp1-TimeSlider.png, MockUp2-AdvanceSearch.png, 
> MockUp3-PatternDetector.png, MockUp4-FlameGraph.png, Screenshot of dependency 
> tree.png, Screenshot-loading-trace-list.png, m1-mockUI-tracedistribution.png, 
> m1-mockUI-tracetimeline.png, screenshot of tracing timeline.png, screenshot 
> of tracing web app.png, timeline.png
>
>
> Currently there's no means of visualizing the trace information provided by 
> Phoenix. We should provide some simple charting over our metrics tables. Take 
> a look at the following JIRA for sample queries: 
> https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151
> The tool need to provide visualization over SYSTEM.TRACING_STATS table.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Samarth Jain
Congrats and welcome, Dumindu!

On Fri, Sep 18, 2015 at 9:41 AM, Andrew Purtell  wrote:

> Congratulations and welcome!
>
>
> On Thu, Sep 17, 2015 at 9:18 PM, Vasudevan, Ramkrishna S <
> ramkrishna.s.vasude...@intel.com> wrote:
>
>> Hi All
>>
>>
>>
>> Please welcome our newest committer Dumindu Buddhika to the Apache
>> Phoenix team.  Dumindu,  a student and an intern in the GSoC  program, has
>> contributed lot of new functionalities related to the PHOENIX ARRAY feature
>> and also has involved himself in lot of critical bug fixes even after the
>> GSoC period was over.
>>
>> He is a quick learner and a very young blood eager to contribute to
>> Phoenix and its roadmap.
>>
>>
>>
>> All the best and congratulations, Dumindu  Welcome on board !!!
>>
>>
>>
>> Regards
>>
>> Ram
>>
>
>
>
> --
> Best regards,
>
>- Andy
>
> Problems worthy of attack prove their worth by hitting back. - Piet Hein
> (via Tom White)
>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Andrew Purtell
Congratulations and welcome!


On Thu, Sep 17, 2015 at 9:18 PM, Vasudevan, Ramkrishna S <
ramkrishna.s.vasude...@intel.com> wrote:

> Hi All
>
>
>
> Please welcome our newest committer Dumindu Buddhika to the Apache Phoenix
> team.  Dumindu,  a student and an intern in the GSoC  program, has
> contributed lot of new functionalities related to the PHOENIX ARRAY feature
> and also has involved himself in lot of critical bug fixes even after the
> GSoC period was over.
>
> He is a quick learner and a very young blood eager to contribute to
> Phoenix and its roadmap.
>
>
>
> All the best and congratulations, Dumindu  Welcome on board !!!
>
>
>
> Regards
>
> Ram
>



-- 
Best regards,

   - Andy

Problems worthy of attack prove their worth by hitting back. - Piet Hein
(via Tom White)


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Eli Levine
Welcome, Dumindu!

On Fri, Sep 18, 2015 at 9:33 AM, Thomas D'Silva 
wrote:

> Congrats Dumindu!
>
> On Fri, Sep 18, 2015 at 8:56 AM, Jesse Yates 
> wrote:
> > Welcome and congrats!
> >
> > On Fri, Sep 18, 2015 at 8:27 AM rajeshb...@apache.org <
> > chrajeshbab...@gmail.com> wrote:
> >
> >> Congratulations Dumindu!!!
> >> Great work.
> >>
> >> Thanks,
> >> Rajeshbabu.
> >>
> >> On Fri, Sep 18, 2015 at 7:43 PM, Ted Yu  wrote:
> >>
> >> > Congratulations Dumindu
> >> >
> >> > On Fri, Sep 18, 2015 at 7:10 AM, Gabriel Reid  >
> >> > wrote:
> >> >
> >> > > Welcome and congratulations Dumindu!
> >> > >
> >> > > - Gabriel
> >> > >
> >> > > On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
> >> > >  wrote:
> >> > > > Hi All
> >> > > >
> >> > > >
> >> > > >
> >> > > > Please welcome our newest committer Dumindu Buddhika to the Apache
> >> > > Phoenix
> >> > > > team.  Dumindu,  a student and an intern in the GSoC  program, has
> >> > > > contributed lot of new functionalities related to the PHOENIX
> ARRAY
> >> > > feature
> >> > > > and also has involved himself in lot of critical bug fixes even
> after
> >> > the
> >> > > > GSoC period was over.
> >> > > >
> >> > > > He is a quick learner and a very young blood eager to contribute
> to
> >> > > Phoenix
> >> > > > and its roadmap.
> >> > > >
> >> > > >
> >> > > >
> >> > > > All the best and congratulations, Dumindu  Welcome on board
> !!!
> >> > > >
> >> > > >
> >> > > >
> >> > > > Regards
> >> > > >
> >> > > > Ram
> >> > >
> >> >
> >>
>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Thomas D'Silva
Congrats Dumindu!

On Fri, Sep 18, 2015 at 8:56 AM, Jesse Yates  wrote:
> Welcome and congrats!
>
> On Fri, Sep 18, 2015 at 8:27 AM rajeshb...@apache.org <
> chrajeshbab...@gmail.com> wrote:
>
>> Congratulations Dumindu!!!
>> Great work.
>>
>> Thanks,
>> Rajeshbabu.
>>
>> On Fri, Sep 18, 2015 at 7:43 PM, Ted Yu  wrote:
>>
>> > Congratulations Dumindu
>> >
>> > On Fri, Sep 18, 2015 at 7:10 AM, Gabriel Reid 
>> > wrote:
>> >
>> > > Welcome and congratulations Dumindu!
>> > >
>> > > - Gabriel
>> > >
>> > > On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
>> > >  wrote:
>> > > > Hi All
>> > > >
>> > > >
>> > > >
>> > > > Please welcome our newest committer Dumindu Buddhika to the Apache
>> > > Phoenix
>> > > > team.  Dumindu,  a student and an intern in the GSoC  program, has
>> > > > contributed lot of new functionalities related to the PHOENIX ARRAY
>> > > feature
>> > > > and also has involved himself in lot of critical bug fixes even after
>> > the
>> > > > GSoC period was over.
>> > > >
>> > > > He is a quick learner and a very young blood eager to contribute to
>> > > Phoenix
>> > > > and its roadmap.
>> > > >
>> > > >
>> > > >
>> > > > All the best and congratulations, Dumindu  Welcome on board !!!
>> > > >
>> > > >
>> > > >
>> > > > Regards
>> > > >
>> > > > Ram
>> > >
>> >
>>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Jesse Yates
Welcome and congrats!

On Fri, Sep 18, 2015 at 8:27 AM rajeshb...@apache.org <
chrajeshbab...@gmail.com> wrote:

> Congratulations Dumindu!!!
> Great work.
>
> Thanks,
> Rajeshbabu.
>
> On Fri, Sep 18, 2015 at 7:43 PM, Ted Yu  wrote:
>
> > Congratulations Dumindu
> >
> > On Fri, Sep 18, 2015 at 7:10 AM, Gabriel Reid 
> > wrote:
> >
> > > Welcome and congratulations Dumindu!
> > >
> > > - Gabriel
> > >
> > > On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
> > >  wrote:
> > > > Hi All
> > > >
> > > >
> > > >
> > > > Please welcome our newest committer Dumindu Buddhika to the Apache
> > > Phoenix
> > > > team.  Dumindu,  a student and an intern in the GSoC  program, has
> > > > contributed lot of new functionalities related to the PHOENIX ARRAY
> > > feature
> > > > and also has involved himself in lot of critical bug fixes even after
> > the
> > > > GSoC period was over.
> > > >
> > > > He is a quick learner and a very young blood eager to contribute to
> > > Phoenix
> > > > and its roadmap.
> > > >
> > > >
> > > >
> > > > All the best and congratulations, Dumindu  Welcome on board !!!
> > > >
> > > >
> > > >
> > > > Regards
> > > >
> > > > Ram
> > >
> >
>


[jira] [Commented] (PHOENIX-2205) Group by a divided value (e.g., time/10) returns NULL.

2015-09-18 Thread James Taylor (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14875822#comment-14875822
 ] 

James Taylor commented on PHOENIX-2205:
---

[~Dumindux] - how about testing our your new commit abilities and checking this 
fix into the 4.x, 4.5, and master branch?

> Group by a divided value (e.g., time/10) returns NULL.
> --
>
> Key: PHOENIX-2205
> URL: https://issues.apache.org/jira/browse/PHOENIX-2205
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Rafit Izhak Ratzin
>Assignee: Dumindu Buddhika
> Attachments: PHOENIX-2205.patch
>
>
> Running with an environment that includes:  phoenix version 4.5.0,  HBase 
> version 0.98, Cloudera 5.2
> When I group by a divided value (e.g., time/10) the divided value will return 
> as NULL.
> Please see the simple examples below,
> Thanks in advance, 
> --Rafit
>  create table test(time integer not null, hostname varchar not null,usage 
> float constraint pk PRIMARY KEY(time, hostname));
> upsert into test values(1439853441,'qa8',3.28);
> upsert into test values(1439853449,'qa8',3.28);
> upsert into test values(1439853459,'qa8',3.28);
> upsert into test values(1439853458,'qa8',3.27);
> upsert into test values(1439853457,'qa8',6.27);
> upsert into test values(1439853462,'qa8',8.27);
> upsert into test values(1439853462,'qa9',8.27);
> upsert into test values(1439853457,'qa9',6.27);
> 0: jdbc:phoenix:localhost> select * from test;
> +--+--++
> |   TIME | HOSTNAME|  
> USAGE   |
> +--+--++
> | 1439853441 | qa8
>   | 3.28 |
> | 1439853449 | qa8
>   | 3.28 |
> | 1439853457 | qa8
>   | 6.27 |
> | 1439853457 | qa9
>   | 6.27 |
> | 1439853458 | qa8
>   | 3.27 |
> | 1439853459 | qa8
>   | 3.28 |
> | 1439853462 | qa8
>   | 8.27 |
> | 1439853462 | qa9
>   | 8.27 |
> +--+--++
> 0: jdbc:phoenix:localhost> select time/10, hostname, usage from test;
> ++--+--+
> |  (TIME / 10)   | HOSTNAME|  
> USAGE  |
> ++--+--+
> | 143985344 | qa8 
>  | 3.28   |
> | 143985344 | qa8 
>  | 3.28   |
> | 143985345 | qa8 
>  | 6.27   |
> | 143985345 | qa9 
>  | 6.27   |
> | 143985345 | qa8 
>  | 3.27   |
> | 143985345 | qa8 
>  | 3.28   |
> | 143985346 | qa8 
>  | 8.27   |
> | 143985346 | qa9 
>  | 8.27   |
> ++--+--+
> 0: jdbc:phoenix:localhost> select time/10 as tm, hostname, avg(usage) from 
> test group by hostname, tm;
> ++--+--+
> |

Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread rajeshb...@apache.org
Congratulations Dumindu!!!
Great work.

Thanks,
Rajeshbabu.

On Fri, Sep 18, 2015 at 7:43 PM, Ted Yu  wrote:

> Congratulations Dumindu
>
> On Fri, Sep 18, 2015 at 7:10 AM, Gabriel Reid 
> wrote:
>
> > Welcome and congratulations Dumindu!
> >
> > - Gabriel
> >
> > On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
> >  wrote:
> > > Hi All
> > >
> > >
> > >
> > > Please welcome our newest committer Dumindu Buddhika to the Apache
> > Phoenix
> > > team.  Dumindu,  a student and an intern in the GSoC  program, has
> > > contributed lot of new functionalities related to the PHOENIX ARRAY
> > feature
> > > and also has involved himself in lot of critical bug fixes even after
> the
> > > GSoC period was over.
> > >
> > > He is a quick learner and a very young blood eager to contribute to
> > Phoenix
> > > and its roadmap.
> > >
> > >
> > >
> > > All the best and congratulations, Dumindu  Welcome on board !!!
> > >
> > >
> > >
> > > Regards
> > >
> > > Ram
> >
>


[jira] [Created] (PHOENIX-2274) Sort-merge join could not optimize out the sort on the right table

2015-09-18 Thread Maryann Xue (JIRA)
Maryann Xue created PHOENIX-2274:


 Summary: Sort-merge join could not optimize out the sort on the 
right table
 Key: PHOENIX-2274
 URL: https://issues.apache.org/jira/browse/PHOENIX-2274
 Project: Phoenix
  Issue Type: Bug
Affects Versions: 4.5.2
Reporter: Maryann Xue
Assignee: Maryann Xue
Priority: Minor


{code}
CREATE TABLE t (
mypk VARCHAR(100) NOT NULL PRIMARY KEY,
mycol VARCHAR(200));

SELECT * FROM t t1 JOIN t t2 ON t1.mypk = t2.mypk;
{code}
would produce a plan like:
{code}
SORT-MERGE-JOIN (INNER) TABLES
CLIENT PARALLEL 1-WAY FULL SCAN OVER T
AND
CLIENT PARALLEL 1-WAY FULL SCAN OVER T
SERVER SORTED BY [MYPK]
CLIENT MERGE SORT
{code}
, while it should have generated a plan like:
{code}
SORT-MERGE-JOIN (INNER) TABLES
CLIENT PARALLEL 1-WAY FULL SCAN OVER T
AND
CLIENT PARALLEL 1-WAY FULL SCAN OVER T
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


problem creating user defined function

2015-09-18 Thread Prathamesh Junnarkar
Hi Team,

I want to create custom function in apache phoenix.
But I am facing problems while running command to create function.
Command:
> CREATE FUNCTION ADDNUM(INTEGER,INTEGER) returns INTEGER as 
> 'phoenix.udf.AddNumber'

Exception:

SQL Error [601] [42P00]: ERROR 601 (42P00): Syntax error. Encountered 
"FUNCTION" at line 1, column 8.
ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column 8.
org.antlr.runtime.NoViableAltException: NoViableAltException

Can you please help me how can I proceed with creating UDF.

Regards,
Prathamesh Junnarkar


"Legal Disclaimer: This electronic message and all contents contain information 
from Cybage Software Private Limited which may be privileged, confidential, or 
otherwise protected from disclosure. The information is intended to be for the 
addressee(s) only. If you are not an addressee, any disclosure, copy, 
distribution, or use of the contents of this message is strictly prohibited. If 
you have received this electronic message in error please notify the sender by 
reply e-mail to and destroy the original message and all copies. Cybage has 
taken every reasonable precaution to minimize the risk of malicious content in 
the mail, but is not liable for any damage you may sustain as a result of any 
malicious content in this e-mail. You should carry out your own malicious 
content checks before opening the e-mail or attachment." www.cybage.com


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Ted Yu
Congratulations Dumindu

On Fri, Sep 18, 2015 at 7:10 AM, Gabriel Reid 
wrote:

> Welcome and congratulations Dumindu!
>
> - Gabriel
>
> On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
>  wrote:
> > Hi All
> >
> >
> >
> > Please welcome our newest committer Dumindu Buddhika to the Apache
> Phoenix
> > team.  Dumindu,  a student and an intern in the GSoC  program, has
> > contributed lot of new functionalities related to the PHOENIX ARRAY
> feature
> > and also has involved himself in lot of critical bug fixes even after the
> > GSoC period was over.
> >
> > He is a quick learner and a very young blood eager to contribute to
> Phoenix
> > and its roadmap.
> >
> >
> >
> > All the best and congratulations, Dumindu  Welcome on board !!!
> >
> >
> >
> > Regards
> >
> > Ram
>


Re: [ANNOUNCE] Welcome our newest Committer Dumindu Buddhika

2015-09-18 Thread Gabriel Reid
Welcome and congratulations Dumindu!

- Gabriel

On Fri, Sep 18, 2015 at 6:18 AM, Vasudevan, Ramkrishna S
 wrote:
> Hi All
>
>
>
> Please welcome our newest committer Dumindu Buddhika to the Apache Phoenix
> team.  Dumindu,  a student and an intern in the GSoC  program, has
> contributed lot of new functionalities related to the PHOENIX ARRAY feature
> and also has involved himself in lot of critical bug fixes even after the
> GSoC period was over.
>
> He is a quick learner and a very young blood eager to contribute to Phoenix
> and its roadmap.
>
>
>
> All the best and congratulations, Dumindu  Welcome on board !!!
>
>
>
> Regards
>
> Ram


[jira] [Commented] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Maryann Xue (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14847360#comment-14847360
 ] 

Maryann Xue commented on PHOENIX-2273:
--

Could you please provide more details, [~nishani]? The queries you run, the DDL 
for your tables, the approximate amount of data in your tables, etc.

> Join Queries fail to give results within a finite time period 
> --
>
> Key: PHOENIX-2273
> URL: https://issues.apache.org/jira/browse/PHOENIX-2273
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Nishani 
>  Labels: Phoenix, query
>
> When the join queries are run on Phoenix Data Tables it fails to give 
> results. Either it takes a long time to give the results or the join queries 
> are not executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Issue Comment Deleted] (PHOENIX-2244) fix rat violations

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  updated PHOENIX-2244:
--
Comment: was deleted

(was: Issue Resolved.)

> fix rat violations
> --
>
> Key: PHOENIX-2244
> URL: https://issues.apache.org/jira/browse/PHOENIX-2244
> Project: Phoenix
>  Issue Type: Sub-task
>Reporter: Nick Dimiduk
>Assignee: Nishani 
>Priority: Blocker
> Fix For: 4.6.0
>
>
> We'll need to resolve the licensing header violations introduced here before 
> we can release.
> {noformat}
> *
> Summary
> ---
> Generated at: 2015-09-09T16:45:47-07:00
> Notes: 0
> Binaries: 9
> Archives: 1
> Standards: 53
> Apache Licensed: 9
> Generated Documents: 0
> JavaDocs are generated and so license header is optional
> Generated files do not required license headers
> 44 Unknown Licenses
> ***
> Unapproved licenses:
>   src/main/webapp/css/bootstrap-theme.css
>   src/main/webapp/css/bootstrap-theme.css.map
>   src/main/webapp/css/bootstrap.css
>   src/main/webapp/css/bootstrap.css.map
>   src/main/webapp/css/font-awesome.css
>   src/main/webapp/fonts/fontawesome-webfont.svg
>   src/main/webapp/fonts/glyphicons-halflings-regular.svg
>   src/main/webapp/index.html
>   src/main/webapp/js/api/chart-model.js
>   src/main/webapp/js/app.js
>   src/main/webapp/js/config/chart-config.js
>   src/main/webapp/js/controllers/accordion-controllers.js
>   src/main/webapp/js/controllers/dependency-tree-controllers.js
>   src/main/webapp/js/controllers/list-controllers.js
>   src/main/webapp/js/controllers/search-controllers.js
>   src/main/webapp/js/controllers/timeline-controllers.js
>   src/main/webapp/js/controllers/trace-count-controllers.js
>   src/main/webapp/js/controllers/trace-distribution-controllers.js
>   src/main/webapp/js/factories/statement-factory-config.js
>   src/main/webapp/js/factories/statement-factory.js
>   src/main/webapp/js/lib/angular-mocks.js
>   src/main/webapp/js/lib/angular-route.js
>   src/main/webapp/js/lib/angular.js
>   src/main/webapp/js/lib/bootstrap.js
>   src/main/webapp/js/lib/jquery-2.1.4.js
>   src/main/webapp/js/lib/jquery.min.js
>   src/main/webapp/js/lib/ng-google-chart.js
>   src/main/webapp/js/lib/ui-bootstrap-tpls.js
>   src/main/webapp/js/services/generate-statement-service.js
>   src/main/webapp/partials/about.html
>   src/main/webapp/partials/chart.html
>   src/main/webapp/partials/contact.html
>   src/main/webapp/partials/dependency-tree.html
>   src/main/webapp/partials/google-chart.html
>   src/main/webapp/partials/help.html
>   src/main/webapp/partials/home.html
>   src/main/webapp/partials/list.html
>   src/main/webapp/partials/phoenix-trace.html
>   src/main/webapp/partials/search.html
>   src/main/webapp/WEB-INF/web.xml
>   src/test/webapp/js/specs/app-route-spec.js
>   src/test/webapp/js/specs/timeline-ctrl-spec.js
>   src/test/webapp/js/specs/trace-list-ctrl-spec.js
>   src/test/webapp/js/specs/tracing-app-ctrl-spec.js
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Reopened] (PHOENIX-2244) fix rat violations

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  reopened PHOENIX-2244:
---

> fix rat violations
> --
>
> Key: PHOENIX-2244
> URL: https://issues.apache.org/jira/browse/PHOENIX-2244
> Project: Phoenix
>  Issue Type: Sub-task
>Reporter: Nick Dimiduk
>Assignee: Nishani 
>Priority: Blocker
> Fix For: 4.6.0
>
>
> We'll need to resolve the licensing header violations introduced here before 
> we can release.
> {noformat}
> *
> Summary
> ---
> Generated at: 2015-09-09T16:45:47-07:00
> Notes: 0
> Binaries: 9
> Archives: 1
> Standards: 53
> Apache Licensed: 9
> Generated Documents: 0
> JavaDocs are generated and so license header is optional
> Generated files do not required license headers
> 44 Unknown Licenses
> ***
> Unapproved licenses:
>   src/main/webapp/css/bootstrap-theme.css
>   src/main/webapp/css/bootstrap-theme.css.map
>   src/main/webapp/css/bootstrap.css
>   src/main/webapp/css/bootstrap.css.map
>   src/main/webapp/css/font-awesome.css
>   src/main/webapp/fonts/fontawesome-webfont.svg
>   src/main/webapp/fonts/glyphicons-halflings-regular.svg
>   src/main/webapp/index.html
>   src/main/webapp/js/api/chart-model.js
>   src/main/webapp/js/app.js
>   src/main/webapp/js/config/chart-config.js
>   src/main/webapp/js/controllers/accordion-controllers.js
>   src/main/webapp/js/controllers/dependency-tree-controllers.js
>   src/main/webapp/js/controllers/list-controllers.js
>   src/main/webapp/js/controllers/search-controllers.js
>   src/main/webapp/js/controllers/timeline-controllers.js
>   src/main/webapp/js/controllers/trace-count-controllers.js
>   src/main/webapp/js/controllers/trace-distribution-controllers.js
>   src/main/webapp/js/factories/statement-factory-config.js
>   src/main/webapp/js/factories/statement-factory.js
>   src/main/webapp/js/lib/angular-mocks.js
>   src/main/webapp/js/lib/angular-route.js
>   src/main/webapp/js/lib/angular.js
>   src/main/webapp/js/lib/bootstrap.js
>   src/main/webapp/js/lib/jquery-2.1.4.js
>   src/main/webapp/js/lib/jquery.min.js
>   src/main/webapp/js/lib/ng-google-chart.js
>   src/main/webapp/js/lib/ui-bootstrap-tpls.js
>   src/main/webapp/js/services/generate-statement-service.js
>   src/main/webapp/partials/about.html
>   src/main/webapp/partials/chart.html
>   src/main/webapp/partials/contact.html
>   src/main/webapp/partials/dependency-tree.html
>   src/main/webapp/partials/google-chart.html
>   src/main/webapp/partials/help.html
>   src/main/webapp/partials/home.html
>   src/main/webapp/partials/list.html
>   src/main/webapp/partials/phoenix-trace.html
>   src/main/webapp/partials/search.html
>   src/main/webapp/WEB-INF/web.xml
>   src/test/webapp/js/specs/app-route-spec.js
>   src/test/webapp/js/specs/timeline-ctrl-spec.js
>   src/test/webapp/js/specs/trace-list-ctrl-spec.js
>   src/test/webapp/js/specs/tracing-app-ctrl-spec.js
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-1119) Use Zipkin to visualize Phoenix metrics data

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-1119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14805160#comment-14805160
 ] 

Nishani  commented on PHOENIX-1119:
---

As I think this issue is redundant since we have Tracing Web App installed. The 
web app can visualize all the required tracing information and Phoenix Metrics. 

> Use Zipkin to visualize Phoenix metrics data
> 
>
> Key: PHOENIX-1119
> URL: https://issues.apache.org/jira/browse/PHOENIX-1119
> Project: Phoenix
>  Issue Type: Sub-task
>Reporter: James Taylor
>
> Zipkin provides a nice tool for visualizing trace information: 
> http://twitter.github.io/zipkin/
> It's likely not difficult to visualize the Phoenix tracing data through this 
> tool.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (PHOENIX-2244) fix rat violations

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  resolved PHOENIX-2244.
---
Resolution: Fixed

Issue Resolved.

> fix rat violations
> --
>
> Key: PHOENIX-2244
> URL: https://issues.apache.org/jira/browse/PHOENIX-2244
> Project: Phoenix
>  Issue Type: Sub-task
>Reporter: Nick Dimiduk
>Assignee: Nishani 
>Priority: Blocker
> Fix For: 4.6.0
>
>
> We'll need to resolve the licensing header violations introduced here before 
> we can release.
> {noformat}
> *
> Summary
> ---
> Generated at: 2015-09-09T16:45:47-07:00
> Notes: 0
> Binaries: 9
> Archives: 1
> Standards: 53
> Apache Licensed: 9
> Generated Documents: 0
> JavaDocs are generated and so license header is optional
> Generated files do not required license headers
> 44 Unknown Licenses
> ***
> Unapproved licenses:
>   src/main/webapp/css/bootstrap-theme.css
>   src/main/webapp/css/bootstrap-theme.css.map
>   src/main/webapp/css/bootstrap.css
>   src/main/webapp/css/bootstrap.css.map
>   src/main/webapp/css/font-awesome.css
>   src/main/webapp/fonts/fontawesome-webfont.svg
>   src/main/webapp/fonts/glyphicons-halflings-regular.svg
>   src/main/webapp/index.html
>   src/main/webapp/js/api/chart-model.js
>   src/main/webapp/js/app.js
>   src/main/webapp/js/config/chart-config.js
>   src/main/webapp/js/controllers/accordion-controllers.js
>   src/main/webapp/js/controllers/dependency-tree-controllers.js
>   src/main/webapp/js/controllers/list-controllers.js
>   src/main/webapp/js/controllers/search-controllers.js
>   src/main/webapp/js/controllers/timeline-controllers.js
>   src/main/webapp/js/controllers/trace-count-controllers.js
>   src/main/webapp/js/controllers/trace-distribution-controllers.js
>   src/main/webapp/js/factories/statement-factory-config.js
>   src/main/webapp/js/factories/statement-factory.js
>   src/main/webapp/js/lib/angular-mocks.js
>   src/main/webapp/js/lib/angular-route.js
>   src/main/webapp/js/lib/angular.js
>   src/main/webapp/js/lib/bootstrap.js
>   src/main/webapp/js/lib/jquery-2.1.4.js
>   src/main/webapp/js/lib/jquery.min.js
>   src/main/webapp/js/lib/ng-google-chart.js
>   src/main/webapp/js/lib/ui-bootstrap-tpls.js
>   src/main/webapp/js/services/generate-statement-service.js
>   src/main/webapp/partials/about.html
>   src/main/webapp/partials/chart.html
>   src/main/webapp/partials/contact.html
>   src/main/webapp/partials/dependency-tree.html
>   src/main/webapp/partials/google-chart.html
>   src/main/webapp/partials/help.html
>   src/main/webapp/partials/home.html
>   src/main/webapp/partials/list.html
>   src/main/webapp/partials/phoenix-trace.html
>   src/main/webapp/partials/search.html
>   src/main/webapp/WEB-INF/web.xml
>   src/test/webapp/js/specs/app-route-spec.js
>   src/test/webapp/js/specs/timeline-ctrl-spec.js
>   src/test/webapp/js/specs/trace-list-ctrl-spec.js
>   src/test/webapp/js/specs/tracing-app-ctrl-spec.js
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information

2015-09-18 Thread Nishani (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14805143#comment-14805143
 ] 

Nishani  commented on PHOENIX-1118:
---

https://github.com/apache/phoenix/tree/master/phoenix-tracing-webapp

The solution Tracing Web App as tool for trace visualization is added to 
Phoenix Master.

> Provide a tool for visualizing Phoenix tracing information
> --
>
> Key: PHOENIX-1118
> URL: https://issues.apache.org/jira/browse/PHOENIX-1118
> Project: Phoenix
>  Issue Type: New Feature
>Reporter: James Taylor
>Assignee: Nishani 
>  Labels: Java, SQL, Visualization, gsoc2015, mentor
> Fix For: 4.6.0
>
> Attachments: MockUp1-TimeSlider.png, MockUp2-AdvanceSearch.png, 
> MockUp3-PatternDetector.png, MockUp4-FlameGraph.png, Screenshot of dependency 
> tree.png, Screenshot-loading-trace-list.png, m1-mockUI-tracedistribution.png, 
> m1-mockUI-tracetimeline.png, screenshot of tracing timeline.png, screenshot 
> of tracing web app.png, timeline.png
>
>
> Currently there's no means of visualizing the trace information provided by 
> Phoenix. We should provide some simple charting over our metrics tables. Take 
> a look at the following JIRA for sample queries: 
> https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151
> The tool need to provide visualization over SYSTEM.TRACING_STATS table.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information

2015-09-18 Thread Nishani (JIRA)

 [ 
https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nishani  resolved PHOENIX-1118.
---
Resolution: Fixed

> Provide a tool for visualizing Phoenix tracing information
> --
>
> Key: PHOENIX-1118
> URL: https://issues.apache.org/jira/browse/PHOENIX-1118
> Project: Phoenix
>  Issue Type: New Feature
>Reporter: James Taylor
>Assignee: Nishani 
>  Labels: Java, SQL, Visualization, gsoc2015, mentor
> Fix For: 4.6.0
>
> Attachments: MockUp1-TimeSlider.png, MockUp2-AdvanceSearch.png, 
> MockUp3-PatternDetector.png, MockUp4-FlameGraph.png, Screenshot of dependency 
> tree.png, Screenshot-loading-trace-list.png, m1-mockUI-tracedistribution.png, 
> m1-mockUI-tracetimeline.png, screenshot of tracing timeline.png, screenshot 
> of tracing web app.png, timeline.png
>
>
> Currently there's no means of visualizing the trace information provided by 
> Phoenix. We should provide some simple charting over our metrics tables. Take 
> a look at the following JIRA for sample queries: 
> https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151
> The tool need to provide visualization over SYSTEM.TRACING_STATS table.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-2273) Join Queries fail to give results within a finite time period

2015-09-18 Thread Nishani (JIRA)
Nishani  created PHOENIX-2273:
-

 Summary: Join Queries fail to give results within a finite time 
period 
 Key: PHOENIX-2273
 URL: https://issues.apache.org/jira/browse/PHOENIX-2273
 Project: Phoenix
  Issue Type: Bug
Reporter: Nishani 


When the join queries are run on Phoenix Data Tables it fails to give results. 
Either it takes a long time to give the results or the join queries are not 
executed properly. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)