Hive入门(四)：HQL查询语句（一）

最新推荐文章于 2024-04-14 21:41:05 发布

weiiL

最新推荐文章于 2024-04-14 21:41:05 发布

阅读量4.9k

点赞数 4

分类专栏： hive hadoop bigdata 文章标签： hive hadoop hql bigdata

本文链接：https://blog.csdn.net/m0_37324825/article/details/80485002

版权

本文详细介绍了Hive的HQL查询语句，包括查询表名、所有列、指定列及别名，集合数据类型如Array、Map、Struct的查询，计算列的算数运算和函数应用，如数学函数、聚合函数和表生成函数。还讨论了Limit、嵌套SELECT、CASE语句、WHERE语句的使用，以及浮点数比较、模糊匹配（LIKE和RLIKE）和GROUP BY分组聚合操作。对于Hive初学者，这些内容提供了全面的查询指导。

摘要由CSDN通过智能技术生成

开始

select

首先可以通过desc tablename查看表列信息。

hive> desc employees;
OK
col_name    data_type   comment
name                    string                  Employee name       
salary                  float                   Employee salay      
subordinates            array<string>           Names of subordiantes
deductions              map<string,float>       <deductions name, percentages>
address                 struct<street:string,city:string,state:string,zip:int>  Home address

employees表中信息为如下：

employees.name  employees.salary    employees.subordinates  employees.deductions    employees.address
John Doe    10000.0 ["Mary Smith","Todd Jones"] {
  "Federal Taxes":0.2,"State Taxes":0.05,"Insurance":0.1}     {
  "street":"1 Michigan Ave.","city":"Chicago","state":"IL","zip":60600}
Mary Smith  8000.0  ["Bill King"]   {
  "Federal Taxes":0.2,"State Taxes":0.05,"Insurance":0.1}    {
  "street":"100 Ontario St.","city":"Chicago","state":"IL","zip":60601}
Todd Jones  7000.0  ["Bill King"]   {
  "Federal Taxes":0.2,"State Taxes":0.03,"Insurance":0.1}    {
  "street":"200 Chicago Ave.","city":"Oak Park","state