Load data into teradata using sqoop

0 votes
I have one partition table, so how I can load data into teradata using sqoop export?
Jul 15 in Big Data Hadoop by Kunal
50 views

1 answer to this question.

0 votes

The general syntax to do this as shown below.

hive table:

CREATE EXTERNAL TABLE mytab_load(field1 STRING, field2 STRING, field3 STRING)

ROW FORMAT DELIMITED 

FIELDS TERMINATED BY '\t' 

STORED AS TEXTFILE 

LOCATION '/maprfs;/../../mytab_load' 

Sqoop Export:

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 
answered Jul 15 by Ritu

Related Questions In Big Data Hadoop

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
73 views
0 votes
1 answer

How to transfer data from Netezza to HDFS using Apache Sqoop?

Remove the --direct option. It gives issue ...READ MORE

answered Apr 23, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
306 views
+3 votes
1 answer

Getting Connection Error while loading data into table using cloudera hive

Hey Nafeesa, Itseems that Hive is not able ...READ MORE

answered Oct 3, 2018 in Big Data Hadoop by Vardhan
• 12,580 points
76 views
0 votes
1 answer

Hadoop Hive Hbase: How to insert data into Hbase using Hive (JSON file)?

You can use the get_json_object function to parse the ...READ MORE

answered Nov 15, 2018 in Big Data Hadoop by Omkar
• 67,620 points
576 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,670 points
2,973 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,670 points
332 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
14,720 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,240 points
1,094 views
0 votes
1 answer
0 votes
1 answer

Can someone explain me how write data into HDFS using Java?

I understand your issue, I would drop ...READ MORE

answered Jun 4 in Big Data Hadoop by ravikiran
• 4,560 points
47 views