Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ingesting calculation views from Hana into Hive with Sqoop

Solved Go to solution
Highlighted

Ingesting calculation views from Hana into Hive with Sqoop

New Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Ingesting calculation views from Hana into Hive with Sqoop

Contributor

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"

View solution in original post

1 REPLY 1
Highlighted

Re: Ingesting calculation views from Hana into Hive with Sqoop

Contributor

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"

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here