In this case, you'll have to use the following options: apt-get install -y mysql-connector-java_8.0.12-1ubuntu18.04_all.deb #or if you're using a minor version of Ubuntu apt-get install -y mysql-connector-java_8.0.12-1ubuntu16.04_all.deb If the issue persists, you can try to download it manually https://dev.mysql.com/downloads/connector/j/ Hope this helps! ... View more

Yeah! It is 🙂 Just don't forget to restart your ambari-server okay? ambari-server restart Hope this helps! ... View more

Hi @Deepak SANAGAPALLI! If you chose MYSQL as your flavour to HiveMetaStore yeah 🙂 Just one thing, make sure to do this at the ambari server host Hope this helps! ... View more

Hello @Deepak SANAGAPALLI. Take a look at this documentation https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.0.0/bk_ambari-installation/content/install-mysql.html Hope this helps ... View more

Hi @Atul Goel! Did you try the following command? [hive@node3 ~]$ beeline -u 'jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2' --showNestedErrs --showWarnings --verbose -e "select 1 + 1;" 2> /tmp/beeline.out [hive@node3 ~]$ cat /tmp/beeline.out issuing: !connect jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 '' [passwd stripped] Connecting to jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292) Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292) Transaction isolation: TRANSACTION_REPEATABLE_READ Executing command: select 1 + 1; Getting log thread is interrupted, since query is done! 1 row selected (0.218 seconds) Beeline version 1.2.1000.2.6.5.0-292 by Apache Hive Closing: 0: jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Hope this helps! ... View more

Hi @Gnanasoundari Soundarajan! Hm, yeah I can't note any errors on the controller log, just one thing, do you see any "Closing connection" or "Closed smtg" on the server log before the date in your logs above (2018-07-19 00:37)? And maybe we can check the zookeeper logs as well 🙂 Just asking but..is this happening only to the 2nd broker? Hope this helps ... View more

Hey @Gnanasoundari Soundarajan! Could you enable the DEBUG for Kafka? Also, do you have something else on the controller log or kafka.err? ... View more

Hi @Sundar Lakshmanan! I think I just answered an old question made by you, not sure if it's related to this one, but.. https://community.hortonworks.com/questions/207791/failed-with-exception-javaioioexceptionorgapacheha.html Could you confirm if you are only having decimal values in this column? Usually, cast fails against mismatched datatype. Hope this helps! 🙂 ... View more

Hey @Sundar Lakshmanan! Could you share with us the following output? describe formatted <table_name>; Usually, this happens to mismatched types or some data overflowing the datatype. Are you able to do a simple query? select * from <table_name> limit 10; Hope this helps! ... View more