With the Data Transfer Wizard, you can export data from a Hadoop table by right-clicking the table and selecting . Hadoop displays as the source of the transfer (Source Type = Hadoop). Possible destination include Aster, Teradata, or External File.
Another option when transferring Hadoop data is to drag and drop 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.