Estos contenidos se han traducido de forma automática para su comodidad, pero Huawei Cloud no garantiza la exactitud de estos. Para consultar los contenidos originales, acceda a la versión en inglés.
Centro de ayuda/ GaussDB(DWS)/ Preguntas frecuentes/ Importación y exportación de datos/ How Can I Import Data to GaussDB(DWS)?
Actualización más reciente 2025-02-07 GMT+08:00
Ver PDF
Compartir

How Can I Import Data to GaussDB(DWS)?

GaussDB(DWS) supports efficient data import from multiple data sources. The following lists typical data import modes. For details, see Importing Data.

  • Importing data from the OBS

    Upload data to OBS and then export it to GaussDB(DWS) clusters. Data formats such as CSV and TEXT are supported.

  • Inserting data with INSERT statements

    Use the gsql client tool provided by GaussDB(DWS) or the JDBC/ODBC driver to write data to GaussDB(DWS) from upper-layer applications. GaussDB(DWS) supports complete database transaction-level CRUD operations. This is the simplest method and is applicable to scenarios with small data volume and low concurrency.

  • Importing data from MRS with MRS as the ETL.
  • Importing data with the COPY FROM STDIN command

    Run the COPY FROM STDIN command to write data to a table.

  • Importing data from a remote server to GaussDB(DWS) using GDS

    Use the GDS data import function provided by GaussDB(DWS) to import data files from a common file system (for example, an ECS).

  • Migrating data to GaussDB(DWS) using CDM