Versions Compared

Old Version 6

changes.mady.by.user Roberta Marton

Saved on

compared with

New Version 7

changes.mady.by.user Roberta Marton

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Import data from the remote source to Hive tables on Trafodion cluster. Use one of these approaches:
    • Use a tool like Apache Sqoop(TM) to move data from a remote relational database management system (RDBMS), such as MySQL or Oracle, to Hive tables on the Trafodion system. For more information, see see Using Sqoop to Import Data Into Hive
    • Copy the data to be imported into Trafodion onto HDFS on the Trafodion cluster. Use Hive external tables to make this data visible from Hive. For more information, see Create Hive External Tables.
  2. Use the Trafodion LOAD statement to import data from Hive to Trafodion tables. For more information, see see Bulk Loading Data Into into Trafodion Tables.

If you want to migrate a smaller amount of data (in the order of a few million rows) from a database that supports ODBC, then use the odb tool, which has parallel data loading and extracting capabilities. For more information, see Trickle Loading Data Into Trafodion Tables Trickle Loading Data Into Trafodion Tables. You can also use ETL tools like SQuirrel-SQL, Pentaho or Informatica. Those tools will connect to Trafodion through ODBC or JDBC and issue INSERT statements with an appropriate rowset size. They are expected to achieve a smaller throughput than odb.

...