json_array_get(json_array, index)


Advertisements

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

Useful Video Courses


Video

Apache Spark Online Training

46 Lectures 3.5 hours

Arnab Chakraborty

Video

Apache Spark with Scala - Hands On with Big Data

23 Lectures 1.5 hours

Mukund Kumar Mishra

Video

Learn Apache Cordova using Visual Studio 2015 & Command line

16 Lectures 1 hours

Nilay Mehta

Video

Delta Lake with Apache Spark using Scala

52 Lectures 1.5 hours

Bigdata Engineer

Video

Apache Zeppelin - Big Data Visualization Tool

14 Lectures 1 hours

Bigdata Engineer

Video

Olympic Games Analytics Project in Apache Spark for Beginner

23 Lectures 1 hours

Bigdata Engineer

Advertisements