Hi Thomas, in your example query the table alias 'a' has a 'pos' pseudo-column that refers to the element-position within the ARRAY, so I think it's indeed what you want. However, I think there is a bug here that may lead to confusion. The query you wrote "should" be illegal because you should not be able to access a.key and a.value without referencing the nested map in the FROM clause. I will follow-up with a JIRA, stay tuned. Can you try running this and see if you get the expected results? select c.id, a.pos from mytable c left join c.`location` a order by c.id, a.pos; Alternatively try this query if you also want to explode the items within the nested MAP: select c.id, a.pos, a.key, a.value from mytable c left join c.`location` a, a.item order by c.id, a.pos;
... View more
