public function partitions(string $table, int $limit = null, bool $active = null)
    {
        $database          = $this->settings()->getDatabase();
        $whereActiveClause = $active === null ? '' : sprintf(' AND active = %s', (int) $active);
        $limitClause       = $limit !== null ? ' LIMIT ' . $limit : '';

        return $this->select(<<<CLICKHOUSE
SELECT *
FROM system.parts 
WHERE like(table,'%$table%') AND database='$database'$whereActiveClause
ORDER BY max_date $limitClause
CLICKHOUSE
        )->rowsAsTree('name');
    }
public function partitions(string $table, int $limit = null, bool $active = null)
    {
        $database          = $this->settings()->getDatabase();
        $whereActiveClause = $active === null ? '' : sprintf(' AND active = %s', (int) $active);
        $limitClause       = $limit !== null ? ' LIMIT ' . $limit : '';

        return $this->select(<<<CLICKHOUSE
SELECT *
FROM system.parts 
WHERE like(table,'%$table%') AND database='$database'$whereActiveClause
ORDER BY max_date $limitClause
CLICKHOUSE
        )->rowsAsTree('name');
    }
public function partitions ( string $ table , int $ limit = null , bool $ active = null ) { $ database = $ this -> settings ( ) -> getDatabase ( ) ; $ whereActiveClause = $ active === null ? '' : sprintf ( ' AND active = %s' , ( int ) $ active ) ; $ limitClause = $ limit !== null ? ' LIMIT ' . $ limit : '' ; return $ this -> select ( <<<CLICKHOUSE
SELECT *
FROM system.parts 
WHERE like(table,'%$table%') AND database='$database'$whereActiveClause
ORDER BY max_date $limitClause
CLICKHOUSE ) -> rowsAsTree ( 'name' ) ; }
List of partitions

@return mixed[][]
List of partitions