bashkarev / clickhouse Goto Github PK

View Code? Open in Web Editor NEW

22.0 22.0 15.0 194 KB

Extension ClickHouse for Yii 2

License: MIT License

PHP 100.00%

clickhouse php yii2 yii2-extension

clickhouse's People

Contributors

Stargazers

Watchers

Forkers

fingligroup mysterydragon arkhamvm sartor tonisormisson olexainf fgh151 vistarsvo wojiukankan alexeitsurkan zkelo perfectpanel ddkirawan

clickhouse's Issues

Migration Table column date as 1970 year alwas

Table structure:

'version' => 'String',
 'date' => 'Date',
 'apply_time' => 'UInt32',
 'is_deleted' => 'UInt8' //0 active 1 //deleted

Migration history insert:

$command->insert($this->migrationTable, [
            'version' => $version,
            'apply_time' => time(),
            'is_deleted' => 0
        ])->execute();

So, no Date in insert...

Changed column name in ClickHouse 1.1.54237+

If I get it correctly, starting from ClickHouse 1.1.54237 in system.columns default_type was renamed to default_kind, so it lead to some mistakes, for example here.

Yii2 migration error - This syntax for *MergeTree engine is deprecated

...

BatchInsert from files

Command::batchInsert is a standard feature, but ClickHouse can insert data from uploaded files via Http Transport for better performance.
It would be nice to have this functionality. A signature may be similar to this Command::batchInsertFiles($table, array $files)

PHP 7.2 compatibility

Is there php 8 support?

Error while using OFFSET

SELECT `statistic`.* FROM `statistic` ALL INNER JOIN `copyright_owner` ON statistic.copyright_owner_id=copyright_owner.id ORDER BY `statistic`.`viewed_at` LIMIT 20 OFFSET 1;

Syntax error: failed at position 165:

SELECT `statistic`.* FROM `statistic` ALL INNER JOIN `copyright_owner` ON statistic.copyright_owner_id=copyright_owner.id ORDER BY `statistic`.`viewed_at` LIMIT 20 OFFSET 1;

Expected one of: UNION ALL, Comma, BY, SETTINGS, INTO OUTFILE, FORMAT, LIMIT, token

Sockets vs. Curl

Which are the points to use "low-level" sockets instead of yii-httpclient for example?
Performance? Could you provide a link to some tests or articles?
Otherwise, it looks like the wheel reinventing :)

Impossible to set database

Consider to add 'database' property to Connection or improve DSN syntax similar to regular connections (mysql for example): 'dsn' => 'tcp://localhost:8823;dbname=test'

Exception 'yii\db\Exception' with message 'Specify engine type'

Hello. I make a migration:
use bashkarev\clickhouse\Migration;
class m230706_140057_create_target extends Migration
{
const TABLE_NAME = 'first_table';
public function up()
{
$this->createTable(
self::TABLE_NAME,
[
'id' => $this->primaryKey(),
'account' => $this->string(35),
'account_state' => $this->tinyInteger(),
]
);

...
run
yii clickhouse-migrate
and get error:

create table first_table ...Exception 'yii\db\Exception' with message 'Specify engine type'

Need sample options string

Fix error in getClient()

Connection.php

change

    public function getClient(): Client
    {
        return $this->_client;
    }

    public function getClient(): Client
    {
        $this->open();
        
        return $this->_client;
    }

How to increase max query size?

I have query where in (ids) is a big items. How I can set options to increase during querying?

Maual not in line with v2

the manual of v2 refers to batchInsertFiles() which does not seem to exist and throws an exception