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.