Ingesting calculation views from Hana into Hive with Sqoop

[#1]

I'm having issues ingesting calculation views from Hana into Hive.

The issue is with the --table parameter. The calculation view's table name is "/path/to/hana/calculation"

How can I pass this to Sqoop?

[#2 · Accepted solution]

Try this:

sqoop import \ 
--username username \ 
--P \ 
--connect jdbc:sap://hostname:portnumber/ \ 
--driver com.sap.db.jdbc.Driver \ 
--query "select * from \"schema\".\"/path/to/hana/calculation\" where \$CONDITIONS" \ 
--hcatalog-database hivedatabase \ 
--hcatalog-table hivetable \ 
--create-hcatalog-table \ 
--hcatalog-storage-stanza "stored as orc"