Hi.. By setting the above parameters on hive shell, it is giving correct output for simple select * from table name query, but is giving error as FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.spark.SparkTask when we do select count(*) from table name query. I have also added spark -assembly-hadoop jar in hive/lib please guide me ,i am new to spark ... View more

I am facing the same issue et hive.execution.engine=spark; and executed query as select count(*) from tablename; getting same error , but select * from table name works fine so what is the best solution to run select count(*) from tablename; in hive shell ... View more

Hi I am also facing same issue of queries not stopping executing in ambari I have restarted my ambari but still naot resolved Here are my ambar-server.log Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/YARN.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/AMBARI_METRICS.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/HOST.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/FLUME.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/HDFS.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/KAFKA.txt Please help me ... View more