StarRocks-流式导入至StarRocks

原创

已于 2024-06-05 16:58:35 修改 · 616 阅读

收录于

当前文章被以下社区和专栏收录：

于 2024-06-05 16:55:24 首次发布

根据业务需求拼接表字段内容，快速批量导入至Starrocks数据表中。

1、创建表

 CREATE TABLE `stream_test` (
   `id` bigint(20) COMMENT "",
   `id2` bigint(20) COMMENT "",
   `username` varchar(32) COMMENT ""
 ) ENGINE=OLAP
 DUPLICATE KEY(`id`)
 DISTRIBUTED BY HASH(`id`) BUCKETS 20;

2、修改配置信息

修改Starrocks集群 ip、port、数据库名称、用户信息

package com.test;

import org.apache.commons.codec.binary.Base64;
import org.apache.http.HttpHeaders;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpPut;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.DefaultRedirectStrategy;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.util.EntityUtils;
import java.io.IOException;
import java.nio.charset.StandardCharsets;

public class

标签