[AMBARI-15346] Hive view: Visual Explain does not work when there are multiple statements in the query editor

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.2
• Fix Version/s: 2.2.2
• Component/s: ambari-views
• Assignee: Pallav Kulshreshtha
• Reporter: Pallav Kulshreshtha
• Due: 11/Mar/16
• Created: 09/Mar/16 10:20
• Updated: 18/Mar/16 13:01
• Resolved: 18/Mar/16 07:30

Description

STEPS TO REPRODUCE:
Execute:
use testdb;
set hive.execution.engine=tez;
set tez.queue.name=dipayan;
select count from geolocation;

After it returns value, click on visual explain button. The call fails with the following error:

org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: ParseException line 2:4 missing KW_ROLE at 'hive' near 'hive'
line 2:8 missing EOF at '.' near 'hive' [ERROR_STATUS]

org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: ParseException line 2:4 missing KW_ROLE at 'hive' near 'hive'
line 2:8 missing EOF at '.' near 'hive' [ERROR_STATUS]
	at org.apache.ambari.view.hive.client.Utils.verifySuccess(Utils.java:46)
	at org.apache.ambari.view.hive.client.Connection.execute(Connection.java:614)
	at org.apache.ambari.view.hive.client.Connection.executeAsync(Connection.java:625)
	at org.apache.ambari.view.hive.resources.jobs.ConnectionController.executeQuery(ConnectionController.java:67)
	at org.apache.ambari.view.hive.resources.jobs.viewJobs.JobControllerImpl.submit(JobControllerImpl.java:109)
	at org.apache.ambari.view.hive.resources.jobs.JobService.create(JobService.java:431)
	at sun.reflect.GeneratedMethodAccessor326.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
	at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
	at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
	at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)

Attached are the screenshot for the same

Issue Links

• links to: Review board link