sqlalchemy_dremio icon indicating copy to clipboard operation
sqlalchemy_dremio copied to clipboard

Extend _type_map with Array

Open bonedi opened this issue 2 years ago • 1 comments

I have some tables containing Array columns in a database. When DremioDialect.get_columns() is called ctype = _type_map[col[1]] throws an KEYERROR 'ARRAY'.
This can be solved with extending _type_map in base.py and query.py with:

_type_map = {
     ...
    'ARRAY': types.ARRAY,
    'array': types.ARRAY,
}

bonedi avatar Mar 14 '22 13:03 bonedi

I also ran into this today. @narendrans if it's ok I'll open a PR to get this fix in

villebro avatar May 02 '22 14:05 villebro