http://git-wip-us.apache.org/repos/asf/incubator-madlib-site/blob/bed9253d/docs/v1.9.1/data__preparation_8sql__in.html
----------------------------------------------------------------------
diff --git a/docs/v1.9.1/data__preparation_8sql__in.html 
b/docs/v1.9.1/data__preparation_8sql__in.html
new file mode 100644
index 0000000..d0d2c71
--- /dev/null
+++ b/docs/v1.9.1/data__preparation_8sql__in.html
@@ -0,0 +1,315 @@
+<!-- HTML header for doxygen 1.8.4-->
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
+<html xmlns="http://www.w3.org/1999/xhtml";>
+<head>
+<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
+<meta http-equiv="X-UA-Compatible" content="IE=9"/>
+<meta name="generator" content="Doxygen 1.8.10"/>
+<meta name="keywords" content="madlib,postgres,greenplum,machine learning,data 
mining,deep learning,ensemble methods,data science,market basket 
analysis,affinity analysis,pca,lda,regression,elastic net,huber 
white,proportional hazards,k-means,latent dirichlet allocation,bayes,support 
vector machines,svm"/>
+<title>MADlib: data_preparation.sql_in File Reference</title>
+<link href="tabs.css" rel="stylesheet" type="text/css"/>
+<script type="text/javascript" src="jquery.js"></script>
+<script type="text/javascript" src="dynsections.js"></script>
+<link href="navtree.css" rel="stylesheet" type="text/css"/>
+<script type="text/javascript" src="resize.js"></script>
+<script type="text/javascript" src="navtreedata.js"></script>
+<script type="text/javascript" src="navtree.js"></script>
+<script type="text/javascript">
+  $(document).ready(initResizable);
+  $(window).load(resizeHeight);
+</script>
+<link href="search/search.css" rel="stylesheet" type="text/css"/>
+<script type="text/javascript" src="search/searchdata.js"></script>
+<script type="text/javascript" src="search/search.js"></script>
+<script type="text/javascript">
+  $(document).ready(function() { init_search(); });
+</script>
+<!-- hack in the navigation tree -->
+<script type="text/javascript" src="eigen_navtree_hacks.js"></script>
+<link href="doxygen.css" rel="stylesheet" type="text/css" />
+<link href="madlib_extra.css" rel="stylesheet" type="text/css"/>
+<!-- google analytics -->
+<script>
+  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new 
Date();a=s.createElement(o),
+  
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+  ga('create', 'UA-45382226-1', 'madlib.net');
+  ga('send', 'pageview');
+</script>
+</head>
+<body>
+<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
+<div id="titlearea">
+<table cellspacing="0" cellpadding="0">
+ <tbody>
+ <tr style="height: 56px;">
+  <td id="projectlogo"><a href="http://madlib.net";><img alt="Logo" 
src="madlib.png" height="50" style="padding-left:0.5em;" border="0"/ ></a></td>
+  <td style="padding-left: 0.5em;">
+   <div id="projectname">
+   <span id="projectnumber">1.9.1</span>
+   </div>
+   <div id="projectbrief">User Documentation for MADlib</div>
+  </td>
+   <td>        <div id="MSearchBox" class="MSearchBoxInactive">
+        <span class="left">
+          <img id="MSearchSelect" src="search/mag_sel.png"
+               onmouseover="return searchBox.OnSearchSelectShow()"
+               onmouseout="return searchBox.OnSearchSelectHide()"
+               alt=""/>
+          <input type="text" id="MSearchField" value="Search" accesskey="S"
+               onfocus="searchBox.OnSearchFieldFocus(true)" 
+               onblur="searchBox.OnSearchFieldFocus(false)" 
+               onkeyup="searchBox.OnSearchFieldChange(event)"/>
+          </span><span class="right">
+            <a id="MSearchClose" 
href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" 
border="0" src="search/close.png" alt=""/></a>
+          </span>
+        </div>
+</td>
+ </tr>
+ </tbody>
+</table>
+</div>
+<!-- end header part -->
+<!-- Generated by Doxygen 1.8.10 -->
+<script type="text/javascript">
+var searchBox = new SearchBox("searchBox", "search",false,'Search');
+</script>
+</div><!-- top -->
+<div id="side-nav" class="ui-resizable side-nav-resizable">
+  <div id="nav-tree">
+    <div id="nav-tree-contents">
+      <div id="nav-sync" class="sync"></div>
+    </div>
+  </div>
+  <div id="splitbar" style="-moz-user-select:none;" 
+       class="ui-resizable-handle">
+  </div>
+</div>
+<script type="text/javascript">
+$(document).ready(function(){initNavTree('data__preparation_8sql__in.html','');});
+</script>
+<div id="doc-content">
+<!-- window showing the filter options -->
+<div id="MSearchSelectWindow"
+     onmouseover="return searchBox.OnSearchSelectShow()"
+     onmouseout="return searchBox.OnSearchSelectHide()"
+     onkeydown="return searchBox.OnSearchSelectKey(event)">
+</div>
+
+<!-- iframe showing the search results (closed by default) -->
+<div id="MSearchResultsWindow">
+<iframe src="javascript:void(0)" frameborder="0" 
+        name="MSearchResults" id="MSearchResults">
+</iframe>
+</div>
+
+<div class="header">
+  <div class="summary">
+<a href="#func-members">Functions</a>  </div>
+  <div class="headertitle">
+<div class="title">data_preparation.sql_in File Reference</div>  </div>
+</div><!--header-->
+<div class="contents">
+
+<p>SQL functions for dummy coding categorical variables.  
+<a href="#details">More...</a></p>
+<table class="memberdecls">
+<tr class="heading"><td colspan="2"><h2 class="groupheader"><a 
name="func-members"></a>
+Functions</h2></td></tr>
+<tr class="memitem:a0add50a6ab76682bde7825fc54f4d64b"><td class="memItemLeft" 
align="right" valign="top">void&#160;</td><td class="memItemRight" 
valign="bottom"><a class="el" 
href="data__preparation_8sql__in.html#a0add50a6ab76682bde7825fc54f4d64b">create_indicator_variables</a>
 (text source_table, text out_table, text categorical_cols, boolean keep_null, 
text distributed_by)</td></tr>
+<tr class="memdesc:a0add50a6ab76682bde7825fc54f4d64b"><td 
class="mdescLeft">&#160;</td><td class="mdescRight">Create new table containing 
dummy coded variables for categorical variables.  <a 
href="#a0add50a6ab76682bde7825fc54f4d64b">More...</a><br /></td></tr>
+<tr class="separator:a0add50a6ab76682bde7825fc54f4d64b"><td 
class="memSeparator" colspan="2">&#160;</td></tr>
+<tr class="memitem:a05dbb30d8dd8589e75a96b3232cafe65"><td class="memItemLeft" 
align="right" valign="top">void&#160;</td><td class="memItemRight" 
valign="bottom"><a class="el" 
href="data__preparation_8sql__in.html#a05dbb30d8dd8589e75a96b3232cafe65">create_indicator_variables</a>
 (text source_table, text out_table, text categorical_cols, boolean 
keep_null)</td></tr>
+<tr class="memdesc:a05dbb30d8dd8589e75a96b3232cafe65"><td 
class="mdescLeft">&#160;</td><td class="mdescRight">Create new table containing 
dummy coded variables for categorical variables.  <a 
href="#a05dbb30d8dd8589e75a96b3232cafe65">More...</a><br /></td></tr>
+<tr class="separator:a05dbb30d8dd8589e75a96b3232cafe65"><td 
class="memSeparator" colspan="2">&#160;</td></tr>
+<tr class="memitem:a617b67999ab8c9c07fb0d24101a1115d"><td class="memItemLeft" 
align="right" valign="top">void&#160;</td><td class="memItemRight" 
valign="bottom"><a class="el" 
href="data__preparation_8sql__in.html#a617b67999ab8c9c07fb0d24101a1115d">create_indicator_variables</a>
 (text source_table, text out_table, text categorical_cols)</td></tr>
