- Apache Presto Tutorial
- Apache Presto - Home
- Apache Presto - Overview
- Apache Presto - Architecture
- Apache Presto - Installation
- Apache Presto - Configuration
- Apache Presto - Administration
- Apache Presto - SQL Operations
- Apache Presto - SQL Functions
- Apache Presto - MySQL Connector
- Apache Presto - JMX Connector
- Apache Presto - HIVE Connector
- Apache Presto - KAFKA Connector
- Apache Presto - JDBC Interface
- Custom Function Application
- Apache Presto Useful Resources
- Apache Presto - Quick Guide
- Apache Presto - Useful Resources
- Apache Presto - Discussion
json_array_get(json_array, index)
Query 1
presto:default> SELECT json_array_get('[11, 12, 13]', 0) as JSON;
Result
JSON ------ 11
Query 2
presto:default> SELECT json_array_get('[11, 12, 13]', -1) as JSON;
Result
JSON ------ 13
Query 3
presto:default> SELECT json_array_get('[11, 12, 13]', 5) as JSON;
Result
JSON ------ NULL
apache_presto_sql_functions.htm
Advertisements