Adding Zookeeper as a Device

firstly, add the zookeeper database to kron pam as a device navigate to devices > inventory click the blue add button and select add device in the information section, enter all the information below then enter the sql proxy bind port (last section in ‘add device’) ip address it is the equivalent of an ip address in etc/hosts file device name a unique name for the hive node it is not required port the port number used by hive (if not specified, the default port is used) access protocol choose hive element type choose hive enter sql proxy bind port (in this case, 1019) save in the information section, enter the required details ip address the ip address of the zookeeper database device name a unique name for the zookeeper device port the port number used by zookeeper access protocol select the protocol appropriate for the zookeeper element type choose database enter sql proxy bind port (in this case 1022) save then return to the hive node that you need to connect; (in this case, this will be our first defined hive db named hive datanode 3 ) zookeeper requires specific properties to be set in kron dam to enable proper communication and metadata management click the edit device button click the edit database button enter your information on this screen in the device's properties section, add the following parameters (the properties that not wrote with bold are examples) external metastore vendor mysql external metastore host 40 114 55 184 external metastore port 3306 external metastore username hiveusr external metastore name metastore db external metastore password enc hivepassword (ensure the password is encrypted) metadata type external after these configurations user should be define user groups, device groups and policy groups like any other sql proxy in this case this document assumes prior knowledge of the process; check the section docid\ facun6 tmgx26ndmgya for a refresher if needed