grafana-trino icon indicating copy to clipboard operation
grafana-trino copied to clipboard

Error when querying column of type array(row)

Open tlegrave opened this issue 7 months ago • 2 comments

Hello there,

Plugin version: 1.0.7

I'm running into the following error when trying to query a table containing a column with the following type:

array(row(score double, word_start double, word_end double, word varchar)

Capture d’écran 2024-07-02 à 14 48 40

However, it works fine when querying a specific index.

Capture d’écran 2024-07-02 à 14 49 30

That doesn't seem to be a problem with trino, because querying directly with it seems to work well:

trino> SELECT transcription_words FROM iceberg.default.diarization_stock;
                                                                                                                                                                                   >
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->
 [{score=0.951171875, word_start=8.640000343322754, word_end=8.979999542236328, word= Bonsoir}, {score=0.9814453125, word_start=8.979999542236328, word_end=9.0, word= <C3><A0>}, {>
 [{score=0.85595703125, word_start=37.43000030517578, word_end=37.709999084472656, word= Une}, {score=0.99853515625, word_start=37.709999084472656, word_end=37.9900016784668, word>

tlegrave avatar Jul 02 '24 12:07 tlegrave