CREATE EXTERNAL TABLE tmp_showcrt1(
  key string, 
  newvalue boolean COMMENT 'a new value')
COMMENT 'temporary table'
PARTITIONED BY ( 
  value bigint COMMENT 'some value')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'file:/tmp/sparkHiveWarehouse1280221975983654134/tmp_showcrt1'
TBLPROPERTIES (
  'transient_lastDdlTime'='1407132112')