You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hivemall.apache.org by my...@apache.org on 2019/01/09 07:03:12 UTC
[incubator-hivemall-site] branch asf-site updated: Updated generic
function doc
This is an automated email from the ASF dual-hosted git repository.
myui pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-hivemall-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new df95254 Updated generic function doc
df95254 is described below
commit df952544beb8f530b090f4ca91baad046d77a9a1
Author: Makoto Yui <my...@apache.org>
AuthorDate: Wed Jan 9 16:02:50 2019 +0900
Updated generic function doc
---
userguide/misc/generic_funcs.html | 33 +++++++++++++++++++++++++++++++--
1 file changed, 31 insertions(+), 2 deletions(-)
diff --git a/userguide/misc/generic_funcs.html b/userguide/misc/generic_funcs.html
index 1d1a0a6..45f031f 100644
--- a/userguide/misc/generic_funcs.html
+++ b/userguide/misc/generic_funcs.html
@@ -2420,7 +2420,7 @@
</li>
<li><p><code>array_slice(array<ANY> values, int offset [, int length])</code> - Slices the given array by the given offset and length parameters.</p>
<pre><code class="lang-sql"><span class="hljs-keyword">SELECT</span>
- array_slice(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>), <span class="hljs-number">2</span>,<span class="hljs-number">4</span>),
+ array_slice(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">2</span>,<span class="hljs-number">4</span>),
array_slice(
<span class="hljs-built_in">array</span>(<span class="hljs-string">"zero"</span>, <span class="hljs-string">"one"</span>, <span class="hljs-string">"two"</span>, <span class="hljs-string">"three"</span>, <span class="hljs-string">"four"</span>, <span class="hljs-string">"five"</span>, <span class="hljs-string">"six"</span>, <span class="hljs-string">"seven"</span>, <span class="hljs-string">"eight&quo [...]
<span class="hljs-number">0</span>, <span class="hljs-comment">-- offset</span>
@@ -2522,6 +2522,35 @@
[-2,1,3,10]
</code></pre>
</li>
+<li><p><code>subarray(array<ANY> values, int fromIndex [, int toIndex])</code>- Returns a slice of the original array between the inclusive fromIndex and the exclusive toIndex.</p>
+<pre><code class="lang-sql"><span class="hljs-keyword">SELECT</span>
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">4</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">3</span>,<span class="hljs-number">4</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">3</span>,<span class="hljs-number">3</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">3</span>,<span class="hljs-number">2</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">0</span>,<span class="hljs-number">2</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">0</span>,<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>),<span class="hljs-number">-1</span>,<span class="hljs-number">2</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">4</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">4</span>,<span class="hljs-number">6</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">2</span>,<span class="hljs-number">4</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">0</span>,<span class="hljs-number">2</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">4</span>,<span class="hljs-number">6</span>),
+ subarray(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>),<span class="hljs-number">4</span>,<span class="hljs-number">7</span>);
+
+ [4,5]
+ [3]
+ []
+ []
+ [0,1]
+ [0,1]
+ [5,6]
+ [5,6]
+ [3,4]
+ [1,2]
+ [5,6]
+ [5,6]
+</code></pre>
+</li>
<li><p><code>subarray_endwith(array<int|text> original, int|text key)</code> - Returns an array that ends with the specified key</p>
<pre><code class="lang-sql"><span class="hljs-keyword">SELECT</span> subarray_endwith(<span class="hljs-built_in">array</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>,<span class="hljs-number">4</span>), <span class="hljs-number">3</span>);
[1,2,3]
@@ -3021,7 +3050,7 @@ Apache Hivemall is an effort undergoing incubation at The Apache Software Founda
<script>
var gitbook = gitbook || [];
gitbook.push(function() {
- gitbook.page.hasChanged({"page":{"title":"List of Generic Hivemall Functions","level":"2.1","depth":1,"next":{"title":"Efficient Top-K Query Processing","level":"2.2","depth":1,"path":"misc/topk.md","ref":"misc/topk.md","articles":[]},"previous":{"title":"Map-side join causes ClassCastException on Tez","level":"1.6.5","depth":2,"path":"troubleshooting/mapjoin_classcastex.md","ref":"troubleshooting/mapjoin_classcastex.md","articles":[]},"dir":"ltr"},"config":{"plugins":["theme [...]
+ gitbook.page.hasChanged({"page":{"title":"List of Generic Hivemall Functions","level":"2.1","depth":1,"next":{"title":"Efficient Top-K Query Processing","level":"2.2","depth":1,"path":"misc/topk.md","ref":"misc/topk.md","articles":[]},"previous":{"title":"Map-side join causes ClassCastException on Tez","level":"1.6.5","depth":2,"path":"troubleshooting/mapjoin_classcastex.md","ref":"troubleshooting/mapjoin_classcastex.md","articles":[]},"dir":"ltr"},"config":{"plugins":["theme [...]
});
</script>
</div>