emacsist/weibo_location

weibo location code

weibo_location

weibo location code

sql

create table wb_location (
	p_code int,
	p_name varchar(32),
	c_code int,
	c_name varchar(32)
);

clickhouse

create table wb_location (p_code Int16, p_name String, c_code Int16, c_name String)Engine=MergeTree ORDER BY p_code SETTINGS index_granularity = 8192;

clickhouse init

#!/usr/bin/env bash

clickhouse --query="create table wb_location (p_code Int16, p_name String, c_code Int16, c_name String)Engine=MergeTree ORDER BY p_code SETTINGS index_granularity = 8192"
curl -s https://raw.githubusercontent.com/emacsist/weibo_location/master/location.csv | clickhouse --query="inser into weibo_location format CSV"