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.

Reply via email to