Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Array doesn't seem to work #43

Open
knoguchi opened this issue Mar 22, 2019 · 0 comments
Open

Array doesn't seem to work #43

knoguchi opened this issue Mar 22, 2019 · 0 comments

Comments

@knoguchi
Copy link

By looking at the base.py it seems Array is supported, however I got an error

can't render element of type <class 'sqlalchemy_clickhouse.base.ARRAY'>

Steps to reproduce

  1. create a table
CREATE TABLE default.xxx ( name String,  phone Array(String)) ENGINE = Memory()
 #!/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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant