You can check the exact reason from job log, but generally, it's caused by missing libs in auxlib conf.
Thar includes hive-hbase-handler.jar, hbase-*.jar, guava-*.jar, zookeeper-*.jar, etc. ,varying the version of your hive and hbase. Thanks, Navis 2014-03-20 3:42 GMT+09:00 Sunil Ranka <sunil_ra...@yahoo.com>: > Hi All > > I am trying to query External Hive Table created on hbase ( hbase table is > compressed using "gzip") . I am getting quick response, if I use "select * > from hbase_acct_pref_dim_", but the query is taking for ever if I try to > retrieve data based on the row_key. > > hive> select * from hbase_acct_pref_dim_ where key = 30001; > > Hadoop job information for Stage-1: number of mappers: 1; number of > reducers: 0 > 2014-03-19 11:14:04,432 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:15:04,617 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:16:04,792 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:17:04,969 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:18:05,140 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:19:05,315 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:20:05,484 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:21:05,667 Stage-1 map = 0%, reduce = 0% > 2014-03-19 11:22:05,835 Stage-1 map = 0%, reduce = 0% > > > Any Help is appreciated. > > > > Thanks, > Sunil S Ranka > Blog :: http://sranka.wordpress.com > "Superior BI is the antidote to Business Failure" > ==================================================== > NOTHING IS IMPOSSIBLE EVEN THE WORD > IMPOSSIBLE SAYS ,I M POSSIBLE. > ====================================================
