title: HBase/Hive table queried from Squirrel SQL - Error in loading storage handler.org.apache.hadoop.hive.hbase.HBaseStorageHandler
body: <p>I am trying to query a HBase table through Squirrel SQL. Created a Hive external table like the following</p>
  
  <pre><code>create external table tweets_hbase(key string, value string)
  stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
  with serdeproperties ("hbase.columns.mapping" = ":key,data:tweet_text")
  tblproperties ("hbase.table.name" = "tweets_hbase")
  </code></pre>
  
  <p>I am able to query through command line HIVE </p>
  
  <pre><code>hive&gt; select * from tweets_hbase;
  OK
  20160725001730109       {"createdat":"25-Jul-2016 12:17:03","tweet_date":"2016-07-25","text":"私のランドールスゴビ:) \n#abyssrium\nhts:t.co/NcKtQi9lzm ht/t.co/WNgQIxLU05","user":"uw_kyaaaan","uniqueid":1469420239464,"searchtag":"Apple"}
  20160725001730266       {"createdat":"25-Jul-2016 12:17:03","tweet_date":"2016-07-25","text":"2016年7月24日\n8422 Steps\n移動距離 6.485 km\n消費カロリー 467.6 kcal\n\n#M7POPOPO ht/t.co/eFathZXTHD","user":"matsuwichi","uniqueid":1469420239465,"searchtag":"Apple"}
  20160725001730308       {"createdat":"25-Jul-2016 12:17:03","tweet_date":"2016-07-25","text":"RT @JBCrewdotcom: Don't forget to leave a nice review for #Coldwater after purchasing! \niTunes: t.co/p5YKRwPKNw\nGoogle Play: ht\u2026","user":"2016OLLGAndUGRL","uniqueid":1469420239466,"searchtag":"Apple"}
  </code></pre>
  
  <p>However when i try to query through Squirrel SQL, i get an Error in loading. The necessary JARs have been added to Extra Class Path. </p>
  
  <blockquote>
    <ol>
    <li>hive-hbase-handler-1.1.0.jar</li>
    <li>hbase-client-1.1.5.jar</li>
    <li>hbase-common-1.1.5.jar</li>
    <li>hbase-protocal-1.1.5.jar</li>
    <li>hbase-server-1.1.5.jar</li>
    <li>hive-jdbc-1.1.1-standalone.jar</li>
    </ol>
  </blockquote>
  
  <p>Please help</p>
  
  <pre><code>java.sql.SQLException: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Error in loading storage handler.org.apache.hadoop.hive.hbase.HBaseStorageHandler
  at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
  at net.sourceforge.squirrel_sql.client.session.StatementWrapper.execute(StatementWrapper.java:165)
  at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:369)
  at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212)
  at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
  at java.lang.Thread.run(Unknown Source)
  </code></pre>