Support Questions
Find answers, ask questions, and share your expertise

Sqoop Import

Contributor

Hi Team,

How to use --jar-file argument with Sqoop command? Here which jar file should i used to import SQL data into HIVE?

2 REPLIES 2

Mentor

Here's an example from sqoop user guide https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

sqoop import --table SomeTable --jar-file mydatatypes.jar \    
 --class-name SomeTableType

New Contributor

Can we use sub query in sqoop script, i'm not able to execute my query

Can anyone helpout here

here is the query

sqoop -- import --driver com.sap.db.jdbc.Driver --connection-manager "org.apache.sqoop.manager.GenericJdbcManager" --fetch-size 10000 --connect "jdbc:sap://ebh01d11.ss.sw.ericsson.se:30015/?currentschema=L_ONE400_R" --username test --query "select * from L_ON00_R.EKPO where \$CONDITIONS SLTTIMESTAMP <= (select max(SLTTIMESTAMP) from L_ON00_R.EKPO where \$CONDITIONS SLTTIMESTAMP <= (select ADD_SECONDS(CURRENT_TIMESTAMP,-100) from dummy))" --hbase-create-table -hbase-create-table -hbase-table "/mapr/MapRDev/data/edw/LandingZone/ONE400/EKPO" --hbase-row-key MANDT,EBELP,SLTTIMESTAMP --column-family CF1 --incremental append --check-column SLTTIMESTAMP --last-value 1 --hive-drop-import-delims --split-by VBELN --m 8