title: Hive can't create partitioned column for external table in hbase
body: <p>I cant create external table with partitioned column in hive with the below script</p>
  
  <pre><code>CREATE EXTERNAL TABLE Opportunity_par(key string,Opportunity__Id string,Campaign__Name string)
      &gt; PARTITIONED BY (eventDate timestamp)
      &gt; STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
      &gt; WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf2:Opportunity__Id,cf3:Campaign__Name,cf1:eventDate")
      &gt; TBLPROPERTIES("hbase.table.name" = "test_table");
  </code></pre>
  
  <p>its showing the following error,</p>
  
  <pre><code>FAILED: Error in metadata: java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException org.apache.hadoop.hive.hbase.HBaseSerDe: columns has 3 elements while hbase.columns.mapping has 4 elements (counting the key if implicit))
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
  </code></pre>
  
  <p>Please give solution or suggestion for creating external table in hive with partitioning column</p>
  
  <p>Thanks all...</p>