This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 5321af4 edits
5321af4 is described below
commit 5321af46f82ebff2f40ff1f7c73b9a2aaef6b705
Author: Bridget Bevens <[email protected]>
AuthorDate: Mon Apr 22 10:46:20 2019 -0700
edits
---
docs/query-profiles/index.html | 293 +++++++----------------------------------
feed.xml | 4 +-
2 files changed, 48 insertions(+), 249 deletions(-)
diff --git a/docs/query-profiles/index.html b/docs/query-profiles/index.html
index 87a75f4..af9102b 100644
--- a/docs/query-profiles/index.html
+++ b/docs/query-profiles/index.html
@@ -1310,7 +1310,7 @@
</div>
- Apr 19, 2019
+ Apr 22, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1369,252 +1369,51 @@
<p>The following table lists the warnings, icons, configurable options related
to the warnings, and option descriptions: </p>
-<p><html></p>
-
-<p><head>
-<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
-<meta name=Generator content="Microsoft Word 15 (filtered)">
-<style>
-</style></p>
-
-<p></head></p>
-
-<p><body lang=EN-US></p>
-
-<div class=WordSection1>
-
-<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
- style='border-collapse:collapse;border:none'>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- background:#E7E6E6;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><b><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>Warning</span></b></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border:solid windowtext 1.0pt;
- border-left:none;background:#E7E6E6;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><b><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>Icon</span></b></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border:solid windowtext 1.0pt;
- border-left:none;background:#E7E6E6;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><b><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>Option</span></b></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border:solid windowtext 1.0pt;
- border-left:none;background:#E7E6E6;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><b><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>Description</span></b></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif;
- color:black'>!WARNING: No fragments have made any progress in the last 300
- seconds. (See Last Progress below.)</span></span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>None</span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif;
-
color:black'>drill.exec.http.profile.warning.progress.threshold</span></span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
- "Arial",sans-serif;color:#333333'>If none of the fragments make any progress
- within the set time, a warning appears. Time is set in seconds. Default is
- 300 seconds (5 minutes). You can see fragment activity in the Fragment
- Profiles section of the query profile.</span></span></span></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>!</span><span
- style='font-size:9.0pt;font-family:"Arial",sans-serif'> WARNING: Some
- operators have data spilled to disk. This will result in performance loss.
- (See Avg Peak memory and Max Peak Memory below)</span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Look for
- the icon in the Avg Peak Memory and Max Peak Memory columns to find the
- operators that spilled data to disk.</span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>See
- Sort-Based and Hash-Based Memory Constrained operators for related
options.</span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Hovering
- the mouse over the icon reveals the average number of spills. The higher the
- value, the greater the degradation.</span></p>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'> </span></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>!WARNING:
- Some of the operators spent more time waiting for data than processing it.
- (See AVG WAIT TIME as compared to Average Process Time for the operators
- below.</span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Look for
- the icon in the Max Process Time or Max Wait Time columns to locate the
- operators that waited or processed too long.</span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>drill.exec.http.profile.warning.time.skew.min</span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Sets the
- minimum threshold for operators with the longest processing or waiting
- fragment. When the slowest fragment hits this threshold and runs or waits at
- least 2X (default setting) longer than the average fragment, the Drill Web UI
- displays a warning message. Default is 2. The
- drill.exec.http.profile.warning.time.skew.ratio.process option sets the
- threshold ratio for processing. The
drill.exec.http.profile.warning.time.skew.ratio.wait
- option sets the threshold ratio for waiting.</span></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
- "Arial",sans-serif;color:#333333'>See warning for
- drill.exec.http.profile.warning.time.skew.min</span></span></span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'> </span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
-
"Arial",sans-serif;color:#333333'>drill.exec.http.profile.warning.time.skew.ratio.process</span></span></span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
- "Arial",sans-serif;color:#333333'>Defines the threshold ratio for processing.
- When the maxProcessing:avgProcessing ratio exceeds the defined threshold, the
- Drill Web UI displays a skew warning. Default is 2.</span></span></span></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
- "Arial",sans-serif;color:#333333'>See warning for
- drill.exec.http.profile.warning.time.skew.min</span></span></span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'> </span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
-
"Arial",sans-serif;color:#333333'>drill.exec.http.profile.warning.time.skew.ratio.wait</span></span></span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span class=apple-style-span><span
style='font-size:9.0pt;font-family:
- "Arial",sans-serif;color:#333333'>Defines the threshold ratio for waiting.
- When the maxWait:avgWait ratio exceeds the defined threshold, the Drill Web
- UI displays a skew warning. Default is 2.</span></span></span></p>
- </td>
- </tr>
- <tr>
- <td width=216 valign=top style='width:161.75pt;border:solid windowtext 1.0pt;
- border-top:none;padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>!WARNING:
- Some of the SCAN operators spent more time waiting for data than processing
- it. (See AVG WAIT TIME as compared to Average Process Time for the scan
- operators below.</span></p>
- </td>
- <td width=186 valign=top style='width:139.4pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Look for
- the icon in the Avg Wait Time or Avg Process Time columns to locate the scan
- operators that waited too long.</span></p>
- </td>
- <td width=295 valign=top style='width:221.3pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span
style='font-size:9.0pt;font-family:"Arial",sans-serif'>drill.exec.http.profile.warning.scan.wait.min</span></p>
- </td>
- <td width=306 valign=top style='width:229.65pt;border-top:none;border-left:
- none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext
1.0pt;
- padding:0in 5.4pt 0in 5.4pt'>
- <p class=MsoNormal
style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
- normal'><span style='font-size:9.0pt;font-family:"Arial",sans-serif'>Sets a
- minimum threshold ratio for the scan operator to wait. When the average wait
- time exceeds the processing time the Drill Web UI displays the warning.
- Default is 60 seconds.</span></p>
- </td>
- </tr>
-</table>
-
-<p class=MsoNormal> </p>
-
-</div>
-
-<p></body></p>
-
-<p></html></p>
+<table><thead>
+<tr>
+<th>Warning Message</th>
+<th>Icon</th>
+<th>Related Option(s)</th>
+<th>Description</th>
+</tr>
+</thead><tbody>
+<tr>
+<td>!WARNING: No fragments have made any progress in the last 300 seconds.
(See Last Progress below.)</td>
+<td>None
</td>
+<td>drill.exec.http.profile.warning.progress.threshold</td>
+<td>If none of the fragments make any progress within the set time, a
warning displays. Time is set in seconds. Default is 300 seconds (5 minutes).
You can see fragment activity in the Fragment Profiles section of the query
profile.</td>
+</tr>
+<tr>
+<td>!WARNING: Some operators have data spilled to disk. This will result in
performance loss. (See Avg Peak memory and Max Peak Memory below)</td>
+<td><img src="https://i.imgur.com/b8LGKmq.png"; alt=""> Look for the icon in
the Avg Peak Memory and Max Peak Memory columns to find the operators that
spilled data to disk.</td>
+<td>See Sort-Based and Hash-Based Memory Constrained operators for related
options.</td>
+<td>Hovering the mouse over the icon reveals the average number of spills.
The higher the value, the greater the degradation</td>
+</tr>
+<tr>
+<td>!WARNING: Some of the operators spent more time waiting for data than
processing it. (See AVG WAIT TIME as compared to Average Process Time for the
operators below)</td>
+<td><img src="https://i.imgur.com/UrHy2Fv.png"; alt=""> Look for the icon in
the Max Process Time or Max Wait Time columns to locate the operators that
waited or processed too long.</td>
+<td>drill.exec.http.profile.warning.time.skew.min</td>
+<td>Sets the minimum threshold for operators with the longest processing or
waiting fragment. When the slowest fragment hits this threshold and runs or
waits at least 2X (default setting) longer than the average fragment, the
Drill Web UI displays a warning message. Default is 2. The
drill.exec.http.profile.warning.time.skew.ratio.process option sets the
threshold ratio for processing. The
drill.exec.http.profile.warning.time.skew.ratio.wait option sets the t [...]
+</tr>
+<tr>
+<td>See warning for drill.exec.http.profile.warning.time.skew.min</td>
+<td><img src="https://i.imgur.com/UrHy2Fv.png"; alt=""></td>
+<td>drill.exec.http.profile.warning.time.skew.ratio.process</td>
+<td>Defines the threshold ratio for processing. When the
maxProcessing:avgProcessing ratio exceeds the defined threshold, the Drill
Web UI displays a skew warning. Default is 2.</td>
+</tr>
+<tr>
+<td>See warning for drill.exec.http.profile.warning.time.skew.min</td>
+<td><img src="https://i.imgur.com/UrHy2Fv.png"; alt=""></td>
+<td>drill.exec.http.profile.warning.time.skew.ratio.wait</td>
+<td>Defines the threshold ratio for waiting. When the maxWait:avgWait ratio
exceeds the defined threshold, the Drill Web UI displays a skew warning.
Default is 2.</td>
+</tr>
+<tr>
+<td>!WARNING: Some of the SCAN operators spent more time waiting for data
than processing it. (See AVG WAIT TIME as compared to Average Process Time
for the scan operators below)</td>
+<td><img src="https://i.imgur.com/RLk2eAU.png"; alt=""> Look for the icon in
the Avg Wait Time or Avg Process Time columns to locate the scan operators that
waited too long.</td>
+<td>drill.exec.http.profile.warning.scan.wait.min</td>
+<td>Sets a minimum threshold ratio for the scan operator to wait. When the
average wait time exceeds the processing time the Drill Web UI displays the
warning. Default is 60 seconds.</td>
+</tr>
+</tbody></table>
<h3 id="configuring-warning-threshold-options">Configuring Warning Threshold
Options</h3>
diff --git a/feed.xml b/feed.xml
index 95f4d0f..6853e0c 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Fri, 19 Apr 2019 15:37:22 -0700</pubDate>
- <lastBuildDate>Fri, 19 Apr 2019 15:37:22 -0700</lastBuildDate>
+ <pubDate>Mon, 22 Apr 2019 10:41:57 -0700</pubDate>
+ <lastBuildDate>Mon, 22 Apr 2019 10:41:57 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
![https://i.imgur.com/b8LGKmq.png"](https://i.imgur.com/b8LGKmq.png"){kind=link}
![https://i.imgur.com/UrHy2Fv.png"](https://i.imgur.com/UrHy2Fv.png"){kind=link}
![https://i.imgur.com/RLk2eAU.png"](https://i.imgur.com/RLk2eAU.png"){kind=link}