parseable icon indicating copy to clipboard operation
parseable copied to clipboard

Issue with casting arrays

Open gyoza opened this issue 1 year ago • 1 comments

query

SELECT array_to_string('tags') FROM stream LIMIT 10;

Error in parseable server

parseable-server-d475ccd9b-bkxz4 server-server thread 'actix-rt|system:0|arbiter:1' panicked at /usr/local/cargo/registry/src/index.crates.io-6f17d22bba15001f/datafusion-physical-expr-32.0.0/src/array_expressions.rs:1506:54:
parseable-server-d475ccd9b-bkxz4 server-server index out of bounds: the len is 1 but the index is 1
parseable-server-d475ccd9b-bkxz4 server-server note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

Let me know if you need anything. Running on 'Edge'

gyoza avatar Jan 26 '24 16:01 gyoza

@gyoza can you try like array_to_string(array, delimiter), in this case the delimiter is ^.

Ref: https://arrow.apache.org/datafusion/user-guide/sql/scalar_functions.html#array-to-string

nitisht avatar Jan 29 '24 12:01 nitisht