The
complex data types contains :
Array
Map
Structs
Arrays :- The array
contains elements of same data type and can be accessed using the
index. For example :- if we have an array called animal , it can
contain animal like [‘dog’,’cat’,’lion’].These animals
can be accessed via index like animal[1] =cat
Let us understand this in four
simple steps :-
Step 1.) We will create a sample
file called ‘array_exm.txt’
We are having three fields
namely id, name and goals .Goals is an array datatype.
Step 2.) we will create the
table .
Create table player(id int,name
varchar(20),goals array<int>) row format delimited fields
terminated by ‘\t’ collection items terminated by ‘,’;
Step 3.) We will load the data
into the table.
Load data local inpath
‘pathname’ into table player;
Step 4.) Select the data from
the table .
We can also select the
specified array position value data from the table .
