RE: Issue with Querying External Hive Table created on hbase
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_ra...@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.
Re: Issue with Querying External Hive Table created on hbase
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.