Apache Presto - Array Operator


Advertisements

Following are the types of Array operators.

Array subscript[] Operator

Query

presto:default> select array[1,2,3] as array_elements; 

Result

array_elements 
---------------- 
 [1, 2, 3] 

Array subscript operator returns array elements.

Array Concatenation Operator

Query

presto:default> select array[1,2,3] || array[4] as array_concat; 

Result

 array_concat 
-------------- 
 [1, 2, 3, 4]

Here, two arrays are concatenated with one array.

apache_presto_basic_sql_operations.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