title: Case Sensitive Partition Column in hive
body: <p>I need to create partition on a column with an UPPERCASE Column Name. However, Hive converts all the column Names to lowercase implicitly. I am not able to get data in my <code>select *</code> query. I cannot change the Folder name to lowercase. Below is the <code>Create</code> query I am using:</p>
  
  <pre><code>CREATE EXTERNAL TABLE db.ALERT_DS_Hive_Test
  PARTITIONED BY (PROC_ID String) 
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
  WITH SERDEPROPERTIES ('casesensitive'='PROC_ID')
  STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
  LOCATION '/user/sam/hive-test/ALERT_DS.avro/' 
  TBLPROPERTIES ('avro.schema.url'='/user/sam/hive-test/ALERT_DS.avsc');
  </code></pre>