You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Varun Rajavelu <va...@tangotech.co.in> on 2020/10/23 12:58:09 UTC
Phoenix connection issue
Hi,,
I'm currently using HDP 2.6 and hbase1.5 and phoenix 4.7 and presto-server
which i have been using presto344. Im facing issue while connecting
prestoserver with hbase;
*./presto --server localhost:14100 --catalog phoenix*
*Issue:*
Fri Oct 23 18:11:06 IST 2020, null, java.net.SocketTimeoutException:
callTimeout=60000, callDuration=69066: Call to
sandbox-hdp.hortonworks.com/127.0.0.1:16020 failed on local exception:
java.io.EOFException row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at
region=hbase:meta,,1.1588230740,
hostname=sandbox-hdp.hortonworks.com,16020,1603447852070,
seqNum=0
*My presto catalog Config:*
connector.name=phoenix
phoenix.connection-url=jdbc:phoenix:localhost:2181:/hbase-unsecure
phoenix.config.resources=/home/desa/Downloads/hbase_schema/hbase-site.xml
Kindly please have a look and help me to resolve this issue.
--
Thanks
Varun Rajavelu
*Data Engineer* Tango Eye
m: 9698747276
w: *www.tangoeye.io <http://www.tangoeye.io/>* e: varun@tangotech.co.in
<ke...@tangotech.co.in>
Re: Phoenix connection issue
Posted by Josh Elser <el...@apache.org>.
If you are not using Kerberos authentication, then you need to figure
out how your DNS names are resolving for your VM. A
SocketTimeoutException means that your client could not open an socket
to that host:port which was specified. Likely, this is something you
need to figure out with your VM.
On 10/23/20 10:29 AM, Varun Rajavelu wrote:
> Hey Hi,
>
> Thanks for the response. Yeah I'm not using in any Kerberos
> authentication hbase still in simple authentication method only. Can you
> please tell me what I'm made any mistakes in these presto catalog
> configuration, while communication between hbase and presto. Please help
> me or suggestions on this issue. I can able to query hbase table from
> phoenix but issue comes only from connecting presto phoenix only.
>
> On Fri, 23 Oct, 2020, 7:27 pm Josh Elser, <elserj@apache.org
> <ma...@apache.org>> wrote:
>
> (-to: dev@phoenix, +bcc: dev@phoenix, +to: user@phoenix)
>
> I've taken the liberty of moving this over to the user list.
>
> Typically, such an exception is related to Kerberos authentication,
> when
> the HBase service denies in an incoming, non-authenticated client.
> However, since you're running inside of a VM, I'd suggest you should
> validate that your environment is sane, first.
>
> HDP 2.6 never shipped an HBase 1.5 release, so it seems like you have
> chosen to own your own set of versions. I'll assume that you have
> already validated that the versions of Hadoop, HBase, and Phoenix that
> you are running are compatible with one another. A common debugging
> trick is to strip away the layers of complexity so that you can isolate
> your problem. Can you talk to HBase or Phoenix not within Presto?
>
> On 10/23/20 8:58 AM, Varun Rajavelu wrote:
> > Hi,,
> >
> > I'm currently using HDP 2.6 and hbase1.5 and phoenix 4.7 and
> presto-server
> > which i have been using presto344. Im facing issue while connecting
> > prestoserver with hbase;
> >
> > *./presto --server localhost:14100 --catalog phoenix*
> > *Issue:*
> > Fri Oct 23 18:11:06 IST 2020, null, java.net
> <http://java.net>.SocketTimeoutException:
> > callTimeout=60000, callDuration=69066: Call to
> > sandbox-hdp.hortonworks.com/127.0.0.1:16020
> <http://sandbox-hdp.hortonworks.com/127.0.0.1:16020> failed on local
> exception:
> > java.io.EOFException row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at
> > region=hbase:meta,,1.1588230740,
> > hostname=sandbox-hdp.hortonworks.com
> <http://sandbox-hdp.hortonworks.com>,16020,1603447852070,
> > seqNum=0
> >
> > *My presto catalog Config:*
> > connector.name <http://connector.name>=phoenix
> > phoenix.connection-url=jdbc:phoenix:localhost:2181:/hbase-unsecure
> >
> phoenix.config.resources=/home/desa/Downloads/hbase_schema/hbase-site.xml
> >
> > Kindly please have a look and help me to resolve this issue.
> >
>
Re: Phoenix connection issue
Posted by Josh Elser <el...@apache.org>.
(-to: dev@phoenix, +bcc: dev@phoenix, +to: user@phoenix)
I've taken the liberty of moving this over to the user list.
Typically, such an exception is related to Kerberos authentication, when
the HBase service denies in an incoming, non-authenticated client.
However, since you're running inside of a VM, I'd suggest you should
validate that your environment is sane, first.
HDP 2.6 never shipped an HBase 1.5 release, so it seems like you have
chosen to own your own set of versions. I'll assume that you have
already validated that the versions of Hadoop, HBase, and Phoenix that
you are running are compatible with one another. A common debugging
trick is to strip away the layers of complexity so that you can isolate
your problem. Can you talk to HBase or Phoenix not within Presto?
On 10/23/20 8:58 AM, Varun Rajavelu wrote:
> Hi,,
>
> I'm currently using HDP 2.6 and hbase1.5 and phoenix 4.7 and presto-server
> which i have been using presto344. Im facing issue while connecting
> prestoserver with hbase;
>
> *./presto --server localhost:14100 --catalog phoenix*
> *Issue:*
> Fri Oct 23 18:11:06 IST 2020, null, java.net.SocketTimeoutException:
> callTimeout=60000, callDuration=69066: Call to
> sandbox-hdp.hortonworks.com/127.0.0.1:16020 failed on local exception:
> java.io.EOFException row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at
> region=hbase:meta,,1.1588230740,
> hostname=sandbox-hdp.hortonworks.com,16020,1603447852070,
> seqNum=0
>
> *My presto catalog Config:*
> connector.name=phoenix
> phoenix.connection-url=jdbc:phoenix:localhost:2181:/hbase-unsecure
> phoenix.config.resources=/home/desa/Downloads/hbase_schema/hbase-site.xml
>
> Kindly please have a look and help me to resolve this issue.
>
Re: Phoenix connection issue
Posted by Josh Elser <el...@apache.org>.
(-to: dev@phoenix, +bcc: dev@phoenix, +to: user@phoenix)
I've taken the liberty of moving this over to the user list.
Typically, such an exception is related to Kerberos authentication, when
the HBase service denies in an incoming, non-authenticated client.
However, since you're running inside of a VM, I'd suggest you should
validate that your environment is sane, first.
HDP 2.6 never shipped an HBase 1.5 release, so it seems like you have
chosen to own your own set of versions. I'll assume that you have
already validated that the versions of Hadoop, HBase, and Phoenix that
you are running are compatible with one another. A common debugging
trick is to strip away the layers of complexity so that you can isolate
your problem. Can you talk to HBase or Phoenix not within Presto?
On 10/23/20 8:58 AM, Varun Rajavelu wrote:
> Hi,,
>
> I'm currently using HDP 2.6 and hbase1.5 and phoenix 4.7 and presto-server
> which i have been using presto344. Im facing issue while connecting
> prestoserver with hbase;
>
> *./presto --server localhost:14100 --catalog phoenix*
> *Issue:*
> Fri Oct 23 18:11:06 IST 2020, null, java.net.SocketTimeoutException:
> callTimeout=60000, callDuration=69066: Call to
> sandbox-hdp.hortonworks.com/127.0.0.1:16020 failed on local exception:
> java.io.EOFException row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at
> region=hbase:meta,,1.1588230740,
> hostname=sandbox-hdp.hortonworks.com,16020,1603447852070,
> seqNum=0
>
> *My presto catalog Config:*
> connector.name=phoenix
> phoenix.connection-url=jdbc:phoenix:localhost:2181:/hbase-unsecure
> phoenix.config.resources=/home/desa/Downloads/hbase_schema/hbase-site.xml
>
> Kindly please have a look and help me to resolve this issue.
>