文件名称：性能测试-vue面试题汇总
文件大小：131KB
文件格式：PDF
更新时间：2024-07-20 16:54:57
clickhouse infiniDB olap选型 大数据
二、性能测试 1、创建表 infiniDB: 1 2 3 4 5 6 7 8 9 CREATE TABLE `billing ̀( `did ̀int(11) NOT NULL DEFAULT '0' COMMENT '', `hit ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '', r̀eqs ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '', r̀x ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '', t̀x ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '', l̀ogtime ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '', t̀pr ̀bigint(20) NOT NULL DEFAULT '0' COMMENT '' ) ENGINE=infiniDB DEFAULT CHARSET=latin1 clickhouse: 1 CREATE TABLE billing (id Int32,did Int32,hit Int64,reqs Int64,rx Int64,tx Int64,logtime Int6 4,tpr Int64) ENGINE=Log; 2、导入csv数据 csv格式如下： 1 2 3 4 106,9,10,123,11858014,1467133200,330,0 122,0,2,506,621,1467133200,150,0 124,112,249,1131297,1899996,1467133200,49,0 127,3,12,64257,88503,1467133200,66,0