Creating a remote source to Hive

[tamasszirtes]

Hi,

I would like to create a virtual table in HANA SP6 based on Hadoop Hive. First I need to create a remote source. Anybody knows how to fill out the Connection Properties?

Driver

Server Name

Server Port

Database

Do I need Extra Adapter Properties?

Thanks for any help.

Regards,

Tamas

[Former Member]

As you may have noted in the PDF attached to note 1868702 you need to create the remote data source with a SQL statement similar to:

CREATE REMOTE SOURCE HIVE1 ADAPTER "hiveodbc" CONFIGURATION 'DSN=hive1' WITH

CREDENTIAL TYPE 'PASSWORD' USING 'user=dftest;password=dftest';

Unfortunately the 'Right click' manual option doesn't seem to be possible yet for HIVE connections.

If you are using a Cloudera distribution of HADOOP, the remote source connection is not yet officially supported, but for testing purposes you may be able to get it to work with the following third party ODBC drivers:

http://www.datadirect.com/products/odbc/index.html

I couldn't get Clouderas ODBC drivers to work yet, but these did for me.

[Former Member]

Sure - have you read the PDF attachment attached to Note 1868702 - SAP HANA Smart Data Access: Remote Datasource Drivers? This describes how to go about it.

I've not done it with Hive but ODBC is ODBC. It is a bit fiddly to set up on Linux.

John