blob: 07c13f1749eaa2794fe8a7c9f22b9c1a23ce1639 [file] [log] [blame]
<!-- 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: table_to_pmml.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</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('table__to__pmml_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">table_to_pmml.sql_in File Reference</div> </div>
</div><!--header-->
<div class="contents">
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:a9635b6989d9f972497b6b4164b77aa0a"><td class="memItemLeft" align="right" valign="top">xml&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="table__to__pmml_8sql__in.html#a9635b6989d9f972497b6b4164b77aa0a">pmml</a> (varchar model_table)</td></tr>
<tr class="memdesc:a9635b6989d9f972497b6b4164b77aa0a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Given the model constructed from a data mining algorithm, this function converts the model into PMML format. <a href="#a9635b6989d9f972497b6b4164b77aa0a">More...</a><br /></td></tr>
<tr class="separator:a9635b6989d9f972497b6b4164b77aa0a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7e2c2a3746b6e2c68f9886ca2b8b7e09"><td class="memItemLeft" align="right" valign="top">xml&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="table__to__pmml_8sql__in.html#a7e2c2a3746b6e2c68f9886ca2b8b7e09">pmml</a> (varchar model_table, varchar name_spec)</td></tr>
<tr class="memdesc:a7e2c2a3746b6e2c68f9886ca2b8b7e09"><td class="mdescLeft">&#160;</td><td class="mdescRight">Given the model constructed from a data mining algorithm, this function converts the model into PMML format. <a href="#a7e2c2a3746b6e2c68f9886ca2b8b7e09">More...</a><br /></td></tr>
<tr class="separator:a7e2c2a3746b6e2c68f9886ca2b8b7e09"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4aa7db5ec62506546dcbe178f6dcf262"><td class="memItemLeft" align="right" valign="top">xml&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="table__to__pmml_8sql__in.html#a4aa7db5ec62506546dcbe178f6dcf262">pmml</a> (varchar model_table, varchar[] name_spec)</td></tr>
<tr class="memdesc:a4aa7db5ec62506546dcbe178f6dcf262"><td class="mdescLeft">&#160;</td><td class="mdescRight">Given the model constructed from a data mining algorithm, this function converts the model into PMML format. <a href="#a4aa7db5ec62506546dcbe178f6dcf262">More...</a><br /></td></tr>
<tr class="separator:a4aa7db5ec62506546dcbe178f6dcf262"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3aa36483b5dd5af46f9b564397822817"><td class="memItemLeft" align="right" valign="top">text&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="table__to__pmml_8sql__in.html#a3aa36483b5dd5af46f9b564397822817">pmml</a> ()</td></tr>
<tr class="separator:a3aa36483b5dd5af46f9b564397822817"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Function Documentation</h2>
<a class="anchor" id="a9635b6989d9f972497b6b4164b77aa0a"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">xml pmml </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>model_table</em></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">model_table</td><td>Model table that contains the output of a training algorithm.</td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An XML document corresponding to the PMML of the input model.</dd></dl>
<p>The names in the Data Dictionary are generated based on the names used in the model table. If the fields are represented as an array of expressions without array concatenation, the names in the Data Dictionary will match the source table, except that a suffix '_pmml_prediction' is added to the predicted variable. If the field is an array of FLOAT8 values, the names in the Data Dictionary will be indexed using the array name, like 'ind[1]', 'ind[2]', etc. In all other cases, the names will simply be 'x[1]', 'x[2]', and so on. </p>
</div>
</div>
<a class="anchor" id="a7e2c2a3746b6e2c68f9886ca2b8b7e09"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">xml pmml </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>model_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>name_spec</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">model_table</td><td>Model table that contains the output of a training algorithm. </td></tr>
<tr><td class="paramname">name_spec</td><td>Names to be used in the Data Dictionary, given as a string containing an expression such as 'y ~ x1 + x2 + x3'.</td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An XML document corresponding to the PMML of the input model. </dd></dl>
</div>
</div>
<a class="anchor" id="a4aa7db5ec62506546dcbe178f6dcf262"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">xml pmml </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>model_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar[]&#160;</td>
<td class="paramname"><em>name_spec</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">model_table</td><td>Model table that contains the output of a training algorithm. </td></tr>
<tr><td class="paramname">name_spec</td><td>Names to be used in the Data Dictionary given as an array of strings, such as ARRAY['y', 'x1', 'x2', ...].</td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An XML document corresponding to the PMML of the input model. </dd></dl>
</div>
</div>
<a class="anchor" id="a3aa36483b5dd5af46f9b564397822817"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">text pmml </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_d06d449079888c21a85aa00b7664e813.html">pmml</a></li><li class="navelem"><a class="el" href="table__to__pmml_8sql__in.html">table_to_pmml.sql_in</a></li>
<li class="footer">Generated on Thu Apr 7 2016 14:24:10 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>