ClickhouseBuilder

ClickhouseBuilder copied to clipboard

Can generate a Join with on clause instead of USING

1

Can generate a Join with on clause instead of USING? It will be ok also by a raw expression. Is it possibile?

GiuseppeMobijay

I would like to fork and modify this repo to better suit my needs but seems like I can not legaly modify and use your code without any open source...

qK1e

join query error

1

When trying to do ``` $builder->join(function (JoinClause $join) { $join->query() ->select('main_cpm') ->table('campaigns') ->on('campaigns.campaign_id', '=', 'user_event_agr.campaign_id'); }) ``` I get the following ` Call to undefined method PhpClickHouseLaravel\Builder::newQuery()`

smilelanss

fix final=false bug

tw2066

Optimize count calculation

1

Optimize the group by count calculation

tw2066

Where: https://github.com/the-tinderbox/ClickhouseBuilder/blob/master/src/Query/Enums/Operator.php Solution: public const NOT_EQUAL_TO = '';

srocerer

count return string instead of number

3

Could you please explain if I run the query: DB::connection('clickhouse')->select(raw('select count(*) as summary from table')); I get the result like this array:1 [ 0 => array:1 [ "summary" => "4309900"...

olegsklyarov1972

Is it possible to set the session_id parameter? Doesn't work with options array ``` 'options' => [ 'session_id' => "my_session_key" ] ```

Stajor