第一步:Mysql导入数据到Python
第二步:python在clickhouse建表及数据处理,准备导入
第三步:数据导入(数据文件无压缩)
from clickhouse_driver import Client
import types
import time,datetime
from datetime import date
import pymysql
import warnings
import csv
warnings.filterwarnings('ignore')
pos1 = pymysql.connect(host='192.168.1.235',port=3306,user='root',password='123456',db='0001790455_pos',charset="utf8")
pos = pos1.cursor()
client = Client(host='192.168.1.231',database='test6',user='default',password='')
x=1000
while (x <=1000) :
client.execute('DROP TABLE IF EXISTS test')
creattable="""CREATE TABLE test (\
consumption_id UInt64,\
member_id UInt64,\
fans_id UInt64,\
bill_date Date,\