You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@madlib.apache.org by xt...@apache.org on 2016/09/20 18:31:37 UTC
[25/51] [partial] incubator-madlib-site git commit: Update doc for
1.9.1 release
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 </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"> </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"> </td></tr>
+<tr class="memitem:a05dbb30d8dd8589e75a96b3232cafe65"><td class="memItemLeft" align="right" valign="top">void </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"> </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"> </td></tr>
+<tr class="memitem:a617b67999ab8c9c07fb0d24101a1115d"><td class="memItemLeft" align="right" valign="top">void </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"> </td></tr>
+<tr class="memitem:a839b64f47a11a35c5df24ee93e36ba26"><td class="memItemLeft" align="right" valign="top">varchar </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"> </td></tr>
+<tr class="memitem:a5d0ef27bc38be2b4b5f063cf7b560d1f"><td class="memItemLeft" align="right" valign="top">varchar </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"> </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 </td>
+ <td class="paramname"><em>source_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>out_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>categorical_cols</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">boolean </td>
+ <td class="paramname"><em>keep_null</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>distributed_by</em> </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 </td>
+ <td class="paramname"><em>source_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>out_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>categorical_cols</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">boolean </td>
+ <td class="paramname"><em>keep_null</em> </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 </td>
+ <td class="paramname"><em>source_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>out_table</em>, </td>
+ </tr>
+ <tr>
+ <td class="paramkey"></td>
+ <td></td>
+ <td class="paramtype">text </td>
+ <td class="paramname"><em>categorical_cols</em> </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 </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>