I have to extract the value from the path '$.quotes.NAME.cheapest.cost', the NAME changes but the rest of the path is the same. Is it possible to use a wildcard or something like *?
Asked
Active
Viewed 620 times
0
user1181237
- 73
- 6
1 Answers
1
No, json path support in Presto is very limited (unlike one which was added to Trino). You need to use alternative approaches via casting needed stuff to MAP's and ARRAYS's and processing it with unnest like here or here.
Guru Stron
- 102,774
- 10
- 95
- 132