connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

trino error querying column of type 'array of structs'

Open tooptoop4 opened this issue 9 months ago • 0 comments

What language are you using?

python

What version are you using?

connectorx-0.4.1a1

What database are you using?

trino with hive catalog

Can you describe your bug?

import connectorx as cx
conn = 'trino+https://redact:redact@redact:443/hive'
cx.read_sql(conn, "select * from hive.redact.redact limit 2")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.10/site-packages/connectorx/__init__.py", line 367, in read_sql
    result = _read_sql(
RuntimeError: Trino unknown value at position: (0, 86): Array [Array [String("redact"), String("redact"), String("sstring")], Array [String("..........redacted

the table has some columns that are ARRAY of STRUCT types

it works when i just select simple columns like varchar, int

i guess this error is from https://github.com/sfu-db/connector-x/blob/053a59eaf4a43c8acfc927f9d1ac1a90023f2dda/connectorx/src/sources/trino/mod.rs#L437-L476

tooptoop4 avatar Jan 06 '25 06:01 tooptoop4