The Teradata Aster JDBC (v5.1) driver (provided with Teradata Aster) must be downloaded from the vendor and is no longer bundled within Aqua Data Studio. Copy the driver into the Aqua Data Studio/lib/drivers folder. The product or products described in this book are licens ed products of Teradata Corporation or its affiliates. Teradata, Applications-Within, Aster, BYNET, Claraview, DecisionCast, Gridscale, MyCommerce, QueryGrid, SQL-MapReduce, Teradata. Microsoft SQL Server JDBC for macOS This tutorial shows how to set up a data source and connect to a Microsoft ® SQL Server ® database using the Database Explorer app or the command line. This tutorial uses the Microsoft JDBC Driver 4.0 for Microsoft SQL Server to connect to a Microsoft SQL Server 2016 Express database.
I am using the below syntax to read from Teradata Aster database Table transaction and load into Hadoop/Hive Table
I have added the below jar files in /usr/iop/4.1.0.0/sqoop/lib
folder
Syntax:
Error:
George Sovetov2 Answers
Add --connection-manager
in your sqoop command if available for your RDBMS in sqoop.
Otherwise, add --driver
in your sqoop command to use Generic connection manager.
You can try with JDBC jar from Aster.
Jdbc Driver Mysql
Here are some steps that I followed to create an external Hive table after importing an Aster table using Sqoop:
Download JDBC jar from https://aster-community.teradata.com/docs/DOC-2254
export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:$PWD/noarch-aster-jdbc-driver.jar
sqoop import -D mapreduce.job.name='Sqoop Hive Import for Aster table tableName' --connect 'jdbc:ncluster://X.X.X.X/database' --driver com.asterdata.ncluster.Driver --username 'user1' --password 'password' --query 'select * from schema.table where $CONDITIONS limit 10' --split-by col1 --as-avrodatafile --target-dir /tmp/aster/tableName
Create an external Hive table on target directory or replace avrodatafile with hive table options.
You can try with JDBC jar from Aster.
Jdbc Driver Mysql
Here are some steps that I followed to create an external Hive table after importing an Aster table using Sqoop:
Download JDBC jar from https://aster-community.teradata.com/docs/DOC-2254
export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:$PWD/noarch-aster-jdbc-driver.jar
sqoop import -D mapreduce.job.name='Sqoop Hive Import for Aster table tableName' --connect 'jdbc:ncluster://X.X.X.X/database' --driver com.asterdata.ncluster.Driver --username 'user1' --password 'password' --query 'select * from schema.table where $CONDITIONS limit 10' --split-by col1 --as-avrodatafile --target-dir /tmp/aster/tableName
Create an external Hive table on target directory or replace avrodatafile with hive table options.