01 - Hive 常用命令

【推荐】2019 Java 开发者跳槽指南.pdf(吐血整理) >>>

1. 输出表结构到SQL文件

hive -e "show table product.table" >> table.sql

2. 执行SQL文件

hive -f sql.sql

CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
  [(col_name data_type [COMMENT col_comment], ...)]
  [COMMENT table_comment]
  [PARTITIONED BY (col_name data_type
    [COMMENT col_comment], ...)]
  [CLUSTERED BY (col_name, col_name, ...)
  [SORTED BY (col_name [ASC|DESC], ...)]
  INTO num_buckets BUCKETS]
  [ROW FORMAT row_format]
  [STORED AS file_format]
  [LOCATION hdfs_path]