Support Questions

Find answers, ask questions, and share your expertise

Connect Aginity for Hadoop to Sandbox Hive

Explorer

I Installed Aginity For Hadoop and tried to use it with Hive with the default HDP Sandbox parameters and still not able to make it work:

I need help in order to find and provide the right connection parameters.

Thanks

39843-capture1.png

39844-capture2.png

1 REPLY 1

New Contributor

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.