https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175185#M61241 <P>I see there is a similar question and answer here:</P><P><A href="https://community.hortonworks.com/questions/103167/hi-i-am-using-hdp-26-and-i-cant-seem-to-create-an.html#answer-103175" target="_blank">https://community.hortonworks.com/questions/103167/hi-i-am-using-hdp-26-and-i-cant-seem-to-create-an.html#answer-103175</A></P> Thu, 18 May 2017 10:25:46 GMT namaheshwari 2017-05-18T10:25:46Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175182#M61238 <P>FAILED: SemanticException Cannot find class 'org.apache.hadoop.hive.hbase.HbaseStorageHandl</P> Tue, 16 May 2017 21:37:21 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175182#M61238 aljohnmangahas 2017-05-16T21:37:21Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175183#M61239 <P>You need to use org.apache.hadoop.hive.hbase.HBaseStorageHandler.</P><P>Please see if that helps.</P> Thu, 18 May 2017 03:14:45 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175183#M61239 namaheshwari 2017-05-18T03:14:45Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175184#M61240 <P>You should add hive-hbase-handler.jar in hive shell or hive-conf.</P><P>Connect Hive Shell</P><P>Execute these commands.</P><P>ADD JAR /usr/hdp/2.5.3.0-37/hive/lib/hive-hbase-handler.jar; </P><P> CREATE TABLE hbase_table_1(tags map&lt;string,int&gt;, row_key string) </P><P> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' </P><P>WITH SERDEPROPERTIES ( "hbase.columns.mapping" = "cf:tag_.*,:key", "hbase.columns.mapping.prefix.hide" = "true" ); </P><P>Then you'll find created table in hbase shell.</P> Thu, 18 May 2017 08:04:46 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175184#M61240 MindGlass 2017-05-18T08:04:46Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175185#M61241 <P>I see there is a similar question and answer here:</P><P><A href="https://community.hortonworks.com/questions/103167/hi-i-am-using-hdp-26-and-i-cant-seem-to-create-an.html#answer-103175" target="_blank">https://community.hortonworks.com/questions/103167/hi-i-am-using-hdp-26-and-i-cant-seem-to-create-an.html#answer-103175</A></P> Thu, 18 May 2017 10:25:46 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hi-I-am-using-HDP-2-6-I-am-unable-to-create-Hive-External/m-p/175185#M61241 namaheshwari 2017-05-18T10:25:46Z