| <!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.6"/> |
| <title>Impala: fe/src/test/java/com/cloudera/impala/analysis/AnalyzeSubqueriesTest.java Source File</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="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/search.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(function() { searchBox.OnSelectItem(0); }); |
| </script> |
| <link href="doxygen.css" rel="stylesheet" type="text/css" /> |
| </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 style="padding-left: 0.5em;"> |
| <div id="projectname">Impala |
| </div> |
| <div id="projectbrief">Impalaistheopensource,nativeanalyticdatabaseforApacheHadoop.</div> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| <!-- end header part --> |
| <!-- Generated by Doxygen 1.8.6 --> |
| <script type="text/javascript"> |
| var searchBox = new SearchBox("searchBox", "search",false,'Search'); |
| </script> |
| <div id="navrow1" class="tabs"> |
| <ul class="tablist"> |
| <li><a href="index.html"><span>Main Page</span></a></li> |
| <li><a href="namespaces.html"><span>Namespaces</span></a></li> |
| <li><a href="annotated.html"><span>Classes</span></a></li> |
| <li class="current"><a href="files.html"><span>Files</span></a></li> |
| <li> |
| <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> |
| </li> |
| </ul> |
| </div> |
| <div id="navrow2" class="tabs2"> |
| <ul class="tablist"> |
| <li><a href="files.html"><span>File List</span></a></li> |
| <li><a href="globals.html"><span>File Members</span></a></li> |
| </ul> |
| </div> |
| </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('AnalyzeSubqueriesTest_8java_source.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)"> |
| <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark"> </span>Friends</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(10)"><span class="SelectionMark"> </span>Macros</a></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="headertitle"> |
| <div class="title">AnalyzeSubqueriesTest.java</div> </div> |
| </div><!--header--> |
| <div class="contents"> |
| <a href="AnalyzeSubqueriesTest_8java.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"> 1</span> <span class="comment">// Copyright (c) 2014 Cloudera, Inc. All rights reserved.</span></div> |
| <div class="line"><a name="l00002"></a><span class="lineno"> 2</span> <span class="comment">//</span></div> |
| <div class="line"><a name="l00003"></a><span class="lineno"> 3</span> <span class="comment">// Licensed under the Apache License, Version 2.0 (the "License");</span></div> |
| <div class="line"><a name="l00004"></a><span class="lineno"> 4</span> <span class="comment">// you may not use this file except in compliance with the License.</span></div> |
| <div class="line"><a name="l00005"></a><span class="lineno"> 5</span> <span class="comment">// You may obtain a copy of the License at</span></div> |
| <div class="line"><a name="l00006"></a><span class="lineno"> 6</span> <span class="comment">//</span></div> |
| <div class="line"><a name="l00007"></a><span class="lineno"> 7</span> <span class="comment">// http://www.apache.org/licenses/LICENSE-2.0</span></div> |
| <div class="line"><a name="l00008"></a><span class="lineno"> 8</span> <span class="comment">//</span></div> |
| <div class="line"><a name="l00009"></a><span class="lineno"> 9</span> <span class="comment">// Unless required by applicable law or agreed to in writing, software</span></div> |
| <div class="line"><a name="l00010"></a><span class="lineno"> 10</span> <span class="comment">// distributed under the License is distributed on an "AS IS" BASIS,</span></div> |
| <div class="line"><a name="l00011"></a><span class="lineno"> 11</span> <span class="comment">// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</span></div> |
| <div class="line"><a name="l00012"></a><span class="lineno"> 12</span> <span class="comment">// See the License for the specific language governing permissions and</span></div> |
| <div class="line"><a name="l00013"></a><span class="lineno"> 13</span> <span class="comment">// limitations under the License.</span></div> |
| <div class="line"><a name="l00014"></a><span class="lineno"> 14</span> </div> |
| <div class="line"><a name="l00015"></a><span class="lineno"> 15</span> <span class="keyword">package </span>com.cloudera.impala.analysis;</div> |
| <div class="line"><a name="l00016"></a><span class="lineno"> 16</span> </div> |
| <div class="line"><a name="l00017"></a><span class="lineno"> 17</span> <span class="keyword">import</span> <a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">org.junit.Test</a>;</div> |
| <div class="line"><a name="l00018"></a><span class="lineno"> 18</span> </div> |
| <div class="line"><a name="l00019"></a><span class="lineno"> 19</span> <span class="keyword">import</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html">com.cloudera.impala.catalog.Type</a>;</div> |
| <div class="line"><a name="l00020"></a><span class="lineno"> 20</span> <span class="keyword">import</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">com.cloudera.impala.common.AnalysisException</a>;</div> |
| <div class="line"><a name="l00021"></a><span class="lineno"> 21</span> </div> |
| <div class="line"><a name="l00022"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html"> 22</a></span> <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html">AnalyzeSubqueriesTest</a> <span class="keyword">extends</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html">AnalyzerTest</a> {</div> |
| <div class="line"><a name="l00023"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12"> 23</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> String <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12">cmpOperators</a>[] = {<span class="stringliteral">"="</span>, <span class="stringliteral">"!="</span>, <span class="stringliteral">"<="</span>, <span class="stringliteral">">="</span>, <span class="stringliteral">">"</span>, <span class="stringliteral">"<"</span>};</div> |
| <div class="line"><a name="l00024"></a><span class="lineno"> 24</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00025"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a31554d96cb3441a182589eca29955ab1"> 25</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a31554d96cb3441a182589eca29955ab1">TestInSubqueries</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00026"></a><span class="lineno"> 26</span>  String colNames[] = {<span class="stringliteral">"bool_col"</span>, <span class="stringliteral">"tinyint_col"</span>, <span class="stringliteral">"smallint_col"</span>, <span class="stringliteral">"int_col"</span>,</div> |
| <div class="line"><a name="l00027"></a><span class="lineno"> 27</span>  <span class="stringliteral">"bigint_col"</span>, <span class="stringliteral">"float_col"</span>, <span class="stringliteral">"double_col"</span>, <span class="stringliteral">"string_col"</span>, <span class="stringliteral">"date_string_col"</span>,</div> |
| <div class="line"><a name="l00028"></a><span class="lineno"> 28</span>  <span class="stringliteral">"timestamp_col"</span>};</div> |
| <div class="line"><a name="l00029"></a><span class="lineno"> 29</span>  String joinOperators[] = {<span class="stringliteral">"inner join"</span>, <span class="stringliteral">"left outer join"</span>, <span class="stringliteral">"right outer join"</span>,</div> |
| <div class="line"><a name="l00030"></a><span class="lineno"> 30</span>  <span class="stringliteral">"left semi join"</span>, <span class="stringliteral">"left anti join"</span>};</div> |
| <div class="line"><a name="l00031"></a><span class="lineno"> 31</span> </div> |
| <div class="line"><a name="l00032"></a><span class="lineno"> 32</span>  <span class="comment">// [NOT] IN subquery predicates</span></div> |
| <div class="line"><a name="l00033"></a><span class="lineno"> 33</span>  String operators[] = {<span class="stringliteral">"in"</span>, <span class="stringliteral">"not in"</span>};</div> |
| <div class="line"><a name="l00034"></a><span class="lineno"> 34</span>  <span class="keywordflow">for</span> (String op: operators) {</div> |
| <div class="line"><a name="l00035"></a><span class="lineno"> 35</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where id %s "</span> +</div> |
| <div class="line"><a name="l00036"></a><span class="lineno"> 36</span>  <span class="stringliteral">"(select id from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00037"></a><span class="lineno"> 37</span>  <span class="comment">// Using column and table aliases similar to the ones produced by the</span></div> |
| <div class="line"><a name="l00038"></a><span class="lineno"> 38</span>  <span class="comment">// column/table alias generators during a rewrite.</span></div> |
| <div class="line"><a name="l00039"></a><span class="lineno"> 39</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select id `$c$1` from functional.alltypestiny `$a$1` "</span> +</div> |
| <div class="line"><a name="l00040"></a><span class="lineno"> 40</span>  <span class="stringliteral">"where id %s (select id from functional.alltypessmall)"</span>, op));</div> |
| <div class="line"><a name="l00041"></a><span class="lineno"> 41</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00042"></a><span class="lineno"> 42</span>  <span class="stringliteral">"(select id from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00043"></a><span class="lineno"> 43</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00044"></a><span class="lineno"> 44</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a)"</span>, op));</div> |
| <div class="line"><a name="l00045"></a><span class="lineno"> 45</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00046"></a><span class="lineno"> 46</span>  <span class="stringliteral">"t.id %s (select id from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00047"></a><span class="lineno"> 47</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select t.id, max(t.int_col) from "</span> +</div> |
| <div class="line"><a name="l00048"></a><span class="lineno"> 48</span>  <span class="stringliteral">"functional.alltypes t where t.int_col %s (select int_col from "</span> +</div> |
| <div class="line"><a name="l00049"></a><span class="lineno"> 49</span>  <span class="stringliteral">"functional.alltypesagg) group by t.id having count(*) < 10"</span>, op));</div> |
| <div class="line"><a name="l00050"></a><span class="lineno"> 50</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select t.bigint_col, t.string_col from "</span> +</div> |
| <div class="line"><a name="l00051"></a><span class="lineno"> 51</span>  <span class="stringliteral">"functional.alltypes t where t.id %s (select id from "</span> +</div> |
| <div class="line"><a name="l00052"></a><span class="lineno"> 52</span>  <span class="stringliteral">"functional.alltypesagg where int_col < 10) order by bigint_col"</span>, op));</div> |
| <div class="line"><a name="l00053"></a><span class="lineno"> 53</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes a where a.id %s "</span> +</div> |
| <div class="line"><a name="l00054"></a><span class="lineno"> 54</span>  <span class="stringliteral">"(select id from functional.alltypes b where a.id = b.id)"</span>, op));</div> |
| <div class="line"><a name="l00055"></a><span class="lineno"> 55</span> </div> |
| <div class="line"><a name="l00056"></a><span class="lineno"> 56</span>  <span class="comment">// Complex expressions</span></div> |
| <div class="line"><a name="l00057"></a><span class="lineno"> 57</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00058"></a><span class="lineno"> 58</span>  <span class="stringliteral">"(select id + int_col from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00059"></a><span class="lineno"> 59</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00060"></a><span class="lineno"> 60</span>  <span class="stringliteral">"t.int_col + 1 %s (select int_col - 1 from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00061"></a><span class="lineno"> 61</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00062"></a><span class="lineno"> 62</span>  <span class="stringliteral">"abs(t.double_col) %s (select int_col from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00063"></a><span class="lineno"> 63</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select NULL from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00064"></a><span class="lineno"> 64</span>  <span class="stringliteral">"cast(t.double_col as int) %s (select int_col from "</span> +</div> |
| <div class="line"><a name="l00065"></a><span class="lineno"> 65</span>  <span class="stringliteral">"functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00066"></a><span class="lineno"> 66</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes where id %s "</span> +</div> |
| <div class="line"><a name="l00067"></a><span class="lineno"> 67</span>  <span class="stringliteral">"(select 1 from functional.alltypestiny)"</span>, op));</div> |
| <div class="line"><a name="l00068"></a><span class="lineno"> 68</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where id %s "</span> +</div> |
| <div class="line"><a name="l00069"></a><span class="lineno"> 69</span>  <span class="stringliteral">"(select 1 + 1 from functional.alltypestiny group by int_col)"</span>, op));</div> |
| <div class="line"><a name="l00070"></a><span class="lineno"> 70</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select max(id) from functional.alltypes where id %s "</span> +</div> |
| <div class="line"><a name="l00071"></a><span class="lineno"> 71</span>  <span class="stringliteral">"(select max(id) from functional.alltypesagg a where a.int_col < 10) "</span> +</div> |
| <div class="line"><a name="l00072"></a><span class="lineno"> 72</span>  <span class="stringliteral">"and bool_col = false"</span>, op));</div> |
| <div class="line"><a name="l00073"></a><span class="lineno"> 73</span> </div> |
| <div class="line"><a name="l00074"></a><span class="lineno"> 74</span>  <span class="comment">// Subquery returns multiple columns</span></div> |
| <div class="line"><a name="l00075"></a><span class="lineno"> 75</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where id %s "</span> +</div> |
| <div class="line"><a name="l00076"></a><span class="lineno"> 76</span>  <span class="stringliteral">"(select id, int_col from functional.alltypessmall)"</span>, op),</div> |
| <div class="line"><a name="l00077"></a><span class="lineno"> 77</span>  <span class="stringliteral">"Subquery must return a single column: (SELECT id, int_col "</span> +</div> |
| <div class="line"><a name="l00078"></a><span class="lineno"> 78</span>  <span class="stringliteral">"FROM functional.alltypessmall)"</span>);</div> |
| <div class="line"><a name="l00079"></a><span class="lineno"> 79</span>  <span class="comment">// Subquery returns an incompatible column type</span></div> |
| <div class="line"><a name="l00080"></a><span class="lineno"> 80</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where id %s "</span> +</div> |
| <div class="line"><a name="l00081"></a><span class="lineno"> 81</span>  <span class="stringliteral">"(select timestamp_col from functional.alltypessmall)"</span>, op),</div> |
| <div class="line"><a name="l00082"></a><span class="lineno"> 82</span>  <span class="stringliteral">"Incompatible return types 'INT' and 'TIMESTAMP' of exprs 'id' and "</span> +</div> |
| <div class="line"><a name="l00083"></a><span class="lineno"> 83</span>  <span class="stringliteral">"'timestamp_col'."</span>);</div> |
| <div class="line"><a name="l00084"></a><span class="lineno"> 84</span> </div> |
| <div class="line"><a name="l00085"></a><span class="lineno"> 85</span>  <span class="comment">// Different column types in the subquery predicate</span></div> |
| <div class="line"><a name="l00086"></a><span class="lineno"> 86</span>  <span class="keywordflow">for</span> (String col: colNames) {</div> |
| <div class="line"><a name="l00087"></a><span class="lineno"> 87</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.%s %s "</span> +</div> |
| <div class="line"><a name="l00088"></a><span class="lineno"> 88</span>  <span class="stringliteral">"(select a.%s from functional.alltypestiny a)"</span>, col, op, col));</div> |
| <div class="line"><a name="l00089"></a><span class="lineno"> 89</span>  }</div> |
| <div class="line"><a name="l00090"></a><span class="lineno"> 90</span>  <span class="comment">// Decimal in the subquery predicate</span></div> |
| <div class="line"><a name="l00091"></a><span class="lineno"> 91</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00092"></a><span class="lineno"> 92</span>  <span class="stringliteral">"t.double_col %s (select d3 from functional.decimal_tbl a)"</span>, op));</div> |
| <div class="line"><a name="l00093"></a><span class="lineno"> 93</span>  <span class="comment">// Varchar in the subquery predicate</span></div> |
| <div class="line"><a name="l00094"></a><span class="lineno"> 94</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00095"></a><span class="lineno"> 95</span>  <span class="stringliteral">"t.string_col %s (select cast(a.string_col as varchar(1)) from "</span> +</div> |
| <div class="line"><a name="l00096"></a><span class="lineno"> 96</span>  <span class="stringliteral">"functional.alltypestiny a)"</span>, op));</div> |
| <div class="line"><a name="l00097"></a><span class="lineno"> 97</span> </div> |
| <div class="line"><a name="l00098"></a><span class="lineno"> 98</span>  <span class="comment">// Subqueries with multiple predicates in the WHERE clause</span></div> |
| <div class="line"><a name="l00099"></a><span class="lineno"> 99</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00100"></a><span class="lineno"> 100</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a where a.int_col < 10)"</span>, op));</div> |
| <div class="line"><a name="l00101"></a><span class="lineno"> 101</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00102"></a><span class="lineno"> 102</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a where a.int_col > 10 and "</span> +</div> |
| <div class="line"><a name="l00103"></a><span class="lineno"> 103</span>  <span class="stringliteral">"a.tinyint_col < 5)"</span>, op));</div> |
| <div class="line"><a name="l00104"></a><span class="lineno"> 104</span> </div> |
| <div class="line"><a name="l00105"></a><span class="lineno"> 105</span>  <span class="comment">// Subqueries with a GROUP BY clause</span></div> |
| <div class="line"><a name="l00106"></a><span class="lineno"> 106</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00107"></a><span class="lineno"> 107</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a where a.double_col < 10.1 "</span> +</div> |
| <div class="line"><a name="l00108"></a><span class="lineno"> 108</span>  <span class="stringliteral">"group by a.id)"</span>, op));</div> |
| <div class="line"><a name="l00109"></a><span class="lineno"> 109</span> </div> |
| <div class="line"><a name="l00110"></a><span class="lineno"> 110</span>  <span class="comment">// Subqueries with GROUP BY and HAVING clauses</span></div> |
| <div class="line"><a name="l00111"></a><span class="lineno"> 111</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00112"></a><span class="lineno"> 112</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a where a.bool_col = true and "</span> +</div> |
| <div class="line"><a name="l00113"></a><span class="lineno"> 113</span>  <span class="stringliteral">"int_col < 10 group by id having count(*) < 10)"</span>, op));</div> |
| <div class="line"><a name="l00114"></a><span class="lineno"> 114</span> </div> |
| <div class="line"><a name="l00115"></a><span class="lineno"> 115</span>  <span class="comment">// Subqueries with a LIMIT clause</span></div> |
| <div class="line"><a name="l00116"></a><span class="lineno"> 116</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00117"></a><span class="lineno"> 117</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a where id < 100 limit 10)"</span>, op));</div> |
| <div class="line"><a name="l00118"></a><span class="lineno"> 118</span> </div> |
| <div class="line"><a name="l00119"></a><span class="lineno"> 119</span>  <span class="comment">// Subqueries with multiple tables in the FROM clause</span></div> |
| <div class="line"><a name="l00120"></a><span class="lineno"> 120</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00121"></a><span class="lineno"> 121</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a, functional.alltypessmall s "</span> +</div> |
| <div class="line"><a name="l00122"></a><span class="lineno"> 122</span>  <span class="stringliteral">"where a.int_col = s.int_col and s.bigint_col < 100 and a.tinyint_col < 10)"</span>,</div> |
| <div class="line"><a name="l00123"></a><span class="lineno"> 123</span>  op));</div> |
| <div class="line"><a name="l00124"></a><span class="lineno"> 124</span> </div> |
| <div class="line"><a name="l00125"></a><span class="lineno"> 125</span>  <span class="comment">// Different join operators between the tables in subquery's FROM clause</span></div> |
| <div class="line"><a name="l00126"></a><span class="lineno"> 126</span>  <span class="keywordflow">for</span> (String joinOp: joinOperators) {</div> |
| <div class="line"><a name="l00127"></a><span class="lineno"> 127</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00128"></a><span class="lineno"> 128</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a %s functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00129"></a><span class="lineno"> 129</span>  <span class="stringliteral">"s on a.int_col = s.int_col where a.bool_col = false)"</span>, op, joinOp));</div> |
| <div class="line"><a name="l00130"></a><span class="lineno"> 130</span>  }</div> |
| <div class="line"><a name="l00131"></a><span class="lineno"> 131</span> </div> |
| <div class="line"><a name="l00132"></a><span class="lineno"> 132</span>  <span class="comment">// Correlated predicates in the subquery's ON clause</span></div> |
| <div class="line"><a name="l00133"></a><span class="lineno"> 133</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00134"></a><span class="lineno"> 134</span>  <span class="stringliteral">"(select a.id from functional.alltypesagg a left outer join "</span> +</div> |
| <div class="line"><a name="l00135"></a><span class="lineno"> 135</span>  <span class="stringliteral">"functional.alltypessmall s on s.int_col = t.int_col)"</span>, op));</div> |
| <div class="line"><a name="l00136"></a><span class="lineno"> 136</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00137"></a><span class="lineno"> 137</span>  <span class="stringliteral">"(select a.id from functional.alltypesagg a left outer join "</span> +</div> |
| <div class="line"><a name="l00138"></a><span class="lineno"> 138</span>  <span class="stringliteral">"functional.alltypessmall s on s.bigint_col = a.bigint_col and "</span> +</div> |
| <div class="line"><a name="l00139"></a><span class="lineno"> 139</span>  <span class="stringliteral">"s.int_col = t.int_col)"</span>, op));</div> |
| <div class="line"><a name="l00140"></a><span class="lineno"> 140</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00141"></a><span class="lineno"> 141</span>  <span class="stringliteral">"(select a.id from functional.alltypesagg a left outer join "</span> +</div> |
| <div class="line"><a name="l00142"></a><span class="lineno"> 142</span>  <span class="stringliteral">"functional.alltypessmall s on a.bool_col = s.bool_col and t.int_col = 1)"</span>,</div> |
| <div class="line"><a name="l00143"></a><span class="lineno"> 143</span>  op));</div> |
| <div class="line"><a name="l00144"></a><span class="lineno"> 144</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00145"></a><span class="lineno"> 145</span>  <span class="stringliteral">"(select a.id from functional.alltypesagg a left outer join "</span> +</div> |
| <div class="line"><a name="l00146"></a><span class="lineno"> 146</span>  <span class="stringliteral">"functional.alltypessmall s on ifnull(s.int_col, s.int_col + 20) = "</span> +</div> |
| <div class="line"><a name="l00147"></a><span class="lineno"> 147</span>  <span class="stringliteral">"t.int_col + t.bigint_col)"</span>, op));</div> |
| <div class="line"><a name="l00148"></a><span class="lineno"> 148</span> </div> |
| <div class="line"><a name="l00149"></a><span class="lineno"> 149</span>  <span class="comment">// Subqueries with inline views</span></div> |
| <div class="line"><a name="l00150"></a><span class="lineno"> 150</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00151"></a><span class="lineno"> 151</span>  <span class="stringliteral">"(select a.id from functional.alltypestiny a, "</span> +</div> |
| <div class="line"><a name="l00152"></a><span class="lineno"> 152</span>  <span class="stringliteral">"(select * from functional.alltypessmall) s where s.int_col = a.int_col "</span> +</div> |
| <div class="line"><a name="l00153"></a><span class="lineno"> 153</span>  <span class="stringliteral">"and s.bool_col = false)"</span>, op));</div> |
| <div class="line"><a name="l00154"></a><span class="lineno"> 154</span> </div> |
| <div class="line"><a name="l00155"></a><span class="lineno"> 155</span>  <span class="comment">// Subqueries with inline views that contain subqueries</span></div> |
| <div class="line"><a name="l00156"></a><span class="lineno"> 156</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00157"></a><span class="lineno"> 157</span>  <span class="stringliteral">"(select a.id from (select id from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00158"></a><span class="lineno"> 158</span>  <span class="stringliteral">"g.int_col in (select int_col from functional.alltypestiny)) a)"</span>, op));</div> |
| <div class="line"><a name="l00159"></a><span class="lineno"> 159</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where t.id %s "</span> +</div> |
| <div class="line"><a name="l00160"></a><span class="lineno"> 160</span>  <span class="stringliteral">"(select a.id from (select g.* from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00161"></a><span class="lineno"> 161</span>  <span class="stringliteral">"g.int_col in (select int_col from functional.alltypestiny)) a where "</span> +</div> |
| <div class="line"><a name="l00162"></a><span class="lineno"> 162</span>  <span class="stringliteral">"a.bigint_col = 100)"</span>, op));</div> |
| <div class="line"><a name="l00163"></a><span class="lineno"> 163</span> </div> |
| <div class="line"><a name="l00164"></a><span class="lineno"> 164</span>  <span class="comment">// Multiple tables in the FROM clause of the outer query block</span></div> |
| <div class="line"><a name="l00165"></a><span class="lineno"> 165</span>  <span class="keywordflow">for</span> (String joinOp: joinOperators) {</div> |
| <div class="line"><a name="l00166"></a><span class="lineno"> 166</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t %s "</span> +</div> |
| <div class="line"><a name="l00167"></a><span class="lineno"> 167</span>  <span class="stringliteral">"functional.alltypessmall s on t.int_col = s.int_col where "</span> +</div> |
| <div class="line"><a name="l00168"></a><span class="lineno"> 168</span>  <span class="stringliteral">"t.tinyint_col %s (select tinyint_col from functional.alltypesagg) "</span> +</div> |
| <div class="line"><a name="l00169"></a><span class="lineno"> 169</span>  <span class="stringliteral">"and t.bool_col = false and t.bigint_col = 10"</span>, joinOp, op));</div> |
| <div class="line"><a name="l00170"></a><span class="lineno"> 170</span>  }</div> |
| <div class="line"><a name="l00171"></a><span class="lineno"> 171</span> </div> |
| <div class="line"><a name="l00172"></a><span class="lineno"> 172</span>  <span class="comment">// Subqueries in WITH clause</span></div> |
| <div class="line"><a name="l00173"></a><span class="lineno"> 173</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"with t as (select a.* from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00174"></a><span class="lineno"> 174</span>  <span class="stringliteral">"id %s (select id from functional.alltypestiny)) select * from t where "</span> +</div> |
| <div class="line"><a name="l00175"></a><span class="lineno"> 175</span>  <span class="stringliteral">"t.bool_col = false and t.int_col = 10"</span>, op));</div> |
| <div class="line"><a name="l00176"></a><span class="lineno"> 176</span> </div> |
| <div class="line"><a name="l00177"></a><span class="lineno"> 177</span>  <span class="comment">// Subqueries in WITH and WHERE clauses</span></div> |
| <div class="line"><a name="l00178"></a><span class="lineno"> 178</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"with t as (select a.* from functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00179"></a><span class="lineno"> 179</span>  <span class="stringliteral">"where id %s (select id from functional.alltypestiny s)) select * from t "</span> +</div> |
| <div class="line"><a name="l00180"></a><span class="lineno"> 180</span>  <span class="stringliteral">"where t.int_col in (select int_col from functional.alltypessmall) and "</span> +</div> |
| <div class="line"><a name="l00181"></a><span class="lineno"> 181</span>  <span class="stringliteral">"t.bool_col = false"</span>, op));</div> |
| <div class="line"><a name="l00182"></a><span class="lineno"> 182</span> </div> |
| <div class="line"><a name="l00183"></a><span class="lineno"> 183</span>  <span class="comment">// Subqueries in WITH, FROM and WHERE clauses</span></div> |
| <div class="line"><a name="l00184"></a><span class="lineno"> 184</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"with t as (select a.* from functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00185"></a><span class="lineno"> 185</span>  <span class="stringliteral">"where id %s (select id from functional.alltypestiny)) select t.* from t, "</span> +</div> |
| <div class="line"><a name="l00186"></a><span class="lineno"> 186</span>  <span class="stringliteral">"(select * from functional.alltypesagg g where g.id in "</span> +</div> |
| <div class="line"><a name="l00187"></a><span class="lineno"> 187</span>  <span class="stringliteral">"(select id from functional.alltypes)) s where s.string_col = t.string_col "</span> +</div> |
| <div class="line"><a name="l00188"></a><span class="lineno"> 188</span>  <span class="stringliteral">"and t.int_col in (select int_col from functional.alltypessmall) and "</span> +</div> |
| <div class="line"><a name="l00189"></a><span class="lineno"> 189</span>  <span class="stringliteral">"s.bool_col = false"</span>, op));</div> |
| <div class="line"><a name="l00190"></a><span class="lineno"> 190</span> </div> |
| <div class="line"><a name="l00191"></a><span class="lineno"> 191</span>  <span class="comment">// Correlated subqueries</span></div> |
| <div class="line"><a name="l00192"></a><span class="lineno"> 192</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00193"></a><span class="lineno"> 193</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.int_col = a.int_col) "</span> +</div> |
| <div class="line"><a name="l00194"></a><span class="lineno"> 194</span>  <span class="stringliteral">"and t.bool_col = false"</span>, op));</div> |
| <div class="line"><a name="l00195"></a><span class="lineno"> 195</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00196"></a><span class="lineno"> 196</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.int_col + 1 = a.int_col)"</span>,</div> |
| <div class="line"><a name="l00197"></a><span class="lineno"> 197</span>  op));</div> |
| <div class="line"><a name="l00198"></a><span class="lineno"> 198</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00199"></a><span class="lineno"> 199</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.int_col + 1 = a.int_col + 1)"</span>,</div> |
| <div class="line"><a name="l00200"></a><span class="lineno"> 200</span>  op));</div> |
| <div class="line"><a name="l00201"></a><span class="lineno"> 201</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00202"></a><span class="lineno"> 202</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.int_col + a.int_col = "</span> +</div> |
| <div class="line"><a name="l00203"></a><span class="lineno"> 203</span>  <span class="stringliteral">"a.bigint_col and a.bool_col = true)"</span>, op));</div> |
| <div class="line"><a name="l00204"></a><span class="lineno"> 204</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00205"></a><span class="lineno"> 205</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.bool_col = false and "</span> +</div> |
| <div class="line"><a name="l00206"></a><span class="lineno"> 206</span>  <span class="stringliteral">"a.int_col < 10)"</span>, op));</div> |
| <div class="line"><a name="l00207"></a><span class="lineno"> 207</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00208"></a><span class="lineno"> 208</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.bool_col)"</span>, op));</div> |
| <div class="line"><a name="l00209"></a><span class="lineno"> 209</span> </div> |
| <div class="line"><a name="l00210"></a><span class="lineno"> 210</span>  <span class="comment">// Multiple nesting levels (uncorrelated queries)</span></div> |
| <div class="line"><a name="l00211"></a><span class="lineno"> 211</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00212"></a><span class="lineno"> 212</span>  <span class="stringliteral">"(select id from functional.alltypesagg where int_col %s "</span> +</div> |
| <div class="line"><a name="l00213"></a><span class="lineno"> 213</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny) and bool_col = false) "</span> +</div> |
| <div class="line"><a name="l00214"></a><span class="lineno"> 214</span>  <span class="stringliteral">"and bigint_col < 1000"</span>, op, op));</div> |
| <div class="line"><a name="l00215"></a><span class="lineno"> 215</span> </div> |
| <div class="line"><a name="l00216"></a><span class="lineno"> 216</span>  <span class="comment">// Multiple nesting levels (correlated queries)</span></div> |
| <div class="line"><a name="l00217"></a><span class="lineno"> 217</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00218"></a><span class="lineno"> 218</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where a.int_col = t.int_col "</span> +</div> |
| <div class="line"><a name="l00219"></a><span class="lineno"> 219</span>  <span class="stringliteral">"and a.tinyint_col %s (select tinyint_col from functional.alltypestiny s "</span> +</div> |
| <div class="line"><a name="l00220"></a><span class="lineno"> 220</span>  <span class="stringliteral">"where s.bigint_col = a.bigint_col))"</span>, op, op));</div> |
| <div class="line"><a name="l00221"></a><span class="lineno"> 221</span> </div> |
| <div class="line"><a name="l00222"></a><span class="lineno"> 222</span>  <span class="comment">// Multiple nesting levels (correlated and uncorrelated queries)</span></div> |
| <div class="line"><a name="l00223"></a><span class="lineno"> 223</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where id %s "</span> +</div> |
| <div class="line"><a name="l00224"></a><span class="lineno"> 224</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where t.int_col = a.int_col "</span> +</div> |
| <div class="line"><a name="l00225"></a><span class="lineno"> 225</span>  <span class="stringliteral">"and a.int_col %s (select int_col from functional.alltypestiny s))"</span>,</div> |
| <div class="line"><a name="l00226"></a><span class="lineno"> 226</span>  op, op));</div> |
| <div class="line"><a name="l00227"></a><span class="lineno"> 227</span> </div> |
| <div class="line"><a name="l00228"></a><span class="lineno"> 228</span>  <span class="comment">// NOT ([NOT] IN predicate)</span></div> |
| <div class="line"><a name="l00229"></a><span class="lineno"> 229</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where not (id %s "</span> +</div> |
| <div class="line"><a name="l00230"></a><span class="lineno"> 230</span>  <span class="stringliteral">"(select id from functional.alltypesagg))"</span>, op));</div> |
| <div class="line"><a name="l00231"></a><span class="lineno"> 231</span> </div> |
| <div class="line"><a name="l00232"></a><span class="lineno"> 232</span>  <span class="comment">// Different cmp operators in the correlation predicate</span></div> |
| <div class="line"><a name="l00233"></a><span class="lineno"> 233</span>  <span class="keywordflow">for</span> (String cmpOp: <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12">cmpOperators</a>) {</div> |
| <div class="line"><a name="l00234"></a><span class="lineno"> 234</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t "</span> +</div> |
| <div class="line"><a name="l00235"></a><span class="lineno"> 235</span>  <span class="stringliteral">"where t.id %s (select a.id from functional.alltypesagg a where "</span> +</div> |
| <div class="line"><a name="l00236"></a><span class="lineno"> 236</span>  <span class="stringliteral">"t.int_col %s a.int_col)"</span>, op, cmpOp));</div> |
| <div class="line"><a name="l00237"></a><span class="lineno"> 237</span>  }</div> |
| <div class="line"><a name="l00238"></a><span class="lineno"> 238</span> </div> |
| <div class="line"><a name="l00239"></a><span class="lineno"> 239</span>  <span class="comment">// Uncorrelated IN subquery with analytic function</span></div> |
| <div class="line"><a name="l00240"></a><span class="lineno"> 240</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00241"></a><span class="lineno"> 241</span>  <span class="stringliteral">"functional.alltypestiny t1 where int_col %s (select min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00242"></a><span class="lineno"> 242</span>  <span class="stringliteral">"over (partition by bool_col) from functional.alltypessmall t2 where "</span> +</div> |
| <div class="line"><a name="l00243"></a><span class="lineno"> 243</span>  <span class="stringliteral">"int_col < 10)"</span>, op));</div> |
| <div class="line"><a name="l00244"></a><span class="lineno"> 244</span>  }</div> |
| <div class="line"><a name="l00245"></a><span class="lineno"> 245</span> </div> |
| <div class="line"><a name="l00246"></a><span class="lineno"> 246</span>  <span class="comment">// Constant on the left hand side</span></div> |
| <div class="line"><a name="l00247"></a><span class="lineno"> 247</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes a where 1 in "</span> +</div> |
| <div class="line"><a name="l00248"></a><span class="lineno"> 248</span>  <span class="stringliteral">"(select id from functional.alltypesagg s where s.int_col = a.int_col)"</span>);</div> |
| <div class="line"><a name="l00249"></a><span class="lineno"> 249</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes a where 1 not in "</span> +</div> |
| <div class="line"><a name="l00250"></a><span class="lineno"> 250</span>  <span class="stringliteral">"(select id from functional.alltypesagg s where s.int_col = a.int_col)"</span>,</div> |
| <div class="line"><a name="l00251"></a><span class="lineno"> 251</span>  <span class="stringliteral">"Unsupported NOT IN predicate with subquery: 1 NOT IN (SELECT id FROM "</span> +</div> |
| <div class="line"><a name="l00252"></a><span class="lineno"> 252</span>  <span class="stringliteral">"functional.alltypesagg s WHERE s.int_col = a.int_col)"</span>);</div> |
| <div class="line"><a name="l00253"></a><span class="lineno"> 253</span> </div> |
| <div class="line"><a name="l00254"></a><span class="lineno"> 254</span>  <span class="comment">// IN subquery that is equivalent to an uncorrelated EXISTS subquery</span></div> |
| <div class="line"><a name="l00255"></a><span class="lineno"> 255</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where 1 in "</span> +</div> |
| <div class="line"><a name="l00256"></a><span class="lineno"> 256</span>  <span class="stringliteral">"(select int_col from functional.alltypesagg)"</span>, <span class="stringliteral">"Unsupported "</span> +</div> |
| <div class="line"><a name="l00257"></a><span class="lineno"> 257</span>  <span class="stringliteral">"predicate with subquery: 1 IN (SELECT int_col FROM functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00258"></a><span class="lineno"> 258</span>  <span class="comment">// Different non-equi comparison operators in the correlated predicate</span></div> |
| <div class="line"><a name="l00259"></a><span class="lineno"> 259</span>  String nonEquiCmpOperators[] = {<span class="stringliteral">"!="</span>, <span class="stringliteral">"<="</span>, <span class="stringliteral">">="</span>, <span class="stringliteral">">"</span>, <span class="stringliteral">"<"</span>};</div> |
| <div class="line"><a name="l00260"></a><span class="lineno"> 260</span>  <span class="keywordflow">for</span> (String cmpOp: nonEquiCmpOperators) {</div> |
| <div class="line"><a name="l00261"></a><span class="lineno"> 261</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypes t where 1 in "</span> +</div> |
| <div class="line"><a name="l00262"></a><span class="lineno"> 262</span>  <span class="stringliteral">"(select int_col from functional.alltypesagg g where g.id %s t.id)"</span>,</div> |
| <div class="line"><a name="l00263"></a><span class="lineno"> 263</span>  cmpOp), String.format(<span class="stringliteral">"Unsupported predicate with subquery: 1 "</span> +</div> |
| <div class="line"><a name="l00264"></a><span class="lineno"> 264</span>  <span class="stringliteral">"IN (SELECT int_col FROM functional.alltypesagg g WHERE g.id %s t.id)"</span>,</div> |
| <div class="line"><a name="l00265"></a><span class="lineno"> 265</span>  cmpOp));</div> |
| <div class="line"><a name="l00266"></a><span class="lineno"> 266</span>  }</div> |
| <div class="line"><a name="l00267"></a><span class="lineno"> 267</span> </div> |
| <div class="line"><a name="l00268"></a><span class="lineno"> 268</span>  <span class="comment">// NOT IN subquery with a correlated predicate that can't be used in an equi</span></div> |
| <div class="line"><a name="l00269"></a><span class="lineno"> 269</span>  <span class="comment">// join</span></div> |
| <div class="line"><a name="l00270"></a><span class="lineno"> 270</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select 1 from functional.alltypes t where 1 not in "</span> +</div> |
| <div class="line"><a name="l00271"></a><span class="lineno"> 271</span>  <span class="stringliteral">"(select id from functional.alltypestiny g where g.id < t.id)"</span>,</div> |
| <div class="line"><a name="l00272"></a><span class="lineno"> 272</span>  <span class="stringliteral">"Unsupported predicate with subquery: 1 NOT IN (SELECT id FROM "</span> +</div> |
| <div class="line"><a name="l00273"></a><span class="lineno"> 273</span>  <span class="stringliteral">"functional.alltypestiny g WHERE g.id < t.id)"</span>);</div> |
| <div class="line"><a name="l00274"></a><span class="lineno"> 274</span> </div> |
| <div class="line"><a name="l00275"></a><span class="lineno"> 275</span>  <span class="comment">// Statement with a GROUP BY and a correlated IN subquery that has</span></div> |
| <div class="line"><a name="l00276"></a><span class="lineno"> 276</span>  <span class="comment">// correlated predicate that cannot be transformed into an equi-join.</span></div> |
| <div class="line"><a name="l00277"></a><span class="lineno"> 277</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, count(*) from functional.alltypes t "</span> +</div> |
| <div class="line"><a name="l00278"></a><span class="lineno"> 278</span>  <span class="stringliteral">"where 1 IN (select id from functional.alltypesagg g where t.int_col < "</span> +</div> |
| <div class="line"><a name="l00279"></a><span class="lineno"> 279</span>  <span class="stringliteral">"g.int_col) group by id"</span>, <span class="stringliteral">"Unsupported predicate with subquery: 1 IN "</span> +</div> |
| <div class="line"><a name="l00280"></a><span class="lineno"> 280</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypesagg g WHERE t.int_col < g.int_col)"</span>);</div> |
| <div class="line"><a name="l00281"></a><span class="lineno"> 281</span> </div> |
| <div class="line"><a name="l00282"></a><span class="lineno"> 282</span>  <span class="comment">// Reference a non-existing table in the subquery</span></div> |
| <div class="line"><a name="l00283"></a><span class="lineno"> 283</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where id in "</span> +</div> |
| <div class="line"><a name="l00284"></a><span class="lineno"> 284</span>  <span class="stringliteral">"(select id from functional.alltypessmall s left outer join p on "</span> +</div> |
| <div class="line"><a name="l00285"></a><span class="lineno"> 285</span>  <span class="stringliteral">"(s.int_col = p.int_col))"</span>,</div> |
| <div class="line"><a name="l00286"></a><span class="lineno"> 286</span>  <span class="stringliteral">"Could not resolve table reference: 'p'"</span>);</div> |
| <div class="line"><a name="l00287"></a><span class="lineno"> 287</span>  <span class="comment">// Reference a non-existing column from a table in the outer scope</span></div> |
| <div class="line"><a name="l00288"></a><span class="lineno"> 288</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where id in "</span> +</div> |
| <div class="line"><a name="l00289"></a><span class="lineno"> 289</span>  <span class="stringliteral">"(select id from functional.alltypessmall s where s.int_col = t.bad_col)"</span>,</div> |
| <div class="line"><a name="l00290"></a><span class="lineno"> 290</span>  <span class="stringliteral">"Could not resolve column/field reference: 't.bad_col'"</span>);</div> |
| <div class="line"><a name="l00291"></a><span class="lineno"> 291</span> </div> |
| <div class="line"><a name="l00292"></a><span class="lineno"> 292</span>  <span class="comment">// Referencing the same table in the inner and the outer query block</span></div> |
| <div class="line"><a name="l00293"></a><span class="lineno"> 293</span>  <span class="comment">// No explicit alias</span></div> |
| <div class="line"><a name="l00294"></a><span class="lineno"> 294</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny where int_col in "</span> +</div> |
| <div class="line"><a name="l00295"></a><span class="lineno"> 295</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00296"></a><span class="lineno"> 296</span>  <span class="comment">// Different alias between inner and outer block referencing the same table</span></div> |
| <div class="line"><a name="l00297"></a><span class="lineno"> 297</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col in "</span> +</div> |
| <div class="line"><a name="l00298"></a><span class="lineno"> 298</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny p)"</span>);</div> |
| <div class="line"><a name="l00299"></a><span class="lineno"> 299</span>  <span class="comment">// Alias only in the outer block</span></div> |
| <div class="line"><a name="l00300"></a><span class="lineno"> 300</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col in "</span> +</div> |
| <div class="line"><a name="l00301"></a><span class="lineno"> 301</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00302"></a><span class="lineno"> 302</span>  <span class="comment">// Same alias in both inner and outer block</span></div> |
| <div class="line"><a name="l00303"></a><span class="lineno"> 303</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col in "</span> +</div> |
| <div class="line"><a name="l00304"></a><span class="lineno"> 304</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny t)"</span>);</div> |
| <div class="line"><a name="l00305"></a><span class="lineno"> 305</span>  <span class="comment">// Binary predicate with non-comparable operands</span></div> |
| <div class="line"><a name="l00306"></a><span class="lineno"> 306</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00307"></a><span class="lineno"> 307</span>  <span class="stringliteral">"(id in (select id from functional.alltypestiny)) = 'string_val'"</span>,</div> |
| <div class="line"><a name="l00308"></a><span class="lineno"> 308</span>  <span class="stringliteral">"operands of type BOOLEAN and STRING are not comparable: "</span> +</div> |
| <div class="line"><a name="l00309"></a><span class="lineno"> 309</span>  <span class="stringliteral">"(id IN (SELECT id FROM functional.alltypestiny)) = 'string_val'"</span>);</div> |
| <div class="line"><a name="l00310"></a><span class="lineno"> 310</span> </div> |
| <div class="line"><a name="l00311"></a><span class="lineno"> 311</span>  <span class="comment">// OR with subquery predicates</span></div> |
| <div class="line"><a name="l00312"></a><span class="lineno"> 312</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id in "</span> +</div> |
| <div class="line"><a name="l00313"></a><span class="lineno"> 313</span>  <span class="stringliteral">"(select id from functional.alltypesagg) or t.bool_col = false"</span>,</div> |
| <div class="line"><a name="l00314"></a><span class="lineno"> 314</span>  <span class="stringliteral">"Subqueries in OR predicates are not supported: t.id IN "</span> +</div> |
| <div class="line"><a name="l00315"></a><span class="lineno"> 315</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypesagg) OR t.bool_col = FALSE"</span>);</div> |
| <div class="line"><a name="l00316"></a><span class="lineno"> 316</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where not (t.id in "</span> +</div> |
| <div class="line"><a name="l00317"></a><span class="lineno"> 317</span>  <span class="stringliteral">"(select id from functional.alltypesagg) and t.int_col = 10)"</span>,</div> |
| <div class="line"><a name="l00318"></a><span class="lineno"> 318</span>  <span class="stringliteral">"Subqueries in OR predicates are not supported: t.id NOT IN "</span> +</div> |
| <div class="line"><a name="l00319"></a><span class="lineno"> 319</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypesagg) OR t.int_col != 10"</span>);</div> |
| <div class="line"><a name="l00320"></a><span class="lineno"> 320</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where exists "</span> +</div> |
| <div class="line"><a name="l00321"></a><span class="lineno"> 321</span>  <span class="stringliteral">"(select * from functional.alltypesagg g where g.bool_col = false) "</span> +</div> |
| <div class="line"><a name="l00322"></a><span class="lineno"> 322</span>  <span class="stringliteral">"or t.bool_col = true"</span>, <span class="stringliteral">"Subqueries in OR predicates are not "</span> +</div> |
| <div class="line"><a name="l00323"></a><span class="lineno"> 323</span>  <span class="stringliteral">"supported: EXISTS (SELECT * FROM functional.alltypesagg g WHERE "</span> +</div> |
| <div class="line"><a name="l00324"></a><span class="lineno"> 324</span>  <span class="stringliteral">"g.bool_col = FALSE) OR t.bool_col = TRUE"</span>);</div> |
| <div class="line"><a name="l00325"></a><span class="lineno"> 325</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id = "</span> +</div> |
| <div class="line"><a name="l00326"></a><span class="lineno"> 326</span>  <span class="stringliteral">"(select min(id) from functional.alltypesagg g) or t.id = 10"</span>,</div> |
| <div class="line"><a name="l00327"></a><span class="lineno"> 327</span>  <span class="stringliteral">"Subqueries in OR predicates are not supported: t.id = "</span> +</div> |
| <div class="line"><a name="l00328"></a><span class="lineno"> 328</span>  <span class="stringliteral">"(SELECT min(id) FROM functional.alltypesagg g) OR t.id = 10"</span>);</div> |
| <div class="line"><a name="l00329"></a><span class="lineno"> 329</span> </div> |
| <div class="line"><a name="l00330"></a><span class="lineno"> 330</span>  <span class="comment">// Correlated subquery with OR predicate</span></div> |
| <div class="line"><a name="l00331"></a><span class="lineno"> 331</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where id in "</span> +</div> |
| <div class="line"><a name="l00332"></a><span class="lineno"> 332</span>  <span class="stringliteral">"(select id from functional.alltypesagg a where "</span> +</div> |
| <div class="line"><a name="l00333"></a><span class="lineno"> 333</span>  <span class="stringliteral">"a.int_col = t.int_col or a.bool_col = false)"</span>, <span class="stringliteral">"Disjunctions "</span> +</div> |
| <div class="line"><a name="l00334"></a><span class="lineno"> 334</span>  <span class="stringliteral">"with correlated predicates are not supported: a.int_col = "</span> +</div> |
| <div class="line"><a name="l00335"></a><span class="lineno"> 335</span>  <span class="stringliteral">"t.int_col OR a.bool_col = FALSE"</span>);</div> |
| <div class="line"><a name="l00336"></a><span class="lineno"> 336</span> </div> |
| <div class="line"><a name="l00337"></a><span class="lineno"> 337</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where id in "</span> +</div> |
| <div class="line"><a name="l00338"></a><span class="lineno"> 338</span>  <span class="stringliteral">"(select id from functional.alltypestiny) and (bool_col = false or "</span> +</div> |
| <div class="line"><a name="l00339"></a><span class="lineno"> 339</span>  <span class="stringliteral">"int_col = 10)"</span>);</div> |
| <div class="line"><a name="l00340"></a><span class="lineno"> 340</span> </div> |
| <div class="line"><a name="l00341"></a><span class="lineno"> 341</span>  <span class="comment">// Correlated subqueries with GROUP BY, AGG functions or DISTINCT</span></div> |
| <div class="line"><a name="l00342"></a><span class="lineno"> 342</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id in "</span> +</div> |
| <div class="line"><a name="l00343"></a><span class="lineno"> 343</span>  <span class="stringliteral">"(select max(a.id) from functional.alltypesagg a where "</span> +</div> |
| <div class="line"><a name="l00344"></a><span class="lineno"> 344</span>  <span class="stringliteral">"t.int_col = a.int_col)"</span>, <span class="stringliteral">"Unsupported correlated subquery with grouping "</span> +</div> |
| <div class="line"><a name="l00345"></a><span class="lineno"> 345</span>  <span class="stringliteral">"and/or aggregation: SELECT max(a.id) FROM functional.alltypesagg a "</span> +</div> |
| <div class="line"><a name="l00346"></a><span class="lineno"> 346</span>  <span class="stringliteral">"WHERE t.int_col = a.int_col"</span>);</div> |
| <div class="line"><a name="l00347"></a><span class="lineno"> 347</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id in "</span> +</div> |
| <div class="line"><a name="l00348"></a><span class="lineno"> 348</span>  <span class="stringliteral">"(select a.id from functional.alltypesagg a where "</span> +</div> |
| <div class="line"><a name="l00349"></a><span class="lineno"> 349</span>  <span class="stringliteral">"t.int_col = a.int_col group by a.id)"</span>, <span class="stringliteral">"Unsupported correlated "</span> +</div> |
| <div class="line"><a name="l00350"></a><span class="lineno"> 350</span>  <span class="stringliteral">"subquery with grouping and/or aggregation: SELECT a.id FROM "</span> +</div> |
| <div class="line"><a name="l00351"></a><span class="lineno"> 351</span>  <span class="stringliteral">"functional.alltypesagg a WHERE t.int_col = a.int_col GROUP BY a.id"</span>);</div> |
| <div class="line"><a name="l00352"></a><span class="lineno"> 352</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id in "</span> +</div> |
| <div class="line"><a name="l00353"></a><span class="lineno"> 353</span>  <span class="stringliteral">"(select distinct a.id from functional.alltypesagg a where "</span> +</div> |
| <div class="line"><a name="l00354"></a><span class="lineno"> 354</span>  <span class="stringliteral">"a.bigint_col = t.bigint_col)"</span>, <span class="stringliteral">"Unsupported correlated subquery with "</span> +</div> |
| <div class="line"><a name="l00355"></a><span class="lineno"> 355</span>  <span class="stringliteral">"grouping and/or aggregation: SELECT DISTINCT a.id FROM "</span> +</div> |
| <div class="line"><a name="l00356"></a><span class="lineno"> 356</span>  <span class="stringliteral">"functional.alltypesagg a WHERE a.bigint_col = t.bigint_col"</span>);</div> |
| <div class="line"><a name="l00357"></a><span class="lineno"> 357</span> </div> |
| <div class="line"><a name="l00358"></a><span class="lineno"> 358</span>  <span class="comment">// NOT compound predicates with OR</span></div> |
| <div class="line"><a name="l00359"></a><span class="lineno"> 359</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where not ("</span> +</div> |
| <div class="line"><a name="l00360"></a><span class="lineno"> 360</span>  <span class="stringliteral">"id in (select id from functional.alltypesagg) or int_col < 10)"</span>);</div> |
| <div class="line"><a name="l00361"></a><span class="lineno"> 361</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where not ("</span> +</div> |
| <div class="line"><a name="l00362"></a><span class="lineno"> 362</span>  <span class="stringliteral">"t.id < 10 or not (t.int_col in (select int_col from "</span> +</div> |
| <div class="line"><a name="l00363"></a><span class="lineno"> 363</span>  <span class="stringliteral">"functional.alltypesagg) and t.bool_col = false))"</span>);</div> |
| <div class="line"><a name="l00364"></a><span class="lineno"> 364</span> </div> |
| <div class="line"><a name="l00365"></a><span class="lineno"> 365</span>  <span class="comment">// Multiple subquery predicates</span></div> |
| <div class="line"><a name="l00366"></a><span class="lineno"> 366</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where id in "</span> +</div> |
| <div class="line"><a name="l00367"></a><span class="lineno"> 367</span>  <span class="stringliteral">"(select id from functional.alltypestiny where int_col = 10) and int_col in "</span> +</div> |
| <div class="line"><a name="l00368"></a><span class="lineno"> 368</span>  <span class="stringliteral">"(select int_col from functional.alltypessmall where bigint_col = 1000) and "</span> +</div> |
| <div class="line"><a name="l00369"></a><span class="lineno"> 369</span>  <span class="stringliteral">"string_col not in (select string_col from functional.alltypesagg where "</span> +</div> |
| <div class="line"><a name="l00370"></a><span class="lineno"> 370</span>  <span class="stringliteral">"tinyint_col > 10) and bool_col = false"</span>);</div> |
| <div class="line"><a name="l00371"></a><span class="lineno"> 371</span> </div> |
| <div class="line"><a name="l00372"></a><span class="lineno"> 372</span>  <span class="comment">// Correlated subquery with a LIMIT clause</span></div> |
| <div class="line"><a name="l00373"></a><span class="lineno"> 373</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where id in "</span> +</div> |
| <div class="line"><a name="l00374"></a><span class="lineno"> 374</span>  <span class="stringliteral">"(select s.id from functional.alltypesagg s where s.int_col = t.int_col "</span> +</div> |
| <div class="line"><a name="l00375"></a><span class="lineno"> 375</span>  <span class="stringliteral">"limit 1)"</span>, <span class="stringliteral">"Unsupported correlated subquery with a LIMIT clause: "</span> +</div> |
| <div class="line"><a name="l00376"></a><span class="lineno"> 376</span>  <span class="stringliteral">"SELECT s.id FROM functional.alltypesagg s WHERE s.int_col = t.int_col "</span> +</div> |
| <div class="line"><a name="l00377"></a><span class="lineno"> 377</span>  <span class="stringliteral">"LIMIT 1"</span>);</div> |
| <div class="line"><a name="l00378"></a><span class="lineno"> 378</span> </div> |
| <div class="line"><a name="l00379"></a><span class="lineno"> 379</span>  <span class="comment">// Correlated IN with an analytic function</span></div> |
| <div class="line"><a name="l00380"></a><span class="lineno"> 380</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, int_col, bool_col from functional.alltypestiny t1 "</span> +</div> |
| <div class="line"><a name="l00381"></a><span class="lineno"> 381</span>  <span class="stringliteral">"where int_col in (select min(bigint_col) over (partition by bool_col) "</span> +</div> |
| <div class="line"><a name="l00382"></a><span class="lineno"> 382</span>  <span class="stringliteral">"from functional.alltypessmall t2 where t1.id < t2.id)"</span>, <span class="stringliteral">"Unsupported "</span> +</div> |
| <div class="line"><a name="l00383"></a><span class="lineno"> 383</span>  <span class="stringliteral">"correlated subquery with grouping and/or aggregation: SELECT "</span> +</div> |
| <div class="line"><a name="l00384"></a><span class="lineno"> 384</span>  <span class="stringliteral">"min(bigint_col) OVER (PARTITION BY bool_col) FROM "</span> +</div> |
| <div class="line"><a name="l00385"></a><span class="lineno"> 385</span>  <span class="stringliteral">"functional.alltypessmall t2 WHERE t1.id < t2.id"</span>);</div> |
| <div class="line"><a name="l00386"></a><span class="lineno"> 386</span> </div> |
| <div class="line"><a name="l00387"></a><span class="lineno"> 387</span>  <span class="comment">// IN subquery in binary predicate</span></div> |
| <div class="line"><a name="l00388"></a><span class="lineno"> 388</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00389"></a><span class="lineno"> 389</span>  <span class="stringliteral">"(tinyint_col in (1,2)) = (bool_col in (select bool_col from "</span> +</div> |
| <div class="line"><a name="l00390"></a><span class="lineno"> 390</span>  <span class="stringliteral">"functional.alltypes))"</span>, <span class="stringliteral">"IN subquery predicates are not supported "</span> +</div> |
| <div class="line"><a name="l00391"></a><span class="lineno"> 391</span>  <span class="stringliteral">"in binary predicates: (tinyint_col IN (1, 2)) = (bool_col IN (SELECT "</span> +</div> |
| <div class="line"><a name="l00392"></a><span class="lineno"> 392</span>  <span class="stringliteral">"bool_col FROM functional.alltypes))"</span>);</div> |
| <div class="line"><a name="l00393"></a><span class="lineno"> 393</span> </div> |
| <div class="line"><a name="l00394"></a><span class="lineno"> 394</span>  <span class="comment">// Column labels may conflict after the rewrite as an inline view</span></div> |
| <div class="line"><a name="l00395"></a><span class="lineno"> 395</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select int_col from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00396"></a><span class="lineno"> 396</span>  <span class="stringliteral">"int_col in (select 1 as int_col from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00397"></a><span class="lineno"> 397</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select int_col from functional.alltypestiny a where "</span> +</div> |
| <div class="line"><a name="l00398"></a><span class="lineno"> 398</span>  <span class="stringliteral">"int_col not in (select 1 as int_col from functional.alltypesagg b "</span> +</div> |
| <div class="line"><a name="l00399"></a><span class="lineno"> 399</span>  <span class="stringliteral">"where a.int_col = b.int_col)"</span>);</div> |
| <div class="line"><a name="l00400"></a><span class="lineno"> 400</span>  }</div> |
| <div class="line"><a name="l00401"></a><span class="lineno"> 401</span> </div> |
| <div class="line"><a name="l00402"></a><span class="lineno"> 402</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00403"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a8bc3362becb290a4bbdcbf6a668978bd"> 403</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a8bc3362becb290a4bbdcbf6a668978bd">TestExistsSubqueries</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00404"></a><span class="lineno"> 404</span>  String existsOperators[] = {<span class="stringliteral">"exists"</span>, <span class="stringliteral">"not exists"</span>};</div> |
| <div class="line"><a name="l00405"></a><span class="lineno"> 405</span> </div> |
| <div class="line"><a name="l00406"></a><span class="lineno"> 406</span>  <span class="keywordflow">for</span> (String op: existsOperators) {</div> |
| <div class="line"><a name="l00407"></a><span class="lineno"> 407</span>  <span class="comment">// [NOT] EXISTS predicate (correlated)</span></div> |
| <div class="line"><a name="l00408"></a><span class="lineno"> 408</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t "</span> +</div> |
| <div class="line"><a name="l00409"></a><span class="lineno"> 409</span>  <span class="stringliteral">"where %s (select * from functional.alltypestiny p where "</span> +</div> |
| <div class="line"><a name="l00410"></a><span class="lineno"> 410</span>  <span class="stringliteral">"p.id = t.id)"</span>, op));</div> |
| <div class="line"><a name="l00411"></a><span class="lineno"> 411</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t "</span> +</div> |
| <div class="line"><a name="l00412"></a><span class="lineno"> 412</span>  <span class="stringliteral">"where %s (select * from functional.alltypestiny p where "</span> +</div> |
| <div class="line"><a name="l00413"></a><span class="lineno"> 413</span>  <span class="stringliteral">"p.int_col = t.int_col and p.bool_col = false)"</span>, op));</div> |
| <div class="line"><a name="l00414"></a><span class="lineno"> 414</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t, "</span> +</div> |
| <div class="line"><a name="l00415"></a><span class="lineno"> 415</span>  <span class="stringliteral">"functional.alltypessmall s where s.id = t.id and %s (select * from "</span> +</div> |
| <div class="line"><a name="l00416"></a><span class="lineno"> 416</span>  <span class="stringliteral">"functional.alltypestiny a where a.int_col = t.int_col)"</span>, op));</div> |
| <div class="line"><a name="l00417"></a><span class="lineno"> 417</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t, "</span> +</div> |
| <div class="line"><a name="l00418"></a><span class="lineno"> 418</span>  <span class="stringliteral">"functional.alltypessmall s where s.id = t.id and %s (select * from "</span> +</div> |
| <div class="line"><a name="l00419"></a><span class="lineno"> 419</span>  <span class="stringliteral">"functional.alltypestiny a where a.int_col = t.int_col and a.bool_col = "</span> +</div> |
| <div class="line"><a name="l00420"></a><span class="lineno"> 420</span>  <span class="stringliteral">"t.bool_col)"</span>, op));</div> |
| <div class="line"><a name="l00421"></a><span class="lineno"> 421</span>  <span class="comment">// Multiple [NOT] EXISTS predicates</span></div> |
| <div class="line"><a name="l00422"></a><span class="lineno"> 422</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00423"></a><span class="lineno"> 423</span>  <span class="stringliteral">"%s (select * from functional.alltypessmall s where s.id = t.id) and "</span> +</div> |
| <div class="line"><a name="l00424"></a><span class="lineno"> 424</span>  <span class="stringliteral">"%s (select NULL from functional.alltypesagg g where t.int_col = g.int_col)"</span>,</div> |
| <div class="line"><a name="l00425"></a><span class="lineno"> 425</span>  op, op));</div> |
| <div class="line"><a name="l00426"></a><span class="lineno"> 426</span>  <span class="comment">// OR between two subqueries</span></div> |
| <div class="line"><a name="l00427"></a><span class="lineno"> 427</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00428"></a><span class="lineno"> 428</span>  <span class="stringliteral">"%s (select * from functional.alltypesagg a where a.id = t.id) or %s "</span> +</div> |
| <div class="line"><a name="l00429"></a><span class="lineno"> 429</span>  <span class="stringliteral">"(select * from functional.alltypessmall s where s.int_col = t.int_col)"</span>, op,</div> |
| <div class="line"><a name="l00430"></a><span class="lineno"> 430</span>  op), String.format(<span class="stringliteral">"Subqueries in OR predicates are not supported: %s "</span> +</div> |
| <div class="line"><a name="l00431"></a><span class="lineno"> 431</span>  <span class="stringliteral">"(SELECT * FROM functional.alltypesagg a WHERE a.id = t.id) OR %s (SELECT "</span> +</div> |
| <div class="line"><a name="l00432"></a><span class="lineno"> 432</span>  <span class="stringliteral">"* FROM functional.alltypessmall s WHERE s.int_col = t.int_col)"</span>,</div> |
| <div class="line"><a name="l00433"></a><span class="lineno"> 433</span>  op.toUpperCase(), op.toUpperCase()));</div> |
| <div class="line"><a name="l00434"></a><span class="lineno"> 434</span>  <span class="comment">// Complex correlation predicates</span></div> |
| <div class="line"><a name="l00435"></a><span class="lineno"> 435</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00436"></a><span class="lineno"> 436</span>  <span class="stringliteral">"%s (select * from functional.alltypesagg a where a.id = t.id + 1) and "</span> +</div> |
| <div class="line"><a name="l00437"></a><span class="lineno"> 437</span>  <span class="stringliteral">"%s (select 1 from functional.alltypes s where s.int_col + s.bigint_col = "</span> +</div> |
| <div class="line"><a name="l00438"></a><span class="lineno"> 438</span>  <span class="stringliteral">"t.bigint_col + 1)"</span>, op, op));</div> |
| <div class="line"><a name="l00439"></a><span class="lineno"> 439</span>  <span class="comment">// Correlated predicates</span></div> |
| <div class="line"><a name="l00440"></a><span class="lineno"> 440</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00441"></a><span class="lineno"> 441</span>  <span class="stringliteral">"%s (select * from functional.alltypesagg g where t.int_col = g.int_col "</span> +</div> |
| <div class="line"><a name="l00442"></a><span class="lineno"> 442</span>  <span class="stringliteral">"and t.bool_col = false)"</span>, op));</div> |
| <div class="line"><a name="l00443"></a><span class="lineno"> 443</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00444"></a><span class="lineno"> 444</span>  <span class="stringliteral">"%s (select id from functional.alltypessmall s where t.tinyint_col = "</span> +</div> |
| <div class="line"><a name="l00445"></a><span class="lineno"> 445</span>  <span class="stringliteral">"s.tinyint_col and t.bool_col)"</span>, op));</div> |
| <div class="line"><a name="l00446"></a><span class="lineno"> 446</span>  <span class="comment">// Multiple nesting levels</span></div> |
| <div class="line"><a name="l00447"></a><span class="lineno"> 447</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where %s "</span> +</div> |
| <div class="line"><a name="l00448"></a><span class="lineno"> 448</span>  <span class="stringliteral">"(select * from functional.alltypessmall s where t.id = s.id and %s "</span> +</div> |
| <div class="line"><a name="l00449"></a><span class="lineno"> 449</span>  <span class="stringliteral">"(select * from functional.alltypestiny g where g.int_col = s.int_col))"</span>,</div> |
| <div class="line"><a name="l00450"></a><span class="lineno"> 450</span>  op, op));</div> |
| <div class="line"><a name="l00451"></a><span class="lineno"> 451</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where %s "</span> +</div> |
| <div class="line"><a name="l00452"></a><span class="lineno"> 452</span>  <span class="stringliteral">"(select * from functional.alltypessmall s where t.id = s.id and %s "</span> +</div> |
| <div class="line"><a name="l00453"></a><span class="lineno"> 453</span>  <span class="stringliteral">"(select * from functional.alltypestiny g where g.bool_col = "</span> +</div> |
| <div class="line"><a name="l00454"></a><span class="lineno"> 454</span>  <span class="stringliteral">"s.bool_col))"</span>, op, op));</div> |
| <div class="line"><a name="l00455"></a><span class="lineno"> 455</span>  <span class="comment">// Correlated EXISTS subquery with a group by and aggregation</span></div> |
| <div class="line"><a name="l00456"></a><span class="lineno"> 456</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t "</span> +</div> |
| <div class="line"><a name="l00457"></a><span class="lineno"> 457</span>  <span class="stringliteral">"where %s (select id, count(*) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00458"></a><span class="lineno"> 458</span>  <span class="stringliteral">"t.id = g.id group by id)"</span>, op));</div> |
| <div class="line"><a name="l00459"></a><span class="lineno"> 459</span>  <span class="comment">// Correlated EXISTS subquery with an analytic function</span></div> |
| <div class="line"><a name="l00460"></a><span class="lineno"> 460</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00461"></a><span class="lineno"> 461</span>  <span class="stringliteral">"functional.alltypestiny t1 where %s (select min(bigint_col) over "</span> +</div> |
| <div class="line"><a name="l00462"></a><span class="lineno"> 462</span>  <span class="stringliteral">"(partition by bool_col) from functional.alltypessmall t2 where "</span> +</div> |
| <div class="line"><a name="l00463"></a><span class="lineno"> 463</span>  <span class="stringliteral">"t1.id = t2.id)"</span>, op));</div> |
| <div class="line"><a name="l00464"></a><span class="lineno"> 464</span>  <span class="comment">// Correlated EXISTS subquery with an analytic function and a group by</span></div> |
| <div class="line"><a name="l00465"></a><span class="lineno"> 465</span>  <span class="comment">// clause</span></div> |
| <div class="line"><a name="l00466"></a><span class="lineno"> 466</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00467"></a><span class="lineno"> 467</span>  <span class="stringliteral">"functional.alltypestiny t1 where exists (select min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00468"></a><span class="lineno"> 468</span>  <span class="stringliteral">"over (partition by bool_col) from functional.alltypessmall t2 "</span> +</div> |
| <div class="line"><a name="l00469"></a><span class="lineno"> 469</span>  <span class="stringliteral">"where t1.id = t2.id group by bigint_col, bool_col)"</span>, op));</div> |
| <div class="line"><a name="l00470"></a><span class="lineno"> 470</span> </div> |
| <div class="line"><a name="l00471"></a><span class="lineno"> 471</span>  String nullOps[] = {<span class="stringliteral">"is null"</span>, <span class="stringliteral">"is not null"</span>};</div> |
| <div class="line"><a name="l00472"></a><span class="lineno"> 472</span>  <span class="keywordflow">for</span> (String nullOp: nullOps) {</div> |
| <div class="line"><a name="l00473"></a><span class="lineno"> 473</span>  <span class="comment">// Uncorrelated EXISTS subquery in an IS [NOT] NULL predicate</span></div> |
| <div class="line"><a name="l00474"></a><span class="lineno"> 474</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where %s "</span> +</div> |
| <div class="line"><a name="l00475"></a><span class="lineno"> 475</span>  <span class="stringliteral">"(select * from functional.alltypestiny) %s and id < 5"</span>, op, nullOp));</div> |
| <div class="line"><a name="l00476"></a><span class="lineno"> 476</span>  <span class="comment">// Correlated EXISTS subquery in an IS [NOT] NULL predicate</span></div> |
| <div class="line"><a name="l00477"></a><span class="lineno"> 477</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00478"></a><span class="lineno"> 478</span>  <span class="stringliteral">"%s (select 1 from functional.alltypestiny s where t.id = s.id) "</span> +</div> |
| <div class="line"><a name="l00479"></a><span class="lineno"> 479</span>  <span class="stringliteral">"%s and t.bool_col = false"</span>, op, nullOp));</div> |
| <div class="line"><a name="l00480"></a><span class="lineno"> 480</span>  }</div> |
| <div class="line"><a name="l00481"></a><span class="lineno"> 481</span>  }</div> |
| <div class="line"><a name="l00482"></a><span class="lineno"> 482</span> </div> |
| <div class="line"><a name="l00483"></a><span class="lineno"> 483</span>  <span class="comment">// Uncorrelated EXISTS subquery with an analytic function</span></div> |
| <div class="line"><a name="l00484"></a><span class="lineno"> 484</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny t "</span> +</div> |
| <div class="line"><a name="l00485"></a><span class="lineno"> 485</span>  <span class="stringliteral">"where EXISTS (select id, min(int_col) over (partition by bool_col) "</span> +</div> |
| <div class="line"><a name="l00486"></a><span class="lineno"> 486</span>  <span class="stringliteral">"from functional.alltypesagg a where bigint_col < 10)"</span>);</div> |
| <div class="line"><a name="l00487"></a><span class="lineno"> 487</span> </div> |
| <div class="line"><a name="l00488"></a><span class="lineno"> 488</span>  <span class="comment">// Different non-equi comparison operators in the correlated predicate</span></div> |
| <div class="line"><a name="l00489"></a><span class="lineno"> 489</span>  String nonEquiCmpOperators[] = {<span class="stringliteral">"!="</span>, <span class="stringliteral">"<="</span>, <span class="stringliteral">">="</span>, <span class="stringliteral">">"</span>, <span class="stringliteral">"<"</span>};</div> |
| <div class="line"><a name="l00490"></a><span class="lineno"> 490</span>  <span class="keywordflow">for</span> (String cmpOp: nonEquiCmpOperators) {</div> |
| <div class="line"><a name="l00491"></a><span class="lineno"> 491</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t where exists "</span> +</div> |
| <div class="line"><a name="l00492"></a><span class="lineno"> 492</span>  <span class="stringliteral">"(select * from functional.alltypesagg a where t.id %s a.id)"</span>, cmpOp),</div> |
| <div class="line"><a name="l00493"></a><span class="lineno"> 493</span>  String.format(<span class="stringliteral">"Unsupported predicate with subquery: EXISTS (SELECT * FROM "</span> +</div> |
| <div class="line"><a name="l00494"></a><span class="lineno"> 494</span>  <span class="stringliteral">"functional.alltypesagg a WHERE t.id %s a.id)"</span>, cmpOp));</div> |
| <div class="line"><a name="l00495"></a><span class="lineno"> 495</span>  }</div> |
| <div class="line"><a name="l00496"></a><span class="lineno"> 496</span>  <span class="comment">// Uncorrelated EXISTS in a query with GROUP BY</span></div> |
| <div class="line"><a name="l00497"></a><span class="lineno"> 497</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id, count(*) from functional.alltypes t "</span> +</div> |
| <div class="line"><a name="l00498"></a><span class="lineno"> 498</span>  <span class="stringliteral">"where exists (select 1 from functional.alltypestiny where id < 5) group by id"</span>);</div> |
| <div class="line"><a name="l00499"></a><span class="lineno"> 499</span>  <span class="comment">// Subquery with a correlated predicate that cannot be transformed into an</span></div> |
| <div class="line"><a name="l00500"></a><span class="lineno"> 500</span>  <span class="comment">// equi-join</span></div> |
| <div class="line"><a name="l00501"></a><span class="lineno"> 501</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00502"></a><span class="lineno"> 502</span>  <span class="stringliteral">"exists (select int_col + 1 from functional.alltypessmall s where "</span> +</div> |
| <div class="line"><a name="l00503"></a><span class="lineno"> 503</span>  <span class="stringliteral">"t.int_col = 10)"</span>, <span class="stringliteral">"Unsupported predicate with subquery: EXISTS "</span> +</div> |
| <div class="line"><a name="l00504"></a><span class="lineno"> 504</span>  <span class="stringliteral">"(SELECT int_col + 1 FROM functional.alltypessmall s WHERE t.int_col = 10)"</span>);</div> |
| <div class="line"><a name="l00505"></a><span class="lineno"> 505</span>  <span class="comment">// Uncorrelated EXISTS subquery</span></div> |
| <div class="line"><a name="l00506"></a><span class="lineno"> 506</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny where exists "</span> +</div> |
| <div class="line"><a name="l00507"></a><span class="lineno"> 507</span>  <span class="stringliteral">"(select * from functional.alltypesagg where id < 10)"</span>);</div> |
| <div class="line"><a name="l00508"></a><span class="lineno"> 508</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny where exists "</span> +</div> |
| <div class="line"><a name="l00509"></a><span class="lineno"> 509</span>  <span class="stringliteral">"(select id from functional.alltypessmall where bool_col = false)"</span>);</div> |
| <div class="line"><a name="l00510"></a><span class="lineno"> 510</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select 1 from functional.alltypestiny t where exists "</span> +</div> |
| <div class="line"><a name="l00511"></a><span class="lineno"> 511</span>  <span class="stringliteral">"(select 1 from functional.alltypessmall where id < 5)"</span>);</div> |
| <div class="line"><a name="l00512"></a><span class="lineno"> 512</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select 1 + 1 from functional.alltypestiny where exists "</span> +</div> |
| <div class="line"><a name="l00513"></a><span class="lineno"> 513</span>  <span class="stringliteral">"(select null from functional.alltypessmall where id != 5)"</span>);</div> |
| <div class="line"><a name="l00514"></a><span class="lineno"> 514</span>  <span class="comment">// Multiple nesting levels with uncorrelated EXISTS</span></div> |
| <div class="line"><a name="l00515"></a><span class="lineno"> 515</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypes where exists "</span> +</div> |
| <div class="line"><a name="l00516"></a><span class="lineno"> 516</span>  <span class="stringliteral">"(select id from functional.alltypestiny where int_col < 10 and exists ("</span> +</div> |
| <div class="line"><a name="l00517"></a><span class="lineno"> 517</span>  <span class="stringliteral">"select id from functional.alltypessmall where bool_col = true))"</span>);</div> |
| <div class="line"><a name="l00518"></a><span class="lineno"> 518</span>  <span class="comment">// Uncorrelated NOT EXISTS subquery</span></div> |
| <div class="line"><a name="l00519"></a><span class="lineno"> 519</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny where not exists "</span> +</div> |
| <div class="line"><a name="l00520"></a><span class="lineno"> 520</span>  <span class="stringliteral">"(select 1 from functional.alltypessmall where bool_col = false)"</span>,</div> |
| <div class="line"><a name="l00521"></a><span class="lineno"> 521</span>  <span class="stringliteral">"Unsupported uncorrelated NOT EXISTS subquery: SELECT 1 FROM "</span> +</div> |
| <div class="line"><a name="l00522"></a><span class="lineno"> 522</span>  <span class="stringliteral">"functional.alltypessmall WHERE bool_col = FALSE"</span>);</div> |
| <div class="line"><a name="l00523"></a><span class="lineno"> 523</span> </div> |
| <div class="line"><a name="l00524"></a><span class="lineno"> 524</span>  <span class="comment">// Subquery references an explicit alias from the outer block in the FROM</span></div> |
| <div class="line"><a name="l00525"></a><span class="lineno"> 525</span>  <span class="comment">// clause</span></div> |
| <div class="line"><a name="l00526"></a><span class="lineno"> 526</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00527"></a><span class="lineno"> 527</span>  <span class="stringliteral">"exists (select * from t)"</span>, <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00528"></a><span class="lineno"> 528</span>  <span class="comment">// Uncorrelated subquery with no FROM clause</span></div> |
| <div class="line"><a name="l00529"></a><span class="lineno"> 529</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes where exists (select 1,2)"</span>);</div> |
| <div class="line"><a name="l00530"></a><span class="lineno"> 530</span>  <span class="comment">// EXISTS subquery in a binary predicate</span></div> |
| <div class="line"><a name="l00531"></a><span class="lineno"> 531</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00532"></a><span class="lineno"> 532</span>  <span class="stringliteral">"if(exists(select * from functional.alltypesagg), 1, 0) = 1"</span>,</div> |
| <div class="line"><a name="l00533"></a><span class="lineno"> 533</span>  <span class="stringliteral">"EXISTS subquery predicates are not supported in binary predicates: "</span> +</div> |
| <div class="line"><a name="l00534"></a><span class="lineno"> 534</span>  <span class="stringliteral">"if(EXISTS (SELECT * FROM functional.alltypesagg), 1, 0) = 1"</span>);</div> |
| <div class="line"><a name="l00535"></a><span class="lineno"> 535</span>  <span class="comment">// Correlated subquery with a LIMIT clause</span></div> |
| <div class="line"><a name="l00536"></a><span class="lineno"> 536</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypes t where exists "</span> +</div> |
| <div class="line"><a name="l00537"></a><span class="lineno"> 537</span>  <span class="stringliteral">"(select 1 from functional.alltypesagg g where t.id = g.id limit 1)"</span>);</div> |
| <div class="line"><a name="l00538"></a><span class="lineno"> 538</span> </div> |
| <div class="line"><a name="l00539"></a><span class="lineno"> 539</span>  <span class="comment">// Column labels may conflict after the rewrite as an inline view</span></div> |
| <div class="line"><a name="l00540"></a><span class="lineno"> 540</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select int_col from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00541"></a><span class="lineno"> 541</span>  <span class="stringliteral">"exists (select int_col from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00542"></a><span class="lineno"> 542</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select int_col from functional.alltypestiny a where "</span> +</div> |
| <div class="line"><a name="l00543"></a><span class="lineno"> 543</span>  <span class="stringliteral">"not exists (select 1 as int_col from functional.alltypesagg b "</span> +</div> |
| <div class="line"><a name="l00544"></a><span class="lineno"> 544</span>  <span class="stringliteral">"where a.int_col = b.int_col)"</span>);</div> |
| <div class="line"><a name="l00545"></a><span class="lineno"> 545</span>  }</div> |
| <div class="line"><a name="l00546"></a><span class="lineno"> 546</span> </div> |
| <div class="line"><a name="l00547"></a><span class="lineno"> 547</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00548"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#afff235518baeae3caf4f0d6a239c3abc"> 548</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#afff235518baeae3caf4f0d6a239c3abc">TestAggregateSubqueries</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00549"></a><span class="lineno"> 549</span>  String aggFns[] = {<span class="stringliteral">"count(id)"</span>, <span class="stringliteral">"max(id)"</span>, <span class="stringliteral">"min(id)"</span>, <span class="stringliteral">"avg(id)"</span>, <span class="stringliteral">"sum(id)"</span>};</div> |
| <div class="line"><a name="l00550"></a><span class="lineno"> 550</span>  <span class="keywordflow">for</span> (String aggFn: aggFns) {</div> |
| <div class="line"><a name="l00551"></a><span class="lineno"> 551</span>  <span class="keywordflow">for</span> (String cmpOp: <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12">cmpOperators</a>) {</div> |
| <div class="line"><a name="l00552"></a><span class="lineno"> 552</span>  <span class="comment">// Uncorrelated</span></div> |
| <div class="line"><a name="l00553"></a><span class="lineno"> 553</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where id %s "</span> +</div> |
| <div class="line"><a name="l00554"></a><span class="lineno"> 554</span>  <span class="stringliteral">"(select %s from functional.alltypestiny)"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00555"></a><span class="lineno"> 555</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00556"></a><span class="lineno"> 556</span>  <span class="stringliteral">"(select %s from functional.alltypestiny) %s id"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00557"></a><span class="lineno"> 557</span>  <span class="comment">// Uncorrelated with constant expr</span></div> |
| <div class="line"><a name="l00558"></a><span class="lineno"> 558</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where 10 %s "</span> +</div> |
| <div class="line"><a name="l00559"></a><span class="lineno"> 559</span>  <span class="stringliteral">"(select %s from functional.alltypestiny)"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00560"></a><span class="lineno"> 560</span>  <span class="comment">// Uncorrelated with complex cmp expr</span></div> |
| <div class="line"><a name="l00561"></a><span class="lineno"> 561</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where id + 10 %s "</span> +</div> |
| <div class="line"><a name="l00562"></a><span class="lineno"> 562</span>  <span class="stringliteral">"(select %s from functional.alltypestiny)"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00563"></a><span class="lineno"> 563</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where id + 10 %s "</span> +</div> |
| <div class="line"><a name="l00564"></a><span class="lineno"> 564</span>  <span class="stringliteral">"(select %s + 1 from functional.alltypestiny)"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00565"></a><span class="lineno"> 565</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00566"></a><span class="lineno"> 566</span>  <span class="stringliteral">"(select %s + 1 from functional.alltypestiny) %s id + 10"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00567"></a><span class="lineno"> 567</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00568"></a><span class="lineno"> 568</span>  <span class="stringliteral">"1 + (select %s - 1 from functional.alltypestiny where bool_col = false) "</span> +</div> |
| <div class="line"><a name="l00569"></a><span class="lineno"> 569</span>  <span class="stringliteral">"%s id - 10"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00570"></a><span class="lineno"> 570</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t1 where "</span> +</div> |
| <div class="line"><a name="l00571"></a><span class="lineno"> 571</span>  <span class="stringliteral">"(select %s from functional.alltypes) - t1.id %s "</span> +</div> |
| <div class="line"><a name="l00572"></a><span class="lineno"> 572</span>  <span class="stringliteral">"t1.tinyint_col"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00573"></a><span class="lineno"> 573</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t1 where "</span> +</div> |
| <div class="line"><a name="l00574"></a><span class="lineno"> 574</span>  <span class="stringliteral">"(select %s from functional.alltypes) + t1.id %s "</span> +</div> |
| <div class="line"><a name="l00575"></a><span class="lineno"> 575</span>  <span class="stringliteral">"t1.tinyint_col + t1.bigint_col + 1"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00576"></a><span class="lineno"> 576</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypestiny t1 inner "</span> +</div> |
| <div class="line"><a name="l00577"></a><span class="lineno"> 577</span>  <span class="stringliteral">"join functional.alltypessmall t2 on t1.id = t2.id where "</span> +</div> |
| <div class="line"><a name="l00578"></a><span class="lineno"> 578</span>  <span class="stringliteral">"(select %s from functional.alltypes) + 1 %s t1.int_col + t2.int_col"</span>,</div> |
| <div class="line"><a name="l00579"></a><span class="lineno"> 579</span>  aggFn, cmpOp));</div> |
| <div class="line"><a name="l00580"></a><span class="lineno"> 580</span> </div> |
| <div class="line"><a name="l00581"></a><span class="lineno"> 581</span>  <span class="comment">// Correlated</span></div> |
| <div class="line"><a name="l00582"></a><span class="lineno"> 582</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00583"></a><span class="lineno"> 583</span>  <span class="stringliteral">"id %s (select %s from functional.alltypestiny t where t.bool_col = false "</span> +</div> |
| <div class="line"><a name="l00584"></a><span class="lineno"> 584</span>  <span class="stringliteral">"and a.int_col = t.int_col) and a.bigint_col < 10"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00585"></a><span class="lineno"> 585</span>  <span class="comment">// Correlated with constant expr</span></div> |
| <div class="line"><a name="l00586"></a><span class="lineno"> 586</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00587"></a><span class="lineno"> 587</span>  <span class="stringliteral">"10 %s (select %s from functional.alltypestiny t where t.bool_col = false "</span> +</div> |
| <div class="line"><a name="l00588"></a><span class="lineno"> 588</span>  <span class="stringliteral">"and a.int_col = t.int_col) and a.bigint_col < 10"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00589"></a><span class="lineno"> 589</span> </div> |
| <div class="line"><a name="l00590"></a><span class="lineno"> 590</span>  <span class="comment">// Correlated with complex expr</span></div> |
| <div class="line"><a name="l00591"></a><span class="lineno"> 591</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00592"></a><span class="lineno"> 592</span>  <span class="stringliteral">"id - 10 %s (select %s from functional.alltypestiny t where t.bool_col = "</span> +</div> |
| <div class="line"><a name="l00593"></a><span class="lineno"> 593</span>  <span class="stringliteral">"false and a.int_col = t.int_col) and a.bigint_col < 10"</span>, cmpOp, aggFn));</div> |
| <div class="line"><a name="l00594"></a><span class="lineno"> 594</span> </div> |
| <div class="line"><a name="l00595"></a><span class="lineno"> 595</span>  <span class="comment">// count is not supported in select list expressions of a correlated subquery</span></div> |
| <div class="line"><a name="l00596"></a><span class="lineno"> 596</span>  <span class="keywordflow">if</span> (aggFn.equals(<span class="stringliteral">"count(id)"</span>)) {</div> |
| <div class="line"><a name="l00597"></a><span class="lineno"> 597</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00598"></a><span class="lineno"> 598</span>  <span class="stringliteral">"id - 10 %s (select 1 + %s from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00599"></a><span class="lineno"> 599</span>  <span class="stringliteral">"t.bool_col = false and a.int_col = t.int_col) and a.bigint_col < 10"</span>,</div> |
| <div class="line"><a name="l00600"></a><span class="lineno"> 600</span>  cmpOp, aggFn), String.format(<span class="stringliteral">"Aggregate function that returns non-null "</span> +</div> |
| <div class="line"><a name="l00601"></a><span class="lineno"> 601</span>  <span class="stringliteral">"on an empty input cannot be used in an expression in a "</span> +</div> |
| <div class="line"><a name="l00602"></a><span class="lineno"> 602</span>  <span class="stringliteral">"correlated subquery's select list: (SELECT 1 + %s FROM "</span> +</div> |
| <div class="line"><a name="l00603"></a><span class="lineno"> 603</span>  <span class="stringliteral">"functional.alltypestiny t WHERE t.bool_col = FALSE AND a.int_col = "</span> +</div> |
| <div class="line"><a name="l00604"></a><span class="lineno"> 604</span>  <span class="stringliteral">"t.int_col)"</span>, aggFn));</div> |
| <div class="line"><a name="l00605"></a><span class="lineno"> 605</span>  } <span class="keywordflow">else</span> {</div> |
| <div class="line"><a name="l00606"></a><span class="lineno"> 606</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00607"></a><span class="lineno"> 607</span>  <span class="stringliteral">"id - 10 %s (select 1 + %s from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00608"></a><span class="lineno"> 608</span>  <span class="stringliteral">"t.bool_col = false and a.int_col = t.int_col) and a.bigint_col < 10"</span>,</div> |
| <div class="line"><a name="l00609"></a><span class="lineno"> 609</span>  cmpOp, aggFn));</div> |
| <div class="line"><a name="l00610"></a><span class="lineno"> 610</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00611"></a><span class="lineno"> 611</span>  <span class="stringliteral">"(select 1 + %s from functional.alltypestiny t where t.bool_col = false "</span> +</div> |
| <div class="line"><a name="l00612"></a><span class="lineno"> 612</span>  <span class="stringliteral">"and a.int_col = t.int_col) %s id - 10 and a.bigint_col < 10"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00613"></a><span class="lineno"> 613</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00614"></a><span class="lineno"> 614</span>  <span class="stringliteral">"1 + (select 1 + %s from functional.alltypestiny t where t.id = a.id "</span> +</div> |
| <div class="line"><a name="l00615"></a><span class="lineno"> 615</span>  <span class="stringliteral">"and t.int_col < 10) %s a.id + 10"</span>, aggFn, cmpOp));</div> |
| <div class="line"><a name="l00616"></a><span class="lineno"> 616</span>  }</div> |
| <div class="line"><a name="l00617"></a><span class="lineno"> 617</span>  }</div> |
| <div class="line"><a name="l00618"></a><span class="lineno"> 618</span>  }</div> |
| <div class="line"><a name="l00619"></a><span class="lineno"> 619</span>  <span class="comment">// Column labels may conflict after the rewrite as an inline view</span></div> |
| <div class="line"><a name="l00620"></a><span class="lineno"> 620</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select 1 from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00621"></a><span class="lineno"> 621</span>  <span class="stringliteral">"int_col = (select count(int_col) as int_col from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00622"></a><span class="lineno"> 622</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select 1 from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00623"></a><span class="lineno"> 623</span>  <span class="stringliteral">"int_col in (select sum(int_col) as int_col from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00624"></a><span class="lineno"> 624</span> </div> |
| <div class="line"><a name="l00625"></a><span class="lineno"> 625</span>  <span class="keywordflow">for</span> (String cmpOp: <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12">cmpOperators</a>) {</div> |
| <div class="line"><a name="l00626"></a><span class="lineno"> 626</span>  <span class="comment">// Multiple tables in parent and subquery query blocks</span></div> |
| <div class="line"><a name="l00627"></a><span class="lineno"> 627</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes t, "</span> +</div> |
| <div class="line"><a name="l00628"></a><span class="lineno"> 628</span>  <span class="stringliteral">"functional.alltypesagg a where a.id = t.id and t.int_col %s ("</span> +</div> |
| <div class="line"><a name="l00629"></a><span class="lineno"> 629</span>  <span class="stringliteral">"select max(g.int_col) from functional.alltypestiny g left outer join "</span> +</div> |
| <div class="line"><a name="l00630"></a><span class="lineno"> 630</span>  <span class="stringliteral">"functional.alltypessmall s on s.bigint_col = g.bigint_col where "</span> +</div> |
| <div class="line"><a name="l00631"></a><span class="lineno"> 631</span>  <span class="stringliteral">"g.bool_col = false) and t.bool_col = true"</span>, cmpOp));</div> |
| <div class="line"><a name="l00632"></a><span class="lineno"> 632</span>  <span class="comment">// Group by in the parent query block</span></div> |
| <div class="line"><a name="l00633"></a><span class="lineno"> 633</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select t.int_col, count(*) from "</span> +</div> |
| <div class="line"><a name="l00634"></a><span class="lineno"> 634</span>  <span class="stringliteral">"functional.alltypes t left outer join functional.alltypesagg g "</span> +</div> |
| <div class="line"><a name="l00635"></a><span class="lineno"> 635</span>  <span class="stringliteral">"on t.id = g.id where t.bigint_col %s (select count(*) from "</span> +</div> |
| <div class="line"><a name="l00636"></a><span class="lineno"> 636</span>  <span class="stringliteral">"functional.alltypestiny a where a.int_col < 10) and g.bool_col = false "</span> +</div> |
| <div class="line"><a name="l00637"></a><span class="lineno"> 637</span>  <span class="stringliteral">"group by t.int_col having count(*) < 100"</span>, cmpOp));</div> |
| <div class="line"><a name="l00638"></a><span class="lineno"> 638</span>  <span class="comment">// Multiple binary predicates</span></div> |
| <div class="line"><a name="l00639"></a><span class="lineno"> 639</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00640"></a><span class="lineno"> 640</span>  <span class="stringliteral">"int_col %s (select min(int_col) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00641"></a><span class="lineno"> 641</span>  <span class="stringliteral">"g.bool_col = false) and int_col %s (select max(int_col) from "</span> +</div> |
| <div class="line"><a name="l00642"></a><span class="lineno"> 642</span>  <span class="stringliteral">"functional.alltypesagg g where g.bool_col = true) and a.tinyint_col = 10"</span>,</div> |
| <div class="line"><a name="l00643"></a><span class="lineno"> 643</span>  cmpOp, cmpOp));</div> |
| <div class="line"><a name="l00644"></a><span class="lineno"> 644</span>  <span class="comment">// Multiple nesting levels</span></div> |
| <div class="line"><a name="l00645"></a><span class="lineno"> 645</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00646"></a><span class="lineno"> 646</span>  <span class="stringliteral">"tinyint_col %s (select count(*) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00647"></a><span class="lineno"> 647</span>  <span class="stringliteral">"g.int_col %s (select max(int_col) from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00648"></a><span class="lineno"> 648</span>  <span class="stringliteral">"t.id = g.id) and g.id = a.id and g.bool_col = false) and a.int_col < 10"</span>,</div> |
| <div class="line"><a name="l00649"></a><span class="lineno"> 649</span>  cmpOp, cmpOp));</div> |
| <div class="line"><a name="l00650"></a><span class="lineno"> 650</span>  <span class="comment">// NOT with a binary subquery predicate</span></div> |
| <div class="line"><a name="l00651"></a><span class="lineno"> 651</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypes a where "</span> +</div> |
| <div class="line"><a name="l00652"></a><span class="lineno"> 652</span>  <span class="stringliteral">"not (int_col %s (select max(int_col) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00653"></a><span class="lineno"> 653</span>  <span class="stringliteral">"a.id = g.id and g.bool_col = false))"</span>, cmpOp));</div> |
| <div class="line"><a name="l00654"></a><span class="lineno"> 654</span>  <span class="comment">// Subquery returns a scalar (no FORM clause)</span></div> |
| <div class="line"><a name="l00655"></a><span class="lineno"> 655</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select id from functional.alltypestiny where id %s "</span> +</div> |
| <div class="line"><a name="l00656"></a><span class="lineno"> 656</span>  <span class="stringliteral">"(select 1)"</span>, cmpOp));</div> |
| <div class="line"><a name="l00657"></a><span class="lineno"> 657</span>  <span class="comment">// Incompatible comparison types</span></div> |
| <div class="line"><a name="l00658"></a><span class="lineno"> 658</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(String.format(<span class="stringliteral">"select id from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00659"></a><span class="lineno"> 659</span>  <span class="stringliteral">"int_col %s (select max(timestamp_col) from functional.alltypessmall)"</span>, cmpOp),</div> |
| <div class="line"><a name="l00660"></a><span class="lineno"> 660</span>  String.format(<span class="stringliteral">"operands of type INT and TIMESTAMP are not comparable: "</span> +</div> |
| <div class="line"><a name="l00661"></a><span class="lineno"> 661</span>  <span class="stringliteral">"int_col %s (SELECT max(timestamp_col) FROM functional.alltypessmall)"</span>, cmpOp));</div> |
| <div class="line"><a name="l00662"></a><span class="lineno"> 662</span>  <span class="comment">// Distinct in the outer select block</span></div> |
| <div class="line"><a name="l00663"></a><span class="lineno"> 663</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select distinct id from functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00664"></a><span class="lineno"> 664</span>  <span class="stringliteral">"where 100 %s (select count(*) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00665"></a><span class="lineno"> 665</span>  <span class="stringliteral">"a.int_col %s g.int_col) and a.bool_col = false"</span>, cmpOp, cmpOp));</div> |
| <div class="line"><a name="l00666"></a><span class="lineno"> 666</span>  }</div> |
| <div class="line"><a name="l00667"></a><span class="lineno"> 667</span> </div> |
| <div class="line"><a name="l00668"></a><span class="lineno"> 668</span>  <span class="comment">// Subquery returns multiple rows</span></div> |
| <div class="line"><a name="l00669"></a><span class="lineno"> 669</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00670"></a><span class="lineno"> 670</span>  <span class="stringliteral">"(select max(id) from functional.alltypes) = "</span> +</div> |
| <div class="line"><a name="l00671"></a><span class="lineno"> 671</span>  <span class="stringliteral">"(select id from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00672"></a><span class="lineno"> 672</span>  <span class="stringliteral">"Subquery must return a single row: "</span> +</div> |
| <div class="line"><a name="l00673"></a><span class="lineno"> 673</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00674"></a><span class="lineno"> 674</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col = "</span> +</div> |
| <div class="line"><a name="l00675"></a><span class="lineno"> 675</span>  <span class="stringliteral">"(select int_col from functional.alltypessmall limit 2)"</span>,</div> |
| <div class="line"><a name="l00676"></a><span class="lineno"> 676</span>  <span class="stringliteral">"Subquery must return a single row: "</span> +</div> |
| <div class="line"><a name="l00677"></a><span class="lineno"> 677</span>  <span class="stringliteral">"(SELECT int_col FROM functional.alltypessmall LIMIT 2)"</span>);</div> |
| <div class="line"><a name="l00678"></a><span class="lineno"> 678</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny where int_col = "</span> +</div> |
| <div class="line"><a name="l00679"></a><span class="lineno"> 679</span>  <span class="stringliteral">"(select id from functional.alltypessmall)"</span>,</div> |
| <div class="line"><a name="l00680"></a><span class="lineno"> 680</span>  <span class="stringliteral">"Subquery must return a single row: "</span> +</div> |
| <div class="line"><a name="l00681"></a><span class="lineno"> 681</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypessmall)"</span>);</div> |
| <div class="line"><a name="l00682"></a><span class="lineno"> 682</span> </div> |
| <div class="line"><a name="l00683"></a><span class="lineno"> 683</span>  <span class="comment">// Subquery returns multiple columns</span></div> |
| <div class="line"><a name="l00684"></a><span class="lineno"> 684</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny where int_col = "</span> +</div> |
| <div class="line"><a name="l00685"></a><span class="lineno"> 685</span>  <span class="stringliteral">"(select id, int_col from functional.alltypessmall)"</span>,</div> |
| <div class="line"><a name="l00686"></a><span class="lineno"> 686</span>  <span class="stringliteral">"Subquery must return a single row: "</span> +</div> |
| <div class="line"><a name="l00687"></a><span class="lineno"> 687</span>  <span class="stringliteral">"(SELECT id, int_col FROM functional.alltypessmall)"</span>);</div> |
| <div class="line"><a name="l00688"></a><span class="lineno"> 688</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny where id in "</span> +</div> |
| <div class="line"><a name="l00689"></a><span class="lineno"> 689</span>  <span class="stringliteral">"(select * from (values(1,2)) as t)"</span>,</div> |
| <div class="line"><a name="l00690"></a><span class="lineno"> 690</span>  <span class="stringliteral">"Subquery must return a single column: (SELECT * FROM (VALUES(1, 2)) t)"</span>);</div> |
| <div class="line"><a name="l00691"></a><span class="lineno"> 691</span> </div> |
| <div class="line"><a name="l00692"></a><span class="lineno"> 692</span>  <span class="comment">// Subquery returns multiple columns due to a group by clause</span></div> |
| <div class="line"><a name="l00693"></a><span class="lineno"> 693</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny where int_col = "</span> +</div> |
| <div class="line"><a name="l00694"></a><span class="lineno"> 694</span>  <span class="stringliteral">"(select int_col, count(*) from functional.alltypessmall group by int_col)"</span>,</div> |
| <div class="line"><a name="l00695"></a><span class="lineno"> 695</span>  <span class="stringliteral">"Subquery must return a single row: "</span> +</div> |
| <div class="line"><a name="l00696"></a><span class="lineno"> 696</span>  <span class="stringliteral">"(SELECT int_col, count(*) FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00697"></a><span class="lineno"> 697</span>  <span class="stringliteral">"GROUP BY int_col)"</span>);</div> |
| <div class="line"><a name="l00698"></a><span class="lineno"> 698</span> </div> |
| <div class="line"><a name="l00699"></a><span class="lineno"> 699</span>  <span class="comment">// Outer join with a table from the outer block using an explicit alias</span></div> |
| <div class="line"><a name="l00700"></a><span class="lineno"> 700</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col = "</span> +</div> |
| <div class="line"><a name="l00701"></a><span class="lineno"> 701</span>  <span class="stringliteral">"(select count(*) from functional.alltypessmall s left outer join t "</span> +</div> |
| <div class="line"><a name="l00702"></a><span class="lineno"> 702</span>  <span class="stringliteral">"on (t.id = s.id))"</span>, <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00703"></a><span class="lineno"> 703</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col = "</span> +</div> |
| <div class="line"><a name="l00704"></a><span class="lineno"> 704</span>  <span class="stringliteral">"(select count(*) from functional.alltypessmall s right outer join t "</span> +</div> |
| <div class="line"><a name="l00705"></a><span class="lineno"> 705</span>  <span class="stringliteral">"on (t.id = s.id))"</span>, <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00706"></a><span class="lineno"> 706</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col = "</span> +</div> |
| <div class="line"><a name="l00707"></a><span class="lineno"> 707</span>  <span class="stringliteral">"(select count(*) from functional.alltypessmall s full outer join t "</span> +</div> |
| <div class="line"><a name="l00708"></a><span class="lineno"> 708</span>  <span class="stringliteral">"on (t.id = s.id))"</span>, <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00709"></a><span class="lineno"> 709</span> </div> |
| <div class="line"><a name="l00710"></a><span class="lineno"> 710</span>  <span class="comment">// Multiple subqueries in a binary predicate</span></div> |
| <div class="line"><a name="l00711"></a><span class="lineno"> 711</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00712"></a><span class="lineno"> 712</span>  <span class="stringliteral">"(select count(*) from functional.alltypessmall) = "</span> +</div> |
| <div class="line"><a name="l00713"></a><span class="lineno"> 713</span>  <span class="stringliteral">"(select count(*) from functional.alltypesagg)"</span>, <span class="stringliteral">"Multiple subqueries are not "</span> +</div> |
| <div class="line"><a name="l00714"></a><span class="lineno"> 714</span>  <span class="stringliteral">"supported in binary predicates: (SELECT count(*) FROM "</span> +</div> |
| <div class="line"><a name="l00715"></a><span class="lineno"> 715</span>  <span class="stringliteral">"functional.alltypessmall) = (SELECT count(*) FROM functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00716"></a><span class="lineno"> 716</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00717"></a><span class="lineno"> 717</span>  <span class="stringliteral">"(select max(id) from functional.alltypessmall) + "</span> +</div> |
| <div class="line"><a name="l00718"></a><span class="lineno"> 718</span>  <span class="stringliteral">"(select min(id) from functional.alltypessmall) - "</span> +</div> |
| <div class="line"><a name="l00719"></a><span class="lineno"> 719</span>  <span class="stringliteral">"(select count(id) from functional.alltypessmall) < 1000"</span>,</div> |
| <div class="line"><a name="l00720"></a><span class="lineno"> 720</span>  <span class="stringliteral">"Multiple subqueries are not supported in binary predicates: (SELECT max(id) "</span> +</div> |
| <div class="line"><a name="l00721"></a><span class="lineno"> 721</span>  <span class="stringliteral">"FROM functional.alltypessmall) + (SELECT min(id) FROM "</span> +</div> |
| <div class="line"><a name="l00722"></a><span class="lineno"> 722</span>  <span class="stringliteral">"functional.alltypessmall) - (SELECT count(id) FROM functional.alltypessmall) "</span> +</div> |
| <div class="line"><a name="l00723"></a><span class="lineno"> 723</span>  <span class="stringliteral">"< 1000"</span>);</div> |
| <div class="line"><a name="l00724"></a><span class="lineno"> 724</span> </div> |
| <div class="line"><a name="l00725"></a><span class="lineno"> 725</span>  <span class="comment">// Comparison between invalid types</span></div> |
| <div class="line"><a name="l00726"></a><span class="lineno"> 726</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00727"></a><span class="lineno"> 727</span>  <span class="stringliteral">"(select max(string_col) from functional.alltypesagg) = 1"</span>,</div> |
| <div class="line"><a name="l00728"></a><span class="lineno"> 728</span>  <span class="stringliteral">"operands of type STRING and TINYINT are not comparable: (SELECT "</span> +</div> |
| <div class="line"><a name="l00729"></a><span class="lineno"> 729</span>  <span class="stringliteral">"max(string_col) FROM functional.alltypesagg) = 1"</span>);</div> |
| <div class="line"><a name="l00730"></a><span class="lineno"> 730</span> </div> |
| <div class="line"><a name="l00731"></a><span class="lineno"> 731</span>  <span class="comment">// Aggregate subquery with a LIMIT 1 clause</span></div> |
| <div class="line"><a name="l00732"></a><span class="lineno"> 732</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where int_col = "</span> +</div> |
| <div class="line"><a name="l00733"></a><span class="lineno"> 733</span>  <span class="stringliteral">"(select int_col from functional.alltypessmall limit 1)"</span>);</div> |
| <div class="line"><a name="l00734"></a><span class="lineno"> 734</span>  <span class="comment">// Correlated aggregate suquery with correlated predicate that can't be</span></div> |
| <div class="line"><a name="l00735"></a><span class="lineno"> 735</span>  <span class="comment">// transformed into an equi-join</span></div> |
| <div class="line"><a name="l00736"></a><span class="lineno"> 736</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00737"></a><span class="lineno"> 737</span>  <span class="stringliteral">"1 < (select sum(int_col) from functional.alltypessmall s where "</span> +</div> |
| <div class="line"><a name="l00738"></a><span class="lineno"> 738</span>  <span class="stringliteral">"t.id < 10)"</span>);</div> |
| <div class="line"><a name="l00739"></a><span class="lineno"> 739</span>  <span class="comment">// Aggregate subqueries in an IS [NOT] NULL predicate</span></div> |
| <div class="line"><a name="l00740"></a><span class="lineno"> 740</span>  String nullOps[] = {<span class="stringliteral">"is null"</span>, <span class="stringliteral">"is not null"</span>};</div> |
| <div class="line"><a name="l00741"></a><span class="lineno"> 741</span>  <span class="keywordflow">for</span> (String aggFn: aggFns) {</div> |
| <div class="line"><a name="l00742"></a><span class="lineno"> 742</span>  <span class="keywordflow">for</span> (String nullOp: nullOps) {</div> |
| <div class="line"><a name="l00743"></a><span class="lineno"> 743</span>  <span class="comment">// Uncorrelated aggregate subquery</span></div> |
| <div class="line"><a name="l00744"></a><span class="lineno"> 744</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l00745"></a><span class="lineno"> 745</span>  <span class="stringliteral">"(select %s from functional.alltypessmall where bool_col = false) "</span> +</div> |
| <div class="line"><a name="l00746"></a><span class="lineno"> 746</span>  <span class="stringliteral">"%s and int_col < 10"</span>, aggFn, nullOp));</div> |
| <div class="line"><a name="l00747"></a><span class="lineno"> 747</span>  <span class="comment">// Correlated aggregate subquery</span></div> |
| <div class="line"><a name="l00748"></a><span class="lineno"> 748</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00749"></a><span class="lineno"> 749</span>  <span class="stringliteral">"(select %s from functional.alltypessmall s where s.id = t.id "</span> +</div> |
| <div class="line"><a name="l00750"></a><span class="lineno"> 750</span>  <span class="stringliteral">"and s.bool_col = false) %s and bool_col = true"</span>, aggFn, nullOp));</div> |
| <div class="line"><a name="l00751"></a><span class="lineno"> 751</span>  }</div> |
| <div class="line"><a name="l00752"></a><span class="lineno"> 752</span>  }</div> |
| <div class="line"><a name="l00753"></a><span class="lineno"> 753</span>  <span class="comment">// Aggregate subquery with a correlated predicate that can't be transformed</span></div> |
| <div class="line"><a name="l00754"></a><span class="lineno"> 754</span>  <span class="comment">// into an equi-join in an IS NULL predicate</span></div> |
| <div class="line"><a name="l00755"></a><span class="lineno"> 755</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select 1 from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00756"></a><span class="lineno"> 756</span>  <span class="stringliteral">"(select max(id) from functional.alltypessmall s where t.id < 10) "</span> +</div> |
| <div class="line"><a name="l00757"></a><span class="lineno"> 757</span>  <span class="stringliteral">"is null"</span>);</div> |
| <div class="line"><a name="l00758"></a><span class="lineno"> 758</span> </div> |
| <div class="line"><a name="l00759"></a><span class="lineno"> 759</span>  <span class="comment">// Mathematical functions with scalar subqueries</span></div> |
| <div class="line"><a name="l00760"></a><span class="lineno"> 760</span>  String mathFns[] = {<span class="stringliteral">"abs"</span>, <span class="stringliteral">"cos"</span>, <span class="stringliteral">"ceil"</span>, <span class="stringliteral">"floor"</span>};</div> |
| <div class="line"><a name="l00761"></a><span class="lineno"> 761</span>  <span class="keywordflow">for</span> (String mathFn: mathFns) {</div> |
| <div class="line"><a name="l00762"></a><span class="lineno"> 762</span>  <span class="keywordflow">for</span> (String aggFn: aggFns) {</div> |
| <div class="line"><a name="l00763"></a><span class="lineno"> 763</span>  String expr = aggFn.equals(<span class="stringliteral">"count(id)"</span>) ? <span class="stringliteral">""</span> : <span class="stringliteral">"1 + "</span>;</div> |
| <div class="line"><a name="l00764"></a><span class="lineno"> 764</span>  <span class="keywordflow">for</span> (String cmpOp: cmpOperators) {</div> |
| <div class="line"><a name="l00765"></a><span class="lineno"> 765</span>  <span class="comment">// Uncorrelated scalar subquery</span></div> |
| <div class="line"><a name="l00766"></a><span class="lineno"> 766</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00767"></a><span class="lineno"> 767</span>  <span class="stringliteral">"%s((select %s %s from functional.alltypessmall where bool_col = "</span> +</div> |
| <div class="line"><a name="l00768"></a><span class="lineno"> 768</span>  <span class="stringliteral">"false)) %s 100 - t.int_col and t.bigint_col < 100"</span>, mathFn, expr, aggFn,</div> |
| <div class="line"><a name="l00769"></a><span class="lineno"> 769</span>  cmpOp));</div> |
| <div class="line"><a name="l00770"></a><span class="lineno"> 770</span>  <span class="comment">// Correlated scalar subquery</span></div> |
| <div class="line"><a name="l00771"></a><span class="lineno"> 771</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00772"></a><span class="lineno"> 772</span>  <span class="stringliteral">"%s((select %s %s from functional.alltypessmall s where bool_col = false "</span> +</div> |
| <div class="line"><a name="l00773"></a><span class="lineno"> 773</span>  <span class="stringliteral">"and t.id = s.id)) %s 100 - t.int_col and t.bigint_col < 100"</span>, mathFn, expr,</div> |
| <div class="line"><a name="l00774"></a><span class="lineno"> 774</span>  aggFn, cmpOp));</div> |
| <div class="line"><a name="l00775"></a><span class="lineno"> 775</span>  }</div> |
| <div class="line"><a name="l00776"></a><span class="lineno"> 776</span>  }</div> |
| <div class="line"><a name="l00777"></a><span class="lineno"> 777</span>  }</div> |
| <div class="line"><a name="l00778"></a><span class="lineno"> 778</span> </div> |
| <div class="line"><a name="l00779"></a><span class="lineno"> 779</span>  <span class="comment">// Conditional functions with scalar subqueries</span></div> |
| <div class="line"><a name="l00780"></a><span class="lineno"> 780</span>  <span class="keywordflow">for</span> (String aggFn: aggFns) {</div> |
| <div class="line"><a name="l00781"></a><span class="lineno"> 781</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00782"></a><span class="lineno"> 782</span>  <span class="stringliteral">"nullifzero((select %s from functional.alltypessmall s where "</span> +</div> |
| <div class="line"><a name="l00783"></a><span class="lineno"> 783</span>  <span class="stringliteral">"s.bool_col = false)) is null"</span>, aggFn));</div> |
| <div class="line"><a name="l00784"></a><span class="lineno"> 784</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select count(*) from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00785"></a><span class="lineno"> 785</span>  <span class="stringliteral">"zeroifnull((select %s from functional.alltypessmall s where t.id = s.id)) "</span> +</div> |
| <div class="line"><a name="l00786"></a><span class="lineno"> 786</span>  <span class="stringliteral">"= 0 and t.int_col < 10"</span>, aggFn));</div> |
| <div class="line"><a name="l00787"></a><span class="lineno"> 787</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select 1 from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00788"></a><span class="lineno"> 788</span>  <span class="stringliteral">"isnull((select %s from functional.alltypestiny s where s.bool_col = false "</span> +</div> |
| <div class="line"><a name="l00789"></a><span class="lineno"> 789</span>  <span class="stringliteral">"), 10) < 5"</span>, aggFn));</div> |
| <div class="line"><a name="l00790"></a><span class="lineno"> 790</span>  }</div> |
| <div class="line"><a name="l00791"></a><span class="lineno"> 791</span> </div> |
| <div class="line"><a name="l00792"></a><span class="lineno"> 792</span>  <span class="comment">// Correlated aggregate subquery with a GROUP BY</span></div> |
| <div class="line"><a name="l00793"></a><span class="lineno"> 793</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select min(t.id) as min_id from functional.alltypestiny t "</span> +</div> |
| <div class="line"><a name="l00794"></a><span class="lineno"> 794</span>  <span class="stringliteral">"where t.int_col < (select max(s.int_col) from functional.alltypessmall s "</span> +</div> |
| <div class="line"><a name="l00795"></a><span class="lineno"> 795</span>  <span class="stringliteral">"where s.id = t.id group by s.bigint_col order by 1 limit 1)"</span>,</div> |
| <div class="line"><a name="l00796"></a><span class="lineno"> 796</span>  <span class="stringliteral">"Unsupported correlated subquery with grouping and/or aggregation: "</span> +</div> |
| <div class="line"><a name="l00797"></a><span class="lineno"> 797</span>  <span class="stringliteral">"SELECT max(s.int_col) FROM functional.alltypessmall s WHERE "</span> +</div> |
| <div class="line"><a name="l00798"></a><span class="lineno"> 798</span>  <span class="stringliteral">"s.id = t.id GROUP BY s.bigint_col ORDER BY 1 ASC LIMIT 1"</span>);</div> |
| <div class="line"><a name="l00799"></a><span class="lineno"> 799</span>  <span class="comment">// Correlated aggregate subquery with a LIMIT clause</span></div> |
| <div class="line"><a name="l00800"></a><span class="lineno"> 800</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00801"></a><span class="lineno"> 801</span>  <span class="stringliteral">"t.id = (select count(*) from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00802"></a><span class="lineno"> 802</span>  <span class="stringliteral">"g.int_col = t.int_col limit 1)"</span>);</div> |
| <div class="line"><a name="l00803"></a><span class="lineno"> 803</span> </div> |
| <div class="line"><a name="l00804"></a><span class="lineno"> 804</span>  <span class="comment">// Aggregate subquery with analytic function</span></div> |
| <div class="line"><a name="l00805"></a><span class="lineno"> 805</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00806"></a><span class="lineno"> 806</span>  <span class="stringliteral">"functional.alltypestiny t1 where int_col = (select min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00807"></a><span class="lineno"> 807</span>  <span class="stringliteral">"over (partition by bool_col) from functional.alltypessmall t2 where "</span> +</div> |
| <div class="line"><a name="l00808"></a><span class="lineno"> 808</span>  <span class="stringliteral">"int_col < 10)"</span>, <span class="stringliteral">"Subquery must return a single row: (SELECT "</span> +</div> |
| <div class="line"><a name="l00809"></a><span class="lineno"> 809</span>  <span class="stringliteral">"min(bigint_col) OVER (PARTITION BY bool_col) FROM "</span> +</div> |
| <div class="line"><a name="l00810"></a><span class="lineno"> 810</span>  <span class="stringliteral">"functional.alltypessmall t2 WHERE int_col < 10)"</span>);</div> |
| <div class="line"><a name="l00811"></a><span class="lineno"> 811</span> </div> |
| <div class="line"><a name="l00812"></a><span class="lineno"> 812</span>  <span class="comment">// Aggregate subquery with analytic function and limit 1 clause</span></div> |
| <div class="line"><a name="l00813"></a><span class="lineno"> 813</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00814"></a><span class="lineno"> 814</span>  <span class="stringliteral">"functional.alltypestiny t1 where int_col = (select min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00815"></a><span class="lineno"> 815</span>  <span class="stringliteral">"over (partition by bool_col) from functional.alltypessmall t2 where "</span> +</div> |
| <div class="line"><a name="l00816"></a><span class="lineno"> 816</span>  <span class="stringliteral">"t1.id = t2.id and int_col < 10 limit 1)"</span>, <span class="stringliteral">"Unsupported correlated "</span> +</div> |
| <div class="line"><a name="l00817"></a><span class="lineno"> 817</span>  <span class="stringliteral">"subquery with grouping and/or aggregation: SELECT min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00818"></a><span class="lineno"> 818</span>  <span class="stringliteral">"OVER (PARTITION BY bool_col) FROM functional.alltypessmall t2 WHERE "</span> +</div> |
| <div class="line"><a name="l00819"></a><span class="lineno"> 819</span>  <span class="stringliteral">"t1.id = t2.id AND int_col < 10 LIMIT 1"</span>);</div> |
| <div class="line"><a name="l00820"></a><span class="lineno"> 820</span> </div> |
| <div class="line"><a name="l00821"></a><span class="lineno"> 821</span>  <span class="comment">// Uncorrelated aggregate subquery with analytic function and limit 1 clause</span></div> |
| <div class="line"><a name="l00822"></a><span class="lineno"> 822</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id, int_col, bool_col from "</span> +</div> |
| <div class="line"><a name="l00823"></a><span class="lineno"> 823</span>  <span class="stringliteral">"functional.alltypestiny t1 where int_col = (select min(bigint_col) "</span> +</div> |
| <div class="line"><a name="l00824"></a><span class="lineno"> 824</span>  <span class="stringliteral">"over (partition by bool_col) from functional.alltypessmall t2 where "</span> +</div> |
| <div class="line"><a name="l00825"></a><span class="lineno"> 825</span>  <span class="stringliteral">"int_col < 10 limit 1)"</span>);</div> |
| <div class="line"><a name="l00826"></a><span class="lineno"> 826</span> </div> |
| <div class="line"><a name="l00827"></a><span class="lineno"> 827</span>  <span class="comment">// Subquery with distinct in binary predicate</span></div> |
| <div class="line"><a name="l00828"></a><span class="lineno"> 828</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes where int_col = "</span> +</div> |
| <div class="line"><a name="l00829"></a><span class="lineno"> 829</span>  <span class="stringliteral">"(select distinct int_col from functional.alltypesagg)"</span>, <span class="stringliteral">"Subquery "</span> +</div> |
| <div class="line"><a name="l00830"></a><span class="lineno"> 830</span>  <span class="stringliteral">"must return a single row: (SELECT DISTINCT int_col FROM "</span> +</div> |
| <div class="line"><a name="l00831"></a><span class="lineno"> 831</span>  <span class="stringliteral">"functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00832"></a><span class="lineno"> 832</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes where int_col = "</span> +</div> |
| <div class="line"><a name="l00833"></a><span class="lineno"> 833</span>  <span class="stringliteral">"(select count(distinct int_col) from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00834"></a><span class="lineno"> 834</span>  <span class="comment">// Multiple count aggregate functions in a correlated subquery's select list</span></div> |
| <div class="line"><a name="l00835"></a><span class="lineno"> 835</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes t where "</span> +</div> |
| <div class="line"><a name="l00836"></a><span class="lineno"> 836</span>  <span class="stringliteral">"int_col = (select count(id) + count(int_col) - 1 from "</span> +</div> |
| <div class="line"><a name="l00837"></a><span class="lineno"> 837</span>  <span class="stringliteral">"functional.alltypesagg g where g.int_col = t.int_col)"</span>,</div> |
| <div class="line"><a name="l00838"></a><span class="lineno"> 838</span>  <span class="stringliteral">"Aggregate function that returns non-null on an empty input "</span> +</div> |
| <div class="line"><a name="l00839"></a><span class="lineno"> 839</span>  <span class="stringliteral">"cannot be used in an expression in a correlated "</span> +</div> |
| <div class="line"><a name="l00840"></a><span class="lineno"> 840</span>  <span class="stringliteral">"subquery's select list: (SELECT count(id) + count(int_col) - 1 "</span> +</div> |
| <div class="line"><a name="l00841"></a><span class="lineno"> 841</span>  <span class="stringliteral">"FROM functional.alltypesagg g WHERE g.int_col = t.int_col)"</span>);</div> |
| <div class="line"><a name="l00842"></a><span class="lineno"> 842</span> </div> |
| <div class="line"><a name="l00843"></a><span class="lineno"> 843</span>  <span class="comment">// UDAs in aggregate subqqueries</span></div> |
| <div class="line"><a name="l00844"></a><span class="lineno"> 844</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a74e33f1aa938744c9c39e5d1b18d2406">addTestUda</a>(<span class="stringliteral">"AggFn"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html">Type</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html#aac9963d35d8ba3e584476c5a37fe131a">BIGINT</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html">Type</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html#aac9963d35d8ba3e584476c5a37fe131a">BIGINT</a>);</div> |
| <div class="line"><a name="l00845"></a><span class="lineno"> 845</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00846"></a><span class="lineno"> 846</span>  <span class="stringliteral">"(select aggfn(int_col) from functional.alltypes s where "</span> +</div> |
| <div class="line"><a name="l00847"></a><span class="lineno"> 847</span>  <span class="stringliteral">"s.id = g.id) = 10"</span>, <span class="stringliteral">"UDAs are not supported in the select list of "</span> +</div> |
| <div class="line"><a name="l00848"></a><span class="lineno"> 848</span>  <span class="stringliteral">"correlated subqueries: (SELECT default.aggfn(int_col) FROM "</span> +</div> |
| <div class="line"><a name="l00849"></a><span class="lineno"> 849</span>  <span class="stringliteral">"functional.alltypes s WHERE s.id = g.id)"</span>);</div> |
| <div class="line"><a name="l00850"></a><span class="lineno"> 850</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypesagg g where "</span> +</div> |
| <div class="line"><a name="l00851"></a><span class="lineno"> 851</span>  <span class="stringliteral">"(select aggfn(int_col) from functional.alltypes s where "</span> +</div> |
| <div class="line"><a name="l00852"></a><span class="lineno"> 852</span>  <span class="stringliteral">"s.bool_col = false) < 10"</span>);</div> |
| <div class="line"><a name="l00853"></a><span class="lineno"> 853</span> </div> |
| <div class="line"><a name="l00854"></a><span class="lineno"> 854</span>  <span class="comment">// sample, histogram in scalar subqueries</span></div> |
| <div class="line"><a name="l00855"></a><span class="lineno"> 855</span>  String aggFnsReturningStringOnEmpty[] = {<span class="stringliteral">"sample(int_col)"</span>, <span class="stringliteral">"histogram(int_col)"</span>};</div> |
| <div class="line"><a name="l00856"></a><span class="lineno"> 856</span>  <span class="keywordflow">for</span> (String aggFn: aggFnsReturningStringOnEmpty) {</div> |
| <div class="line"><a name="l00857"></a><span class="lineno"> 857</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(String.format(<span class="stringliteral">"select * from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00858"></a><span class="lineno"> 858</span>  <span class="stringliteral">"t.string_col = (select %s from functional.alltypesagg g where t.id = "</span> +</div> |
| <div class="line"><a name="l00859"></a><span class="lineno"> 859</span>  <span class="stringliteral">"g.id)"</span>, aggFn));</div> |
| <div class="line"><a name="l00860"></a><span class="lineno"> 860</span>  }</div> |
| <div class="line"><a name="l00861"></a><span class="lineno"> 861</span>  <span class="comment">// Complex correlated predicate in which columns from the subquery appear in</span></div> |
| <div class="line"><a name="l00862"></a><span class="lineno"> 862</span>  <span class="comment">// both sides of a correlated binary predicate</span></div> |
| <div class="line"><a name="l00863"></a><span class="lineno"> 863</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select 1 from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l00864"></a><span class="lineno"> 864</span>  <span class="stringliteral">"(select sum(t1.id) from functional.alltypesagg t1 inner join "</span> +</div> |
| <div class="line"><a name="l00865"></a><span class="lineno"> 865</span>  <span class="stringliteral">"functional.alltypes t2 on t1.id = t2.id where "</span> +</div> |
| <div class="line"><a name="l00866"></a><span class="lineno"> 866</span>  <span class="stringliteral">"t1.id + t2.id = t.int_col + t1.int_col) = t.int_col"</span>,</div> |
| <div class="line"><a name="l00867"></a><span class="lineno"> 867</span>  <span class="stringliteral">"All subquery columns that participate in a predicate "</span> +</div> |
| <div class="line"><a name="l00868"></a><span class="lineno"> 868</span>  <span class="stringliteral">"must be on the same side of that predicate: t1.id + t2.id = t.int_col "</span> +</div> |
| <div class="line"><a name="l00869"></a><span class="lineno"> 869</span>  <span class="stringliteral">"+ t1.int_col"</span>);</div> |
| <div class="line"><a name="l00870"></a><span class="lineno"> 870</span>  }</div> |
| <div class="line"><a name="l00871"></a><span class="lineno"> 871</span> </div> |
| <div class="line"><a name="l00872"></a><span class="lineno"> 872</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00873"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#ace115bc47c28f140698e1c3d82be732b"> 873</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#ace115bc47c28f140698e1c3d82be732b">TestSubqueries</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00874"></a><span class="lineno"> 874</span>  <span class="comment">// Test resolution of column references inside subqueries.</span></div> |
| <div class="line"><a name="l00875"></a><span class="lineno"> 875</span>  <span class="comment">// Correlated column references can be qualified or unqualified.</span></div> |
| <div class="line"><a name="l00876"></a><span class="lineno"> 876</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.jointbl t where exists "</span> +</div> |
| <div class="line"><a name="l00877"></a><span class="lineno"> 877</span>  <span class="stringliteral">"(select id from functional.alltypes where id = test_id and id = t.test_id)"</span>);</div> |
| <div class="line"><a name="l00878"></a><span class="lineno"> 878</span>  <span class="comment">// Correlated column references are invalid outside of WHERE and ON clauses.</span></div> |
| <div class="line"><a name="l00879"></a><span class="lineno"> 879</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.jointbl t where exists "</span> +</div> |
| <div class="line"><a name="l00880"></a><span class="lineno"> 880</span>  <span class="stringliteral">"(select t.test_id = id from functional.alltypes)"</span>,</div> |
| <div class="line"><a name="l00881"></a><span class="lineno"> 881</span>  <span class="stringliteral">"Could not resolve column/field reference: 't.test_id'"</span>);</div> |
| <div class="line"><a name="l00882"></a><span class="lineno"> 882</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.jointbl t where test_zip in "</span> +</div> |
| <div class="line"><a name="l00883"></a><span class="lineno"> 883</span>  <span class="stringliteral">"(select count(*) from functional.alltypes group by t.test_id)"</span>,</div> |
| <div class="line"><a name="l00884"></a><span class="lineno"> 884</span>  <span class="stringliteral">"Could not resolve column/field reference: 't.test_id'"</span>);</div> |
| <div class="line"><a name="l00885"></a><span class="lineno"> 885</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.jointbl t where exists "</span> +</div> |
| <div class="line"><a name="l00886"></a><span class="lineno"> 886</span>  <span class="stringliteral">"(select 1 from functional.alltypes order by t.test_id limit 1)"</span>,</div> |
| <div class="line"><a name="l00887"></a><span class="lineno"> 887</span>  <span class="stringliteral">"Could not resolve column/field reference: 't.test_id'"</span>);</div> |
| <div class="line"><a name="l00888"></a><span class="lineno"> 888</span>  <span class="comment">// Star exprs cannot reference an alias from a parent block.</span></div> |
| <div class="line"><a name="l00889"></a><span class="lineno"> 889</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.jointbl t where exists "</span> +</div> |
| <div class="line"><a name="l00890"></a><span class="lineno"> 890</span>  <span class="stringliteral">"(select t.* from functional.alltypes)"</span>,</div> |
| <div class="line"><a name="l00891"></a><span class="lineno"> 891</span>  <span class="stringliteral">"Could not resolve star expression: 't.*'"</span>);</div> |
| <div class="line"><a name="l00892"></a><span class="lineno"> 892</span> </div> |
| <div class="line"><a name="l00893"></a><span class="lineno"> 893</span>  <span class="comment">// EXISTS, IN and aggregate subqueries</span></div> |
| <div class="line"><a name="l00894"></a><span class="lineno"> 894</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where exists "</span> +</div> |
| <div class="line"><a name="l00895"></a><span class="lineno"> 895</span>  <span class="stringliteral">"(select * from functional.alltypesagg a where a.int_col = "</span> +</div> |
| <div class="line"><a name="l00896"></a><span class="lineno"> 896</span>  <span class="stringliteral">"t.int_col) and t.bigint_col in (select bigint_col from "</span> +</div> |
| <div class="line"><a name="l00897"></a><span class="lineno"> 897</span>  <span class="stringliteral">"functional.alltypestiny s) and t.bool_col = false and "</span> +</div> |
| <div class="line"><a name="l00898"></a><span class="lineno"> 898</span>  <span class="stringliteral">"t.int_col = (select min(int_col) from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l00899"></a><span class="lineno"> 899</span>  <span class="comment">// Nested IN with an EXISTS subquery that contains an aggregate subquery</span></div> |
| <div class="line"><a name="l00900"></a><span class="lineno"> 900</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypes t where t.id "</span> +</div> |
| <div class="line"><a name="l00901"></a><span class="lineno"> 901</span>  <span class="stringliteral">"in (select id from functional.alltypesagg a where a.int_col = "</span> +</div> |
| <div class="line"><a name="l00902"></a><span class="lineno"> 902</span>  <span class="stringliteral">"t.int_col and exists (select * from functional.alltypestiny s "</span> +</div> |
| <div class="line"><a name="l00903"></a><span class="lineno"> 903</span>  <span class="stringliteral">"where s.bool_col = a.bool_col and s.int_col = (select min(int_col) "</span> +</div> |
| <div class="line"><a name="l00904"></a><span class="lineno"> 904</span>  <span class="stringliteral">"from functional.alltypessmall where bigint_col = 10)))"</span>);</div> |
| <div class="line"><a name="l00905"></a><span class="lineno"> 905</span>  <span class="comment">// Nested EXISTS with an IN subquery that has a nested aggregate subquery</span></div> |
| <div class="line"><a name="l00906"></a><span class="lineno"> 906</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypes t where exists "</span> +</div> |
| <div class="line"><a name="l00907"></a><span class="lineno"> 907</span>  <span class="stringliteral">"(select * from functional.alltypesagg a where a.id in (select id "</span> +</div> |
| <div class="line"><a name="l00908"></a><span class="lineno"> 908</span>  <span class="stringliteral">"from functional.alltypestiny s where bool_col = false and "</span> +</div> |
| <div class="line"><a name="l00909"></a><span class="lineno"> 909</span>  <span class="stringliteral">"s.int_col < (select max(int_col) from functional.alltypessmall where "</span> +</div> |
| <div class="line"><a name="l00910"></a><span class="lineno"> 910</span>  <span class="stringliteral">"bigint_col < 100)) and a.int_col = t.int_col)"</span>);</div> |
| <div class="line"><a name="l00911"></a><span class="lineno"> 911</span>  <span class="comment">// Nested aggregate subqueries with EXISTS and IN subqueries</span></div> |
| <div class="line"><a name="l00912"></a><span class="lineno"> 912</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypes t where t.int_col = "</span> +</div> |
| <div class="line"><a name="l00913"></a><span class="lineno"> 913</span>  <span class="stringliteral">"(select avg(g.int_col) * 2 from functional.alltypesagg g where g.id in "</span> +</div> |
| <div class="line"><a name="l00914"></a><span class="lineno"> 914</span>  <span class="stringliteral">"(select id from functional.alltypessmall s where exists (select "</span> +</div> |
| <div class="line"><a name="l00915"></a><span class="lineno"> 915</span>  <span class="stringliteral">"* from functional.alltypestiny a where a.int_col = s.int_col and "</span> +</div> |
| <div class="line"><a name="l00916"></a><span class="lineno"> 916</span>  <span class="stringliteral">"a.bigint_col < 10)))"</span>);</div> |
| <div class="line"><a name="l00917"></a><span class="lineno"> 917</span> </div> |
| <div class="line"><a name="l00918"></a><span class="lineno"> 918</span>  <span class="comment">// INSERT SELECT</span></div> |
| <div class="line"><a name="l00919"></a><span class="lineno"> 919</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"insert into functional.alltypessmall partition (year, month) "</span> +</div> |
| <div class="line"><a name="l00920"></a><span class="lineno"> 920</span>  <span class="stringliteral">"select * from functional.alltypes where id in (select id from "</span> +</div> |
| <div class="line"><a name="l00921"></a><span class="lineno"> 921</span>  <span class="stringliteral">"functional.alltypesagg a where a.bool_col = false)"</span>);</div> |
| <div class="line"><a name="l00922"></a><span class="lineno"> 922</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"insert into functional.alltypessmall partition (year, month) "</span> +</div> |
| <div class="line"><a name="l00923"></a><span class="lineno"> 923</span>  <span class="stringliteral">"select * from functional.alltypes t where int_col in (select int_col "</span> +</div> |
| <div class="line"><a name="l00924"></a><span class="lineno"> 924</span>  <span class="stringliteral">"from functional.alltypesagg a where a.id = t.id) and exists "</span> +</div> |
| <div class="line"><a name="l00925"></a><span class="lineno"> 925</span>  <span class="stringliteral">"(select * from functional.alltypestiny s where s.bigint_col = "</span> +</div> |
| <div class="line"><a name="l00926"></a><span class="lineno"> 926</span>  <span class="stringliteral">"t.bigint_col) and int_col < (select min(int_col) from functional.alltypes)"</span>);</div> |
| <div class="line"><a name="l00927"></a><span class="lineno"> 927</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"insert into functional.alltypessmall partition (year, month) "</span> +</div> |
| <div class="line"><a name="l00928"></a><span class="lineno"> 928</span>  <span class="stringliteral">"select * from functional.alltypestiny where id = (select 1) "</span> +</div> |
| <div class="line"><a name="l00929"></a><span class="lineno"> 929</span>  <span class="stringliteral">"union select * from functional.alltypestiny where id = (select 2)"</span>);</div> |
| <div class="line"><a name="l00930"></a><span class="lineno"> 930</span> </div> |
| <div class="line"><a name="l00931"></a><span class="lineno"> 931</span>  <span class="comment">// CTAS with correlated subqueries</span></div> |
| <div class="line"><a name="l00932"></a><span class="lineno"> 932</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"create table functional.test_tbl as select * from "</span> +</div> |
| <div class="line"><a name="l00933"></a><span class="lineno"> 933</span>  <span class="stringliteral">"functional.alltypes t where t.id in (select id from functional.alltypesagg "</span> +</div> |
| <div class="line"><a name="l00934"></a><span class="lineno"> 934</span>  <span class="stringliteral">"a where a.int_col = t.int_col and a.bool_col = false) and not exists "</span> +</div> |
| <div class="line"><a name="l00935"></a><span class="lineno"> 935</span>  <span class="stringliteral">"(select * from functional.alltypestiny s where s.int_col = t.int_col) "</span> +</div> |
| <div class="line"><a name="l00936"></a><span class="lineno"> 936</span>  <span class="stringliteral">"and t.bigint_col = (select count(*) from functional.alltypessmall)"</span>);</div> |
| <div class="line"><a name="l00937"></a><span class="lineno"> 937</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"create table functional.test_tbl as "</span> +</div> |
| <div class="line"><a name="l00938"></a><span class="lineno"> 938</span>  <span class="stringliteral">"select * from functional.alltypestiny where id = (select 1) "</span> +</div> |
| <div class="line"><a name="l00939"></a><span class="lineno"> 939</span>  <span class="stringliteral">"union select * from functional.alltypestiny where id = (select 2)"</span>);</div> |
| <div class="line"><a name="l00940"></a><span class="lineno"> 940</span> </div> |
| <div class="line"><a name="l00941"></a><span class="lineno"> 941</span>  <span class="comment">// Predicate with a child subquery in the HAVING clause</span></div> |
| <div class="line"><a name="l00942"></a><span class="lineno"> 942</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, count(*) from functional.alltypestiny t group by "</span> +</div> |
| <div class="line"><a name="l00943"></a><span class="lineno"> 943</span>  <span class="stringliteral">"id having count(*) > (select count(*) from functional.alltypesagg)"</span>,</div> |
| <div class="line"><a name="l00944"></a><span class="lineno"> 944</span>  <span class="stringliteral">"Subqueries are not supported in the HAVING clause."</span>);</div> |
| <div class="line"><a name="l00945"></a><span class="lineno"> 945</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, count(*) from functional.alltypestiny t group by "</span> +</div> |
| <div class="line"><a name="l00946"></a><span class="lineno"> 946</span>  <span class="stringliteral">"id having (select count(*) from functional.alltypesagg) > 10"</span>,</div> |
| <div class="line"><a name="l00947"></a><span class="lineno"> 947</span>  <span class="stringliteral">"Subqueries are not supported in the HAVING clause."</span>);</div> |
| <div class="line"><a name="l00948"></a><span class="lineno"> 948</span> </div> |
| <div class="line"><a name="l00949"></a><span class="lineno"> 949</span>  <span class="comment">// Subquery in the select list</span></div> |
| <div class="line"><a name="l00950"></a><span class="lineno"> 950</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, (select int_col from functional.alltypestiny) "</span> +</div> |
| <div class="line"><a name="l00951"></a><span class="lineno"> 951</span>  <span class="stringliteral">"from functional.alltypestiny"</span>,</div> |
| <div class="line"><a name="l00952"></a><span class="lineno"> 952</span>  <span class="stringliteral">"Subqueries are not supported in the select list."</span>);</div> |
| <div class="line"><a name="l00953"></a><span class="lineno"> 953</span> </div> |
| <div class="line"><a name="l00954"></a><span class="lineno"> 954</span>  <span class="comment">// Subquery in the GROUP BY clause</span></div> |
| <div class="line"><a name="l00955"></a><span class="lineno"> 955</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id, count(*) from functional.alltypestiny "</span> +</div> |
| <div class="line"><a name="l00956"></a><span class="lineno"> 956</span>  <span class="stringliteral">"group by (select int_col from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00957"></a><span class="lineno"> 957</span>  <span class="stringliteral">"Subqueries are not supported in the GROUP BY clause."</span>);</div> |
| <div class="line"><a name="l00958"></a><span class="lineno"> 958</span> </div> |
| <div class="line"><a name="l00959"></a><span class="lineno"> 959</span>  <span class="comment">// Subquery in the ORDER BY clause</span></div> |
| <div class="line"><a name="l00960"></a><span class="lineno"> 960</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from functional.alltypestiny "</span> +</div> |
| <div class="line"><a name="l00961"></a><span class="lineno"> 961</span>  <span class="stringliteral">"order by (select int_col from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00962"></a><span class="lineno"> 962</span>  <span class="stringliteral">"Subqueries are not supported in the ORDER BY clause."</span>);</div> |
| <div class="line"><a name="l00963"></a><span class="lineno"> 963</span> </div> |
| <div class="line"><a name="l00964"></a><span class="lineno"> 964</span>  <span class="comment">// Subquery with an inline view</span></div> |
| <div class="line"><a name="l00965"></a><span class="lineno"> 965</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny t where exists "</span> +</div> |
| <div class="line"><a name="l00966"></a><span class="lineno"> 966</span>  <span class="stringliteral">"(select * from (select id, int_col from functional.alltypesagg) a where "</span> +</div> |
| <div class="line"><a name="l00967"></a><span class="lineno"> 967</span>  <span class="stringliteral">"a.id < 10 and a.int_col = t.int_col)"</span>);</div> |
| <div class="line"><a name="l00968"></a><span class="lineno"> 968</span> </div> |
| <div class="line"><a name="l00969"></a><span class="lineno"> 969</span>  <span class="comment">// Inner block references an inline view in the outer block</span></div> |
| <div class="line"><a name="l00970"></a><span class="lineno"> 970</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from (select * from functional.alltypestiny) t "</span> +</div> |
| <div class="line"><a name="l00971"></a><span class="lineno"> 971</span>  <span class="stringliteral">"where t.int_col = (select count(*) from t)"</span>,</div> |
| <div class="line"><a name="l00972"></a><span class="lineno"> 972</span>  <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00973"></a><span class="lineno"> 973</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from (select * from functional.alltypestiny) t "</span> +</div> |
| <div class="line"><a name="l00974"></a><span class="lineno"> 974</span>  <span class="stringliteral">"where t.int_col = (select count(*) from t) and "</span> +</div> |
| <div class="line"><a name="l00975"></a><span class="lineno"> 975</span>  <span class="stringliteral">"t.string_col in (select string_col from t)"</span>,</div> |
| <div class="line"><a name="l00976"></a><span class="lineno"> 976</span>  <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00977"></a><span class="lineno"> 977</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select id from (select * from functional.alltypestiny) t "</span> +</div> |
| <div class="line"><a name="l00978"></a><span class="lineno"> 978</span>  <span class="stringliteral">"where exists (select * from t, functional.alltypesagg p where "</span> +</div> |
| <div class="line"><a name="l00979"></a><span class="lineno"> 979</span>  <span class="stringliteral">"t.id = p.id)"</span>, <span class="stringliteral">"Could not resolve table reference: 't'"</span>);</div> |
| <div class="line"><a name="l00980"></a><span class="lineno"> 980</span> </div> |
| <div class="line"><a name="l00981"></a><span class="lineno"> 981</span>  <span class="comment">// Subquery referencing a view</span></div> |
| <div class="line"><a name="l00982"></a><span class="lineno"> 982</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes a where exists "</span> +</div> |
| <div class="line"><a name="l00983"></a><span class="lineno"> 983</span>  <span class="stringliteral">"(select * from functional.alltypes_view b where b.id = a.id)"</span>);</div> |
| <div class="line"><a name="l00984"></a><span class="lineno"> 984</span>  <span class="comment">// Same view referenced in both the inner and outer block</span></div> |
| <div class="line"><a name="l00985"></a><span class="lineno"> 985</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes_view a where exists "</span> +</div> |
| <div class="line"><a name="l00986"></a><span class="lineno"> 986</span>  <span class="stringliteral">"(select * from functional.alltypes_view b where a.id = b.id)"</span>);</div> |
| <div class="line"><a name="l00987"></a><span class="lineno"> 987</span> </div> |
| <div class="line"><a name="l00988"></a><span class="lineno"> 988</span>  <span class="comment">// Union query with subqueries</span></div> |
| <div class="line"><a name="l00989"></a><span class="lineno"> 989</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes where id = "</span> +</div> |
| <div class="line"><a name="l00990"></a><span class="lineno"> 990</span>  <span class="stringliteral">"(select max(id) from functional.alltypestiny) union "</span> +</div> |
| <div class="line"><a name="l00991"></a><span class="lineno"> 991</span>  <span class="stringliteral">"select * from functional.alltypes where id = "</span> +</div> |
| <div class="line"><a name="l00992"></a><span class="lineno"> 992</span>  <span class="stringliteral">"(select min(id) from functional.alltypessmall)"</span>);</div> |
| <div class="line"><a name="l00993"></a><span class="lineno"> 993</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes where id = (select 1) "</span> +</div> |
| <div class="line"><a name="l00994"></a><span class="lineno"> 994</span>  <span class="stringliteral">"union all select * from functional.alltypes where id in "</span> +</div> |
| <div class="line"><a name="l00995"></a><span class="lineno"> 995</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00996"></a><span class="lineno"> 996</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes where id = (select 1) "</span> +</div> |
| <div class="line"><a name="l00997"></a><span class="lineno"> 997</span>  <span class="stringliteral">"union select * from (select * from functional.alltypes where id in "</span> +</div> |
| <div class="line"><a name="l00998"></a><span class="lineno"> 998</span>  <span class="stringliteral">"(select int_col from functional.alltypestiny)) t"</span>);</div> |
| <div class="line"><a name="l00999"></a><span class="lineno"> 999</span> </div> |
| <div class="line"><a name="l01000"></a><span class="lineno"> 1000</span>  <span class="comment">// Union in the subquery</span></div> |
| <div class="line"><a name="l01001"></a><span class="lineno"> 1001</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes where exists "</span> +</div> |
| <div class="line"><a name="l01002"></a><span class="lineno"> 1002</span>  <span class="stringliteral">"(select id from functional.alltypestiny union "</span> +</div> |
| <div class="line"><a name="l01003"></a><span class="lineno"> 1003</span>  <span class="stringliteral">"select id from functional.alltypesagg)"</span>,</div> |
| <div class="line"><a name="l01004"></a><span class="lineno"> 1004</span>  <span class="stringliteral">"A subquery must contain a single select block: "</span> +</div> |
| <div class="line"><a name="l01005"></a><span class="lineno"> 1005</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny UNION "</span> +</div> |
| <div class="line"><a name="l01006"></a><span class="lineno"> 1006</span>  <span class="stringliteral">"SELECT id FROM functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l01007"></a><span class="lineno"> 1007</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes where exists (values(1))"</span>,</div> |
| <div class="line"><a name="l01008"></a><span class="lineno"> 1008</span>  <span class="stringliteral">"A subquery must contain a single select block: (VALUES(1))"</span>);</div> |
| <div class="line"><a name="l01009"></a><span class="lineno"> 1009</span> </div> |
| <div class="line"><a name="l01010"></a><span class="lineno"> 1010</span>  <span class="comment">// Subquery in LIMIT</span></div> |
| <div class="line"><a name="l01011"></a><span class="lineno"> 1011</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypes limit "</span> +</div> |
| <div class="line"><a name="l01012"></a><span class="lineno"> 1012</span>  <span class="stringliteral">"(select count(*) from functional.alltypesagg)"</span>,</div> |
| <div class="line"><a name="l01013"></a><span class="lineno"> 1013</span>  <span class="stringliteral">"LIMIT expression must be a constant expression: "</span> +</div> |
| <div class="line"><a name="l01014"></a><span class="lineno"> 1014</span>  <span class="stringliteral">"(SELECT count(*) FROM functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l01015"></a><span class="lineno"> 1015</span> </div> |
| <div class="line"><a name="l01016"></a><span class="lineno"> 1016</span>  <span class="comment">// NOT predicates in conjunction with subqueries</span></div> |
| <div class="line"><a name="l01017"></a><span class="lineno"> 1017</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypes t where t.id not in "</span> +</div> |
| <div class="line"><a name="l01018"></a><span class="lineno"> 1018</span>  <span class="stringliteral">"(select id from functional.alltypesagg g where g.bool_col = false) "</span> +</div> |
| <div class="line"><a name="l01019"></a><span class="lineno"> 1019</span>  <span class="stringliteral">"and t.string_col not like '%1%' and not (t.int_col < 5) "</span> +</div> |
| <div class="line"><a name="l01020"></a><span class="lineno"> 1020</span>  <span class="stringliteral">"and not (t.int_col is null) and not (t.int_col between 5 and 10)"</span>);</div> |
| <div class="line"><a name="l01021"></a><span class="lineno"> 1021</span>  <span class="comment">// IS NULL with an InPredicate that contains a subquery</span></div> |
| <div class="line"><a name="l01022"></a><span class="lineno"> 1022</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny t where (id in "</span> +</div> |
| <div class="line"><a name="l01023"></a><span class="lineno"> 1023</span>  <span class="stringliteral">"(select id from functional.alltypes)) is null"</span>, <span class="stringliteral">"Unsupported IS NULL "</span> +</div> |
| <div class="line"><a name="l01024"></a><span class="lineno"> 1024</span>  <span class="stringliteral">"predicate that contains a subquery: (id IN (SELECT id FROM "</span> +</div> |
| <div class="line"><a name="l01025"></a><span class="lineno"> 1025</span>  <span class="stringliteral">"functional.alltypes)) IS NULL"</span>);</div> |
| <div class="line"><a name="l01026"></a><span class="lineno"> 1026</span>  <span class="comment">// IS NULL with a BinaryPredicate that contains a subquery</span></div> |
| <div class="line"><a name="l01027"></a><span class="lineno"> 1027</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny where (id = "</span> +</div> |
| <div class="line"><a name="l01028"></a><span class="lineno"> 1028</span>  <span class="stringliteral">"(select max(id) from functional.alltypessmall)) is null"</span>);</div> |
| <div class="line"><a name="l01029"></a><span class="lineno"> 1029</span> </div> |
| <div class="line"><a name="l01030"></a><span class="lineno"> 1030</span>  <span class="comment">// between predicates with subqueries</span></div> |
| <div class="line"><a name="l01031"></a><span class="lineno"> 1031</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l01032"></a><span class="lineno"> 1032</span>  <span class="stringliteral">"(select avg(id) from functional.alltypesagg where bool_col = true) "</span> +</div> |
| <div class="line"><a name="l01033"></a><span class="lineno"> 1033</span>  <span class="stringliteral">"between 1 and 100 and int_col < 10"</span>);</div> |
| <div class="line"><a name="l01034"></a><span class="lineno"> 1034</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select count(*) from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l01035"></a><span class="lineno"> 1035</span>  <span class="stringliteral">"(select count(id) from functional.alltypesagg g where t.id = g.id "</span> +</div> |
| <div class="line"><a name="l01036"></a><span class="lineno"> 1036</span>  <span class="stringliteral">"and g.bigint_col < 10) between 1 and 1000"</span>);</div> |
| <div class="line"><a name="l01037"></a><span class="lineno"> 1037</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select id from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l01038"></a><span class="lineno"> 1038</span>  <span class="stringliteral">"int_col between (select min(int_col) from functional.alltypesagg where "</span> +</div> |
| <div class="line"><a name="l01039"></a><span class="lineno"> 1039</span>  <span class="stringliteral">"id < 10) and 100 and bool_col = false"</span>);</div> |
| <div class="line"><a name="l01040"></a><span class="lineno"> 1040</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypessmall s where "</span> +</div> |
| <div class="line"><a name="l01041"></a><span class="lineno"> 1041</span>  <span class="stringliteral">"int_col between (select count(t.id) from functional.alltypestiny t where "</span> +</div> |
| <div class="line"><a name="l01042"></a><span class="lineno"> 1042</span>  <span class="stringliteral">"t.int_col = s.int_col) and (select max(int_col) from "</span> +</div> |
| <div class="line"><a name="l01043"></a><span class="lineno"> 1043</span>  <span class="stringliteral">"functional.alltypes a where a.id = s.id and a.bool_col = false)"</span>);</div> |
| <div class="line"><a name="l01044"></a><span class="lineno"> 1044</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypessmall where "</span> +</div> |
| <div class="line"><a name="l01045"></a><span class="lineno"> 1045</span>  <span class="stringliteral">"int_col between (select min(int_col) from functional.alltypestiny) and "</span> +</div> |
| <div class="line"><a name="l01046"></a><span class="lineno"> 1046</span>  <span class="stringliteral">"(select max(int_col) from functional.alltypestiny) and bigint_col between "</span> +</div> |
| <div class="line"><a name="l01047"></a><span class="lineno"> 1047</span>  <span class="stringliteral">"(select min(bigint_col) from functional.alltypesagg) and (select "</span> +</div> |
| <div class="line"><a name="l01048"></a><span class="lineno"> 1048</span>  <span class="stringliteral">"max(bigint_col) from functional.alltypesagg)"</span>);</div> |
| <div class="line"><a name="l01049"></a><span class="lineno"> 1049</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">AnalysisError</a>(<span class="stringliteral">"select * from functional.alltypestiny where (select min(id) "</span> +</div> |
| <div class="line"><a name="l01050"></a><span class="lineno"> 1050</span>  <span class="stringliteral">"from functional.alltypes) between 1 and (select max(id) from "</span> +</div> |
| <div class="line"><a name="l01051"></a><span class="lineno"> 1051</span>  <span class="stringliteral">"functional.alltypes)"</span>, <span class="stringliteral">"Comparison between subqueries is not supported "</span> +</div> |
| <div class="line"><a name="l01052"></a><span class="lineno"> 1052</span>  <span class="stringliteral">"in a between predicate: (SELECT min(id) FROM functional.alltypes) BETWEEN "</span> +</div> |
| <div class="line"><a name="l01053"></a><span class="lineno"> 1053</span>  <span class="stringliteral">"1 AND (SELECT max(id) FROM functional.alltypes)"</span>);</div> |
| <div class="line"><a name="l01054"></a><span class="lineno"> 1054</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny where "</span> +</div> |
| <div class="line"><a name="l01055"></a><span class="lineno"> 1055</span>  <span class="stringliteral">"int_col between 0 and 10 and exists (select 1)"</span>);</div> |
| <div class="line"><a name="l01056"></a><span class="lineno"> 1056</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(<span class="stringliteral">"select * from functional.alltypestiny a where "</span> +</div> |
| <div class="line"><a name="l01057"></a><span class="lineno"> 1057</span>  <span class="stringliteral">"double_col between cast(1 as double) and cast(10 as double) and "</span> +</div> |
| <div class="line"><a name="l01058"></a><span class="lineno"> 1058</span>  <span class="stringliteral">"exists (select 1 from functional.alltypessmall b where a.id = b.id)"</span>);</div> |
| <div class="line"><a name="l01059"></a><span class="lineno"> 1059</span>  }</div> |
| <div class="line"><a name="l01060"></a><span class="lineno"> 1060</span> }</div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type_html_aac9963d35d8ba3e584476c5a37fe131a"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html#aac9963d35d8ba3e584476c5a37fe131a">com.cloudera.impala.catalog.Type.BIGINT</a></div><div class="ttdeci">static final ScalarType BIGINT</div><div class="ttdef"><b>Definition:</b> <a href="Type_8java_source.html#l00050">Type.java:50</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1catalog_1_1Type.html">com.cloudera.impala.catalog.Type</a></div><div class="ttdef"><b>Definition:</b> <a href="Type_8java_source.html#l00042">Type.java:42</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html_a31554d96cb3441a182589eca29955ab1"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a31554d96cb3441a182589eca29955ab1">com.cloudera.impala.analysis.AnalyzeSubqueriesTest.TestInSubqueries</a></div><div class="ttdeci">void TestInSubqueries()</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00025">AnalyzeSubqueriesTest.java:25</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">com.cloudera.impala.common.AnalysisException</a></div><div class="ttdef"><b>Definition:</b> <a href="AnalysisException_8java_source.html#l00021">AnalysisException.java:21</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html_a1e2e6ad4ec252e68b7dbd69ba310f85a"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">com.cloudera.impala.analysis.AnalyzerTest.AnalyzesOk</a></div><div class="ttdeci">ParseNode AnalyzesOk(String stmt)</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00252">AnalyzerTest.java:252</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html_afff235518baeae3caf4f0d6a239c3abc"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#afff235518baeae3caf4f0d6a239c3abc">com.cloudera.impala.analysis.AnalyzeSubqueriesTest.TestAggregateSubqueries</a></div><div class="ttdeci">void TestAggregateSubqueries()</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00548">AnalyzeSubqueriesTest.java:548</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html_a74e33f1aa938744c9c39e5d1b18d2406"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a74e33f1aa938744c9c39e5d1b18d2406">com.cloudera.impala.analysis.AnalyzerTest.addTestUda</a></div><div class="ttdeci">void addTestUda(String name, Type retType, Type...argTypes)</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00129">AnalyzerTest.java:129</a></div></div> |
| <div class="ttc" id="cache-hash-test_8cc_html_a18269e3eecadb27e79614c02d898173e"><div class="ttname"><a href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div><div class="ttdeci">uint64_t Test(T *ht, const ProbeTuple *input, uint64_t num_tuples)</div><div class="ttdef"><b>Definition:</b> <a href="cache-hash-test_8cc_source.html#l00067">cache-hash-test.cc:67</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html">com.cloudera.impala.analysis.AnalyzerTest</a></div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00056">AnalyzerTest.java:56</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html_a8bc3362becb290a4bbdcbf6a668978bd"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#a8bc3362becb290a4bbdcbf6a668978bd">com.cloudera.impala.analysis.AnalyzeSubqueriesTest.TestExistsSubqueries</a></div><div class="ttdeci">void TestExistsSubqueries()</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00403">AnalyzeSubqueriesTest.java:403</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html">com.cloudera.impala.analysis.AnalyzeSubqueriesTest</a></div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00022">AnalyzeSubqueriesTest.java:22</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html_acd43f5e0b16afe9c9bc6db6a0f2dde12"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#acd43f5e0b16afe9c9bc6db6a0f2dde12">com.cloudera.impala.analysis.AnalyzeSubqueriesTest.cmpOperators</a></div><div class="ttdeci">static String cmpOperators[]</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00023">AnalyzeSubqueriesTest.java:23</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html_a38cb2f258ac5494c8d6ddb55d6258663"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a38cb2f258ac5494c8d6ddb55d6258663">com.cloudera.impala.analysis.AnalyzerTest.AnalysisError</a></div><div class="ttdeci">void AnalysisError(String stmt)</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00304">AnalyzerTest.java:304</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest_html_ace115bc47c28f140698e1c3d82be732b"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzeSubqueriesTest.html#ace115bc47c28f140698e1c3d82be732b">com.cloudera.impala.analysis.AnalyzeSubqueriesTest.TestSubqueries</a></div><div class="ttdeci">void TestSubqueries()</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzeSubqueriesTest_8java_source.html#l00873">AnalyzeSubqueriesTest.java:873</a></div></div> |
| </div><!-- fragment --></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_ca2797c59c2e868cd2eca72571423f6a.html">fe</a></li><li class="navelem"><a class="el" href="dir_9456c03c9c6e5a96e843b28fc5c6395b.html">src</a></li><li class="navelem"><a class="el" href="dir_5e883f6dc74bff61c96421c8f6a7e178.html">test</a></li><li class="navelem"><a class="el" href="dir_90203b64d536a3b270171a34c42a21ea.html">java</a></li><li class="navelem"><a class="el" href="dir_11616761b8bb98abd72e3e6bfe811524.html">com</a></li><li class="navelem"><a class="el" href="dir_b7afc6fa9388eeabd689520334a456b3.html">cloudera</a></li><li class="navelem"><a class="el" href="dir_85b47c81f280e02ede8246bf72165fa2.html">impala</a></li><li class="navelem"><a class="el" href="dir_cdbbf6d73da7e44e161bf53ae6a5acb7.html">analysis</a></li><li class="navelem"><a class="el" href="AnalyzeSubqueriesTest_8java.html">AnalyzeSubqueriesTest.java</a></li> |
| <li class="footer">Generated on Thu May 7 2015 16:10:39 for Impala by |
| <a href="http://www.doxygen.org/index.html"> |
| <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li> |
| </ul> |
| </div> |
| </body> |
| </html> |
