Updated on 2022-09-22 GMT+08:00

INSERT INTO CARBON TABLE

Function

This command is used to add the output of the SELECT command to a Carbon table.

Syntax

INSERT INTO [CARBON TABLE] [select query];

Parameter Description

Table 1 INSERT INTO parameters

Parameter

Description

CARBON TABLE

Name of the CarbonData table to be inserted

select query

SELECT query on the source table (CarbonData, Hive, and Parquet tables are supported)

Precautions

  • A table has been created.
  • You must belong to the data loading group in order to perform data loading operations. By default, the data loading group is named ficommon.
  • CarbonData tables cannot be overwritten.
  • The data type of the source table and the target table must be the same. Otherwise, data in the source table will be regarded as bad records.
  • The INSERT INTO command does not support partial success. If bad records exist, the command fails.
  • When you insert data of the source table to the target table, you cannot upload or update data of the source table.

    To enable data loading or updating during the INSERT operation, set the following parameter to true.

    carbon.insert.persist.enable=true

    By default, the preceding parameters are set to false.

    Enabling this property will reduce the performance of the INSERT operation.

Example

create table carbon01(a int,b string,c string) stored as carbondata;

insert into table carbon01 values(1,'a','aa'),(2,'b','bb'),(3,'c','cc');

create table carbon02(a int,b string,c string) stored as carbondata;

INSERT INTO carbon02 select * from carbon01 where a > 1;

System Response

Success or failure will be recorded in the driver logs.