You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Sukant Jain <su...@gmail.com> on 2017/01/25 04:53:15 UTC
Phoenix Question
Hi Team,
First i would like to congratulate you to bring up with phoenix project.
I have a question regarding phoenix.
Question : How phoenix supports embedding into web container specifically
data source support.
I hope i am clear,if not my intention is to know how to use the data
retrieved by phoenix in web ui.
Thanks in advance!!!
Regards
Re: Phoenix Question
Posted by ankit beohar <an...@gmail.com>.
HI Sukant,
You can use phoenix jdbc driver and retrieve through phoenix sql like we do
for mysql or oracle below link may help you:-
http://phoenix.apache.org/installation.html
Best Regards,
ANKIT BEOHAR
On Wed, Jan 25, 2017 at 10:23 AM, Sukant Jain <su...@gmail.com> wrote:
> Hi Team,
>
> First i would like to congratulate you to bring up with phoenix project.
>
> I have a question regarding phoenix.
>
> Question : How phoenix supports embedding into web container specifically
> data source support.
>
> I hope i am clear,if not my intention is to know how to use the data
> retrieved by phoenix in web ui.
>
> Thanks in advance!!!
>
> Regards
>
Re: Phoenix Question
Posted by Mark Heppner <he...@gmail.com>.
Will,
Yes. I don't know much about it, but it's somewhat new and is still in the
Apache incubator. Since there are no versioned docs for Phoenix and you
have to hunt to find what features are available in which version, I think
the transactions were introduced as a beta feature in 4.7, but someone
correct me if I'm wrong. I have no idea if this is considered a stable
feature in 4.8 or 4.9.
Since this isn't linked anywhere on the Phoenix site, check out the blog (
https://blogs.apache.org/phoenix/) for better release notes and news.
On Tue, Jan 31, 2017 at 10:07 AM, Will Xu <wx...@hortonworks.com> wrote:
> Hi Mark,
>
> When you say Phoenix supports ACID do you mean via Tephra?
>
>
> Regards,
>
> Will
> ------------------------------
> *From:* Mark Heppner <he...@gmail.com>
> *Sent:* Tuesday, January 31, 2017 6:37 AM
> *To:* user@phoenix.apache.org
> *Cc:* Noam.Bulvik@teoco.com
> *Subject:* Re: Phoenix Question
>
> Sukant,
> Yes, you definitely could replace your RDBMS with Phoenix. However, it
> does behave fairly differently than a traditional RDBMS. You should fully
> understand HBase and HDFS before making a decision. HBase scales really
> well as long as you plan it out. Phoenix does provide full ACID support,
> but it's a pretty new feature. I highly suggest importing a subset of your
> data into Phoenix and testing it out for yourself before making the switch.
>
> On Tue, Jan 31, 2017 at 1:45 AM, Sukant Jain <su...@gmail.com> wrote:
>
>> Hi Noam,
>>
>> Thanks for answering below question.
>>
>> I will appreciate if you can please let me know whether can we replace
>> rdbms as a combination of Hbase+Apache Phoenix.
>>
>> If yes then will this combination scale and will provide me fully ACID.
>>
>> I have read at my places that we should not replace rdbms with hbase but
>> wondering whether combination of hbase and phoenix can be replaced.
>>
>> Regards
>> Sukant
>>
>>
>> On Wed, Jan 25, 2017 at 12:05 PM, Bulvik, Noam <No...@teoco.com>
>> wrote:
>>
>>> You set it like any other data source of Weblogic.
>>>
>>> You need to:
>>>
>>> · Set the WLS class path to point to phoenix-XXXX-client.jar
>>>
>>> · Create data source from type other
>>>
>>> · Set the connection definition (driver class and jdbc URL)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *From:* Sukant Jain [mailto:sukantjain@gmail.com]
>>> *Sent:* Wednesday, January 25, 2017 8:18 AM
>>> *To:* user@phoenix.apache.org; 김나헌 <na...@navercorp.com>
>>> *Subject:* Re: Phoenix Question
>>>
>>>
>>>
>>> Hi,
>>>
>>> My question is on the weblogic server when defining the data source how
>>> to configure phenoix so that the operations like update,insert happens on
>>> hbase through phenoix.
>>>
>>> Regards
>>>
>>>
>>>
>>>
>>> On Wed, Jan 25, 2017 at 10:37 AM, 김나헌 <na...@navercorp.com> wrote:
>>>
>>> Hi,
>>>
>>>
>>>
>>> Did you mean something like SQL client on the web?
>>>
>>>
>>>
>>> Regards,
>>>
>>> NaHeon
>>>
>>>
>>>
>>> -----Original Message-----
>>> *From:* "Sukant Jain"<su...@gmail.com>
>>> *To:* <us...@phoenix.apache.org>;
>>> *Cc:*
>>> *Sent:* 2017-01-25 (수) 13:53:15
>>> *Subject:* Phoenix Question
>>>
>>>
>>> Hi Team,
>>>
>>>
>>> First i would like to congratulate you to bring up with phoenix project.
>>>
>>>
>>> I have a question regarding phoenix.
>>>
>>>
>>> Question : How phoenix supports embedding into web container
>>> specifically data source support.
>>>
>>>
>>> I hope i am clear,if not my intention is to know how to use the data
>>> retrieved by phoenix in web ui.
>>>
>>>
>>> Thanks in advance!!!
>>>
>>>
>>>
>>> Regards
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> PRIVILEGED AND CONFIDENTIAL
>>> PLEASE NOTE: The information contained in this message is privileged and
>>> confidential, and is intended only for the use of the individual to whom it
>>> is addressed and others who have been specifically authorized to receive
>>> it. If you are not the intended recipient, you are hereby notified that any
>>> dissemination, distribution or copying of this communication is strictly
>>> prohibited. If you have received this communication in error, or if any
>>> problems occur with transmission, please contact sender. Thank you.
>>>
>>
>>
>
>
> --
> Mark Heppner
>
--
Mark Heppner
Re: Phoenix Question
Posted by Will Xu <wx...@hortonworks.com>.
Hi Mark,
When you say Phoenix supports ACID do you mean via Tephra?
Regards,
Will
________________________________
From: Mark Heppner <he...@gmail.com>
Sent: Tuesday, January 31, 2017 6:37 AM
To: user@phoenix.apache.org
Cc: Noam.Bulvik@teoco.com
Subject: Re: Phoenix Question
Sukant,
Yes, you definitely could replace your RDBMS with Phoenix. However, it does behave fairly differently than a traditional RDBMS. You should fully understand HBase and HDFS before making a decision. HBase scales really well as long as you plan it out. Phoenix does provide full ACID support, but it's a pretty new feature. I highly suggest importing a subset of your data into Phoenix and testing it out for yourself before making the switch.
On Tue, Jan 31, 2017 at 1:45 AM, Sukant Jain <su...@gmail.com>> wrote:
Hi Noam,
Thanks for answering below question.
I will appreciate if you can please let me know whether can we replace rdbms as a combination of Hbase+Apache Phoenix.
If yes then will this combination scale and will provide me fully ACID.
I have read at my places that we should not replace rdbms with hbase but wondering whether combination of hbase and phoenix can be replaced.
Regards
Sukant
On Wed, Jan 25, 2017 at 12:05 PM, Bulvik, Noam <No...@teoco.com>> wrote:
You set it like any other data source of Weblogic.
You need to:
* Set the WLS class path to point to phoenix-XXXX-client.jar
* Create data source from type other
* Set the connection definition (driver class and jdbc URL)
From: Sukant Jain [mailto:sukantjain@gmail.com<ma...@gmail.com>]
Sent: Wednesday, January 25, 2017 8:18 AM
To: user@phoenix.apache.org<ma...@phoenix.apache.org>; ??? <na...@navercorp.com>>
Subject: Re: Phoenix Question
Hi,
My question is on the weblogic server when defining the data source how to configure phenoix so that the operations like update,insert happens on hbase through phenoix.
Regards
On Wed, Jan 25, 2017 at 10:37 AM, ??? <na...@navercorp.com>> wrote:
Hi,
Did you mean something like SQL client on the web?
Regards,
NaHeon
-----Original Message-----
From: "Sukant Jain"<su...@gmail.com>>
To: <us...@phoenix.apache.org>>;
Cc:
Sent: 2017-01-25 (?) 13:53:15
Subject: Phoenix Question
Hi Team,
First i would like to congratulate you to bring up with phoenix project.
I have a question regarding phoenix.
Question : How phoenix supports embedding into web container specifically data source support.
I hope i am clear,if not my intention is to know how to use the data retrieved by phoenix in web ui.
Thanks in advance!!!
Regards
[X]
________________________________
PRIVILEGED AND CONFIDENTIAL
PLEASE NOTE: The information contained in this message is privileged and confidential, and is intended only for the use of the individual to whom it is addressed and others who have been specifically authorized to receive it. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, or if any problems occur with transmission, please contact sender. Thank you.
--
Mark Heppner
Re: Phoenix Question
Posted by Mark Heppner <he...@gmail.com>.
Sukant,
Yes, you definitely could replace your RDBMS with Phoenix. However, it does
behave fairly differently than a traditional RDBMS. You should fully
understand HBase and HDFS before making a decision. HBase scales really
well as long as you plan it out. Phoenix does provide full ACID support,
but it's a pretty new feature. I highly suggest importing a subset of your
data into Phoenix and testing it out for yourself before making the switch.
On Tue, Jan 31, 2017 at 1:45 AM, Sukant Jain <su...@gmail.com> wrote:
> Hi Noam,
>
> Thanks for answering below question.
>
> I will appreciate if you can please let me know whether can we replace
> rdbms as a combination of Hbase+Apache Phoenix.
>
> If yes then will this combination scale and will provide me fully ACID.
>
> I have read at my places that we should not replace rdbms with hbase but
> wondering whether combination of hbase and phoenix can be replaced.
>
> Regards
> Sukant
>
>
> On Wed, Jan 25, 2017 at 12:05 PM, Bulvik, Noam <No...@teoco.com>
> wrote:
>
>> You set it like any other data source of Weblogic.
>>
>> You need to:
>>
>> · Set the WLS class path to point to phoenix-XXXX-client.jar
>>
>> · Create data source from type other
>>
>> · Set the connection definition (driver class and jdbc URL)
>>
>>
>>
>>
>>
>>
>>
>> *From:* Sukant Jain [mailto:sukantjain@gmail.com]
>> *Sent:* Wednesday, January 25, 2017 8:18 AM
>> *To:* user@phoenix.apache.org; 김나헌 <na...@navercorp.com>
>> *Subject:* Re: Phoenix Question
>>
>>
>>
>> Hi,
>>
>> My question is on the weblogic server when defining the data source how
>> to configure phenoix so that the operations like update,insert happens on
>> hbase through phenoix.
>>
>> Regards
>>
>>
>>
>>
>> On Wed, Jan 25, 2017 at 10:37 AM, 김나헌 <na...@navercorp.com> wrote:
>>
>> Hi,
>>
>>
>>
>> Did you mean something like SQL client on the web?
>>
>>
>>
>> Regards,
>>
>> NaHeon
>>
>>
>>
>> -----Original Message-----
>> *From:* "Sukant Jain"<su...@gmail.com>
>> *To:* <us...@phoenix.apache.org>;
>> *Cc:*
>> *Sent:* 2017-01-25 (수) 13:53:15
>> *Subject:* Phoenix Question
>>
>>
>> Hi Team,
>>
>>
>> First i would like to congratulate you to bring up with phoenix project.
>>
>>
>> I have a question regarding phoenix.
>>
>>
>> Question : How phoenix supports embedding into web container specifically
>> data source support.
>>
>>
>> I hope i am clear,if not my intention is to know how to use the data
>> retrieved by phoenix in web ui.
>>
>>
>> Thanks in advance!!!
>>
>>
>>
>> Regards
>>
>>
>>
>> ------------------------------
>>
>> PRIVILEGED AND CONFIDENTIAL
>> PLEASE NOTE: The information contained in this message is privileged and
>> confidential, and is intended only for the use of the individual to whom it
>> is addressed and others who have been specifically authorized to receive
>> it. If you are not the intended recipient, you are hereby notified that any
>> dissemination, distribution or copying of this communication is strictly
>> prohibited. If you have received this communication in error, or if any
>> problems occur with transmission, please contact sender. Thank you.
>>
>
>
--
Mark Heppner
Re: Phoenix Question
Posted by Sukant Jain <su...@gmail.com>.
Hi Noam,
Thanks for answering below question.
I will appreciate if you can please let me know whether can we replace
rdbms as a combination of Hbase+Apache Phoenix.
If yes then will this combination scale and will provide me fully ACID.
I have read at my places that we should not replace rdbms with hbase but
wondering whether combination of hbase and phoenix can be replaced.
Regards
Sukant
On Wed, Jan 25, 2017 at 12:05 PM, Bulvik, Noam <No...@teoco.com>
wrote:
> You set it like any other data source of Weblogic.
>
> You need to:
>
> · Set the WLS class path to point to phoenix-XXXX-client.jar
>
> · Create data source from type other
>
> · Set the connection definition (driver class and jdbc URL)
>
>
>
>
>
>
>
> *From:* Sukant Jain [mailto:sukantjain@gmail.com]
> *Sent:* Wednesday, January 25, 2017 8:18 AM
> *To:* user@phoenix.apache.org; 김나헌 <na...@navercorp.com>
> *Subject:* Re: Phoenix Question
>
>
>
> Hi,
>
> My question is on the weblogic server when defining the data source how to
> configure phenoix so that the operations like update,insert happens on
> hbase through phenoix.
>
> Regards
>
>
>
>
> On Wed, Jan 25, 2017 at 10:37 AM, 김나헌 <na...@navercorp.com> wrote:
>
> Hi,
>
>
>
> Did you mean something like SQL client on the web?
>
>
>
> Regards,
>
> NaHeon
>
>
>
> -----Original Message-----
> *From:* "Sukant Jain"<su...@gmail.com>
> *To:* <us...@phoenix.apache.org>;
> *Cc:*
> *Sent:* 2017-01-25 (수) 13:53:15
> *Subject:* Phoenix Question
>
>
> Hi Team,
>
>
> First i would like to congratulate you to bring up with phoenix project.
>
>
> I have a question regarding phoenix.
>
>
> Question : How phoenix supports embedding into web container specifically
> data source support.
>
>
> I hope i am clear,if not my intention is to know how to use the data
> retrieved by phoenix in web ui.
>
>
> Thanks in advance!!!
>
>
>
> Regards
>
>
>
> ------------------------------
>
> PRIVILEGED AND CONFIDENTIAL
> PLEASE NOTE: The information contained in this message is privileged and
> confidential, and is intended only for the use of the individual to whom it
> is addressed and others who have been specifically authorized to receive
> it. If you are not the intended recipient, you are hereby notified that any
> dissemination, distribution or copying of this communication is strictly
> prohibited. If you have received this communication in error, or if any
> problems occur with transmission, please contact sender. Thank you.
>
RE: Phoenix Question
Posted by "Bulvik, Noam" <No...@teoco.com>.
You set it like any other data source of Weblogic.
You need to:
· Set the WLS class path to point to phoenix-XXXX-client.jar
· Create data source from type other
· Set the connection definition (driver class and jdbc URL)
From: Sukant Jain [mailto:sukantjain@gmail.com]
Sent: Wednesday, January 25, 2017 8:18 AM
To: user@phoenix.apache.org; 김나헌 <na...@navercorp.com>
Subject: Re: Phoenix Question
Hi,
My question is on the weblogic server when defining the data source how to configure phenoix so that the operations like update,insert happens on hbase through phenoix.
Regards
On Wed, Jan 25, 2017 at 10:37 AM, 김나헌 <na...@navercorp.com>> wrote:
Hi,
Did you mean something like SQL client on the web?
Regards,
NaHeon
-----Original Message-----
From: "Sukant Jain"<su...@gmail.com>>
To: <us...@phoenix.apache.org>>;
Cc:
Sent: 2017-01-25 (수) 13:53:15
Subject: Phoenix Question
Hi Team,
First i would like to congratulate you to bring up with phoenix project.
I have a question regarding phoenix.
Question : How phoenix supports embedding into web container specifically data source support.
I hope i am clear,if not my intention is to know how to use the data retrieved by phoenix in web ui.
Thanks in advance!!!
Regards
[https://ack.mail.navercorp.com/readReceipt/notify/?img=%2FXKmFqM9Fxu9FzMYaqumFzE%2FMqgXp4t9FoMqax3vMrUXpovrKAi4aAI0KEIo%2BrkSKAK5W49vpSl51zlqDBFdp6d5MreRhoR9brkZtHIcWrk51B25MBICMrC074eZpm%3D%3D.gif]
________________________________
PRIVILEGED AND CONFIDENTIAL
PLEASE NOTE: The information contained in this message is privileged and confidential, and is intended only for the use of the individual to whom it is addressed and others who have been specifically authorized to receive it. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, or if any problems occur with transmission, please contact sender. Thank you.
Re: Phoenix Question
Posted by Sukant Jain <su...@gmail.com>.
Hi,
My question is on the weblogic server when defining the data source how to
configure phenoix so that the operations like update,insert happens on
hbase through phenoix.
Regards
On Wed, Jan 25, 2017 at 10:37 AM, 김나헌 <na...@navercorp.com> wrote:
> Hi,
>
>
>
> Did you mean something like SQL client on the web?
>
>
>
> Regards,
>
> NaHeon
>
>
>
> -----Original Message-----
> *From:* "Sukant Jain"<su...@gmail.com>
> *To:* <us...@phoenix.apache.org>;
> *Cc:*
> *Sent:* 2017-01-25 (수) 13:53:15
> *Subject:* Phoenix Question
>
> Hi Team,
>
> First i would like to congratulate you to bring up with phoenix project.
>
> I have a question regarding phoenix.
>
> Question : How phoenix supports embedding into web container specifically
> data source support.
>
> I hope i am clear,if not my intention is to know how to use the data
> retrieved by phoenix in web ui.
>
> Thanks in advance!!!
>
> Regards
>
RE: Phoenix Question
Posted by 김나헌 <na...@navercorp.com>.
Hi,
Did you mean something like SQL client on the web?
Regards,
NaHeon
-----Original Message-----
From: "Sukant Jain"<sukantjain@gmail.com>
To: <user@phoenix.apache.org>;
Cc:
Sent: 2017-01-25 (수) 13:53:15
Subject: Phoenix Question
Hi Team,
First i would like to congratulate you to bring up with phoenix project.
I have a question regarding phoenix.
Question : How phoenix supports embedding into web container specifically data source support.
I hope i am clear,if not my intention is to know how to use the data retrieved by phoenix in web ui.
Thanks in advance!!! Regards