Sqoop: Dsqoop.export.records.per.statement option

0 votes

In the following command, what is the use of "Dsqoop.export.records.per.statement=1"

sqoop export --driver com.teradata.jdbc.TeraDriver --connect "jdbc:teradata://localhost/database=dbname" --password "xxxx" --username "usser" --table "mytab_load" --num-mappers 1 --export-dir "/maprfs:/../../mytab_load" --input-fields-terminated-by '\t' -Dsqoop.export.records.per.statement=1 
Jul 15 in Big Data Hadoop by Quill
70 views

1 answer to this question.

0 votes

Dsqoop.export.records.per.statement=1 is as the name suggests how many records or rows sqoop export at a time to mysql. So when you assign it to 1, you are telling sqoop to export 1 row at a time. 

answered Jul 15 by Krish

Related Questions In Big Data Hadoop

0 votes
1 answer

How to export file from sqoop to sql table?

For SQOOP export please try below command: bin/sqoop ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 67,600 points
107 views
0 votes
1 answer

SQOOP Export command failing

First create a table, which should have ...READ MORE

answered Jan 7 in Big Data Hadoop by Omkar
• 67,600 points
714 views
0 votes
1 answer

Load data into teradata using sqoop export

The general syntax to do this as ...READ MORE

answered Aug 9 in Big Data Hadoop by Kunal
97 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,690 points
3,097 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,690 points
348 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
15,203 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,128 views
0 votes
1 answer

Sqoop export not working

The issue that you might be getting ...READ MORE

answered Jul 16 in Big Data Hadoop by Tina
73 views
0 votes
1 answer

Hadoop Sqoop: How to change sqoop metastore?

In sqoop-site.xml I configured it with, the ...READ MORE

answered Nov 13, 2018 in Big Data Hadoop by Omkar
• 67,600 points
277 views