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, <els...@apache.org
<mailto:els...@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.
>
