hive load csv 文件

1. 创建表 

CREATE EXTERNAL TABLE `***`(
  `***` bigint COMMENT '个数')
COMMENT '测试表'
PARTITIONED BY (
  `dt` string)
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES
("separatorChar"=',',
"escapeChar" = "//")
LOCATION
  'hdfs://hadoop-ha-cluster/user/agc/data/homestead/app_homestead_region_index_flink_test'
TBLPROPERTIES (
  'bucketing_version'='2',
  )

2. alter table add partition

3.load data local input '路径' into table table_name partition(dt='***');

注：

特别注意：需要指定

ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES
("separatorChar"=',',
"escapeChar" = "//")