title: Hive - Unable to create PARTITIONS in EXTERNAL TABLE STORED BY Hbase
body: <p>HBase table specs</p>
  
  <pre><code>DESCRIPTION ENABLED {NAME =&gt; 'hbase_2_hive_names', FAMILIES =&gt; [{NAME =&gt; 'age',
  DATA_BLOCK_ENCODING =&gt; 'NONE', BLOOMFILTER =&gt; 'NONE', REPLICATION_SCOPE =&gt; '0', VERSIONS =&gt; 
  '3', COMPRESSION =&gt;  true 'NONE', MIN_VERSIONS =&gt; '0', TTL =&gt; '2147483647', KEEP_DELETED_CELLS 
  =&gt; 'false', BLOCKSIZE =&gt; '65536', IN_MEMORY =&gt; 'false', ENCODE_ON_DISK =&gt; 'true', BLOCKCACHE 
  =&gt; 'true'}, {NAME =&gt; 'id', DATA_BLOCK_ENCODING =&gt; 'NONE', BLOOMFILTER =&gt; 'NONE', 
  REPLICATION_SCOPE =&gt; '0', VERSIONS =&gt; '3', COMPRESSION =&gt; 'NONE', MIN_VERSIONS =&gt; '0', TTL =&gt; 
  '2147483647', KEEP_DELETED_CELLS =&gt; 'false', BLOCKSIZE =&gt; '65536', IN_MEMORY =&gt; 'false', 
  ENCODE_ON_DISK =&gt; 'true', BLOCKCACHE =&gt; 'true'}, {NAME =&gt; 'name', DATA_BLOCK_ENCODING 
  =&gt;'NONE', BLOOMFILTER =&gt; 'NONE', REPLICATION_SCOPE =&gt; '0', VERSIONS =&gt; '3', COMPRESSION =&gt; 
  'NONE', MIN_VERSIONS =&gt; '0', TTL =&gt; '2147483647', KEEP_DELETED_CELLS =&gt; 'false', BLOCKSIZE =&gt; 
  '65536', IN_MEMORY =&gt; 'false', ENCODE_ON_DISK =&gt; 'true', BLOCKCACHE =&gt; 'true'}]}                                                                                                                                                    
  </code></pre>
  
  <p>Create external table in Hive:</p>
  
  <pre><code>CREATE EXTERNAL TABLE hbase_hive_names(hbid INT, id INT,  fn STRING, ln STRING)
  PARTITIONED BY (age INT) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
  WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,id:id,name:fn,name:ln,age:age")
  TBLPROPERTIES("hbase.table.name" = "hbase_2_hive_names");
  </code></pre>
  
  <p>Get following error   </p>
  
  <pre><code> Error in metadata: java.lang.RuntimeException:
     MetaException(message:org.apache.hadoop.hive.serde2.SerDeException      
     org.apache.hadoop.hive.hbase.HBaseSerDe: columns has 4 elements while hbase.columns.mapping has 5 elements (counting the key if implicit)
  </code></pre>