Loading Table Data from a File (Hadoop) - Teradata Studio
Teradata Studio User Guide
Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Preface
Purpose
Audience
Revision History
Additional Information
Product Safety Information
Getting Started With Studio
About Teradata Studio
Launching the Workbench
Workbench
Customizing the Display
Toolbars
Preferences
Logging Preferences
Displaying the Teradata Log Console
Controlling Log Levels
Adding Logging Levels
Setting the Log File Location
Teradata Datatools Preferences
JDBC Connection Properties
Perspectives
Query Development Perspective
Data Transfer Perspective
Administration Perspective
Navigator
Object List Viewer
Filters
Filtering the Object List Viewer
Administration Forms
Setting Root in the Administrative Perspective
Views
Opening Views
Moving View Panels
Data Source Explorer
Data Source Explorer Load Preferences
Setting Data Source Explorer Load Preferences
Setting Root in the Data Source Explorer
Database Connectivity
About Connection Profiles
Maximum Connections per Profile Preference
Adding a New Driver Definition
Teradata Database Connectivity
Creating a Teradata Connection Profile
Kerberos Authentication
Adding a JDBC Property
Editing JDBC Connection Properties
Database Cache
QueryBand Preferences
Aster Database Connectivity
Creating an Aster Database Connection Profile
Creating an Aster Execution Engine Connection Profile
Specify a Driver and Connection Details
Aster Connection Properties
Connecting to an Aster Database or Aster Execution Engine
Disconnecting From Aster Database or Aster Execution Engine
Deleting an Aster Connection Profile
Adding and Editing JDBC Connection Properties
Changing the Aster User Password
Adding an Aster Database Driver Definition
New JDBC Property
Add a JDBC Property
About Caching Aster Schemas
Caching Aster Schemas
Schema Cache Properties
Editing Aster Cache Schema Properties
About Refreshing Schema Cache
Deleting Aster Cache Files
Hadoop Connectivity
Creating a Hadoop Generic System Connection Profile
Hadoop Cloudera Connection Profiles
Creating Hadoop Cloudera Connection Profiles
Hadoop Hortonworks Connection Profiles
Creating a Hortonworks Self-Signed Certificate
Creating Hadoop Hortonworks Connection Profiles
Oracle, DB2, and SQL Server Connections
Database Administration
Teradata Database
Database Object Management
Viewing Database Objects
Creating Database Objects
Modifying Database Objects
Dropping Database Objects
Foreign Server Administration
Creating a Foreign Server
Altering Foreign Server Properties
Dropping a Foreign Server
Secure Zones Administration
Listing Secure Zones
Creating a Secure Zone
Dropping a Secure Zone
Modifying a Secure Zone
Adding Users to a Secure Zone
Removing Users from a Secure Zone
Adding Zone Guests to a Secure Zone
Removing Zone Guests From a Secure Zone
Database and User Management
Creating a Teradata Database or User
Viewing Teradata Database or User Properties
Modifying Teradata Database or User Properties
Cloning a Teradata Database or User
Table Management
Adding a Teradata Table
Profile Management
Creating a Profile
Viewing Profile Properties
Modifying Profile Properties
Privileges Modifications
Granting and Modifying Object-Level Privileges
Granting and Modifying System Privileges
Trigger Management
Displaying Triggers in a Database
Creating a Trigger
Enabling or Disabling a Trigger
Viewing Trigger Properties
Modifying Trigger Properties
Roles Management
Creating a Role
Viewing Role Properties
Modifying Role Properties
Dataset Schemas
Viewing Dataset Schemas
Creating Dataset Schemas
Dropping Dataset Schemas
Authorization Management
Creating an Authorization
Viewing Authorization Properties
Modifying Authorization Properties
View Management
Creating a View
Modifying a View
Dropping a View
Teradata Database Browsers
Dependency Browser
Dependencies Preferences
Interdependency Browser
Interdependency Browser Actions
Interdependency Printing
Macro Management
Creating a Macro
Dropping a Macro
Stored Procedure Management
Creating a Stored Procedure
Dropping a Stored Procedure
User-Defined Function (UDF) Management
Creating a UDF
Dropping a UDF
User-Defined Type (UDT) Management
Creating an Array UDT
Creating a Distinct UDT
Creating a Structured UDT
Dropping a UDT
Rights Management
Connect Through Rights
Permanent Proxy Users Tab
Application Proxy Users Tab
Display Tab
Revoke Tab
SQL Preview Tab
Logon Rights
Display Tab
Revoke Tab
Grant Tab
SQL Preview Tab
Access Logging Rules
Display Access Logging Tab
Set Access Logging Tab
Viewing Access Logging Rules
Setting Access Logging Rules
Query Logging Rules
Display Query Logging Rules
Set Query Logging Tab
Viewing Query Logging Rules
Setting Query Logging Rules
Move Space
Moving Spacing Between Databases and Users
Object Space
Data Tools
Compare Objects
About Comparing Objects
Teradata Compare Objects View
Types of Objects to Compare
Comparing Database and User Objects in Teradata
Comparing Table Objects in Teradata
About the Compare Editor
About Launching the Compare Editor
Compare Editor Toolbar
Statistics
Statistics Collection View
Collect Statistics Wizard
Collecting Statistics
Drop Statistics
Dropping Statistics
Filter Operations
Collect Statistics SQL Preview
Aster Database
Aster Databases and Privileges
Granted Privileges
Grantee Type and Privileges
Aster Databases, Users, and Roles
Aster Database Roles and Membership
Browsing Aster Schemas and Objects
Defining Databases on an Aster Server
Creating an Aster Database
Naming an Aster Database
Database Form
Dropping an Aster Database
Defining Aster Schemas
Creating an Aster Schema
Schema Form
Dropping an Aster Schema
Defining Aster Database Users
Creating an Aster Database User
User Form
Dropping an Aster Database User
Defining Aster Roles
Creating an Aster Role
Role Form
Dropping an Aster Role
Defining Aster Tables
Aster Analytic Tables and Persistence
Creating an Aster Table
Table Form
Dropping an Aster Table
Aster Table Types
Defining Aster Views
Creating an Aster View
View Form
Dropping an Aster View
DDL Management
Showing DDL Statements
Data Definitions Generation
Generate DDL Basics
Generating DDL for Database Objects
Teradata Data Lab
About Data Lab
About the Data Lab View
Opening the Data Lab View
Copying Tables to Data Labs
Data Lab Copy Wizard
About the Data Lab Copy Wizard
About Copy Table
About Filter Table
About SQL Preview Filter Table
Query Development
Data Tools for Query Development
Teradata SQL Editor
About the SQL Editor
Using the SQL File Editor
Drag and Drop into SQL Editor
SQL Editor Preferences
SQL Formatter Preferences
SQL Editor Toolbar
SQL Handling
BLOB Disposition
CLOB Disposition
LOB Disposition
Setting SQL Handling Preferences
Execute SQL
Running SQL
Format SQL Command
Set Connection Information
SQL Editor Templates
Retrieving Table Rows using a SELECT Template
Inserting Table Rows using an INSERT Template
Inserting Table Rows using Parameterized Queries
Parameterized Queries
Updating Table Rows using an UPDATE Template
Deleting Table Rows using a DELETE Template
Inserting Aster Analytical Functions
About Teradata SQL Query Builder
Result Set Viewer
Result Set Viewer Preferences
Setting Result Set Viewer Preferences
Results Preferences
Formatting the Foreground in Selected Cells
Formatting the Background in Selected Cells
Java Simple Date Format
SQL History View
SQL History Form
About SQL History Form
Toolbar for SQL History
Cleanup History
Import History
Export History
Filtering with Data Filter
History Preferences
Database Objects Search
Find Object
Finding Objects
Advanced Find Objects
Find Results
Enabling Teradata Unicode Pass-Through
Showing Table Row Counts
Table Data Development
About the Table Data Editor
Table Data Editor
Toolbar
About Editing Large Data and Objects
About Paging Large Tables
Data Filter
Opening the Table Data Editor
Table Data Editor Preferences
Setting Table Data Editor Preferences
Table Data Editing
About Editing Table Data
Editing Table Data
Inserting Table Data
Displaying Column Data by Value
Deleting Table Rows
Deleting Data from Cells
Reverting Edits
Finding and Replacing Data
Find Replace
Selecting to Filter by Edits
Viewing SQL Preview for Data Updates
Large Data and Objects Editing
About the Blob Editor
Blob Editor
Opening the Blob Editor
Editing BLOB Data
About the Clob Editor
Clob Editor
Opening the Clob Editor
Editing CLOB Data
About the Large Binary Editor
Opening the Large Binary Editor
Large Binary Editor
Editing Large Binary Data
About the Large Text Editor
Large Text Editor
Opening the Large Text Editor
Editing Large Text Data
About the XML Data Type Editor
XML Editor
Opening the XML Editor
Editing XML Data
Table Data Filtering
About Filtering Table Data
About the Data Filter
Exporting Table Data
Data Transfer
About Transferring Data
Transfer View
Transferring Data From Tables
Data Transfer Wizard
About the Data Transfer Wizard
Opening the Data Transfer Wizard
Working with Data Transfer Wizard
Transferring Teradata Database Data
Data Transfer to Teradata
About Transfer Hadoop Table to Teradata Table
Data Transfer From Teradata
About Transferring a Teradata Table to a Hadoop Table
About Teradata to Hadoop Column Specification
Transferring Aster Database Data
Data Transfer from Aster
Exporting Data from Aster
Data Transfer to Aster
Loading Data to an Aster Table
About Transfer Hadoop Table to Aster
About Hadoop to Aster Column Specification
About Hadoop to Aster SQL Preview
Transferring Hadoop Data
Data Transfer from Hadoop
Data Transfer to Hadoop
About Transfer Teradata Table to Hadoop
About Teradata to Hadoop Column Specification
About Copying Teradata Objects
Copying Objects Using the Data Transfer Wizard
Copying Table Data Between Teradata Databases
Dropping Objects on Transfer View
About Copy Table
Copy Object Support
Copy Object Wizard
About the Copy Object Wizard
About Filter Copy Column
About Column Specification
Column Data Type
About SQL Summary
Data Import and Export
Importing Data Into a Volatile Table
Import and Load External Data (Teradata, Aster)
About the Load Data Wizard (Teradata, Aster)
Load Data Wizard (Teradata, Aster)
Loading Table Data from a File (Teradata, Aster)
About the Load Data Wizard and JDBC
Import and Load External Data (Hadoop)
About the Load Data Wizard (Hadoop)
Load Data Wizard (Hadoop)
Loading Table Data from a File (Hadoop)
About Smart Load Wizard (Teradata, Aster)
Creating Tables with Smart Load (Teradata, Aster)
Editing Column Data Types (Teradata, Aster)
Smart Load Data Types for Teradata Tables
Smart Load Data Types for Aster Tables
About Smart Load Wizard (Hadoop)
Creating Tables with Smart Load (Hadoop)
Editing Column Data Types (Hadoop)
Smart Load Data Types for Hadoop Tables
Export External Data
About the Export Data Wizard
Exporting Table Data to an External File
Transfer Progress View
About the Transfer Progress View
Transfer Details
Job Details
Transfer History View
About the Transfer History View
Transfer History Filter
Sort
Troubleshooting
Troubleshooting
Open the Data Transfer perspective.
Select a Hadoop table in the Data Source Explorer as the destination table.
Right-click the table and select .
In the Data Transfer Wizard , select External File as the Source Type.
Click Launch .
The Load Data Wizard opens.
At Input File , type the directory path and name of the file that contains the data you want to import.
To find a file in your file system, click Browse , select the file, and click Open .
[Optional] Select Replace Existing Data to specify that data in the source file replaces any existing data in the destination file.
In Line Separator , select one of the following options based on the operating system from which the data is imported. This option enables you to import files with only Carriage Returns (CR), only LineFeeds (LF), or both Carriage Returns and LineFeeds (CR and LF).
Windows OS (CR and LF)
Prior to Mac OS X v10.0 (CR)
Unix, Linux, Mac OS X v10.0 and above (LF)
In File Encoding , select the character set to use to encode the data.
The options are: UTF-8, UTF-16, ISO-8859-1, UTF-16BE, UTF-16LE, US-ASCB, Cp1252.
A sample of the input file based on the options you select displays below the File Options . If you change the values selected in File Options fields, the sample row display also changes.
Click Finish .
When you click Finish , a file transfer job is launched in the Transfer Progress View view. When the transfer is complete, it is displayed in the Transfer History View .