I am using HDP2.6 I want to create a hive external table I am following this. I have created a table in phoenix using the below command CREATE TABLE IF NOT EXISTS tmp ( cola varchar, colb varchar, constraint my_cons primary key(cola) ); Now after opening the hive console I do the following hive> add jar /usr/hdp/2.6.0.3-8/phoenix/phoenix-hive.jar; hive> create external table tmp ( cola string, colb string) STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler' TBLPROPERTIES ( "phoenix.zookeeper.quorum" = "sandbox.hortonworks.com", "phoenix.zookeeper.znode.parent" = "hbase-unsecure", "phoenix.zookeeper.client.port" = "2181",'autocreate'='true','autodrop'='true',"phoenix.rowkeys" = "cola", "phoenix.column.mapping" = "cola:cola,colb:colb" ); The table gets created but when I run select * from tmp; I get the following exception Failed with exception java.io.IOException:java.lang.RuntimeException: org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=cola Though the exception seems obvious i am not able to resolve this. Please help ... View more