| <!-- 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.13"/> |
| <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: svec_util.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); |
| </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> |
| <script type="text/x-mathjax-config"> |
| MathJax.Hub.Config({ |
| extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"], |
| jax: ["input/TeX","output/HTML-CSS"], |
| }); |
| </script><script type="text/javascript" src="http://cdn.mathjax.org/mathjax/latest/MathJax.js"></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.apache.org'); |
| 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.apache.org"><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.20.0</span> |
| </div> |
| <div id="projectbrief">User Documentation for Apache 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.13 --> |
| <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('svec__util_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">svec_util.sql_in File Reference</div> </div> |
| </div><!--header--> |
| <div class="contents"> |
| |
| <p>SQL utility functions for sparse vector data type <code>svec</code> |
| <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:a1f3669297bdf0fec501894d0652ec848"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a1f3669297bdf0fec501894d0652ec848">__gen_svec</a> (bigint[], float8[], bigint)</td></tr> |
| <tr class="separator:a1f3669297bdf0fec501894d0652ec848"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a6136c83e9c419d783d1ec6db061f8d6e"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a6136c83e9c419d783d1ec6db061f8d6e">gen_doc_svecs</a> (text output_tbl, text dictionary_tbl, text dict_id_col, text dict_term_col, text documents_tbl, text doc_id_col, text doc_term_col, text doc_term_info_col)</td></tr> |
| <tr class="separator:a6136c83e9c419d783d1ec6db061f8d6e"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a0c8cd9f0be54a6e739f9ec0bdcbe2d8d"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a0c8cd9f0be54a6e739f9ec0bdcbe2d8d">gen_doc_svecs</a> ()</td></tr> |
| <tr class="separator:a0c8cd9f0be54a6e739f9ec0bdcbe2d8d"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ad1011a13839994adbb1eb3e643c9074d"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ad1011a13839994adbb1eb3e643c9074d">svec_dmin</a> (float8, float8)</td></tr> |
| <tr class="separator:ad1011a13839994adbb1eb3e643c9074d"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:aa05abd8cb32253c07c0f2224861256a5"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#aa05abd8cb32253c07c0f2224861256a5">svec_dmax</a> (float8, float8)</td></tr> |
| <tr class="separator:aa05abd8cb32253c07c0f2224861256a5"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a6a21e25d3f50053c888a0bd126f831f0"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a6a21e25d3f50053c888a0bd126f831f0">svec_count</a> (svec, svec)</td></tr> |
| <tr class="separator:a6a21e25d3f50053c888a0bd126f831f0"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:aab641f9db3deed5bbfa7e050c531e9c1"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#aab641f9db3deed5bbfa7e050c531e9c1">svec_log</a> (svec)</td></tr> |
| <tr class="memdesc:aab641f9db3deed5bbfa7e050c531e9c1"><td class="mdescLeft"> </td><td class="mdescRight">Computes the logarithm of each element of the input SVEC. <a href="#aab641f9db3deed5bbfa7e050c531e9c1">More...</a><br /></td></tr> |
| <tr class="separator:aab641f9db3deed5bbfa7e050c531e9c1"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ab3a1cccd709379973f100e5eb35559d2"><td class="memItemLeft" align="right" valign="top">boolean </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ab3a1cccd709379973f100e5eb35559d2">svec_eq_non_zero</a> (svec, svec)</td></tr> |
| <tr class="separator:ab3a1cccd709379973f100e5eb35559d2"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:afdef1c6bf65ffc0e838cf10f33ae5557"><td class="memItemLeft" align="right" valign="top">boolean </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#afdef1c6bf65ffc0e838cf10f33ae5557">svec_contains</a> (svec, svec)</td></tr> |
| <tr class="separator:afdef1c6bf65ffc0e838cf10f33ae5557"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a475f0f3e4602e8278b582e099fce2487"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a475f0f3e4602e8278b582e099fce2487">svec_l2norm</a> (svec)</td></tr> |
| <tr class="separator:a475f0f3e4602e8278b582e099fce2487"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a536fbd3c596af5ea8ddfa2a3ca3e141c"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a536fbd3c596af5ea8ddfa2a3ca3e141c">svec_l2norm</a> (float8[])</td></tr> |
| <tr class="separator:a536fbd3c596af5ea8ddfa2a3ca3e141c"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a1b6bb42a5176b020aed12734df23aca9"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a1b6bb42a5176b020aed12734df23aca9">l2norm</a> (svec, svec)</td></tr> |
| <tr class="separator:a1b6bb42a5176b020aed12734df23aca9"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a9e9b64c93b29c19adfb670f0171f14bf"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a9e9b64c93b29c19adfb670f0171f14bf">l1norm</a> (svec, svec)</td></tr> |
| <tr class="separator:a9e9b64c93b29c19adfb670f0171f14bf"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ae60f7aaa5710c765d08b6c3906e0c9f0"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ae60f7aaa5710c765d08b6c3906e0c9f0">svec_l1norm</a> (svec)</td></tr> |
| <tr class="separator:ae60f7aaa5710c765d08b6c3906e0c9f0"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ae5ac6f098519439b76e03091022c9508"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ae5ac6f098519439b76e03091022c9508">svec_l1norm</a> (float8[])</td></tr> |
| <tr class="separator:ae5ac6f098519439b76e03091022c9508"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a7e395ee71f6cf05afa76d89a72d45bec"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a7e395ee71f6cf05afa76d89a72d45bec">angle</a> (svec, svec)</td></tr> |
| <tr class="separator:a7e395ee71f6cf05afa76d89a72d45bec"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a98222e58bc519865a26643a61611b717"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a98222e58bc519865a26643a61611b717">tanimoto_distance</a> (svec, svec)</td></tr> |
| <tr class="separator:a98222e58bc519865a26643a61611b717"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a87b45a983da4066fa7f35b17ccecf699"><td class="memItemLeft" align="right" valign="top">set< float8 > </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a87b45a983da4066fa7f35b17ccecf699">svec_unnest</a> (svec)</td></tr> |
| <tr class="separator:a87b45a983da4066fa7f35b17ccecf699"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a929bde3bc91b67300d9d370b6a1495f1"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a929bde3bc91b67300d9d370b6a1495f1">svec_pivot</a> (svec, float8)</td></tr> |
| <tr class="separator:a929bde3bc91b67300d9d370b6a1495f1"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a00a7b3260b9fde9b55061e6bf58a028a"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a00a7b3260b9fde9b55061e6bf58a028a">svec_elsum</a> (svec)</td></tr> |
| <tr class="separator:a00a7b3260b9fde9b55061e6bf58a028a"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:afb2076f09f00e512a62c06d4d33e5922"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#afb2076f09f00e512a62c06d4d33e5922">svec_elsum</a> (float8[])</td></tr> |
| <tr class="separator:afb2076f09f00e512a62c06d4d33e5922"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a2284a118fe03465203ecea8c34acefa5"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a2284a118fe03465203ecea8c34acefa5">svec_median</a> (float8[])</td></tr> |
| <tr class="separator:a2284a118fe03465203ecea8c34acefa5"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:af9950e9ce4770738f2ce368d8124f142"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#af9950e9ce4770738f2ce368d8124f142">svec_median</a> (svec)</td></tr> |
| <tr class="separator:af9950e9ce4770738f2ce368d8124f142"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a5bc053a080fb38601ad91045dc3ffe74"><td class="memItemLeft" align="right" valign="top">int8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a5bc053a080fb38601ad91045dc3ffe74">svec_nonbase_positions</a> (svec, float8)</td></tr> |
| <tr class="separator:a5bc053a080fb38601ad91045dc3ffe74"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a076dcbc0a278bb3b5161b0db2ad8fa44"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a076dcbc0a278bb3b5161b0db2ad8fa44">svec_nonbase_values</a> (svec, float8)</td></tr> |
| <tr class="separator:a076dcbc0a278bb3b5161b0db2ad8fa44"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ab8d1acbe4e8551755fef217b506bed8a"><td class="memItemLeft" align="right" valign="top">integer </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ab8d1acbe4e8551755fef217b506bed8a">svec_dimension</a> (svec)</td></tr> |
| <tr class="separator:ab8d1acbe4e8551755fef217b506bed8a"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a0d94c44dde95a00e3d802dee6d7c01eb"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a0d94c44dde95a00e3d802dee6d7c01eb">svec_lapply</a> (text, svec)</td></tr> |
| <tr class="separator:a0d94c44dde95a00e3d802dee6d7c01eb"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a3950b17b103ceeddca520a0f0d097ddc"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a3950b17b103ceeddca520a0f0d097ddc">svec_append</a> (svec, float8, int8)</td></tr> |
| <tr class="separator:a3950b17b103ceeddca520a0f0d097ddc"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a8787222aec691f94d9808d1369aa401c"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a8787222aec691f94d9808d1369aa401c">svec_proj</a> (svec, int4)</td></tr> |
| <tr class="separator:a8787222aec691f94d9808d1369aa401c"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a5cb3446de5fc117befe88ccb1ebb0e4e"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a5cb3446de5fc117befe88ccb1ebb0e4e">svec_subvec</a> (svec, int4, int4)</td></tr> |
| <tr class="separator:a5cb3446de5fc117befe88ccb1ebb0e4e"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a4a221435ca91b6fa45114e689ee96010"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a4a221435ca91b6fa45114e689ee96010">svec_reverse</a> (svec)</td></tr> |
| <tr class="separator:a4a221435ca91b6fa45114e689ee96010"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a59407764a1cbf1937da39cf39a2f447c"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a59407764a1cbf1937da39cf39a2f447c">svec_change</a> (svec, int4, svec)</td></tr> |
| <tr class="separator:a59407764a1cbf1937da39cf39a2f447c"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a0bfa8f8d083282bc9e8caf6f03bb5251"><td class="memItemLeft" align="right" valign="top">int4 </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a0bfa8f8d083282bc9e8caf6f03bb5251">svec_hash</a> (svec)</td></tr> |
| <tr class="separator:a0bfa8f8d083282bc9e8caf6f03bb5251"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a375acd521ed9cb05f63b3696dcc10bf4"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a375acd521ed9cb05f63b3696dcc10bf4">svec_sfv</a> (text[], text[])</td></tr> |
| <tr class="separator:a375acd521ed9cb05f63b3696dcc10bf4"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a91c23a7ce58932f48f5ab3579ea0309e"><td class="memItemLeft" align="right" valign="top">text [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a91c23a7ce58932f48f5ab3579ea0309e">svec_sort</a> (text[])</td></tr> |
| <tr class="separator:a91c23a7ce58932f48f5ab3579ea0309e"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a1de746ebd23530e72ba4f031ac41d155"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a1de746ebd23530e72ba4f031ac41d155">svec_to_string</a> (svec)</td></tr> |
| <tr class="separator:a1de746ebd23530e72ba4f031ac41d155"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a1f5e8911574cf30cc979478040bd3262"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a1f5e8911574cf30cc979478040bd3262">svec_from_string</a> (text)</td></tr> |
| <tr class="separator:a1f5e8911574cf30cc979478040bd3262"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:afcf2f75cd00ab0ba269caf79dcfcc62c"><td class="memItemLeft" align="right" valign="top">float [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#afcf2f75cd00ab0ba269caf79dcfcc62c">svec_mean_transition</a> (float[], svec)</td></tr> |
| <tr class="separator:afcf2f75cd00ab0ba269caf79dcfcc62c"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ab161647a1498c85762779966790eab71"><td class="memItemLeft" align="right" valign="top">float [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ab161647a1498c85762779966790eab71">svec_mean_prefunc</a> (float[], float[])</td></tr> |
| <tr class="separator:ab161647a1498c85762779966790eab71"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:ac3fc45511b50b5d054bf7bbeb952b98d"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#ac3fc45511b50b5d054bf7bbeb952b98d">svec_mean_final</a> (float[])</td></tr> |
| <tr class="separator:ac3fc45511b50b5d054bf7bbeb952b98d"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a546b947319c9f48237120a31929bdfd9"><td class="memItemLeft" align="right" valign="top">aggregate float [] </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a546b947319c9f48237120a31929bdfd9">mean</a> (svec)</td></tr> |
| <tr class="separator:a546b947319c9f48237120a31929bdfd9"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:af1ce6cdd7244ac0832d15c65b7ccc782"><td class="memItemLeft" align="right" valign="top">aggregate svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#af1ce6cdd7244ac0832d15c65b7ccc782">svec_sum</a> (svec)</td></tr> |
| <tr class="separator:af1ce6cdd7244ac0832d15c65b7ccc782"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:abebdcbe45de346aff874db008e842e65"><td class="memItemLeft" align="right" valign="top">aggregate svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#abebdcbe45de346aff874db008e842e65">svec_count_nonzero</a> (svec)</td></tr> |
| <tr class="separator:abebdcbe45de346aff874db008e842e65"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a93400e39ecce2f11b9ceb08403420a43"><td class="memItemLeft" align="right" valign="top">aggregate svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#a93400e39ecce2f11b9ceb08403420a43">svec_median_inmemory</a> (float8)</td></tr> |
| <tr class="separator:a93400e39ecce2f11b9ceb08403420a43"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:aace16abea7c63f136520fde6c28f1f28"><td class="memItemLeft" align="right" valign="top">svec </td><td class="memItemRight" valign="bottom"><a class="el" href="svec__util_8sql__in.html#aace16abea7c63f136520fde6c28f1f28">normalize</a> (svec)</td></tr> |
| <tr class="separator:aace16abea7c63f136520fde6c28f1f28"><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 see"><dt>See also</dt><dd>For an introduction to the sparse vector implementation, see the module description <a class="el" href="group__grp__svec.html">Sparse Vectors</a>. </dd></dl> |
| </div><h2 class="groupheader">Function Documentation</h2> |
| <a id="a1f3669297bdf0fec501894d0652ec848"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a1f3669297bdf0fec501894d0652ec848">◆ </a></span>__gen_svec()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec __gen_svec </td> |
| <td>(</td> |
| <td class="paramtype">bigint </td> |
| <td class="paramname">[], </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">[], </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">bigint </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Creates sparse vector representation given an array of indexes, respective values and size of the required vector. The function just does the bucket filling with the values at the respective indexes for the vector given the length. </p> |
| |
| </div> |
| </div> |
| <a id="a7e395ee71f6cf05afa76d89a72d45bec"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a7e395ee71f6cf05afa76d89a72d45bec">◆ </a></span>angle()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 angle </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the angle between two SVECs in radians. </p> |
| |
| </div> |
| </div> |
| <a id="a6136c83e9c419d783d1ec6db061f8d6e"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a6136c83e9c419d783d1ec6db061f8d6e">◆ </a></span>gen_doc_svecs() <span class="overload">[1/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">text gen_doc_svecs </td> |
| <td>(</td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>output_tbl</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>dictionary_tbl</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>dict_id_col</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>dict_term_col</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>documents_tbl</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>doc_id_col</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>doc_term_col</em>, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname"><em>doc_term_info_col</em> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Creates the output table containing the sparse vector representation for the documents given the dictionary table, documents tables and names of the respective columns. </p> |
| |
| </div> |
| </div> |
| <a id="a0c8cd9f0be54a6e739f9ec0bdcbe2d8d"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a0c8cd9f0be54a6e739f9ec0bdcbe2d8d">◆ </a></span>gen_doc_svecs() <span class="overload">[2/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">text gen_doc_svecs </td> |
| <td>(</td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Helper function for madlib.gen_doc_svec UDF. </p> |
| |
| </div> |
| </div> |
| <a id="a9e9b64c93b29c19adfb670f0171f14bf"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a9e9b64c93b29c19adfb670f0171f14bf">◆ </a></span>l1norm()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 l1norm </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l1norm distance between two SVECs. </p> |
| |
| </div> |
| </div> |
| <a id="a1b6bb42a5176b020aed12734df23aca9"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a1b6bb42a5176b020aed12734df23aca9">◆ </a></span>l2norm()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 l2norm </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l2norm distance between two SVECs. </p> |
| |
| </div> |
| </div> |
| <a id="a546b947319c9f48237120a31929bdfd9"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a546b947319c9f48237120a31929bdfd9">◆ </a></span>mean()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">aggregate float [] mean </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Aggregate that computes the element-wise mean of a list of vectors. </p> |
| |
| </div> |
| </div> |
| <a id="aace16abea7c63f136520fde6c28f1f28"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#aace16abea7c63f136520fde6c28f1f28">◆ </a></span>normalize()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec normalize </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Normalizes an SVEC that is divides all elements by its norm/magnitude. </p> |
| |
| </div> |
| </div> |
| <a id="a3950b17b103ceeddca520a0f0d097ddc"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a3950b17b103ceeddca520a0f0d097ddc">◆ </a></span>svec_append()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_append </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">int8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Appends a run-length block to the back of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a59407764a1cbf1937da39cf39a2f447c"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a59407764a1cbf1937da39cf39a2f447c">◆ </a></span>svec_change()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_change </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">int4 </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Replaces the subvector of a given SVEC at a given start index with another SVEC. Note that element index should start at 1. </p> |
| |
| </div> |
| </div> |
| <a id="afdef1c6bf65ffc0e838cf10f33ae5557"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#afdef1c6bf65ffc0e838cf10f33ae5557">◆ </a></span>svec_contains()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">boolean svec_contains </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Returns true if left svec contains right one, meaning that every non-zero value in the right svec equals left one </p> |
| |
| </div> |
| </div> |
| <a id="a6a21e25d3f50053c888a0bd126f831f0"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a6a21e25d3f50053c888a0bd126f831f0">◆ </a></span>svec_count()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_count </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Counts the number of non-zero entries in the input vector; the second argument is capped at 1, then added to the first; used as the sfunc in the <a class="el" href="svec__util_8sql__in.html#abebdcbe45de346aff874db008e842e65">svec_count_nonzero()</a> aggregate below. </p> |
| |
| </div> |
| </div> |
| <a id="abebdcbe45de346aff874db008e842e65"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#abebdcbe45de346aff874db008e842e65">◆ </a></span>svec_count_nonzero()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">aggregate svec svec_count_nonzero </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Aggregate that provides a tally of nonzero entries in a list of vectors. </p> |
| |
| </div> |
| </div> |
| <a id="ab8d1acbe4e8551755fef217b506bed8a"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ab8d1acbe4e8551755fef217b506bed8a">◆ </a></span>svec_dimension()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">integer svec_dimension </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Returns the dimension of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="aa05abd8cb32253c07c0f2224861256a5"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#aa05abd8cb32253c07c0f2224861256a5">◆ </a></span>svec_dmax()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_dmax </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Basic floating point scalar operator: MAX. </p> |
| |
| </div> |
| </div> |
| <a id="ad1011a13839994adbb1eb3e643c9074d"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ad1011a13839994adbb1eb3e643c9074d">◆ </a></span>svec_dmin()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_dmin </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Basic floating point scalar operator: MIN. </p> |
| |
| </div> |
| </div> |
| <a id="a00a7b3260b9fde9b55061e6bf58a028a"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a00a7b3260b9fde9b55061e6bf58a028a">◆ </a></span>svec_elsum() <span class="overload">[1/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_elsum </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Sums the elements of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="afb2076f09f00e512a62c06d4d33e5922"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#afb2076f09f00e512a62c06d4d33e5922">◆ </a></span>svec_elsum() <span class="overload">[2/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_elsum </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Sums the elements of a float8 array. </p> |
| |
| </div> |
| </div> |
| <a id="ab3a1cccd709379973f100e5eb35559d2"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ab3a1cccd709379973f100e5eb35559d2">◆ </a></span>svec_eq_non_zero()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">boolean svec_eq_non_zero </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Returns true if two SVECs are equal, not counting zeros (zero equals anything). If the two SVECs are of different size, then the function essentially zero-pads the shorter one and performs the comparison. </p> |
| |
| </div> |
| </div> |
| <a id="a1f5e8911574cf30cc979478040bd3262"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a1f5e8911574cf30cc979478040bd3262">◆ </a></span>svec_from_string()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_from_string </td> |
| <td>(</td> |
| <td class="paramtype">text </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Converts a text string to an svec </p> |
| |
| </div> |
| </div> |
| <a id="a0bfa8f8d083282bc9e8caf6f03bb5251"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a0bfa8f8d083282bc9e8caf6f03bb5251">◆ </a></span>svec_hash()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">int4 svec_hash </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the hash of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="ae60f7aaa5710c765d08b6c3906e0c9f0"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ae60f7aaa5710c765d08b6c3906e0c9f0">◆ </a></span>svec_l1norm() <span class="overload">[1/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_l1norm </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l1norm of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="ae5ac6f098519439b76e03091022c9508"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ae5ac6f098519439b76e03091022c9508">◆ </a></span>svec_l1norm() <span class="overload">[2/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_l1norm </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l1norm of a float8 array. </p> |
| |
| </div> |
| </div> |
| <a id="a475f0f3e4602e8278b582e099fce2487"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a475f0f3e4602e8278b582e099fce2487">◆ </a></span>svec_l2norm() <span class="overload">[1/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_l2norm </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l2norm of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a536fbd3c596af5ea8ddfa2a3ca3e141c"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a536fbd3c596af5ea8ddfa2a3ca3e141c">◆ </a></span>svec_l2norm() <span class="overload">[2/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_l2norm </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the l2norm of a float8 array. </p> |
| |
| </div> |
| </div> |
| <a id="a0d94c44dde95a00e3d802dee6d7c01eb"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a0d94c44dde95a00e3d802dee6d7c01eb">◆ </a></span>svec_lapply()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_lapply </td> |
| <td>(</td> |
| <td class="paramtype">text </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Applies a given function to each element of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="aab641f9db3deed5bbfa7e050c531e9c1"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#aab641f9db3deed5bbfa7e050c531e9c1">◆ </a></span>svec_log()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_log </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| |
| </div> |
| </div> |
| <a id="ac3fc45511b50b5d054bf7bbeb952b98d"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ac3fc45511b50b5d054bf7bbeb952b98d">◆ </a></span>svec_mean_final()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_mean_final </td> |
| <td>(</td> |
| <td class="paramtype">float </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Final function for <a class="el" href="svec__util_8sql__in.html#a546b947319c9f48237120a31929bdfd9">mean(svec)</a> aggregate </p> |
| |
| </div> |
| </div> |
| <a id="ab161647a1498c85762779966790eab71"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#ab161647a1498c85762779966790eab71">◆ </a></span>svec_mean_prefunc()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float [] svec_mean_prefunc </td> |
| <td>(</td> |
| <td class="paramtype">float </td> |
| <td class="paramname">[], </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float </td> |
| <td class="paramname">[] </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Preliminary merge function for <a class="el" href="svec__util_8sql__in.html#a546b947319c9f48237120a31929bdfd9">mean(svec)</a> aggregate </p> |
| |
| </div> |
| </div> |
| <a id="afcf2f75cd00ab0ba269caf79dcfcc62c"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#afcf2f75cd00ab0ba269caf79dcfcc62c">◆ </a></span>svec_mean_transition()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float [] svec_mean_transition </td> |
| <td>(</td> |
| <td class="paramtype">float </td> |
| <td class="paramname">[], </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Transition function for <a class="el" href="svec__util_8sql__in.html#a546b947319c9f48237120a31929bdfd9">mean(svec)</a> aggregate </p> |
| |
| </div> |
| </div> |
| <a id="a2284a118fe03465203ecea8c34acefa5"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a2284a118fe03465203ecea8c34acefa5">◆ </a></span>svec_median() <span class="overload">[1/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_median </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the median element of a float8 array. </p> |
| |
| </div> |
| </div> |
| <a id="af9950e9ce4770738f2ce368d8124f142"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#af9950e9ce4770738f2ce368d8124f142">◆ </a></span>svec_median() <span class="overload">[2/2]</span></h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_median </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the median element of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a93400e39ecce2f11b9ceb08403420a43"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a93400e39ecce2f11b9ceb08403420a43">◆ </a></span>svec_median_inmemory()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">aggregate svec svec_median_inmemory </td> |
| <td>(</td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Aggregate that turns a list of float8 values into an SVEC.Aggregate that computes the median element of a list of float8 values. </p> |
| |
| </div> |
| </div> |
| <a id="a5bc053a080fb38601ad91045dc3ffe74"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a5bc053a080fb38601ad91045dc3ffe74">◆ </a></span>svec_nonbase_positions()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">int8 [] svec_nonbase_positions </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Compares an SVEC to a float8, and returns positions of all elements not equal to the float as an array. Element index here starts at 0. </p> |
| |
| </div> |
| </div> |
| <a id="a076dcbc0a278bb3b5161b0db2ad8fa44"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a076dcbc0a278bb3b5161b0db2ad8fa44">◆ </a></span>svec_nonbase_values()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 [] svec_nonbase_values </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Compares an SVEC to a float8, and returns values of all elements not equal to the float as an array. </p> |
| |
| </div> |
| </div> |
| <a id="a929bde3bc91b67300d9d370b6a1495f1"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a929bde3bc91b67300d9d370b6a1495f1">◆ </a></span>svec_pivot()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_pivot </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">float8 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Appends an element to the back of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a8787222aec691f94d9808d1369aa401c"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a8787222aec691f94d9808d1369aa401c">◆ </a></span>svec_proj()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 svec_proj </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">int4 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Projects onto an element of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a4a221435ca91b6fa45114e689ee96010"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a4a221435ca91b6fa45114e689ee96010">◆ </a></span>svec_reverse()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_reverse </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Reverses the elements of an SVEC. </p> |
| |
| </div> |
| </div> |
| <a id="a375acd521ed9cb05f63b3696dcc10bf4"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a375acd521ed9cb05f63b3696dcc10bf4">◆ </a></span>svec_sfv()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_sfv </td> |
| <td>(</td> |
| <td class="paramtype">text </td> |
| <td class="paramname">[], </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">text </td> |
| <td class="paramname">[] </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the word-occurence vector of a document </p> |
| |
| </div> |
| </div> |
| <a id="a91c23a7ce58932f48f5ab3579ea0309e"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a91c23a7ce58932f48f5ab3579ea0309e">◆ </a></span>svec_sort()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">text [] svec_sort </td> |
| <td>(</td> |
| <td class="paramtype">text </td> |
| <td class="paramname">[]</td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Sorts an array of texts. This function should be in MADlib common. </p> |
| |
| </div> |
| </div> |
| <a id="a5cb3446de5fc117befe88ccb1ebb0e4e"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a5cb3446de5fc117befe88ccb1ebb0e4e">◆ </a></span>svec_subvec()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">svec svec_subvec </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">int4 </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">int4 </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Extracts a subvector of an SVEC given the subvector's start and end indices. </p> |
| |
| </div> |
| </div> |
| <a id="af1ce6cdd7244ac0832d15c65b7ccc782"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#af1ce6cdd7244ac0832d15c65b7ccc782">◆ </a></span>svec_sum()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">aggregate svec svec_sum </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Aggregate that provides the element-wise sum of a list of vectors. </p> |
| |
| </div> |
| </div> |
| <a id="a1de746ebd23530e72ba4f031ac41d155"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a1de746ebd23530e72ba4f031ac41d155">◆ </a></span>svec_to_string()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">text svec_to_string </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Converts an svec to a text string </p> |
| |
| </div> |
| </div> |
| <a id="a87b45a983da4066fa7f35b17ccecf699"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a87b45a983da4066fa7f35b17ccecf699">◆ </a></span>svec_unnest()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">set<float8> svec_unnest </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"></td><td>)</td> |
| <td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Unnests an SVEC into a table of uncompressed values </p> |
| |
| </div> |
| </div> |
| <a id="a98222e58bc519865a26643a61611b717"></a> |
| <h2 class="memtitle"><span class="permalink"><a href="#a98222e58bc519865a26643a61611b717">◆ </a></span>tanimoto_distance()</h2> |
| |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 tanimoto_distance </td> |
| <td>(</td> |
| <td class="paramtype">svec </td> |
| <td class="paramname">, </td> |
| </tr> |
| <tr> |
| <td class="paramkey"></td> |
| <td></td> |
| <td class="paramtype">svec </td> |
| <td class="paramname"> </td> |
| </tr> |
| <tr> |
| <td></td> |
| <td>)</td> |
| <td></td><td></td> |
| </tr> |
| </table> |
| </div><div class="memdoc"> |
| <p>Computes the Tanimoto distance between two SVECs. </p> |
| |
| </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_704eb8350b43e1ca74c0f90ed1ba450e.html">methods</a></li><li class="navelem"><a class="el" href="dir_097d0c47873b413f914e0be0fb8e0c70.html">svec_util</a></li><li class="navelem"><a class="el" href="dir_4f54709f5fc5d0f64da91428555e2469.html">src</a></li><li class="navelem"><a class="el" href="dir_2e2767a73e2d710192c730fd426a8c90.html">pg_gp</a></li><li class="navelem"><a class="el" href="svec__util_8sql__in.html">svec_util.sql_in</a></li> |
| <li class="footer">Generated on Tue Jul 19 2022 12:19:23 for MADlib by |
| <a href="http://www.doxygen.org/index.html"> |
| <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.13 </li> |
| </ul> |
| </div> |
| </body> |
| </html> |
