Re: Connect Aginity for Hadoop to Sandbox Hive

Hello @Fadle Allah Shili you can use Ambari to find these details. **NOTE** I don't have the Hortonworks sandbox installed myself, but the below suggestions should work nonetheless. Connection Properties User ID/Password Section 3: New Users in Sandbox in the documentation contains a list of users and passwords. It looks like you can use raj_ops, maria_dev, or amy_ds as the user id to connect to hive. HiveServer2 Location 1) Log into Ambari 2) From the list of services click Hive. 4) Click the Summary tab 5) Click HiveServer2. The bottom of that page displays a summary box which tells you the hostname and IP address where HiveServer2 was installed. This is the location you will put in the HiveServer2 box above. The tutorial says the host name is sandbox.hortonworks.com. Using the IP address in the connection properties may be easiest if you don't have your hosts file setup (1.3 Add Sandbox Hostname to Your Hosts Filel) HiveServer2 Port 1) Log into Ambari 2) From the list of services click Hive. 3) Click the Configs tab 4) Click the Advanced tab 5) In the Filter on the right side type 'server2' 6) The value 'HiveServer2 port' is the port to use in the connection box above. The default port is 10000 Metastore Location + Port (these properties are optional) 1) Log into Ambari 2) From the list of services click Hive. 3) Click the Configs tab 4) Click the Advanced tab 5) In the Filter box on the right side type 'hive.metastore.uris' The value of this parameter shows the location and port of the metastore. The default port is 9083. **NOTE: The HDP sandbox does not come with port 9083 open by default (see Sandbox Port Forwards for the list of port forwards). Therefore, you must open this port yourself in the virtualization/containerization platform. See the Sandbox Port Forwarding Guide for more details. Hive Advanced Connection Properties Thrift Transport 1) Log into Ambari 2) From the list of services click Hive. 3) Click the Configs tab 4) Click the Advanced tab 5) In the Filter on the right side type 'server2' 6) HiveServer2 port is the port to use in the connection box above. 7) The hive.server2.transport.mode tells you what thrift transport mode you are using (http, binary). Set the thrift transport in the Hive Advanced Connection Properties accordingly. If http is used, the value of hive.server2.thrift.http.path should be used as the http path in the advanced connection settings. The default is 'cliservice'. Using the above information, you should be able to connect to any hive databases in the sandbox. ... View more