AnsweredAssumed Answered

Hive map-reduce query is failing

Question asked by onlineplaymob on Apr 19, 2015
Latest reply on Apr 19, 2015 by onlineplaymob
Dear Friends,

I am trying to run my first Hive query which can launches map-reduce job. I have followed all the steps given at "".

"**web_log**" table has been crated and data loading completed with no error.
But when trying to execute "*SELECT web_log.* FROM web_log WHERE web_log.url LIKE '%doc'*"
I am getting following exception.
Number of reduce tasks is set to 0 since there's no reduce operator

    Starting Job = job_1429420954627_0002, Tracking URL = http://yarn-training:8088/proxy/application_1429420954627_0002/
    Kill Command = /opt/mapr/bin/hadoop job  -kill job_1429420954627_0002
    Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
    2015-04-19 00:19:15,690 Stage-1 map = 0%,  reduce = 0%
    Ended Job = job_1429420954627_0002 with errors
    Error during job, obtaining debugging information...
    FAILED: Execution Error, return code 2 from
    MapReduce Jobs Launched:
    Job 0:  MAPRFS Read: 0 MAPRFS Write: 0 FAIL

Could someone guide me please.