hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navis류승우 <navis....@nexr.com>
Subject Re: Issue with Querying External Hive Table created on hbase
Date Thu, 20 Mar 2014 01:16:37 GMT
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_ranka@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.
> ====================================================

Mime
View raw message