cancel
Showing results for 
Search instead for 
Did you mean: 

HIVE ( HADOOP) System Connection to HANA

aluri_hemanth
Participant
0 Kudos

Hi Folks,

I have a requirement for connecting HIVE system with HANA. Hive is the source and HANA will be the Target. Here my requirement is not to store the data from HIVE in Persistence Layer. Data should be shown Virtually

- I know we can achieve this by Creating Connection with Smart data Access

- Smart data Access will show the list of the Tables under HIVE Source system ( This is my understand)

- Now my First question is -  Would I be able to see the data for list of the tables that are shown under HIVE source system in Remote Sources ?

- I have already created Virtual Tables  in HANA with the SQL Code - CREATE VIRTUAL TABLE MFGSCHEMA.TABLEABCAT  HiveProd"."HIVE"."mfgpro_psna_adm"."aps_mstr";

- This Table has been created and it shown some Remote object in the table.

- If I preview the data in the table in HANA , it will calls the data from HIVE system and shows virtually - Please confirm if this is correct

I wanted to understand in Detail HIVE system connectivity with HANA.

Could anyone please share me Detail level of document on Smart Data access Connection ( HIVE with HANA ) ?

Appreciate your prompt response !

Regards,

HA

Accepted Solutions (0)

Answers (1)

Answers (1)

desgallagher
Contributor
0 Kudos

Hi HA,

The Blog below is pretty old but has been updated with additional information like using remote HADOOP data sources with HANA. Maybe it is of help to you?:

http://scn.sap.com/community/developer-center/hana/blog/2013/08/22/smart-data-access-and-hadoop

Kind Regards,

Des