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.