cloudflare / cloudflare/sqlalchemy-clickhouse

Array doesn't seem to work

Open
#43 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
325
Forks
101
PR merge metrics
No merged PRs in 30d

Description

By looking at the base.py it seems Array is supported, however I got an error
> can't render element of type

# Steps to reproduce
1. create a table

```
CREATE TABLE default.xxx ( name String, phone Array(String)) ENGINE = Memory()
```
2.

```
#!/usr/bin/env python

# Test engine and table
from sqlalchemy import *
from sqlalchemy.engine import create_engine
from sqlalchemy.schema import *
from sqlalchemy_clickhouse.base import dialect
engine = create_engine('clickhouse://default:@localhost:8123/default')
tbl = Table('xxx', MetaData(bind=engine), autoload=True)

ddl = CreateTable(tbl).compile(dialect=dialect())
print(ddl)
```

Maybe my specific case -- print CREATE TABLE stmt isn't supported?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.