How to connect HADOOP to HANA REV80 via sqoop 1.4

[patrickbachmann]

Hi folks,

I have a colleague whom is trying to connect to HANA via HADOOP SQOOP 1.4.  The problem is we can't seem to connect to _SYS_BIC schema as it always defaults to his personal schema.  Is it possible to somehow pass the schema in the call?

EXAMPLE:

sqoop import --username JOEDIRT--password ****** --connect jdbc:sap://***.***.***.***:*****/_SYS_BIC/ --driver com.sap.db.jdbc.Driver --table \"\"production/AN_MATERIAL_MOVEMENTS\"\" --hive-import --hive-table MOVEMENTS

ERROR manager.SqlManager: Error executing statement: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/viewproduction/AN_MATERIAL_MOVEMENTS in schema JOEDIRT

Has anybody had success connecting using SCOOP 1.4?

Sqoop 1.4.4.2.1.1.0-385

hana client jar file version 80

Thanks,

-Patrick

[Former Member]

Hello Patrick,

Can you please share the syntax ,where we need to put this currentscema=_SYS_BIC.

I am not able to fix this thing.

Please help me .

Regards

Kunal

[patrickbachmann]

It was something like this;

:<PORTHERE>/?currentschema=_SYS_BIC

[patrickbachmann]

Ok we figured it out... had to add;

currentschema=_SYS_BIC

Thanks for NOTHING everybody. 

[henrique_pinto]

wow

[Former Member]

We aim to please.