Can you please check your task logs of the job and please share the stack trace you see from there.
Regards, Tanvi Thacker On Thu, Aug 2, 2018 at 9:11 PM Satish Karuturi <sateesh.karutu...@gmail.com> wrote: > I am trying to access the views in Hive, getting following Exception: > > Error: Error while processing statement: FAILED: Execution Error, return code > 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2) > java.sql.SQLException: Error while processing statement: FAILED: Execution > Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask > > Here is my hive query: > > select * from sample_view; > > I have added *SPARK_HOME/jars* path to *$HIVE_HOME/bin/hive* like: > > for f in ${SPARK_HOME}/jars/*.jar; do > CLASSPATH=${CLASSPATH}:$f; > done > > i have tried, hive.execution.engine as *mr* and as well as *spark*, but > no luck. > > > This is my stackoverflow link: > > > https://stackoverflow.com/questions/51664932/unable-to-access-hive-views > > Please help me out. > > >