ClickHouse中文文档

安装

1.使用composer安装ClickHouse依赖

composer require the-tinderbox/clickhouse-builder

2.在config/app.php添加依赖

'providers' => [
    ...
    Tinderbox\ClickhouseBuilder\Integrations\Laravel\ClickhouseServiceProvider::class,
    ...
]

3.连接配置

'connections' => [
    'clickhouse' => [
        'driver' => 'clickhouse',
        'host' => 'ip',
        'port' => '',
        'database' => '',
        'username' => '',
        'password' => '',
        'options' => [
            'timeout' => 10,
            'protocol' => 'https'
        ]
    ]
]

使用

使用方式基本与MySQL使用的方式一致

DB::connection('clickhouse')->table(表名)->select(raw("sum(click_cnt) as click_cnt"), "zone_id");;

DB::connection('clickhouse')->table($table)->insert($popDataToArr);

参考

https://blog.csdn.net/qq_32404231/article/details/118930322