Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to create a table. Error: com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

Unable to create a table. Error: com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

New Contributor

Hi,

We have a cluster with three nodes, each containing one zookeeper server and client, up and running.

Vora version: 1.2

Spark 1.5.2

While creating table, we get the following

scala> vc.sql(testsql)

com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

Error log shows the following:

2016-09-14 15:14:32,418 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxnFactory@197] - Accepted socket connection from /10.78.1.240:46458 2016-09-14 15:14:32,418 - WARN [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@357] - caught end of stream exception EndOfStreamException: Unable to read additional data from client sessionid 0x0, likely client has closed socket at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:228) at org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208) at java.lang.Thread.run(Thread.java:745) 2016-09-14 15:14:32,418 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@1007] - Closed socket connection for client /10.78.1.240:46458 (no session established for client) 2016-09-14 15:15:32,429 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxnFactory@197] - Accepted socket connection from /10.78.1.240:46832 2016-09-14 15:15:32,429 - WARN [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@357] - caught end of stream exception EndOfStreamException: Unable to read additional data from client sessionid 0x0, likely client has closed socket at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:228) at org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208) at java.lang.Thread.run(Thread.java:745) 2016-09-14 15:15:32,429 - INFO [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181:NIOServerCnxn@1007] - Closed socket connection for client /10.78.1.240:46832 (no session established for client)

3 REPLIES 3

Re: Unable to create a table. Error: com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

Expert Contributor

Hi,

Check your configuration in spark-defaults.conf.

Also check your spark.vora.discovery parameters (sometiems it helps just disablin it if running on same host).

/Best regards, Mats

Re: Unable to create a table. Error: com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

New Contributor

Hi Mats,

Thankyou for replying.

spark.vora.discovery parameters have not been defined in spark-defaults.conf.

Below is the content of spark-defaults.conf:

[root@VORA1 ~]# cat /etc/spark/2.3.4.0-3485/0/spark-defaults.conf # Generated by Apache Ambari. Tue Aug 30 16:10:57 2016

spark.history.kerberos.keytab none

spark.history.kerberos.principal none

spark.history.provider org.apache.spark.deploy.yarn.history.YarnHistoryProvider

spark.history.ui.port 18080

spark.yarn.containerLauncherMaxThreads 25

spark.yarn.driver.memoryOverhead 384

spark.yarn.executor.memoryOverhead 384

spark.yarn.historyServer.address vora1.ad.company.com:18080

spark.yarn.max.executor.failures 3

spark.yarn.preserve.staging.files false

spark.yarn.queue default

spark.yarn.scheduler.heartbeat.interval-ms 5000

spark.yarn.services org.apache.spark.deploy.yarn.history.YarnHistoryService

spark.yarn.submit.file.replication 3

park.driver.extraJavaOptions -Dhdp.version=2.3.4.0-3485

spark.yarn.am.extraJavaOptions -Dhdp.version=2.3.4.0-3485

Please let me know if I am missing any parameter here.

Thanks,

Jyoti

Re: Unable to create a table. Error: com.sap.spark.vora.VoraConfigurationException: No ZooKeeper hosts found

New Contributor

Hi Mats,

Thankyou for replying.

spark.vora.discovery parameters have not been defined in spark-defaults.conf.

Below is the content of spark-defaults.conf:

[root@VORA1 ~]# cat /etc/spark/2.3.4.0-3485/0/spark-defaults.conf # Generated by Apache Ambari. Tue Aug 30 16:10:57 2016

spark.history.kerberos.keytab none

spark.history.kerberos.principal none

spark.history.provider org.apache.spark.deploy.yarn.history.YarnHistoryProvider

spark.history.ui.port 18080

spark.yarn.containerLauncherMaxThreads 25

spark.yarn.driver.memoryOverhead 384

spark.yarn.executor.memoryOverhead 384

spark.yarn.historyServer.address vora1.ad.company.com:18080

spark.yarn.max.executor.failures 3

spark.yarn.preserve.staging.files false

spark.yarn.queue default

spark.yarn.scheduler.heartbeat.interval-ms 5000

spark.yarn.services org.apache.spark.deploy.yarn.history.YarnHistoryService

spark.yarn.submit.file.replication 3

park.driver.extraJavaOptions -Dhdp.version=2.3.4.0-3485

spark.yarn.am.extraJavaOptions -Dhdp.version=2.3.4.0-3485

Please let me know if I am missing any parameter here.

Thanks,

Jyoti