FAQ
Hey guys,

I've configured Hive and loaded a few "test" tables with no issue.

I create a test SERDE/HBase table and when I run a select * from hbasetest
it returns all the row. The minute I run a LIKE or RLIKE query, it breaks.

There's nothing in the documentation (unless I missed it) that says these
aren't supported.

Anyways, here's a quick test to show what I mean. Any suggestions welcomed.

hive> CREATE TABLE test(key string, raw string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,cf:raw") TBLPROPERTIES ("hbase.table.name"
= "test");
OK
Time taken: 4.48 seconds
hive> select * from test where key like "%joe%";
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201211161423_0010, Tracking URL =
http://cluster01.lab:50030/jobdetails.jsp?jobid=job_201211161423_0010
Kill Command = /usr/lib/hadoop/bin/hadoop job
-Dmapred.job.tracker=cluster01.lab:8021 -kill job_201211161423_0010
Hadoop job information for Stage-1: number of mappers: 1; number of
reducers: 0
2012-11-20 15:18:40,018 Stage-1 map = 0%, reduce = 0%
2012-11-20 15:19:12,191 Stage-1 map = 100%, reduce = 100%
Ended Job = job_201211161423_0010 with errors
Error during job, obtaining debugging information...
Examining task ID: task_201211161423_0010_m_000002 (and more) from job
job_201211161423_0010
Exception in thread "Thread-28" java.lang.NullPointerException
at
org.apache.hadoop.hive.shims.Hadoop23Shims.getTaskAttemptLogUrl(Hadoop23Shims.java:44)
at
org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.getTaskInfos(JobDebugger.java:186)
at
org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.run(JobDebugger.java:142)
at java.lang.Thread.run(Thread.java:662)
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

Thanks,
Pat

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedNov 20, '12 at 8:23p
activeNov 20, '12 at 9:32p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Rafael: 1 post Patrick Ethier: 1 post

People

Translate

site design / logo © 2022 Grokbase