Create an InfluxDB result table

In Realtime Compute for Apache Flink, you can use InfluxDB to store output data. The following code shows an example:

create table stream_test_influxdb(
    `metric` varchar,
    `timestamp` BIGINT,
    `tag_value1` varchar,
    `field_fieldValue1` Double
)with(
    type = 'influxdb',
    endpoint = 'http://service.cn.influxdb.aliyuncs.com:****',
    database = '<yourDatabaseName>',
    batchPutsize = '1',
    username = '<yourDatabaseUserName>',
    password = '<yourDatabasePassword>'
);

Default format for the created table:

• Column 0: metric (VARCHAR). This column is required.
• Column 1: timestamp (BIGINT). This column is required. Unit: milliseconds.
• Column 2: tag_value1 (VARCHAR). This column is required. You must enter at least one value in this column.
• Column 3: field_fieldValue1 (DOUBLE). This column is required. You must enter at least one value in this column.
  To specify multiple field_fieldValue values, use the following format:

  field_fieldValue1 <Data type>,
  field_fieldValue2 <Data type>,
  ...      
  field_fieldValueN <Data type>

  The following code shows an example:

  field_fieldValue1 Double,
  field_fieldValue2 INTEGER,
  ...      
  field_fieldValueN INTEGER