+<tr class="separator:a617b67999ab8c9c07fb0d24101a1115d"><td 
class="memSeparator" colspan="2">&#160;</td></tr>
+<tr class="memitem:a839b64f47a11a35c5df24ee93e36ba26"><td class="memItemLeft" 
align="right" valign="top">varchar&#160;</td><td class="memItemRight" 
valign="bottom"><a class="el" 
href="data__preparation_8sql__in.html#a839b64f47a11a35c5df24ee93e36ba26">create_indicator_variables</a>
 (varchar message)</td></tr>
+<tr class="separator:a839b64f47a11a35c5df24ee93e36ba26"><td 
class="memSeparator" colspan="2">&#160;</td></tr>
+<tr class="memitem:a5d0ef27bc38be2b4b5f063cf7b560d1f"><td class="memItemLeft" 
align="right" valign="top">varchar&#160;</td><td class="memItemRight" 
valign="bottom"><a class="el" 
href="data__preparation_8sql__in.html#a5d0ef27bc38be2b4b5f063cf7b560d1f">create_indicator_variables</a>
 ()</td></tr>
+<tr class="separator:a5d0ef27bc38be2b4b5f063cf7b560d1f"><td 
class="memSeparator" colspan="2">&#160;</td></tr>
+</table>
+<a name="details" id="details"></a><h2 class="groupheader">Detailed 
Description</h2>
+<div class="textblock"><dl class="section date"><dt>Date</dt><dd>June 
2014</dd></dl>
+<dl class="section see"><dt>See also</dt><dd>Calculates dummy-coded indicator 
variables for categorical variables </dd></dl>
+</div><h2 class="groupheader">Function Documentation</h2>
+<a class="anchor" id="a0add50a6ab76682bde7825fc54f4d64b"></a>
+<div class="memitem">
+<div class="memproto">
+      <table class="memname">
+        <tr>
+          <td class="memname">void create_indicator_variables </td>
+          <td>(</td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>source_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>out_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>categorical_cols</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">boolean&#160;</td>
+          <td class="paramname"><em>keep_null</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>distributed_by</em>&#160;</td>
+        </tr>
+        <tr>
+          <td></td>
+          <td>)</td>
+          <td></td><td></td>
+        </tr>
+      </table>
+</div><div class="memdoc">
+<dl class="params"><dt>Parameters</dt><dd>
+  <table class="params">
+    <tr><td class="paramname">source_table</td><td>Name of table containing 
categorical variable </td></tr>
+    <tr><td class="paramname">out_table</td><td>Name of table to output dummy 
variables </td></tr>
+    <tr><td class="paramname">categorical_cols</td><td>Comma-separated list of 
column names to dummy code </td></tr>
+    <tr><td class="paramname">keep_null</td><td>Boolean to determine the 
behavior for rows with NULL value </td></tr>
+    <tr><td class="paramname">distributed_by</td><td>Comma-separated list of 
column names to use for distribution of output</td></tr>
+  </table>
+  </dd>
+</dl>
+<dl class="section return"><dt>Returns</dt><dd>Void </dd></dl>
+
+</div>
+</div>
+<a class="anchor" id="a05dbb30d8dd8589e75a96b3232cafe65"></a>
+<div class="memitem">
+<div class="memproto">
+      <table class="memname">
+        <tr>
+          <td class="memname">void create_indicator_variables </td>
+          <td>(</td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>source_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>out_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>categorical_cols</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">boolean&#160;</td>
+          <td class="paramname"><em>keep_null</em>&#160;</td>
+        </tr>
+        <tr>
+          <td></td>
+          <td>)</td>
+          <td></td><td></td>
+        </tr>
+      </table>
+</div><div class="memdoc">
+<dl class="params"><dt>Parameters</dt><dd>
+  <table class="params">
+    <tr><td class="paramname">source_table</td><td>Name of table containing 
categorical variable </td></tr>
+    <tr><td class="paramname">out_table</td><td>Name of table to output dummy 
variables </td></tr>
+    <tr><td class="paramname">categorical_cols</td><td>Comma-separated list of 
column names to dummy code </td></tr>
+    <tr><td class="paramname">keep_null</td><td>Boolean to determine the 
behavior for rows with NULL value</td></tr>
+  </table>
+  </dd>
+</dl>
+<dl class="section return"><dt>Returns</dt><dd>Void </dd></dl>
+
+</div>
+</div>
+<a class="anchor" id="a617b67999ab8c9c07fb0d24101a1115d"></a>
+<div class="memitem">
+<div class="memproto">
+      <table class="memname">
+        <tr>
+          <td class="memname">void create_indicator_variables </td>
+          <td>(</td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>source_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>out_table</em>, </td>
+        </tr>
+        <tr>
+          <td class="paramkey"></td>
+          <td></td>
+          <td class="paramtype">text&#160;</td>
+          <td class="paramname"><em>categorical_cols</em>&#160;</td>
+        </tr>
+        <tr>
+          <td></td>
+          <td>)</td>
+          <td></td><td></td>
+        </tr>
+      </table>
+</div><div class="memdoc">
+
+</div>
+</div>
+<a class="anchor" id="a839b64f47a11a35c5df24ee93e36ba26"></a>
+<div class="memitem">
+<div class="memproto">
+      <table class="memname">
+        <tr>
+          <td class="memname">varchar create_indicator_variables </td>
+          <td>(</td>
+          <td class="paramtype">varchar&#160;</td>
+          <td class="paramname"><em>message</em></td><td>)</td>
+          <td></td>
+        </tr>
+      </table>
+</div><div class="memdoc">
+
+</div>
+</div>
+<a class="anchor" id="a5d0ef27bc38be2b4b5f063cf7b560d1f"></a>
+<div class="memitem">
+<div class="memproto">
+      <table class="memname">
+        <tr>
+          <td class="memname">varchar create_indicator_variables </td>
+          <td>(</td>
+          <td class="paramname"></td><td>)</td>
+          <td></td>
+        </tr>
+      </table>
+</div><div class="memdoc">
+
+</div>
+</div>
+</div><!-- contents -->
+</div><!-- doc-content -->
+<!-- start footer part -->
+<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
+  <ul>
+    <li class="navelem"><a class="el" 
href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li 
class="navelem"><a class="el" 
href="dir_efbcf68973d247bbf15f9eecae7f24e3.html">ports</a></li><li 
class="navelem"><a class="el" 
href="dir_a4a48839224ef8488facbffa8a397967.html">postgres</a></li><li 
class="navelem"><a class="el" 
href="dir_dc596537ad427a4d866006d1a3e1fe29.html">modules</a></li><li 
class="navelem"><a class="el" 
href="dir_8d53e1c0026e7e34b4cd68f8b91426d6.html">utilities</a></li><li 
class="navelem"><a class="el" 
href="data__preparation_8sql__in.html">data_preparation.sql_in</a></li>
+    <li class="footer">Generated on Tue Sep 20 2016 11:27:01 for MADlib by
+    <a href="http://www.doxygen.org/index.html";>
+    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.10 </li>
+  </ul>
+</div>
+</body>
+</html>

Reply via email to