hive 数据查询

QQ 交流群：335671559

一、SELECT ... FROM ...子句

hive> SELECT name, salary FROM employees;

hive> SELECT e.name, e.salary FROM employees e;

第一种方式是我们普遍使用的，第二种方式使用了别名，这在JOIN查询时非常必要

    1.1  查询数组结果，subordinates 数组类型

    hive> SELECT name,  subordinates FROM employees;

John Doe ["Mary Smith","Todd Jones"]

Mary Smith ["Bill King"]

Todd Jones []

    查询数组中的某一个值

    hive> SELECT name, subordinates [0] FROM employees;

John Doe Mary Smith

Mary Smith Bill King

     1.2  查询map类型

    hive> SELECT name,  deductions FROM employees;

John Doe {"Federal Taxes":0.2,"State Taxes":0.05,"Insurance":0.1}

Mary Smith {"Federal Taxes":0.2,"State Taxes":0.05,"Insurance":0.1}

    使用key值查询map中的值
    hive> SELECT name,  deductions["State Taxes"] FROM employees;

        John Doe 0.05

     1.3  查询结构体类型

    hive> SELECT name,  address FROM employees;

John Doe {"stre