Pallav Kulshreshtha created AMBARI-15346:
--------------------------------------------
Summary: Hive view: Visual Explain does not work when there are
multiple statements in the query editor
Key: AMBARI-15346
URL: https://issues.apache.org/jira/browse/AMBARI-15346
Project: Ambari
Issue Type: Bug
Components: ambari-views
Affects Versions: 2.2.2
Reporter: Pallav Kulshreshtha
Assignee: Pallav Kulshreshtha
Fix For: 2.2.2
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:
{code:java}
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)
{code}
Attached are the screenshot for the same
!Screen Shot 2016-03-08 at 1.07.02 PM.png|thumbnail!
!Screen Shot 2016-03-08 at 1.07.33 PM (2).png|thumbnail!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
