https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingesting-calculation-views-from-Hana-into-Hive-with-Sqoop/m-p/215501#M63614 <P>I'm having issues ingesting calculation views from Hana into Hive.</P><P>The issue is with the --table parameter. The calculation view's table name is "/path/to/hana/calculation"</P><P>How can I pass this to Sqoop?</P> Sun, 25 Jun 2017 00:51:48 GMT georgejay060 2017-06-25T00:51:48Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingesting-calculation-views-from-Hana-into-Hive-with-Sqoop/m-p/215501#M63614 <P>I'm having issues ingesting calculation views from Hana into Hive.</P><P>The issue is with the --table parameter. The calculation view's table name is "/path/to/hana/calculation"</P><P>How can I pass this to Sqoop?</P> Sun, 25 Jun 2017 00:51:48 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingesting-calculation-views-from-Hana-into-Hive-with-Sqoop/m-p/215501#M63614 georgejay060 2017-06-25T00:51:48Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingesting-calculation-views-from-Hana-into-Hive-with-Sqoop/m-p/215502#M63615 <P> Try this:</P><PRE>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"</PRE> Sun, 25 Jun 2017 01:01:01 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ingesting-calculation-views-from-Hana-into-Hive-with-Sqoop/m-p/215502#M63615 nismaily 2017-06-25T01:01:01Z