细胞膜对《Programming Hive》的笔记(1)

第1页 无

Hive支持的复杂数据类型
Hive复杂数据类型举例
Hive建表分隔符
Hive支持正则表达式
Hive多Partiion
Hive增加列
Hive修改列
Hive命令行设置变量
Hive命令行修改配置
非命令行执行hive语句
执行linux命令
执行hadoop命令

外部表  External Partitioned Tables

You can use partitioning with external tables. In fact, you may find that this is your most common scenario for managing large production data sets. The combi- nation gives you a way to “share” data with other tools, while still optimizing query performance.
You also have more flexibility in the directory structure used, as you define it yourself. We’ll see a particularly useful example in a moment.


Overwrite关键字

If you specify the OVERWRITE keyword, any data already present in the target directory will be deleted first. Without the keyword, the new files are simply added to the target directory. However, if files already exist in the target directory that match filenames being loaded, the old files are overwritten.
LIKE和RLIKE關鍵字