Sqoop and Teradata database connection URL

0 votes
What URL should I use to make a connection from Sqoop to Teradata database? I am using Sqoop version 2. Thanks.
Jun 6, 2019 in Big Data Hadoop by Lakhan
436 views

1 answer to this question.

0 votes

Refer below

Syntax:

jdbc:teradata://<HOST>/DBS_PORT=1025/DATABASE=<DATABASE_NAME>

Example:

jdbc:teradata://my_teradata_server_hostname/DBS_PORT=1025/DATABASE=my_database_name
answered Jun 6, 2019 by Vishwa

Related Questions In Big Data Hadoop

0 votes
1 answer

Connection String for MySQL database using Sqoop

The format for the connection string and ...READ MORE

answered Jun 6, 2019 in Big Data Hadoop by John
635 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is the Data format and database choices in Hadoop and Spark?

Use Parquet. I'm not sure about CSV ...READ MORE

answered Sep 4, 2018 in Big Data Hadoop by Frankie
• 9,810 points
251 views
+1 vote
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
• 11,380 points
7,110 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
• 11,380 points
1,141 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
51,556 views
–1 vote
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,390 points
2,685 views
0 votes
1 answer

Hadoop sqoop import not working. Error: ERROR manager.SqlManager: Error reading from database

In the command, try mentioning the driver ...READ MORE

answered Dec 5, 2018 in Big Data Hadoop by Omkar
• 69,110 points
812 views
0 votes
1 answer

How to use SQLServer database with Sqoop?

First, download the SQLServer connector from Microsoft's ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Karan
83 views