{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/14158","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/14158/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/14158/comments","events_url":"https://api.github.com/repos/apache/spark/issues/14158/events","html_url":"https://github.com/apache/spark/pull/14158","id":165127460,"number":14158,"title":"[SPARK-13547] [SQL] [WEBUI] Add SQL query in web UI's SQL Tab","user":{"login":"nblintao","id":5558370,"avatar_url":"https://avatars.githubusercontent.com/u/5558370?v=3","gravatar_id":"","url":"https://api.github.com/users/nblintao","html_url":"https://github.com/nblintao","followers_url":"https://api.github.com/users/nblintao/followers","following_url":"https://api.github.com/users/nblintao/following{/other_user}","gists_url":"https://api.github.com/users/nblintao/gists{/gist_id}","starred_url":"https://api.github.com/users/nblintao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nblintao/subscriptions","organizations_url":"https://api.github.com/users/nblintao/orgs","repos_url":"https://api.github.com/users/nblintao/repos","events_url":"https://api.github.com/users/nblintao/events{/privacy}","received_events_url":"https://api.github.com/users/nblintao/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":15,"created_at":"2016-07-12T16:56:26Z","updated_at":"2016-10-13T22:47:18Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/14158","html_url":"https://github.com/apache/spark/pull/14158","diff_url":"https://github.com/apache/spark/pull/14158.diff","patch_url":"https://github.com/apache/spark/pull/14158.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nFor the web UI, this PR adds the raw SQL query text for each query in the new column \"SQL Text\" in the SQL Tab. To achieve this, it also passes the SQL text from the parser to the execution UI data, through the logical plan.\r\n\r\nIf the query has no related query text, show a blank in that field. If there is no query in the table has a query text, not show the column.\r\n\r\nIf the query text is long (i.e. longer than 140 chars), show the short abstract and display the full version on demand by the link \"+more\".\r\n\r\nIf the query text is too long (i.e. longer than 1000 chars), it will be truncated. This is to avoid downing browsers or web UI servers by running out of memory.\r\n\r\nAlso, a tooltip is added on the header \"SQL Text\", saying `Shows 140 characters by default. Click \"+more\" to see more. Long texts are truncated to 1000 characters. Left blank when the query was not issued by SQL.`.\r\n\r\n## How was this patch tested?\r\n\r\nTested by trying multiple SQL queries.\r\n\r\nA screenshot of the SQL Tab:\r\n![sqltextwithtooltip](https://cloud.githubusercontent.com/assets/5558370/16863133/5ddb500c-4a15-11e6-9b08-e4ac160a0cd5.png)\r\n(Query 3 is identical to Query 2, but its SQL text is shown in detail by clicking \"+more\")\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/253660796","html_url":"https://github.com/apache/spark/pull/14158#issuecomment-253660796","issue_url":"https://api.github.com/repos/apache/spark/issues/14158","id":253660796,"user":{"login":"ajbozarth","id":13952758,"avatar_url":"https://avatars.githubusercontent.com/u/13952758?v=3","gravatar_id":"","url":"https://api.github.com/users/ajbozarth","html_url":"https://github.com/ajbozarth","followers_url":"https://api.github.com/users/ajbozarth/followers","following_url":"https://api.github.com/users/ajbozarth/following{/other_user}","gists_url":"https://api.github.com/users/ajbozarth/gists{/gist_id}","starred_url":"https://api.github.com/users/ajbozarth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajbozarth/subscriptions","organizations_url":"https://api.github.com/users/ajbozarth/orgs","repos_url":"https://api.github.com/users/ajbozarth/repos","events_url":"https://api.github.com/users/ajbozarth/events{/privacy}","received_events_url":"https://api.github.com/users/ajbozarth/received_events","type":"User","site_admin":false},"created_at":"2016-10-13T22:47:18Z","updated_at":"2016-10-13T22:47:18Z","body":"Thanks @markhamstra that was already addressed earlier in review"}}
{"actor":{"display_login":"ajbozarth"}}