@ARUNKUMAR RAMASAMY The communication between the datanodes and mysql needs to be open. Make sure telnet <mysql_server> <port> works on all the nodes in the cluster. Also, need to verify the bind address at mysql end to verify the connectivity. You can refer to below link for more debugging at mysql end: http://stackoverflow.com/questions/2121829/com-mysql-jdbc-exceptions-jdbc4-communicationsexceptioncommunications-link-fail Hope this helps. Thanks and Regards, Sindhu ... View more

@Pradeep Bhadani Run mysql manual install on the machine itself as: rpm -e --nodeps mysql-libs Hope this helps. Thanks and Regards, Sindhu ... View more

Could you please share the steps that resolved the issue and mark as best answer? Thanks, Sindhu ... View more

@Simran Kaur Seems like TotalRecords is a keyword. Try using TotalRecords_1 and see if it helps. Thanks and Regards, Sindhu ... View more

@khushi kalra You can also use RJDBC as below to connect to Hive: library("DBI") library("rJava") library("RJDBC") hive.class.path = list.files(path=c("/usr/hdp/current/hive-client/lib"), pattern="jar", full.names=T); hadoop.lib.path = list.files(path=c("/usr/hdp/current/hive-client/lib"), pattern="jar", full.names=T); hadoop.class.path = list.files(path=c("/usr/hdp/2.4.0.0-169/hadoop"), pattern="jar", full.names=T); cp = c(hive.class.path, hadoop.lib.path, hadoop.class.path, "/usr/hdp/2.4.0.0-169/hadoop-mapreduce/hadoop-mapreduce-client-core.jar") .jinit(classpath=cp) drv <- JDBC("org.apache.hive.jdbc.HiveDriver","hive-jdbc.jar",identifier.quote="`") url.dbc <- paste0("jdbc:hive2://ironhide.hdp.local:10000/default"); conn <- dbConnect(drv, url.dbc, "hive", “redhat"); log4j:WARN No appenders could be found for logger (org.apache.hadoop.util.Shell). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. dbListTables(conn); Thanks and Regards, Sindhu ... View more