<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Cannot monitor impala queries on Cloudera Manager Impala Queries Tab in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Cannot-monitor-impala-queries-on-Cloudera-Manager-Impala/m-p/287256#M212938</link>
    <description>&lt;P&gt;&lt;a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/72952"&gt;@legendarier&lt;/a&gt;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please go to CM &amp;gt; Cloudera Management Services &amp;gt; Instances &amp;gt; Service Monitor &amp;gt; Charts Library &amp;gt; Service Monitor Storage, and check &lt;STRONG&gt;impala-query-monitoring&lt;/STRONG&gt; and see how old the data is (whether it has any data or not).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;See my screenshot below:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2020-01-09 at 10.06.47 pm.png" style="width: 999px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/25974i54C41C0D8DADE9E1/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screen Shot 2020-01-09 at 10.06.47 pm.png" alt="Screen Shot 2020-01-09 at 10.06.47 pm.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;This can help to confirm if data is stored correctly or not.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In detail, CM agent will get two types of Impala queries and sends to Service Monitor, which will in term display in CM interface:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;1. in flight queries&lt;/P&gt;&lt;P&gt;CM agent will fetch in flight query IDs via API call:&amp;nbsp;&lt;SPAN&gt;http(s)://{host}:{impalad-port}/inflight_query_ids&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;CM agent will fetch in flight query details via API call:&amp;nbsp;http(s)://{host}:{impalad-port}/query_profile_encoded?query_id={query_id}&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Above details will be combined and sent to Service Monitor service&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;2. finished queries&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;CM agent will parse the query profiles under&amp;nbsp;/var/log/impalad/profiles on the impala daemon host and sends data to Service monitor.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;So to troubleshoot the issue, you can check:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;a. CM agent log on the impala coordinator host to see if there is any impala related errors&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;b. Service Monitor server log to see if there is any impala related errors&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Hope above helps.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Cheers&lt;BR /&gt;Eric&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Thu, 09 Jan 2020 11:15:44 GMT</pubDate>
    <dc:creator>EricL</dc:creator>
    <dc:date>2020-01-09T11:15:44Z</dc:date>
  </channel>
</rss>

