You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2019/04/19 19:06:35 UTC
[drill-site] branch asf-site updated: edit
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 dbe7136 edit
dbe7136 is described below
commit dbe713654e461f54973ec3bb4c26869f69e1ce5e
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Fri Apr 19 12:06:15 2019 -0700
edit
---
docs/query-profiles/index.html | 101 ++++++++++++++++++----------------
docs/rest-api-introduction/index.html | 5 +-
feed.xml | 4 +-
3 files changed, 60 insertions(+), 50 deletions(-)
diff --git a/docs/query-profiles/index.html b/docs/query-profiles/index.html
index ff96271..e2f49ea 100644
--- a/docs/query-profiles/index.html
+++ b/docs/query-profiles/index.html
@@ -1310,7 +1310,7 @@
</div>
- Apr 18, 2019
+ Apr 19, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1369,51 +1369,60 @@
<p>The following table lists the warnings, icons, configurable options related to the warnings, and option descriptions: </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/rnT6Uq5.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 <a href="https://drill.apache.org/docs/sort-based-and-hash-based-memory-constrained-operators/">Sort-Based and Hash-Based Memory Constrained Operators</a> 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/hxwsiaA.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 thres [...]
-</tr>
-<tr>
-<td>See warning for drill.exec.http.profile.warning.time.skew.min</td>
-<td></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></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/HHA5CkV.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>
+<style type="text/css">
+.tg {border-collapse:collapse;border-spacing:0;}
+.tg td{font-family:Arial, sans-serif;font-size:12px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
+.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
+.tg .tg-13we{font-weight:bold;background-color:#c0c0c0;border-color:inherit;text-align:left}
+.tg .tg-6e8n{font-weight:bold;background-color:#c0c0c0;border-color:inherit;text-align:left;vertical-align:top}
+.tg .tg-xldj{border-color:inherit;text-align:left}
+.tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top}
+</style>
+
+<table class="tg">
+ <tr>
+ <th class="tg-13we">Warning Message</th>
+ <th class="tg-13we">Icon</th>
+ <th class="tg-13we">Related Option(s)</th>
+ <th class="tg-6e8n">Description</th>
+ </tr>
+ <tr>
+ <td class="tg-xldj">!WARNING: No fragments have made any progress in the last 300 seconds. (See Last Progress below.)</td>
+ <td class="tg-xldj">None</td>
+ <td class="tg-xldj">drill.exec.http.profile.warning.progress.threshold</td>
+ <td class="tg-0pky">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 class="tg-xldj">!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 class="tg-xldj"> 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 class="tg-xldj"> See Sort-Based and Hash-Based Memory Constrained operators for related options.</td>
+ <td class="tg-0pky">Hovering the mouse over the icon reveals the average number of spills. The higher the value, the greater the degradation.</td>
+ </tr>
+ <tr>
+ <td class="tg-xldj">!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 class="tg-xldj"> 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 class="tg-xldj"> drill.exec.http.profile.warning.time.skew.min</td>
+ <td class="tg-0pky">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. <br> 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 thres [...]
+ </tr>
+ <tr>
+ <td class="tg-xldj">See warning for drill.exec.http.profile.warning.time.skew.min</td>
+ <td class="tg-xldj"> </td>
+ <td class="tg-xldj"> drill.exec.http.profile.warning.time.skew.ratio.process<br> </td>
+ <td class="tg-0pky"> 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 class="tg-xldj">See warning for drill.exec.http.profile.warning.time.skew.min</td>
+ <td class="tg-xldj"> </td>
+ <td class="tg-xldj"><br> <br> drill.exec.http.profile.warning.time.skew.ratio.wait<br> </td>
+ <td class="tg-0pky"> 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 class="tg-xldj"> !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 class="tg-xldj"> 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 class="tg-xldj"> drill.exec.http.profile.warning.scan.wait.min</td>
+ <td class="tg-0pky"> 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>
+</table>
<h3 id="configuring-warning-threshold-options">Configuring Warning Threshold Options</h3>
diff --git a/docs/rest-api-introduction/index.html b/docs/rest-api-introduction/index.html
index f48bda0..8abeb9c 100644
--- a/docs/rest-api-introduction/index.html
+++ b/docs/rest-api-introduction/index.html
@@ -1310,7 +1310,7 @@
</div>
- Apr 18, 2019
+ Apr 19, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1385,7 +1385,8 @@
<p><strong>Request Body</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> {
"queryType" : "SQL",
- "query" : "<Drill query>"
+ "query" : "<Drill query>",
+ "autoLimit" : "<rows returned>"
}
</code></pre></div>
<p><strong>Example</strong></p>
diff --git a/feed.xml b/feed.xml
index 5760102..3134b3b 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>Thu, 18 Apr 2019 12:35:49 -0700</pubDate>
- <lastBuildDate>Thu, 18 Apr 2019 12:35:49 -0700</lastBuildDate>
+ <pubDate>Fri, 19 Apr 2019 12:03:38 -0700</pubDate>
+ <lastBuildDate>Fri, 19 Apr 2019 12:03:38 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>