海外网站建设教程,php做简单网站教程视频,邢台网红打卡地,怎么做网站解析概述
ARRAY#xff1a;ARRAY类型是由一系列相同数据类型的元素组成#xff0c;这些元素可以通过下标来访问。比如有一个ARRAY类型的变量fruits#xff0c;它是由[apple,orange,mango]组成#xff0c;那么我们可以通过fruits[1]来访问元素orange#xff0c;因为ARRAY类型的…
概述
ARRAYARRAY类型是由一系列相同数据类型的元素组成这些元素可以通过下标来访问。比如有一个ARRAY类型的变量fruits它是由[apple,orange,mango]组成那么我们可以通过fruits[1]来访问元素orange因为ARRAY类型的下标是从0开始的 操作实例 1、创建表 hive create table array_test(name string,list arrayint)row format delimited fields terminated by ,collection items terminated by :;OK2、准备文件
[roothello110 data]# vi array_test zhangsan,1:2:3:4:5 lisi,6:7:8:9:10 xiaoming,11:12:13:14:15 xiaoxiao,21:22:23:24:25 dingding,33:34:35:36:37 3、文件导入表 hive load data local inpath /data/array_test into table array_test;Loading data to table default.array_test4、查看表 hive select * from array_test;OKzhangsan [1,2,3,4,5]lisi [6,7,8,9,10]xiaoming [11,12,13,14,15]xiaoxiao [21,22,23,24,25]dingding [33,34,35,36,37]Time taken: 5.293 seconds, Fetched: 5 row(s)-------------hive select name from array_test;OKzhangsanlisixiaomingxiaoxiaodingdingTime taken: 4.278 seconds, Fetched: 5 row(s)-----------------hive select name,list[1] from array_test;OKzhangsan 2lisi 7xiaoming 12xiaoxiao 22dingding 34Time taken: 4.857 seconds, Fetched: 5 row(s)-----------下标从0开始-------------hive select name,list[0] from array_test;OKzhangsan 1lisi 6xiaoming 11xiaoxiao 21dingding 33Time taken: 4.175 seconds, Fetched: 5 row(s)---------当序号不存在的时候返回null------hive select name,list[-1] from array_test;OKzhangsan NULLlisi NULLxiaoming NULLxiaoxiao NULLdingding NULLTime taken: 4.195 seconds, Fetched: 5 row(s)---------------------------------hive select name,list[100] from array_test;OKzhangsan NULLlisi NULLxiaoming NULLxiaoxiao NULLdingding NULLTime taken: 4.256 seconds, Fetched: 5 row(s)hive 5、hadoop中文件内容
