Hi @Pierre Gunet-Caplain I don't believe multiple HS2 interactive instances are currently supported. I'll see if I can find out anything further within the community. ... View more

Hi @sijeesh kunnotharamal As per the Apache Knox project website, Phoenix is a supported service of Knox. http://knox.apache.org/ Specifically, see this section of the User's Guide: http://knox.apache.org/books/knox-0-13-0/user-guide.html#Avatica ... View more

Hi @Nilesh If you are using HDP via Ambari, you can use the Stacks and Versions feature to see all of the installed components and versions from the stack. Via command line, you can navigate to /usr/hdp/current/kafka-broker/libs and see the jar files with the versions. See the attachments for examples of each. I don't believe there is a --version type of command in any of the Kafka cli scripts from what I remember. screen-shot-2017-11-29-at-84935-am.pngscreen-shot-2017-11-29-at-85206-am.png ... View more

Hi @Mike Bit If you want to use a CLI to access Hive, the recommend client tool to use is called beeline. It is normally included in the client tools installation, so you probably already have it ready to go. From your client tools machine/host/server, you will use the beeline client to connect to the HiveServer2 JDBC URL, and everything from there is the usual SQL commands. In Ambari, you can easily copy the HiveServer2 JDBC URL directly from the Hive service config screen, and paste it right into a beeline connect string. So for example, if my machines were ssahi[0-2].hortonworks.com, where I was running ZooKeeper, and I was using hive/hive as the user/password, my beeline command to open the client and connect to Hive may look like: beeline -u "jdbc:hive2://ssahi1.hortonworks.com:2181,ssahi0.hortonworks.com:2181,ssahi2.hortonworks.com:2181/;ServiceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" -n hive -p hive You can find more on Beeline from the project documentation here, including example syntax, and config to have things display nicer, etc: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Beeline–CommandLineShell ... View more

hi @Sofiane CHIBANI The releases are listed, and will be updated here: https://hortonworks.com/services/training/certification/hdpca-certification/ Currently, HDP 2.3 and Ambari 2.1 are the releases that are part of the exam. I did hear there was work underway to upgrade them, but no timeline was available to me. The website, the practice exams, and the links will be updated when the exam changes over to newer versions. Good luck! ... View more

My personal preference is HDFS put over flume if those are the options. Even better would be HDF, but it sounds like a simple HDFS put would solve it ... View more

Hi @Larry Wilson The connect string that Hive View 2.0 is using looks ok, however, the Hive View logs show an underlying error: ava.sql.SQLException: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 configs from ZooKeeper Do you have HiveServerHA enabled? I would start by starting/stopping ZooKeeper, then starting/stopping Hive all from Ambari and trying again. Can you do this and report back results. ... View more

Hi @fnu rasool There are some good links online, but this is one of the better ones despite its age: https://hortonworks.com/blog/deploying-hadoop-cluster-amazon-ec2-hortonworks/ ... View more

Hi @yassine sihi Having both Ambari and its mysql db on the same machine does not normally cause any issues logging in. Most of my lab clusters are setup in the fashion. I think Jay is on the right track to look at the grants and hostnames. I've also seen one similar login error when a user tried to access mysql without using the server's FQDN - ensure FQDN are being used whenever possible. ... View more

Hi @sbx hadoop you should probably check with your local Hortonworks team for a proper answer. I don't think you need to worry about logically/physically moving anything, just ensuring that you have the proper support subscriptions in place from the HDP and HDF products that you need. Again, your local Hortonworks team can provide an official answer to your inquiry. ... View more