CSV数据导入Parquet表

1，执行sql获取csv文件

select * from ad.click where month = 201412 and referralpage like 'http://weibo.com%'

2，将csv文件上传到服务器local:

/home/maoxiao/ad_weibo/data/click/201412.csv

3，创建csv表

CREATE TABLE maoxiao.click_csv(

  profile_id int  ,

  server_time STRING  ,

  gridsum_id string  ,

  client_ip string  ,

  referral_page string  ,

  referral_host string  ,

  ad_id string  ,

  os_brief string  ,

  os_detail string  ,

  browser_brief string  ,

  browser_detail string  ,

  dotnet_version string  ,

  is_mobile boolean  ,

  device_brand string  ,

  device_type string  ,

  device_name string  ,

  geo_code int  ,

  country string  ,

  province string  ,

  city string  ,

  district string  ,

  longitude float  ,

  latitude float  ,

  isp string ,

  year int,

  month int,

  day int

 ) row format delimited fields terminated by ',';

CREATE TABLE maoxiao.impression_csv(

    profile_id int  ,

  server_time STRING  ,

  gridsum_id string  ,

  client_ip string  ,

  referral_page string  ,

  referral_host string  ,

  ad_id string  ,

  os_brief string  ,

  os_detail string  ,

  browser_brief string  ,

  browser_detail string  ,

  dotnet_version string  ,

  is_mobile boolean  ,

  device_brand string  ,

  device_type string  ,