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.

Sqoop Import

Highlighted

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
Highlighted

Re: Sqoop Import

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

Re: Sqoop Import

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

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