Exporting Data from Hadoop - Teradata Studio

Teradata® Studio™ User Guide
Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
The following procedure presents the option to export data using the Data > Export Data method. Hadoop data can be transferred in other ways:
  • Dragging and dropping a Hadoop table object from the Data Source Explorer to the Transfer View window. The Data Transfer wizard launches and opens the Column Specification dialog to allow you to specify which columns to transfer.
  • right-clicking the database's Tables node in the Data Source Explorer and selecting Hadoop > Data Transfer > External file, the data transfer is performed using the Teradata FastExport utility.
  1. In Data Source Explorer right-click the table and select Data > Export Data.
  2. In the Data Transfer Wizard, select the Destination Type.
  3. Click Launch.
  4. Do one of the following:
    If you selected this Destination Type Complete these steps:
    Aster
    1. Select the Aster Connection Profile.
    2. Select the schema containing the table you want to export.
    3. Select the table you want to export.
    4. By default, a new table will be created. Clear the Create New Table check box to select individual tables.
    5. If Create New Table is not checked, select the table you want to export then click Next.
    6. In the Column Specification dialog:
      • Enter the name of a new Hadoop Table, select the File Type from the drop-down menu, and enter a Delimiter.
      • Check the boxes for the Teradata table columns to transfer to the Hadoop table.
      • View and assign mappings for the table column types.
      • Enter a Job Name.
    7. [Optional] Click Next to view the SQL generated by the choices you made.
    Teradata
    1. Select the Teradata Connection Profile.
    2. Select the database containing the table you want to export.
    3. Check the Create New Table check box to export the data as a new table. Selecting this option disables the Table list.
    4. If Create New Table is not checked, select the table you want to export then click Next.
    5. Specify column information:
      • Enter a Delimiter.
      • Enter a name for the Teradata table.
      • Select a Primary Index from the drop-down menu.
      • Check the boxes for the Hadoop table columns to transfer to the Teradata table.
      • View and assign mappings for the table column types.
      • Enter a Job Name.
    6. [Optional] Click Next to view the SQL generated by the choices you made.
    External File (FastExport)
    1. Click Browse and specify and Output File.
    2. Select the File Type.
    3. [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
    4. If you specified the Delimited Text file type, complete the fields in the File Options section.
    5. Click Next and set up the filtering by data or column.
    6. [Optional] Click Next to view the SQL generated by the choices you made.