CREATE EXTERNAL TABLE `webprd_iis`(
  `s_ip` string, 
  `cs_method` string, 
  `cs_uri_stem` string, 
  `cs_uri_query` string, 
  `s_port` bigint, 
  `cs_username` string, 
  `c_ip` string, 
  `cs_user_agent` string, 
  `cs_referer` string, 
  `cs_host` string, 
  `sc_status` bigint, 
  `sc_substatus` bigint, 
  `sc_win32_status` bigint, 
  `time_taken` bigint, 
  `datetime` string)
PARTITIONED BY ( 
  `hostname` string, 
  `svc` string)
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  's3://***WEBPRD/IIS/'
TBLPROPERTIES (
  'CrawlerSchemaDeserializerVersion'='1.0', 
  'CrawlerSchemaSerializerVersion'='1.0', 
  'UPDATED_BY_CRAWLER'='iis-logs-parquet', 
  'averageRecordSize'='6', 
  'classification'='parquet', 
  'compressionType'='none', 
  'objectCount'='196', 
  'recordCount'='13488318', 
  'sizeKey'='171943168', 
  'typeOfData'='file')