You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Arshad Matin (JIRA)" <ji...@apache.org> on 2015/01/27 12:36:34 UTC
[jira] [Created] (LENS-240) Explain for Hive query is taking time
Arshad Matin created LENS-240:
---------------------------------
Summary: Explain for Hive query is taking time
Key: LENS-240
URL: https://issues.apache.org/jira/browse/LENS-240
Project: Apache Lens
Issue Type: Bug
Reporter: Arshad Matin
Query Fired from RestApi call
{noformat}
27 Jan 2015 11:22:52,981 [lens-server-snapshotter] INFO org.apache.lens.server.LensServices - SnapShot of Lens Services created
27 Jan 2015 11:24:03,445 [Grizzly-worker(30)] INFO org.apache.lens.server.AuthenticationFilter - Request from user: null, path=/queryapi/queries
27 Jan 2015 11:24:03,451 [Grizzly-worker(30)] INFO org.apache.lens.server.query.QueryExecutionServiceImpl - Explain: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><lensSessionHandle><publicId>94ed-a660e111111a</publicId><secretId>4a8f-a47d-11111afda</secretId></lensSessionHandle> query:cube select field1 from cube where time_range_in(request_time, '2014-12-01-01', '2014-12-04-01')
{noformat}
Lens Server answered and closed the explain in 7 secs
{noformat}
27 Jan 2015 11:24:11,502 [Grizzly-worker(30)] INFO org.apache.lens.driver.hive.HiveDriver - No more results closing the query
27 Jan 2015 11:24:11,503 [Grizzly-worker(30)] INFO org.apache.lens.driver.hive.HiveDriver - CloseQuery: 6e3e8512-a3d4-4c66-97d3-f43d10639b9d
{noformat}
Since Explain is syn call.. client waited for 7 mins
{noformat}
Minutes diff : 7
Seconds diff : 427
Millis diff : 427719
{noformat}
Seems like formatting of query plan is taking time.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)