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 fcd2002 edit phonetic and string distance functions examples
fcd2002 is described below
commit fcd200226ebbf831ca55fe0b3df6d2e139281f61
Author: Bridget Bevens <bbev...@maprtech.com>
AuthorDate: Thu Jul 19 18:44:47 2018 -0700
edit phonetic and string distance functions examples
---
docs/phonetic-functions/index.html | 17 ++++++++---------
docs/string-distance-functions/index.html | 19 +++++++++++--------
feed.xml | 4 ++--
3 files changed, 21 insertions(+), 19 deletions(-)
diff --git a/docs/phonetic-functions/index.html
b/docs/phonetic-functions/index.html
index b19ac81..c8e5479 100644
--- a/docs/phonetic-functions/index.html
+++ b/docs/phonetic-functions/index.html
@@ -1244,13 +1244,18 @@
</div>
- Jul 18, 2018
+ Jul 20, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>Starting in version 1.14, Drill supports phonetic functions. You
can use phonetic functions to match similar sounding words. For example, the
names “Jayme” and “Jamie” have the same soundex values. </p>
+ <p>Starting in version 1.14, Drill supports phonetic functions.
Typically, you use phonetic functions in the WHERE clause of a query to find
words that sound similar. For example, to find all the people named Jaime in a
data source, you could issue the following query on the data source: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">
SELECT first_name
+ FROM name_data
+ WHERE soundex( `first_name` ) = soundex( “Jayme” );
+</code></pre></div>
+<p>The search would return data from rows where the first name field contains
names that sound similar to Jayme, such as Jaime, Jaymee, and so on. </p>
<p>Drill supports the following phonetic matching functions that map text to a
number or string based on how a word sounds: </p>
@@ -1267,15 +1272,9 @@
<li><a
href="/docs/phonetic-functions/#soundex(string)"><code>soundex(string)</code></a><br></li>
</ul>
-<h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT <phonetic-function>(string) FROM…
-</code></pre></div>
-<h2 id="usage-example">Usage Example</h2>
-<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT match_rating_encoder('Boston') AS MR FROM
(VALUES(1));
-</code></pre></div>
<h2 id="function-descriptions">Function Descriptions</h2>
-<p>The following sections describe each of the phonetic functions that Drill
supports. </p>
+<p>The following sections describe each of the phonetic functions that Drill
supports. Each function has a different algorithm that may work better for
certain words. </p>
<h3 id="caverphone1(string)">caverphone1(string)</h3>
diff --git a/docs/string-distance-functions/index.html
b/docs/string-distance-functions/index.html
index d85d225..f739033 100644
--- a/docs/string-distance-functions/index.html
+++ b/docs/string-distance-functions/index.html
@@ -1244,13 +1244,22 @@
</div>
- Jul 18, 2018
+ Jul 20, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>String distance functions measure the difference between two
strings. Starting in version 1.14, Drill supports the following string distance
functions: </p>
+ <p>Starting in version 1.14, Drill supports string distance functions.
Typically, you use string distance functions in the WHERE clause of a query to
measure the difference between two strings. For example, if you want to match a
street address, but do not know how to spell a street name, you could issue a
query on the data source with the street addresses:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">
SELECT street_address
+ FROM address-data
+ WHERE cosine_distance( `street_address`, “1234 North Quail Ln” ) < 0.5;
+</code></pre></div>
+<p>The search would return addresses from rows with street addresses similar
to 1234 North Quail Ln, such as: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">
1234 N. Quail Lane
+ 1234 N Quaile Lan
+</code></pre></div>
+<p>Drill supports the following string distance functions: </p>
<ul>
<li><a
href="/docs/string-distance-functions/#cosine_distance(string1,string2)"><code>cosine_distance(string1,string2)</code></a></li>
@@ -1262,12 +1271,6 @@
<li><a
href="/docs/string-distance-functions/#longest_common_substring_distance(string1,string2)"><code>longest_common_substring_distance(string1,string2)</code></a><br></li>
</ul>
-<h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text">
SELECT <string-distance-function>( string1, string2 ) FROM…
-</code></pre></div>
-<h2 id="example-usage">Example Usage</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text">
SELECT fuzzy_score( string1, string2 ) AS fuzzy_score FROM…
-</code></pre></div>
<h2 id="function-descriptions">Function Descriptions</h2>
<p>The following sections describe each of the string distance functions that
Drill supports. </p>
diff --git a/feed.xml b/feed.xml
index 86b7d2e..81c7a71 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>Wed, 18 Jul 2018 16:42:41 -0700</pubDate>
- <lastBuildDate>Wed, 18 Jul 2018 16:42:41 -0700</lastBuildDate>
+ <pubDate>Thu, 19 Jul 2018 18:42:15 -0700</pubDate>
+ <lastBuildDate>Thu, 19 Jul 2018 18:42:15 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
