创建csv格式的hive表

CREATE EXTERNAL TABLE dmd.tablename( ) PARTITIONED BY ( dt string) row format serde ‘org.apache.hadoop.hive.serde2.OpenCSVSerde’ with SERDEPROPERTIES (“separatorChar”=",",“quotechar”="\"") STORED AS TEXTFILE;