AnsweredAssumed Answered

HIVE select can't return

Question asked by jmzhuzhonghua on Oct 30, 2012
Latest reply on Nov 1, 2012 by nabeel
When running
<code>
SELECT web_log.* FROM web_log WHERE web_log.url LIKE '%doc';

</code>
there is no result returned. See the following:
<pre>
hive> select web_log.* from web_log where web_log.url LIKE '%doc';
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_201210310251_0008, Tracking URL = http://mapr-desktop:50030/jobdetails.jsp?jobid=job_201210310251_0008
Kill Command = /opt/mapr/hadoop/hadoop-0.20.2/bin/../bin/hadoop job  -Dmapred.job.tracker=maprfs:/// -kill job_201210310251_0008
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2012-10-31 03:25:49,068 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:26:49,904 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:27:50,413 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:28:50,960 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:29:51,450 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:30:51,867 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:31:52,337 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:32:52,919 Stage-1 map = 0%,  reduce = 0%
2012-10-31 03:33:53,431 Stage-1 map = 0%,  reduce = 0%
</pre>

Outcomes