hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From java8964 <java8...@hotmail.com>
Subject RE: Issue with Querying External Hive Table created on hbase
Date Sat, 22 Mar 2014 02:47:09 GMT
I am not sure about your question.
Do you mean the query runs very fast if you run like 'select * from hbase_table', but very
slow for 'select * from hbase where row_key = ?'
I  think it should be the other way round, right?
Yong

Date: Wed, 19 Mar 2014 11:42:39 -0700
From: sunil_ranka@yahoo.com
Subject: Issue with Querying External Hive Table created on hbase
To: user@hive.apache.org

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: 02014-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