鏈€杩戝湪one妗嗘灦涓姞鍏ヤ簡瀵筩lickhouse鏁版嵁搴撶殑鏀寔锛屼絾鏄病鏈夋壘鍒版弧鎰忕殑瀹㈡埛绔€傚幓瀹樻柟鐨刢lickhouse鐪嬪埌娌℃湁瀹㈡埛绔殑鍗忚鏂囨。锛屼絾鏄繕鏄尅涓嶄綇鑷繁閫犺疆瀛愮殑鐑儏銆傛垜鏄牴鎹畼鏂圭殑c++浠ｇ爜鐚滅殑锛屽啓鍑烘潵鐨勩€傝繕鏈変竴浜涚被鍨嬫殏鏃朵笉鏀寔锛屼互鍚庝細瀹屽杽...浠撳簱鍦板潃https://github.com/lizhichao/...瀹夎composerrequirelizhichao/one-ck鏀寔鐨勭被鍨媅x]UInt8,UInt16,UInt32,UInt64,Int8,Int16,Int32,Int64[x]Float32,Float64[x]Decimal(P,S),Decimal32(S),Decimal64(S),Decimal128(S)[x]瀛楃涓瞇x]FixedString(N)[x]UUID[x]Date[x]Datetime[x]Datetime64[x]Nullable(T)[x]IPv4[x]IPv6[x]Array(T)[]Tuple(T)[]鏋氫妇锛堝彲浠ヤ娇鐢↙owCardinality浠ｆ浛锛塂emouseOneCk\Client;useOneCk\Types;//default//$ck=newClient('tcp://127.0.0.1:9000','default','','榛樿'锛?$t1=microtime(true);$ck=newClient('tcp://192.168.31.216:9091','default','123456','test1');$data['鏈嶅姟鍣ㄤ俊鎭?]=$ck->getServerInfo();$data['droptable']=$ck->query('DROPTABLEIFEXISTSt6');$table=['CREATETABLEt6(','`id`UInt32,','`f1`Int32,','`f2`Nullable(Int32),','`f3`UInt8,','`f4`Nullable(UInt8),','`f5`UInt16,','`f6`UInt64,','`f7`Int64,','`f8`Float32,','`f9`Float64,','`f10`Nullable(Float64),','`f11`Decimal32(3),','`f12`Decimal64(5),','`f13`Decimal128(7),','`f14`Nullable(Decimal128(7)),','`f15`String,','`f16`Nullable(String),','`f17`FixedString(32),','`f18`UUID,','`f19`Date,','`f20`Nullable(Date),','`f21`Datetime,','`f22`Datetime64(3),','`f23`IPv4,','`f24`Nullable(IPv4),','`f25`IPv6,','`f26`LowCardinality(String)',')ENGINE=MergeTree()ORDERBYidSETTINGSindex_granularity=8192'];$data['鍒涘缓琛?]=$ck->query(implode("\n",$table));$data['鎻掑叆鏁版嵁']=$ck->insert('t6',[['id'=>1,'f1'=>-3,'f2'=>null,'f3'=>127,'f4'=>null,'f5'=>3322,'f6'=>1844674407370955161,'f7'=>9223372036854775807,'f8'=>-2132121.5,'f9'=>6546546544665.66658,'f10'=>null,'f11'=>552.339,'f12'=>3658.6954,'f13'=>'170141183460469231168730371588.4105721','f14'=>null,'f15'=>'emoji馃榾馃榿馃槀馃槀馃槂馃槃'='f16'>null,'f17'=>md5('a'),'f18'=>'016e64be-605f-4108-8a67-495d74d7ef3c','f19'=>'2020-09-05','f20'=>null,'f21'=>'2020-09-0514:25:12','f22'=>'2020-09-0514:25:12.258','f23'=>'192.168.1.1','f24'=>null,'f25'=>'CDCD:910A:2222:5498:8475:1111:3900:2020','f26'=>'eee'],['id'=>2,'f1'=>3,'f2'=>3,'f3'=>3,'f4'=>3,'f5'=>3,'f6'=>3,'f7'=>3,'f8'=>3,'f9'=>3,'f10'=>3,'f11'=>-552.339,'f12'=>-3658.6954,'f13'=>'-170141183460469231168730371588.4105721','f14'=>3,'f15'=>'aaa','f16'=>'aaa','f17'=>md5('55'),'f18'=>md5('55'),'f19'=>'2020-09-06','f20'=>'2020-09-06','f21'=>'2020-09-0614:25:12','f22'=>'2020-09-0614:25:12.258','f23'=>'251.222.221.231','f24'=>'192.168.1.2','f25'=>'1030::C9B4:FF12:48AA:1A2B','f26'=>'eee22'],['id'=>3,'f1'=>-1,'f2'=>3,'f3'=>3,'f4'=>3,'f5'=>3,'f6'=>3,'f7'=>3,'f8'=>3,'f9'=>3,'f10'=>3,'f11'=>3,'f12'=>3,'f13'=>3,'f14'=>3,'f15'=>'aaa','f16'=>'aaa','f17'=>md5('a'),'f18'=>'3026ee79-ac2a-46d2-882d-959a55d71025','f19'=>'2020-09-07','f20'=>'2020-09-07','f21'=>'2020-09-0714:25:12','f22'=>'2020-09-0714:25:12.258','f23'=>'192.168.1.1','f24'=>null,'f25'=>'2001:DB8:2de::e13','f26'=>'eee22']]);//$data['struct']=$ck->query('desct6');$data['selectt6']=$ck->query('select*fromt6');$data['selectt6int64']=$ck->query("selectid,f6fromt6wheref6=1844674407370955161");$data['selectt6Decimal32']=$ck->query("selectid,f11fromt6wheref11='552.339'");$data['selectt6Decimal64']=$ck->query("selectid,f12fromt6wheref12='-3658.69540'");$data['selectt6Decimal128']=$ck->query(鈥滀粠t6涓€夋嫨id锛宖13锛屽叾涓璮13='170141183460469231168730371588.4105721'鈥濓級锛?data['selectt6uuid']=$ck->query锛堚€滀粠t6涓€夋嫨id锛宖18锛屽叾涓璮18='3026ee79-ac2a-46d2-882d-959a55d71025'");$data['selectt6date']=$ck->query("selectid,f19fromt6wheref19='2020-09-05'");$data['selectt6datetime']=$ck->query("selectid,f21fromt6wheref21='2020-09-0720:25:12'");$data['selectt6datetime64']=$ck->query("selectid,f22fromt6wheref22='2020-09-0620:25:12.258'");$data['selectt6ip']=$ck->query("selectid,f23,f25fromt6wheref23=".Types::encodeIpv4('192.168.1.1'));$data['selectt6ip64']=$ck->query("selectid,f23,f25fromt6wheref25='".Types::encodeIpv6('1030::c9b4:ff12:48aa:1a2b')."'");echojson_encode($data);//鎵归噺鍐欏叆//$data['droptable']=$ck->query('DROPTABLEIFEXISTSt7');//$table=[//'CREATETABLEt7(',//'`id`UInt32,',//'`f2`Nullable(Int32),',//'`f5`UInt16,',//'`f15`String',//')ENGINE=MergeTree()ORDERBYidSETTINGSindex_granularity=8192'//];//$data['createtable']=$ck->query(implode("\n",$table));//$ck->writeStart('t7',['id','f2','f5','f15']);//for($i=0;$i<100;$i++){//$da=[];//for($j=0;$j&l鍚?1000;$j++){//$da[]=[//'id'=>mt_rand(1,1000000),//'f2'=>mt_rand(-1000000,1000000),//'f5'=>mt_rand(1,10000),//'f15'=>md5(mt_rand(1,10000))//];//}//$ck->writeBlock($da);//////$ck->writeEnd();////echomicrotime(true)-$t1;
