ClickhouseBuilder
ClickhouseBuilder copied to clipboard
Fluent queries builder for Clickhouse. Also has integration with Laravel / Lumen.
in http interface , the password can place in `url` with paramater ``` $ echo 'SELECT 1' | curl 'http://localhost:8123/?user=user&password=password' -d @- ``` however , the password and username will...
is there any support mothod to update data?
This PR addresses my comment on #56 In my case, a `select` column exist that applies an alias, that alias is then used in the `orderBy`, when fetching a `count()`...
Hello! Now, where I want create table on cluster with this code: ``` $this->builder ->onCluster('test') ->createTableIfNotExists('test', 'ReplicatedMergeTree ORDER BY number', [ 'number' => 'UInt64', ]); ``` I have error, because...
add setting clickhouse when insert Sometime , we should set setting when insert. ``` \DB::connection('clickhouse')->setSetting(['insert_deduplicate' => 0])->table('table')->insert($data); ``` When i want to set the setting of `insert_deduplicate` , i can...
Hi, Great work on the code base, its difficult to find any laravel implementations with clickhouse. Would it be possible to support the Builder method **offset**? EG: ``` DB::table()->where()->limit()->offset()->get(); ```...
How to make join on different column names? ```select * from t1 all left join t2 on t1.v =t2.viewId;```
DB::Exception: Unknown setting wait_end_of_query