| <!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/ToSqlTest.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('ToSqlTest_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">ToSqlTest.java</div> </div> |
| </div><!--header--> |
| <div class="contents"> |
| <a href="ToSqlTest_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 2013 Cloudera Inc.</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> <span class="keyword">static</span> org.junit.Assert.fail;</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> org.junit.Ignore;</div> |
| <div class="line"><a name="l00020"></a><span class="lineno"> 20</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="l00021"></a><span class="lineno"> 21</span> </div> |
| <div class="line"><a name="l00022"></a><span class="lineno"> 22</span> <span class="keyword">import</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig.html">com.cloudera.impala.authorization.AuthorizationConfig</a>;</div> |
| <div class="line"><a name="l00023"></a><span class="lineno"> 23</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="l00024"></a><span class="lineno"> 24</span> <span class="keyword">import</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils.html">com.cloudera.impala.testutil.TestUtils</a>;</div> |
| <div class="line"><a name="l00025"></a><span class="lineno"> 25</span> <span class="keyword">import</span> com.google.common.base.Preconditions;</div> |
| <div class="line"><a name="l00026"></a><span class="lineno"> 26</span> </div> |
| <div class="line"><a name="l00027"></a><span class="lineno"> 27</span> <span class="comment">// TODO: Expand this test, in particular, because view creation relies</span></div> |
| <div class="line"><a name="l00028"></a><span class="lineno"> 28</span> <span class="comment">// on producing correct SQL.</span></div> |
| <div class="line"><a name="l00029"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html"> 29</a></span> <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html">ToSqlTest</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="l00030"></a><span class="lineno"> 30</span> </div> |
| <div class="line"><a name="l00031"></a><span class="lineno"> 31</span>  <span class="comment">// Helpers for templated join tests.</span></div> |
| <div class="line"><a name="l00032"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18"> 32</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> <span class="keyword">final</span> String[] <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a> =</div> |
| <div class="line"><a name="l00033"></a><span class="lineno"> 33</span>  <span class="keyword">new</span> String[] {<span class="stringliteral">"USING (id)"</span>, <span class="stringliteral">"ON (a.id = b.id)"</span>};</div> |
| <div class="line"><a name="l00034"></a><span class="lineno"> 34</span> </div> |
| <div class="line"><a name="l00035"></a><span class="lineno"> 35</span>  <span class="comment">// All left semi join types.</span></div> |
| <div class="line"><a name="l00036"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2"> 36</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> <span class="keyword">final</span> String[] <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2">leftSemiJoinTypes_</a> =</div> |
| <div class="line"><a name="l00037"></a><span class="lineno"> 37</span>  <span class="keyword">new</span> String[] {<span class="stringliteral">"LEFT SEMI JOIN"</span>, <span class="stringliteral">"LEFT ANTI JOIN"</span>};</div> |
| <div class="line"><a name="l00038"></a><span class="lineno"> 38</span> </div> |
| <div class="line"><a name="l00039"></a><span class="lineno"> 39</span>  <span class="comment">// All right semi join types.</span></div> |
| <div class="line"><a name="l00040"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc"> 40</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> <span class="keyword">final</span> String[] <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc">rightSemiJoinTypes_</a> =</div> |
| <div class="line"><a name="l00041"></a><span class="lineno"> 41</span>  <span class="keyword">new</span> String[] {<span class="stringliteral">"RIGHT SEMI JOIN"</span>, <span class="stringliteral">"RIGHT ANTI JOIN"</span>};</div> |
| <div class="line"><a name="l00042"></a><span class="lineno"> 42</span> </div> |
| <div class="line"><a name="l00043"></a><span class="lineno"> 43</span>  <span class="comment">// All join types that take an ON or USING clause, i.e., all joins except CROSS JOIN.</span></div> |
| <div class="line"><a name="l00044"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593"> 44</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> <span class="keyword">final</span> String[] <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">joinTypes_</a>;</div> |
| <div class="line"><a name="l00045"></a><span class="lineno"> 45</span> </div> |
| <div class="line"><a name="l00046"></a><span class="lineno"> 46</span>  <span class="comment">// Same as joinTypes_, but excluding semi joins.</span></div> |
| <div class="line"><a name="l00047"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351"> 47</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> <span class="keyword">final</span> String[] <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">nonSemiJoinTypes_</a>;</div> |
| <div class="line"><a name="l00048"></a><span class="lineno"> 48</span> </div> |
| <div class="line"><a name="l00049"></a><span class="lineno"> 49</span>  <span class="keyword">static</span> {</div> |
| <div class="line"><a name="l00050"></a><span class="lineno"> 50</span>  <span class="comment">// Exclude the NULL AWARE LEFT ANTI JOIN operator because it cannot</span></div> |
| <div class="line"><a name="l00051"></a><span class="lineno"> 51</span>  <span class="comment">// be directly expressed via SQL.</span></div> |
| <div class="line"><a name="l00052"></a><span class="lineno"> 52</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">joinTypes_</a> = <span class="keyword">new</span> String[JoinOperator.values().length - 2];</div> |
| <div class="line"><a name="l00053"></a><span class="lineno"> 53</span>  <span class="keywordtype">int</span> numNonSemiJoinTypes = JoinOperator.values().length - 2 -</div> |
| <div class="line"><a name="l00054"></a><span class="lineno"> 54</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2">leftSemiJoinTypes_</a>.length - <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc">rightSemiJoinTypes_</a>.length;</div> |
| <div class="line"><a name="l00055"></a><span class="lineno"> 55</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">nonSemiJoinTypes_</a> = <span class="keyword">new</span> String[numNonSemiJoinTypes];</div> |
| <div class="line"><a name="l00056"></a><span class="lineno"> 56</span>  <span class="keywordtype">int</span> i = 0;</div> |
| <div class="line"><a name="l00057"></a><span class="lineno"> 57</span>  <span class="keywordtype">int</span> j = 0;</div> |
| <div class="line"><a name="l00058"></a><span class="lineno"> 58</span>  for (<a class="code" href="enumcom_1_1cloudera_1_1impala_1_1analysis_1_1JoinOperator.html">JoinOperator</a> op: <a class="code" href="enumcom_1_1cloudera_1_1impala_1_1analysis_1_1JoinOperator.html">JoinOperator</a>.values()) {</div> |
| <div class="line"><a name="l00059"></a><span class="lineno"> 59</span>  <span class="keywordflow">if</span> (op.isCrossJoin() || op.isNullAwareLeftAntiJoin()) <span class="keywordflow">continue</span>;</div> |
| <div class="line"><a name="l00060"></a><span class="lineno"> 60</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">joinTypes_</a>[i++] = op.toString();</div> |
| <div class="line"><a name="l00061"></a><span class="lineno"> 61</span>  <span class="keywordflow">if</span> (op.isSemiJoin()) <span class="keywordflow">continue</span>;</div> |
| <div class="line"><a name="l00062"></a><span class="lineno"> 62</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">nonSemiJoinTypes_</a>[j++] = op.toString();</div> |
| <div class="line"><a name="l00063"></a><span class="lineno"> 63</span>  }</div> |
| <div class="line"><a name="l00064"></a><span class="lineno"> 64</span>  }</div> |
| <div class="line"><a name="l00065"></a><span class="lineno"> 65</span> </div> |
| <div class="line"><a name="l00066"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a158f426d5f0fd3eeab05b29d20707d76"> 66</a></span>  <span class="keyword">private</span> <span class="keyword">static</span> AnalysisContext.AnalysisResult <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a158f426d5f0fd3eeab05b29d20707d76">analyze</a>(String query, String defaultDb) {</div> |
| <div class="line"><a name="l00067"></a><span class="lineno"> 67</span>  <span class="keywordflow">try</span> {</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_1AnalysisContext.html">AnalysisContext</a> analysisCtx = <span class="keyword">new</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalysisContext.html">AnalysisContext</a>(<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a399e5acf1b8bd104705c2fb8a43fc611">catalog_</a>,</div> |
| <div class="line"><a name="l00069"></a><span class="lineno"> 69</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils.html">TestUtils</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils.html#a6c9fa086559d58750e77fb02b21cedfd">createQueryContext</a>(defaultDb, System.getProperty(<span class="stringliteral">"user.name"</span>)),</div> |
| <div class="line"><a name="l00070"></a><span class="lineno"> 70</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig.html">AuthorizationConfig</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig.html#ac037eb9db44991e689a14a4d5d0dacf1">createAuthDisabledConfig</a>());</div> |
| <div class="line"><a name="l00071"></a><span class="lineno"> 71</span>  analysisCtx.analyze(query);</div> |
| <div class="line"><a name="l00072"></a><span class="lineno"> 72</span>  AnalysisContext.AnalysisResult analysisResult = analysisCtx.getAnalysisResult();</div> |
| <div class="line"><a name="l00073"></a><span class="lineno"> 73</span>  Preconditions.checkNotNull(analysisResult.getStmt());</div> |
| <div class="line"><a name="l00074"></a><span class="lineno"> 74</span>  <span class="keywordflow">return</span> analysisResult;</div> |
| <div class="line"><a name="l00075"></a><span class="lineno"> 75</span>  } <span class="keywordflow">catch</span> (Exception e) {</div> |
| <div class="line"><a name="l00076"></a><span class="lineno"> 76</span>  e.printStackTrace();</div> |
| <div class="line"><a name="l00077"></a><span class="lineno"> 77</span>  fail(<span class="stringliteral">"Failed to analyze query: "</span> + query + <span class="stringliteral">"\n"</span> + e.getMessage());</div> |
| <div class="line"><a name="l00078"></a><span class="lineno"> 78</span>  }</div> |
| <div class="line"><a name="l00079"></a><span class="lineno"> 79</span>  <span class="keywordflow">return</span> null;</div> |
| <div class="line"><a name="l00080"></a><span class="lineno"> 80</span>  }</div> |
| <div class="line"><a name="l00081"></a><span class="lineno"> 81</span> </div> |
| <div class="line"><a name="l00082"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c"> 82</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String query, String expected) {</div> |
| <div class="line"><a name="l00083"></a><span class="lineno"> 83</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(query, System.getProperty(<span class="stringliteral">"user.name"</span>), expected);</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> </div> |
| <div class="line"><a name="l00086"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3deb54b0c56febe58bdca9fd31129d76"> 86</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3deb54b0c56febe58bdca9fd31129d76">testToSql</a>(String query, String defaultDb, String expected) {</div> |
| <div class="line"><a name="l00087"></a><span class="lineno"> 87</span>  String actual = null;</div> |
| <div class="line"><a name="l00088"></a><span class="lineno"> 88</span>  <span class="keywordflow">try</span> {</div> |
| <div class="line"><a name="l00089"></a><span class="lineno"> 89</span>  <a class="code" href="interfacecom_1_1cloudera_1_1impala_1_1analysis_1_1ParseNode.html">ParseNode</a> node = <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a1e2e6ad4ec252e68b7dbd69ba310f85a">AnalyzesOk</a>(query, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a022278a60d3b447eaaddc80db5d98337">createAnalyzer</a>(defaultDb));</div> |
| <div class="line"><a name="l00090"></a><span class="lineno"> 90</span>  actual = node.toSql();</div> |
| <div class="line"><a name="l00091"></a><span class="lineno"> 91</span>  <span class="keywordflow">if</span> (!actual.equals(expected)) {</div> |
| <div class="line"><a name="l00092"></a><span class="lineno"> 92</span>  String msg = <span class="stringliteral">"Expected: "</span> + expected + <span class="stringliteral">"\n Actual: "</span> + actual + <span class="stringliteral">"\n"</span>;</div> |
| <div class="line"><a name="l00093"></a><span class="lineno"> 93</span>  System.err.println(msg);</div> |
| <div class="line"><a name="l00094"></a><span class="lineno"> 94</span>  fail(msg);</div> |
| <div class="line"><a name="l00095"></a><span class="lineno"> 95</span>  }</div> |
| <div class="line"><a name="l00096"></a><span class="lineno"> 96</span>  } <span class="keywordflow">catch</span> (Exception e) {</div> |
| <div class="line"><a name="l00097"></a><span class="lineno"> 97</span>  e.printStackTrace();</div> |
| <div class="line"><a name="l00098"></a><span class="lineno"> 98</span>  fail(<span class="stringliteral">"Failed to analyze query: "</span> + query + <span class="stringliteral">"\n"</span> + e.getMessage());</div> |
| <div class="line"><a name="l00099"></a><span class="lineno"> 99</span>  }</div> |
| <div class="line"><a name="l00100"></a><span class="lineno"> 100</span>  <span class="comment">// Parse and analyze the resulting SQL to ensure its validity.</span></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>(actual, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a022278a60d3b447eaaddc80db5d98337">createAnalyzer</a>(defaultDb));</div> |
| <div class="line"><a name="l00102"></a><span class="lineno"> 102</span>  }</div> |
| <div class="line"><a name="l00103"></a><span class="lineno"> 103</span> </div> |
| <div class="line"><a name="l00104"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa"> 104</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(String sql, String expectedSql, String[]... testDims) {</div> |
| <div class="line"><a name="l00105"></a><span class="lineno"> 105</span>  Object[] testVector = <span class="keyword">new</span> Object[testDims.length];</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_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(sql, expectedSql, 0, testVector, testDims);</div> |
| <div class="line"><a name="l00107"></a><span class="lineno"> 107</span>  }</div> |
| <div class="line"><a name="l00108"></a><span class="lineno"> 108</span> </div> |
| <div class="line"><a name="l00109"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#aca4ae64da149bb94c2551832197eb7bf"> 109</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#aca4ae64da149bb94c2551832197eb7bf">runTestTemplate</a>(String sql, String expectedSql, <span class="keywordtype">int</span> dim,</div> |
| <div class="line"><a name="l00110"></a><span class="lineno"> 110</span>  Object[] testVector, String[]... testDims) {</div> |
| <div class="line"><a name="l00111"></a><span class="lineno"> 111</span>  <span class="keywordflow">if</span> (dim >= testDims.length) {</div> |
| <div class="line"><a name="l00112"></a><span class="lineno"> 112</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String.format(sql, testVector), String.format(expectedSql, testVector));</div> |
| <div class="line"><a name="l00113"></a><span class="lineno"> 113</span>  <span class="keywordflow">return</span>;</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="keywordflow">for</span> (String s: testDims[dim]) {</div> |
| <div class="line"><a name="l00116"></a><span class="lineno"> 116</span>  testVector[dim] = s;</div> |
| <div class="line"><a name="l00117"></a><span class="lineno"> 117</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(sql, expectedSql, dim + 1, testVector, testDims);</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>  }</div> |
| <div class="line"><a name="l00120"></a><span class="lineno"> 120</span> </div> |
| <div class="line"><a name="l00135"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5"> 135</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String query, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">TableName</a> tbl, String expectedSql) {</div> |
| <div class="line"><a name="l00136"></a><span class="lineno"> 136</span>  Preconditions.checkState(tbl.isFullyQualified());</div> |
| <div class="line"><a name="l00137"></a><span class="lineno"> 137</span>  Preconditions.checkState(query.contains(<span class="stringliteral">"$TBL"</span>));</div> |
| <div class="line"><a name="l00138"></a><span class="lineno"> 138</span>  String uqQuery = query.replace(<span class="stringliteral">"$TBL"</span>, tbl.getTbl());</div> |
| <div class="line"><a name="l00139"></a><span class="lineno"> 139</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(uqQuery, tbl.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html#aeba8e4c3a8552e9da915078adba3948c">getDb</a>(), expectedSql);</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>(uqQuery, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a022278a60d3b447eaaddc80db5d98337">createAnalyzer</a>(tbl.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html#aeba8e4c3a8552e9da915078adba3948c">getDb</a>()));</div> |
| <div class="line"><a name="l00141"></a><span class="lineno"> 141</span>  String fqQuery = query.replace(<span class="stringliteral">"$TBL"</span>, tbl.toString());</div> |
| <div class="line"><a name="l00142"></a><span class="lineno"> 142</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(fqQuery, expectedSql);</div> |
| <div class="line"><a name="l00143"></a><span class="lineno"> 143</span>  }</div> |
| <div class="line"><a name="l00144"></a><span class="lineno"> 144</span> </div> |
| <div class="line"><a name="l00145"></a><span class="lineno"> 145</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00146"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a1d7251ff3274dc6d2455af6db3805864"> 146</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a1d7251ff3274dc6d2455af6db3805864">selectListTest</a>() {</div> |
| <div class="line"><a name="l00147"></a><span class="lineno"> 147</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1234, 1234.0, 1234.0 + 1, 1234.0 + 1.0, 1 + 1, \"abc\" "</span> +</div> |
| <div class="line"><a name="l00148"></a><span class="lineno"> 148</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00149"></a><span class="lineno"> 149</span>  <span class="stringliteral">"SELECT 1234, 1234.0, 1234.0 + 1, 1234.0 + 1.0, 1 + 1, 'abc' "</span> +</div> |
| <div class="line"><a name="l00150"></a><span class="lineno"> 150</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00151"></a><span class="lineno"> 151</span>  <span class="comment">// Test aliases.</span></div> |
| <div class="line"><a name="l00152"></a><span class="lineno"> 152</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1234 i, 1234.0 as j, (1234.0 + 1) k, (1234.0 + 1.0) as l "</span> +</div> |
| <div class="line"><a name="l00153"></a><span class="lineno"> 153</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00154"></a><span class="lineno"> 154</span>  <span class="stringliteral">"SELECT 1234 i, 1234.0 j, (1234.0 + 1) k, (1234.0 + 1.0) l "</span> +</div> |
| <div class="line"><a name="l00155"></a><span class="lineno"> 155</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00156"></a><span class="lineno"> 156</span>  <span class="comment">// Test select without from.</span></div> |
| <div class="line"><a name="l00157"></a><span class="lineno"> 157</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1234 i, 1234.0 as j, (1234.0 + 1) k, (1234.0 + 1.0) as l"</span>,</div> |
| <div class="line"><a name="l00158"></a><span class="lineno"> 158</span>  <span class="stringliteral">"SELECT 1234 i, 1234.0 j, (1234.0 + 1) k, (1234.0 + 1.0) l"</span>);</div> |
| <div class="line"><a name="l00159"></a><span class="lineno"> 159</span>  <span class="comment">// Test select without from.</span></div> |
| <div class="line"><a name="l00160"></a><span class="lineno"> 160</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select null, 1234 < 5678, 1234.0 < 5678.0, 1234 < null "</span> +</div> |
| <div class="line"><a name="l00161"></a><span class="lineno"> 161</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00162"></a><span class="lineno"> 162</span>  <span class="stringliteral">"SELECT NULL, 1234 < 5678, 1234.0 < 5678.0, 1234 < NULL "</span> +</div> |
| <div class="line"><a name="l00163"></a><span class="lineno"> 163</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00164"></a><span class="lineno"> 164</span>  }</div> |
| <div class="line"><a name="l00165"></a><span class="lineno"> 165</span> </div> |
| <div class="line"><a name="l00166"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856"> 166</a></span>  <span class="keyword">private</span> <span class="keywordtype">boolean</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856">isCollectionTableRef</a>(String tableName) {</div> |
| <div class="line"><a name="l00167"></a><span class="lineno"> 167</span>  <span class="keywordflow">return</span> tableName.split(<span class="stringliteral">"\\."</span>).length > 0;</div> |
| <div class="line"><a name="l00168"></a><span class="lineno"> 168</span>  }</div> |
| <div class="line"><a name="l00169"></a><span class="lineno"> 169</span> </div> |
| <div class="line"><a name="l00174"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e"> 174</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(String[] tables, String[] columns)</div> |
| <div class="line"><a name="l00175"></a><span class="lineno"> 175</span>  <span class="keywordflow">throws</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00176"></a><span class="lineno"> 176</span>  <span class="keywordflow">for</span> (String tbl: tables) {</div> |
| <div class="line"><a name="l00177"></a><span class="lineno"> 177</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">TableName</a> tblName = <span class="keyword">new</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">TableName</a>(<span class="stringliteral">"functional"</span>, tbl);</div> |
| <div class="line"><a name="l00178"></a><span class="lineno"> 178</span>  String uqAlias = tbl.substring(tbl.lastIndexOf(<span class="stringliteral">"."</span>) + 1);</div> |
| <div class="line"><a name="l00179"></a><span class="lineno"> 179</span>  String fqAlias = <span class="stringliteral">"functional."</span> + tbl;</div> |
| <div class="line"><a name="l00180"></a><span class="lineno"> 180</span>  <span class="keywordtype">boolean</span> isCollectionTblRef = <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856">isCollectionTableRef</a>(tbl);</div> |
| <div class="line"><a name="l00181"></a><span class="lineno"> 181</span>  <span class="keywordflow">for</span> (String col: columns) {</div> |
| <div class="line"><a name="l00182"></a><span class="lineno"> 182</span>  <span class="comment">// Test implicit table aliases with unqualified and fully qualified</span></div> |
| <div class="line"><a name="l00183"></a><span class="lineno"> 183</span>  <span class="comment">// table/view names. Unqualified table/view names should be fully</span></div> |
| <div class="line"><a name="l00184"></a><span class="lineno"> 184</span>  <span class="comment">// qualified in the generated SQL (IMPALA-962).</span></div> |
| <div class="line"><a name="l00185"></a><span class="lineno"> 185</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select %s from $TBL"</span>, col), tblName,</div> |
| <div class="line"><a name="l00186"></a><span class="lineno"> 186</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s"</span>, col, fqAlias));</div> |
| <div class="line"><a name="l00187"></a><span class="lineno"> 187</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select %s.%s from $TBL"</span>, uqAlias, col), tblName,</div> |
| <div class="line"><a name="l00188"></a><span class="lineno"> 188</span>  String.format(<span class="stringliteral">"SELECT %s.%s FROM %s"</span>, uqAlias, col, fqAlias));</div> |
| <div class="line"><a name="l00189"></a><span class="lineno"> 189</span>  <span class="comment">// Only references to base tables/views have a fully-qualified implicit alias.</span></div> |
| <div class="line"><a name="l00190"></a><span class="lineno"> 190</span>  <span class="keywordflow">if</span> (!isCollectionTblRef) {</div> |
| <div class="line"><a name="l00191"></a><span class="lineno"> 191</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select %s.%s from $TBL"</span>, fqAlias, col), tblName,</div> |
| <div class="line"><a name="l00192"></a><span class="lineno"> 192</span>  String.format(<span class="stringliteral">"SELECT %s.%s FROM %s"</span>, fqAlias, col, fqAlias));</div> |
| <div class="line"><a name="l00193"></a><span class="lineno"> 193</span>  }</div> |
| <div class="line"><a name="l00194"></a><span class="lineno"> 194</span> </div> |
| <div class="line"><a name="l00195"></a><span class="lineno"> 195</span>  <span class="comment">// Explicit table alias.</span></div> |
| <div class="line"><a name="l00196"></a><span class="lineno"> 196</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select %s from $TBL a"</span>, col), tblName,</div> |
| <div class="line"><a name="l00197"></a><span class="lineno"> 197</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s a"</span>, col, fqAlias));</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_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select a.%s from $TBL a"</span>, col), tblName,</div> |
| <div class="line"><a name="l00199"></a><span class="lineno"> 199</span>  String.format(<span class="stringliteral">"SELECT a.%s FROM %s a"</span>, col, fqAlias));</div> |
| <div class="line"><a name="l00200"></a><span class="lineno"> 200</span>  }</div> |
| <div class="line"><a name="l00201"></a><span class="lineno"> 201</span>  }</div> |
| <div class="line"><a name="l00202"></a><span class="lineno"> 202</span> </div> |
| <div class="line"><a name="l00203"></a><span class="lineno"> 203</span>  <span class="comment">// Multiple implicit fully-qualified aliases work.</span></div> |
| <div class="line"><a name="l00204"></a><span class="lineno"> 204</span>  <span class="keywordflow">for</span> (String t1: tables) {</div> |
| <div class="line"><a name="l00205"></a><span class="lineno"> 205</span>  <span class="keywordflow">for</span> (String t2: tables) {</div> |
| <div class="line"><a name="l00206"></a><span class="lineno"> 206</span>  <span class="keywordflow">if</span> (t1 == t2) <span class="keywordflow">continue</span>;</div> |
| <div class="line"><a name="l00207"></a><span class="lineno"> 207</span>  <span class="comment">// Collection tables do not have a fully-qualified implicit alias.</span></div> |
| <div class="line"><a name="l00208"></a><span class="lineno"> 208</span>  <span class="keywordflow">if</span> (<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856">isCollectionTableRef</a>(t1) && <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856">isCollectionTableRef</a>(t2)) <span class="keywordflow">continue</span>;</div> |
| <div class="line"><a name="l00209"></a><span class="lineno"> 209</span>  <span class="keywordflow">for</span> (String col: columns) {</div> |
| <div class="line"><a name="l00210"></a><span class="lineno"> 210</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String.format(</div> |
| <div class="line"><a name="l00211"></a><span class="lineno"> 211</span>  <span class="stringliteral">"select functional.%s.%s, functional.%s.%s "</span> +</div> |
| <div class="line"><a name="l00212"></a><span class="lineno"> 212</span>  <span class="stringliteral">"from functional.%s, functional.%s"</span>, t1, col, t2, col, t1, t2),</div> |
| <div class="line"><a name="l00213"></a><span class="lineno"> 213</span>  String.format(<span class="stringliteral">"SELECT functional.%s.%s, functional.%s.%s "</span> +</div> |
| <div class="line"><a name="l00214"></a><span class="lineno"> 214</span>  <span class="stringliteral">"FROM functional.%s, functional.%s"</span>, t1, col, t2, col, t1, t2));</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>  }</div> |
| <div class="line"><a name="l00217"></a><span class="lineno"> 217</span>  }</div> |
| <div class="line"><a name="l00218"></a><span class="lineno"> 218</span>  }</div> |
| <div class="line"><a name="l00219"></a><span class="lineno"> 219</span> </div> |
| <div class="line"><a name="l00225"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16"> 225</a></span>  <span class="keyword">private</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16">testChildTableRefs</a>(String childTable, String childColumn) {</div> |
| <div class="line"><a name="l00226"></a><span class="lineno"> 226</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">TableName</a> tbl = <span class="keyword">new</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">TableName</a>(<span class="stringliteral">"functional"</span>, <span class="stringliteral">"allcomplextypes"</span>);</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">// Child table uses unqualified implicit alias of parent table.</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_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00230"></a><span class="lineno"> 230</span>  String.format(<span class="stringliteral">"select %s from $TBL, allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00231"></a><span class="lineno"> 231</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00232"></a><span class="lineno"> 232</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s, functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00233"></a><span class="lineno"> 233</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00234"></a><span class="lineno"> 234</span>  <span class="comment">// Child table uses fully qualified implicit alias of parent table.</span></div> |
| <div class="line"><a name="l00235"></a><span class="lineno"> 235</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00236"></a><span class="lineno"> 236</span>  String.format(<span class="stringliteral">"select %s from $TBL, functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00237"></a><span class="lineno"> 237</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00238"></a><span class="lineno"> 238</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s, functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00239"></a><span class="lineno"> 239</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00240"></a><span class="lineno"> 240</span>  <span class="comment">// Child table uses explicit alias of parent table.</span></div> |
| <div class="line"><a name="l00241"></a><span class="lineno"> 241</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00242"></a><span class="lineno"> 242</span>  String.format(<span class="stringliteral">"select %s from $TBL a, a.%s"</span>,</div> |
| <div class="line"><a name="l00243"></a><span class="lineno"> 243</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00244"></a><span class="lineno"> 244</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s a, a.%s"</span>,</div> |
| <div class="line"><a name="l00245"></a><span class="lineno"> 245</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00246"></a><span class="lineno"> 246</span> </div> |
| <div class="line"><a name="l00247"></a><span class="lineno"> 247</span>  <span class="comment">// Parent/child/child join.</span></div> |
| <div class="line"><a name="l00248"></a><span class="lineno"> 248</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00249"></a><span class="lineno"> 249</span>  String.format(<span class="stringliteral">"select b.%s from $TBL a, a.%s b, a.int_map_col c"</span>,</div> |
| <div class="line"><a name="l00250"></a><span class="lineno"> 250</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00251"></a><span class="lineno"> 251</span>  String.format(<span class="stringliteral">"SELECT b.%s FROM %s a, a.%s b, a.int_map_col c"</span>,</div> |
| <div class="line"><a name="l00252"></a><span class="lineno"> 252</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00253"></a><span class="lineno"> 253</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00254"></a><span class="lineno"> 254</span>  String.format(<span class="stringliteral">"select c.%s from $TBL a, a.int_array_col b, a.%s c"</span>,</div> |
| <div class="line"><a name="l00255"></a><span class="lineno"> 255</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00256"></a><span class="lineno"> 256</span>  String.format(<span class="stringliteral">"SELECT c.%s FROM %s a, a.int_array_col b, a.%s c"</span>,</div> |
| <div class="line"><a name="l00257"></a><span class="lineno"> 257</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00258"></a><span class="lineno"> 258</span> </div> |
| <div class="line"><a name="l00259"></a><span class="lineno"> 259</span>  <span class="comment">// Test join types. Parent/child joins do not require an ON or USING clause.</span></div> |
| <div class="line"><a name="l00260"></a><span class="lineno"> 260</span>  <span class="keywordflow">for</span> (String joinType: <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">joinTypes_</a>) {</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_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select 1 from $TBL %s allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00262"></a><span class="lineno"> 262</span>  joinType, childTable), tbl,</div> |
| <div class="line"><a name="l00263"></a><span class="lineno"> 263</span>  String.format(<span class="stringliteral">"SELECT 1 FROM %s %s functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00264"></a><span class="lineno"> 264</span>  tbl.toSql(), joinType, childTable));</div> |
| <div class="line"><a name="l00265"></a><span class="lineno"> 265</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(String.format(<span class="stringliteral">"select 1 from $TBL a %s a.%s"</span>,</div> |
| <div class="line"><a name="l00266"></a><span class="lineno"> 266</span>  joinType, childTable), tbl,</div> |
| <div class="line"><a name="l00267"></a><span class="lineno"> 267</span>  String.format(<span class="stringliteral">"SELECT 1 FROM %s a %s a.%s"</span>,</div> |
| <div class="line"><a name="l00268"></a><span class="lineno"> 268</span>  tbl.toSql(), joinType, childTable));</div> |
| <div class="line"><a name="l00269"></a><span class="lineno"> 269</span>  }</div> |
| <div class="line"><a name="l00270"></a><span class="lineno"> 270</span> </div> |
| <div class="line"><a name="l00271"></a><span class="lineno"> 271</span>  <span class="comment">// Legal, but not a parent/child join.</span></div> |
| <div class="line"><a name="l00272"></a><span class="lineno"> 272</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00273"></a><span class="lineno"> 273</span>  String.format(<span class="stringliteral">"select %s from $TBL a, functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00274"></a><span class="lineno"> 274</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00275"></a><span class="lineno"> 275</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s a, functional.allcomplextypes.%s"</span>,</div> |
| <div class="line"><a name="l00276"></a><span class="lineno"> 276</span>  childColumn, tbl.toSql(), childTable));</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_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">TblsTestToSql</a>(</div> |
| <div class="line"><a name="l00278"></a><span class="lineno"> 278</span>  String.format(<span class="stringliteral">"select %s from $TBL.%s, functional.allcomplextypes"</span>,</div> |
| <div class="line"><a name="l00279"></a><span class="lineno"> 279</span>  childColumn, childTable), tbl,</div> |
| <div class="line"><a name="l00280"></a><span class="lineno"> 280</span>  String.format(<span class="stringliteral">"SELECT %s FROM %s.%s, functional.allcomplextypes"</span>,</div> |
| <div class="line"><a name="l00281"></a><span class="lineno"> 281</span>  childColumn, tbl.toSql(), childTable));</div> |
| <div class="line"><a name="l00282"></a><span class="lineno"> 282</span>  }</div> |
| <div class="line"><a name="l00283"></a><span class="lineno"> 283</span> </div> |
| <div class="line"><a name="l00284"></a><span class="lineno"> 284</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00285"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a04d440534ef30479ea413a6841006cb6"> 285</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a04d440534ef30479ea413a6841006cb6">TestTableAliases</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00286"></a><span class="lineno"> 286</span>  String[] tables = <span class="keyword">new</span> String[] { <span class="stringliteral">"alltypes"</span>, <span class="stringliteral">"alltypes_view"</span> };</div> |
| <div class="line"><a name="l00287"></a><span class="lineno"> 287</span>  String[] columns = <span class="keyword">new</span> String[] { <span class="stringliteral">"int_col"</span>, <span class="stringliteral">"*"</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_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(tables, columns);</div> |
| <div class="line"><a name="l00289"></a><span class="lineno"> 289</span> </div> |
| <div class="line"><a name="l00290"></a><span class="lineno"> 290</span>  <span class="comment">// Unqualified '*' is not ambiguous.</span></div> |
| <div class="line"><a name="l00291"></a><span class="lineno"> 291</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00292"></a><span class="lineno"> 292</span>  <span class="stringliteral">"cross join functional_parquet.alltypes"</span>,</div> |
| <div class="line"><a name="l00293"></a><span class="lineno"> 293</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes CROSS JOIN functional_parquet.alltypes"</span>);</div> |
| <div class="line"><a name="l00294"></a><span class="lineno"> 294</span>  }</div> |
| <div class="line"><a name="l00295"></a><span class="lineno"> 295</span> </div> |
| <div class="line"><a name="l00296"></a><span class="lineno"> 296</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00297"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a21030448315556e130370c46a74a670a"> 297</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a21030448315556e130370c46a74a670a">TestStructFields</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00298"></a><span class="lineno"> 298</span>  String[] tables = <span class="keyword">new</span> String[] { <span class="stringliteral">"allcomplextypes"</span>, };</div> |
| <div class="line"><a name="l00299"></a><span class="lineno"> 299</span>  String[] columns = <span class="keyword">new</span> String[] { <span class="stringliteral">"id"</span>, <span class="stringliteral">"int_struct_col.f1"</span>,</div> |
| <div class="line"><a name="l00300"></a><span class="lineno"> 300</span>  <span class="stringliteral">"nested_struct_col.f2.f12.f21"</span> };</div> |
| <div class="line"><a name="l00301"></a><span class="lineno"> 301</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(tables, columns);</div> |
| <div class="line"><a name="l00302"></a><span class="lineno"> 302</span>  }</div> |
| <div class="line"><a name="l00303"></a><span class="lineno"> 303</span> </div> |
| <div class="line"><a name="l00304"></a><span class="lineno"> 304</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00305"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a67cdae37bf56131e69bd1ce674e47d9c"> 305</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a67cdae37bf56131e69bd1ce674e47d9c">TestCollectionTableRefs</a>() throws <a class="code" href="classcom_1_1cloudera_1_1impala_1_1common_1_1AnalysisException.html">AnalysisException</a> {</div> |
| <div class="line"><a name="l00306"></a><span class="lineno"> 306</span>  <span class="comment">// Test ARRAY type referenced as a table.</span></div> |
| <div class="line"><a name="l00307"></a><span class="lineno"> 307</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(<span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00308"></a><span class="lineno"> 308</span>  <span class="stringliteral">"allcomplextypes.int_array_col"</span>},</div> |
| <div class="line"><a name="l00309"></a><span class="lineno"> 309</span>  <span class="keyword">new</span> String[] {<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#a158469d3042e41b8c8b282ad383365ff">Path.ARRAY_ITEM_FIELD_NAME</a>, <span class="stringliteral">"*"</span>});</div> |
| <div class="line"><a name="l00310"></a><span class="lineno"> 310</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(<span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00311"></a><span class="lineno"> 311</span>  <span class="stringliteral">"allcomplextypes.struct_array_col"</span>},</div> |
| <div class="line"><a name="l00312"></a><span class="lineno"> 312</span>  <span class="keyword">new</span> String[] {<span class="stringliteral">"f1"</span>, <span class="stringliteral">"f2"</span>, <span class="stringliteral">"*"</span>});</div> |
| <div class="line"><a name="l00313"></a><span class="lineno"> 313</span> </div> |
| <div class="line"><a name="l00314"></a><span class="lineno"> 314</span>  <span class="comment">// Test MAP type referenced as a table.</span></div> |
| <div class="line"><a name="l00315"></a><span class="lineno"> 315</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(<span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00316"></a><span class="lineno"> 316</span>  <span class="stringliteral">"allcomplextypes.int_map_col"</span>},</div> |
| <div class="line"><a name="l00317"></a><span class="lineno"> 317</span>  <span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00318"></a><span class="lineno"> 318</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#ad287a1bd3eb082ab61e9b08b55146728">Path.MAP_KEY_FIELD_NAME</a>,</div> |
| <div class="line"><a name="l00319"></a><span class="lineno"> 319</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#abd0f3c7b25a10ffeb1a50d802497b07c">Path.MAP_VALUE_FIELD_NAME</a>,</div> |
| <div class="line"><a name="l00320"></a><span class="lineno"> 320</span>  <span class="stringliteral">"*"</span>});</div> |
| <div class="line"><a name="l00321"></a><span class="lineno"> 321</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(<span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00322"></a><span class="lineno"> 322</span>  <span class="stringliteral">"allcomplextypes.struct_map_col"</span>},</div> |
| <div class="line"><a name="l00323"></a><span class="lineno"> 323</span>  <span class="keyword">new</span> String[] {<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#ad287a1bd3eb082ab61e9b08b55146728">Path.MAP_KEY_FIELD_NAME</a>, <span class="stringliteral">"f1"</span>, <span class="stringliteral">"f2"</span>, <span class="stringliteral">"*"</span>});</div> |
| <div class="line"><a name="l00324"></a><span class="lineno"> 324</span> </div> |
| <div class="line"><a name="l00325"></a><span class="lineno"> 325</span>  <span class="comment">// Test complex table ref path with structs and multiple collections.</span></div> |
| <div class="line"><a name="l00326"></a><span class="lineno"> 326</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">testAllTableAliases</a>(<span class="keyword">new</span> String[] {</div> |
| <div class="line"><a name="l00327"></a><span class="lineno"> 327</span>  <span class="stringliteral">"allcomplextypes.complex_nested_struct_col.f2.f12"</span>},</div> |
| <div class="line"><a name="l00328"></a><span class="lineno"> 328</span>  <span class="keyword">new</span> String[] {<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#ad287a1bd3eb082ab61e9b08b55146728">Path.MAP_KEY_FIELD_NAME</a>, <span class="stringliteral">"f21"</span>, <span class="stringliteral">"*"</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">// Test toSql() of child table refs.</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_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16">testChildTableRefs</a>(<span class="stringliteral">"int_array_col"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html">Path</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#a158469d3042e41b8c8b282ad383365ff">ARRAY_ITEM_FIELD_NAME</a>);</div> |
| <div class="line"><a name="l00332"></a><span class="lineno"> 332</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16">testChildTableRefs</a>(<span class="stringliteral">"int_map_col"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html">Path</a>.<a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#ad287a1bd3eb082ab61e9b08b55146728">MAP_KEY_FIELD_NAME</a>);</div> |
| <div class="line"><a name="l00333"></a><span class="lineno"> 333</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16">testChildTableRefs</a>(<span class="stringliteral">"complex_nested_struct_col.f2.f12"</span>, <span class="stringliteral">"f21"</span>);</div> |
| <div class="line"><a name="l00334"></a><span class="lineno"> 334</span>  }</div> |
| <div class="line"><a name="l00335"></a><span class="lineno"> 335</span> </div> |
| <div class="line"><a name="l00340"></a><span class="lineno"> 340</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00341"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a19f9ebed4855f6d2d8c102a326960687"> 341</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a19f9ebed4855f6d2d8c102a326960687">TestIdentifierQuoting</a>() {</div> |
| <div class="line"><a name="l00342"></a><span class="lineno"> 342</span>  <span class="comment">// The quotes of quoted identifiers will be removed if they are unnecessary.</span></div> |
| <div class="line"><a name="l00343"></a><span class="lineno"> 343</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1 as `abc`, 2.0 as 'xyz'"</span>, <span class="stringliteral">"SELECT 1 abc, 2.0 xyz"</span>);</div> |
| <div class="line"><a name="l00344"></a><span class="lineno"> 344</span> </div> |
| <div class="line"><a name="l00345"></a><span class="lineno"> 345</span>  <span class="comment">// These identifiers are lexable by Impala but not Hive. For view compatibility</span></div> |
| <div class="line"><a name="l00346"></a><span class="lineno"> 346</span>  <span class="comment">// we enclose the idents in quotes.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1 as _c0, 2.0 as $abc"</span>, <span class="stringliteral">"SELECT 1 `_c0`, 2.0 `$abc`"</span>);</div> |
| <div class="line"><a name="l00348"></a><span class="lineno"> 348</span> </div> |
| <div class="line"><a name="l00349"></a><span class="lineno"> 349</span>  <span class="comment">// Quoted identifiers that require quoting in both Impala and Hive.</span></div> |
| <div class="line"><a name="l00350"></a><span class="lineno"> 350</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1 as `???`, 2.0 as '^^^'"</span>, <span class="stringliteral">"SELECT 1 `???`, 2.0 `^^^`"</span>);</div> |
| <div class="line"><a name="l00351"></a><span class="lineno"> 351</span> </div> |
| <div class="line"><a name="l00352"></a><span class="lineno"> 352</span>  <span class="comment">// Test quoting of identifiers that are Impala keywords.</span></div> |
| <div class="line"><a name="l00353"></a><span class="lineno"> 353</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select `end`.`alter`, `end`.`table` from "</span> +</div> |
| <div class="line"><a name="l00354"></a><span class="lineno"> 354</span>  <span class="stringliteral">"(select 1 as `alter`, 2 as `table`) `end`"</span>,</div> |
| <div class="line"><a name="l00355"></a><span class="lineno"> 355</span>  <span class="stringliteral">"SELECT `end`.`alter`, `end`.`table` FROM "</span> +</div> |
| <div class="line"><a name="l00356"></a><span class="lineno"> 356</span>  <span class="stringliteral">"(SELECT 1 `alter`, 2 `table`) `end`"</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">// Test quoting of inline view aliases.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select a from (select 1 as a) as _t"</span>,</div> |
| <div class="line"><a name="l00360"></a><span class="lineno"> 360</span>  <span class="stringliteral">"SELECT a FROM (SELECT 1 a) `_t`"</span>);</div> |
| <div class="line"><a name="l00361"></a><span class="lineno"> 361</span> </div> |
| <div class="line"><a name="l00362"></a><span class="lineno"> 362</span>  <span class="comment">// Test quoting of WITH-clause views.</span></div> |
| <div class="line"><a name="l00363"></a><span class="lineno"> 363</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with _t as (select 1 as a) select * from _t"</span>,</div> |
| <div class="line"><a name="l00364"></a><span class="lineno"> 364</span>  <span class="stringliteral">"WITH `_t` AS (SELECT 1 a) SELECT * FROM `_t`"</span>);</div> |
| <div class="line"><a name="l00365"></a><span class="lineno"> 365</span> </div> |
| <div class="line"><a name="l00366"></a><span class="lineno"> 366</span>  <span class="comment">// Test quoting of non-SlotRef exprs in inline views.</span></div> |
| <div class="line"><a name="l00367"></a><span class="lineno"> 367</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select `1 + 10`, `trim('abc')` from (select 1 + 10, trim('abc')) as t"</span>,</div> |
| <div class="line"><a name="l00368"></a><span class="lineno"> 368</span>  <span class="stringliteral">"SELECT `1 + 10`, `trim('abc')` FROM (SELECT 1 + 10, trim('abc')) t"</span>);</div> |
| <div class="line"><a name="l00369"></a><span class="lineno"> 369</span>  }</div> |
| <div class="line"><a name="l00370"></a><span class="lineno"> 370</span> </div> |
| <div class="line"><a name="l00371"></a><span class="lineno"> 371</span>  <span class="comment">// Test the toSql() output of the where clause.</span></div> |
| <div class="line"><a name="l00372"></a><span class="lineno"> 372</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00373"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26c6a3e237522f7826af92e4b990fb87"> 373</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26c6a3e237522f7826af92e4b990fb87">whereTest</a>() {</div> |
| <div class="line"><a name="l00374"></a><span class="lineno"> 374</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00375"></a><span class="lineno"> 375</span>  <span class="stringliteral">"where tinyint_col < 40 OR int_col = 4 AND float_col > 1.4"</span>,</div> |
| <div class="line"><a name="l00376"></a><span class="lineno"> 376</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00377"></a><span class="lineno"> 377</span>  <span class="stringliteral">"WHERE tinyint_col < 40 OR int_col = 4 AND float_col > 1.4"</span>);</div> |
| <div class="line"><a name="l00378"></a><span class="lineno"> 378</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes where string_col = \"abc\""</span>,</div> |
| <div class="line"><a name="l00379"></a><span class="lineno"> 379</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes WHERE string_col = 'abc'"</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes where string_col = 'abc'"</span>,</div> |
| <div class="line"><a name="l00381"></a><span class="lineno"> 381</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes WHERE string_col = 'abc'"</span>);</div> |
| <div class="line"><a name="l00382"></a><span class="lineno"> 382</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00383"></a><span class="lineno"> 383</span>  <span class="stringliteral">"where 5 between smallint_col and int_col"</span>,</div> |
| <div class="line"><a name="l00384"></a><span class="lineno"> 384</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes WHERE 5 BETWEEN smallint_col AND int_col"</span>);</div> |
| <div class="line"><a name="l00385"></a><span class="lineno"> 385</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00386"></a><span class="lineno"> 386</span>  <span class="stringliteral">"where 5 not between smallint_col and int_col"</span>,</div> |
| <div class="line"><a name="l00387"></a><span class="lineno"> 387</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00388"></a><span class="lineno"> 388</span>  <span class="stringliteral">"WHERE 5 NOT BETWEEN smallint_col AND int_col"</span>);</div> |
| <div class="line"><a name="l00389"></a><span class="lineno"> 389</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes where 5 in (smallint_col, int_col)"</span>,</div> |
| <div class="line"><a name="l00390"></a><span class="lineno"> 390</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes WHERE 5 IN (smallint_col, int_col)"</span>);</div> |
| <div class="line"><a name="l00391"></a><span class="lineno"> 391</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00392"></a><span class="lineno"> 392</span>  <span class="stringliteral">"where 5 not in (smallint_col, int_col)"</span>,</div> |
| <div class="line"><a name="l00393"></a><span class="lineno"> 393</span>  <span class="stringliteral">"SELECT id FROM functional.alltypes WHERE 5 NOT IN (smallint_col, int_col)"</span>);</div> |
| <div class="line"><a name="l00394"></a><span class="lineno"> 394</span>  }</div> |
| <div class="line"><a name="l00395"></a><span class="lineno"> 395</span> </div> |
| <div class="line"><a name="l00396"></a><span class="lineno"> 396</span>  <span class="comment">// Test the toSql() output of joins in a standalone select block.</span></div> |
| <div class="line"><a name="l00397"></a><span class="lineno"> 397</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00398"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#af02bc01ae0d503b3ad035bf6bdd18b70"> 398</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#af02bc01ae0d503b3ad035bf6bdd18b70">joinTest</a>() {</div> |
| <div class="line"><a name="l00399"></a><span class="lineno"> 399</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes a, functional.alltypes b "</span> +</div> |
| <div class="line"><a name="l00400"></a><span class="lineno"> 400</span>  <span class="stringliteral">"where a.id = b.id"</span>,</div> |
| <div class="line"><a name="l00401"></a><span class="lineno"> 401</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes a, functional.alltypes b WHERE a.id = b.id"</span>);</div> |
| <div class="line"><a name="l00402"></a><span class="lineno"> 402</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes a cross join functional.alltypes b"</span>,</div> |
| <div class="line"><a name="l00403"></a><span class="lineno"> 403</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes a CROSS JOIN functional.alltypes b"</span>);</div> |
| <div class="line"><a name="l00404"></a><span class="lineno"> 404</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"select * from functional.alltypes a %s functional.alltypes b %s"</span>,</div> |
| <div class="line"><a name="l00405"></a><span class="lineno"> 405</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes a %s functional.alltypes b %s"</span>,</div> |
| <div class="line"><a name="l00406"></a><span class="lineno"> 406</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">joinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00407"></a><span class="lineno"> 407</span>  }</div> |
| <div class="line"><a name="l00408"></a><span class="lineno"> 408</span> </div> |
| <div class="line"><a name="l00414"></a><span class="lineno"> 414</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00415"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ace7ea1025296ea0878bef4f82ba05e09"> 415</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ace7ea1025296ea0878bef4f82ba05e09">planHintsTest</a>() {</div> |
| <div class="line"><a name="l00416"></a><span class="lineno"> 416</span>  String[][] hintStyles = <span class="keyword">new</span> String[][] {</div> |
| <div class="line"><a name="l00417"></a><span class="lineno"> 417</span>  <span class="keyword">new</span> String[] { <span class="stringliteral">"/* +"</span>, <span class="stringliteral">"*/"</span> }, <span class="comment">// traditional commented hint</span></div> |
| <div class="line"><a name="l00418"></a><span class="lineno"> 418</span>  <span class="keyword">new</span> String[] { <span class="stringliteral">"\n-- +"</span>, <span class="stringliteral">"\n"</span> }, <span class="comment">// eol commented hint</span></div> |
| <div class="line"><a name="l00419"></a><span class="lineno"> 419</span>  <span class="keyword">new</span> String[] { <span class="stringliteral">"["</span>, <span class="stringliteral">"]"</span> } <span class="comment">// legacy style</span></div> |
| <div class="line"><a name="l00420"></a><span class="lineno"> 420</span>  };</div> |
| <div class="line"><a name="l00421"></a><span class="lineno"> 421</span>  <span class="keywordflow">for</span> (String[] hintStyle: hintStyles) {</div> |
| <div class="line"><a name="l00422"></a><span class="lineno"> 422</span>  String prefix = hintStyle[0];</div> |
| <div class="line"><a name="l00423"></a><span class="lineno"> 423</span>  String suffix = hintStyle[1];</div> |
| <div class="line"><a name="l00424"></a><span class="lineno"> 424</span> </div> |
| <div class="line"><a name="l00425"></a><span class="lineno"> 425</span>  <span class="comment">// Join hint.</span></div> |
| <div class="line"><a name="l00426"></a><span class="lineno"> 426</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String.format(</div> |
| <div class="line"><a name="l00427"></a><span class="lineno"> 427</span>  <span class="stringliteral">"select * from functional.alltypes a join %sbroadcast%s "</span> +</div> |
| <div class="line"><a name="l00428"></a><span class="lineno"> 428</span>  <span class="stringliteral">"functional.alltypes b on a.id = b.id"</span>, prefix, suffix),</div> |
| <div class="line"><a name="l00429"></a><span class="lineno"> 429</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes a INNER JOIN \n-- +broadcast\n "</span> +</div> |
| <div class="line"><a name="l00430"></a><span class="lineno"> 430</span>  <span class="stringliteral">"functional.alltypes b ON a.id = b.id"</span>);</div> |
| <div class="line"><a name="l00431"></a><span class="lineno"> 431</span> </div> |
| <div class="line"><a name="l00432"></a><span class="lineno"> 432</span>  <span class="comment">// Insert hint.</span></div> |
| <div class="line"><a name="l00433"></a><span class="lineno"> 433</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String.format(</div> |
| <div class="line"><a name="l00434"></a><span class="lineno"> 434</span>  <span class="stringliteral">"insert into functional.alltypes(int_col, bool_col) "</span> +</div> |
| <div class="line"><a name="l00435"></a><span class="lineno"> 435</span>  <span class="stringliteral">"partition(year, month) %snoshuffle%s "</span> +</div> |
| <div class="line"><a name="l00436"></a><span class="lineno"> 436</span>  <span class="stringliteral">"select int_col, bool_col, year, month from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00437"></a><span class="lineno"> 437</span>  prefix, suffix),</div> |
| <div class="line"><a name="l00438"></a><span class="lineno"> 438</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypes(int_col, bool_col) "</span> +</div> |
| <div class="line"><a name="l00439"></a><span class="lineno"> 439</span>  <span class="stringliteral">"PARTITION (year, month) \n-- +noshuffle\n "</span> +</div> |
| <div class="line"><a name="l00440"></a><span class="lineno"> 440</span>  <span class="stringliteral">"SELECT int_col, bool_col, year, month FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00441"></a><span class="lineno"> 441</span> </div> |
| <div class="line"><a name="l00442"></a><span class="lineno"> 442</span>  <span class="comment">// Select-list hint. The legacy-style hint has no prefix and suffix.</span></div> |
| <div class="line"><a name="l00443"></a><span class="lineno"> 443</span>  <span class="keywordflow">if</span> (prefix.contains(<span class="stringliteral">"["</span>)) {</div> |
| <div class="line"><a name="l00444"></a><span class="lineno"> 444</span>  prefix = <span class="stringliteral">""</span>;</div> |
| <div class="line"><a name="l00445"></a><span class="lineno"> 445</span>  suffix = <span class="stringliteral">""</span>;</div> |
| <div class="line"><a name="l00446"></a><span class="lineno"> 446</span>  }</div> |
| <div class="line"><a name="l00447"></a><span class="lineno"> 447</span>  <span class="comment">// Comment-style select-list plan hint.</span></div> |
| <div class="line"><a name="l00448"></a><span class="lineno"> 448</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(String.format(</div> |
| <div class="line"><a name="l00449"></a><span class="lineno"> 449</span>  <span class="stringliteral">"select %sstraight_join%s * from functional.alltypes"</span>, prefix, suffix),</div> |
| <div class="line"><a name="l00450"></a><span class="lineno"> 450</span>  <span class="stringliteral">"SELECT \n-- +straight_join\n * FROM functional.alltypes"</span>);</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(</div> |
| <div class="line"><a name="l00452"></a><span class="lineno"> 452</span>  String.format(<span class="stringliteral">"select distinct %sstraight_join%s * from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00453"></a><span class="lineno"> 453</span>  prefix, suffix),</div> |
| <div class="line"><a name="l00454"></a><span class="lineno"> 454</span>  <span class="stringliteral">"SELECT DISTINCT \n-- +straight_join\n * FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00455"></a><span class="lineno"> 455</span>  }</div> |
| <div class="line"><a name="l00456"></a><span class="lineno"> 456</span>  }</div> |
| <div class="line"><a name="l00457"></a><span class="lineno"> 457</span> </div> |
| <div class="line"><a name="l00458"></a><span class="lineno"> 458</span>  <span class="comment">// Test the toSql() output of aggregate and group by expressions.</span></div> |
| <div class="line"><a name="l00459"></a><span class="lineno"> 459</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00460"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26df8bd0bab7bc981a24a59936dc8041"> 460</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26df8bd0bab7bc981a24a59936dc8041">aggregationTest</a>() {</div> |
| <div class="line"><a name="l00461"></a><span class="lineno"> 461</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select COUNT(*), count(id), COUNT(id), SUM(id), AVG(id) "</span> +</div> |
| <div class="line"><a name="l00462"></a><span class="lineno"> 462</span>  <span class="stringliteral">"from functional.alltypes group by tinyint_col"</span>,</div> |
| <div class="line"><a name="l00463"></a><span class="lineno"> 463</span>  <span class="stringliteral">"SELECT count(*), count(id), count(id), sum(id), avg(id) "</span> +</div> |
| <div class="line"><a name="l00464"></a><span class="lineno"> 464</span>  <span class="stringliteral">"FROM functional.alltypes GROUP BY tinyint_col"</span>);</div> |
| <div class="line"><a name="l00465"></a><span class="lineno"> 465</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select avg(float_col / id) from functional.alltypes group by tinyint_col"</span>,</div> |
| <div class="line"><a name="l00466"></a><span class="lineno"> 466</span>  <span class="stringliteral">"SELECT avg(float_col / id) "</span> +</div> |
| <div class="line"><a name="l00467"></a><span class="lineno"> 467</span>  <span class="stringliteral">"FROM functional.alltypes GROUP BY tinyint_col"</span>);</div> |
| <div class="line"><a name="l00468"></a><span class="lineno"> 468</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select avg(double_col) from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00469"></a><span class="lineno"> 469</span>  <span class="stringliteral">"group by int_col, tinyint_col, bigint_col"</span>,</div> |
| <div class="line"><a name="l00470"></a><span class="lineno"> 470</span>  <span class="stringliteral">"SELECT avg(double_col) FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00471"></a><span class="lineno"> 471</span>  <span class="stringliteral">"GROUP BY int_col, tinyint_col, bigint_col"</span>);</div> |
| <div class="line"><a name="l00472"></a><span class="lineno"> 472</span>  <span class="comment">// Group by with having clause</span></div> |
| <div class="line"><a name="l00473"></a><span class="lineno"> 473</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select avg(id) from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00474"></a><span class="lineno"> 474</span>  <span class="stringliteral">"group by tinyint_col having count(tinyint_col) > 10"</span>,</div> |
| <div class="line"><a name="l00475"></a><span class="lineno"> 475</span>  <span class="stringliteral">"SELECT avg(id) FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00476"></a><span class="lineno"> 476</span>  <span class="stringliteral">"GROUP BY tinyint_col HAVING count(tinyint_col) > 10"</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select sum(id) from functional.alltypes group by tinyint_col "</span> +</div> |
| <div class="line"><a name="l00478"></a><span class="lineno"> 478</span>  <span class="stringliteral">"having avg(tinyint_col) > 10 AND count(tinyint_col) > 5"</span>,</div> |
| <div class="line"><a name="l00479"></a><span class="lineno"> 479</span>  <span class="stringliteral">"SELECT sum(id) FROM functional.alltypes GROUP BY tinyint_col "</span> +</div> |
| <div class="line"><a name="l00480"></a><span class="lineno"> 480</span>  <span class="stringliteral">"HAVING avg(tinyint_col) > 10 AND count(tinyint_col) > 5"</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">// Test the toSql() output of the order by clause.</span></div> |
| <div class="line"><a name="l00484"></a><span class="lineno"> 484</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00485"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0352d3431af8e7fa2abd6362862bd6fb"> 485</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0352d3431af8e7fa2abd6362862bd6fb">orderByTest</a>() {</div> |
| <div class="line"><a name="l00486"></a><span class="lineno"> 486</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00487"></a><span class="lineno"> 487</span>  <span class="stringliteral">"order by string_col ASC, float_col DESC, int_col ASC"</span>,</div> |
| <div class="line"><a name="l00488"></a><span class="lineno"> 488</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00489"></a><span class="lineno"> 489</span>  <span class="stringliteral">"ORDER BY string_col ASC, float_col DESC, int_col ASC"</span>);</div> |
| <div class="line"><a name="l00490"></a><span class="lineno"> 490</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00491"></a><span class="lineno"> 491</span>  <span class="stringliteral">"order by string_col DESC, float_col ASC, int_col DESC"</span>,</div> |
| <div class="line"><a name="l00492"></a><span class="lineno"> 492</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00493"></a><span class="lineno"> 493</span>  <span class="stringliteral">"ORDER BY string_col DESC, float_col ASC, int_col DESC"</span>);</div> |
| <div class="line"><a name="l00494"></a><span class="lineno"> 494</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00495"></a><span class="lineno"> 495</span>  <span class="stringliteral">"order by string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00496"></a><span class="lineno"> 496</span>  <span class="stringliteral">"int_col DESC"</span>,</div> |
| <div class="line"><a name="l00497"></a><span class="lineno"> 497</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00498"></a><span class="lineno"> 498</span>  <span class="stringliteral">"ORDER BY string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00499"></a><span class="lineno"> 499</span>  <span class="stringliteral">"int_col DESC"</span>);</div> |
| <div class="line"><a name="l00500"></a><span class="lineno"> 500</span>  <span class="comment">// Test limit/offset</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00502"></a><span class="lineno"> 502</span>  <span class="stringliteral">"order by string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00503"></a><span class="lineno"> 503</span>  <span class="stringliteral">"int_col DESC LIMIT 10 OFFSET 5"</span>,</div> |
| <div class="line"><a name="l00504"></a><span class="lineno"> 504</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00505"></a><span class="lineno"> 505</span>  <span class="stringliteral">"ORDER BY string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00506"></a><span class="lineno"> 506</span>  <span class="stringliteral">"int_col DESC LIMIT 10 OFFSET 5"</span>);</div> |
| <div class="line"><a name="l00507"></a><span class="lineno"> 507</span>  <span class="comment">// Offset shouldn't be printed if it's not necessary</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00509"></a><span class="lineno"> 509</span>  <span class="stringliteral">"order by string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00510"></a><span class="lineno"> 510</span>  <span class="stringliteral">"int_col DESC LIMIT 10 OFFSET 0"</span>,</div> |
| <div class="line"><a name="l00511"></a><span class="lineno"> 511</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00512"></a><span class="lineno"> 512</span>  <span class="stringliteral">"ORDER BY string_col ASC NULLS FIRST, float_col DESC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00513"></a><span class="lineno"> 513</span>  <span class="stringliteral">"int_col DESC LIMIT 10"</span>);</div> |
| <div class="line"><a name="l00514"></a><span class="lineno"> 514</span> </div> |
| <div class="line"><a name="l00515"></a><span class="lineno"> 515</span>  <span class="comment">// Check we do not print NULLS FIRST/LAST unless necessary</span></div> |
| <div class="line"><a name="l00516"></a><span class="lineno"> 516</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select id, string_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00517"></a><span class="lineno"> 517</span>  <span class="stringliteral">"order by string_col DESC NULLS FIRST, float_col ASC NULLS LAST, "</span> +</div> |
| <div class="line"><a name="l00518"></a><span class="lineno"> 518</span>  <span class="stringliteral">"int_col DESC"</span>,</div> |
| <div class="line"><a name="l00519"></a><span class="lineno"> 519</span>  <span class="stringliteral">"SELECT id, string_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00520"></a><span class="lineno"> 520</span>  <span class="stringliteral">"ORDER BY string_col DESC, float_col ASC, "</span> +</div> |
| <div class="line"><a name="l00521"></a><span class="lineno"> 521</span>  <span class="stringliteral">"int_col DESC"</span>);</div> |
| <div class="line"><a name="l00522"></a><span class="lineno"> 522</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">// Test the toSql() output of queries with all clauses.</span></div> |
| <div class="line"><a name="l00525"></a><span class="lineno"> 525</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00526"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84ae2cbc3aa440d62ae53631c8de20a4"> 526</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84ae2cbc3aa440d62ae53631c8de20a4">allTest</a>() {</div> |
| <div class="line"><a name="l00527"></a><span class="lineno"> 527</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bigint_col, avg(double_col), sum(tinyint_col) "</span> +</div> |
| <div class="line"><a name="l00528"></a><span class="lineno"> 528</span>  <span class="stringliteral">"from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00529"></a><span class="lineno"> 529</span>  <span class="stringliteral">"where double_col > 2.5 AND string_col != \"abc\""</span> +</div> |
| <div class="line"><a name="l00530"></a><span class="lineno"> 530</span>  <span class="stringliteral">"group by bigint_col, int_col "</span> +</div> |
| <div class="line"><a name="l00531"></a><span class="lineno"> 531</span>  <span class="stringliteral">"having count(int_col) > 10 OR sum(bigint_col) > 20 "</span> +</div> |
| <div class="line"><a name="l00532"></a><span class="lineno"> 532</span>  <span class="stringliteral">"order by 2 DESC NULLS LAST, 3 ASC"</span>,</div> |
| <div class="line"><a name="l00533"></a><span class="lineno"> 533</span>  <span class="stringliteral">"SELECT bigint_col, avg(double_col), sum(tinyint_col) "</span> +</div> |
| <div class="line"><a name="l00534"></a><span class="lineno"> 534</span>  <span class="stringliteral">"FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00535"></a><span class="lineno"> 535</span>  <span class="stringliteral">"WHERE double_col > 2.5 AND string_col != 'abc' "</span> +</div> |
| <div class="line"><a name="l00536"></a><span class="lineno"> 536</span>  <span class="stringliteral">"GROUP BY bigint_col, int_col "</span> +</div> |
| <div class="line"><a name="l00537"></a><span class="lineno"> 537</span>  <span class="stringliteral">"HAVING count(int_col) > 10 OR sum(bigint_col) > 20 "</span> +</div> |
| <div class="line"><a name="l00538"></a><span class="lineno"> 538</span>  <span class="stringliteral">"ORDER BY 2 DESC NULLS LAST, 3 ASC"</span>);</div> |
| <div class="line"><a name="l00539"></a><span class="lineno"> 539</span>  }</div> |
| <div class="line"><a name="l00540"></a><span class="lineno"> 540</span> </div> |
| <div class="line"><a name="l00541"></a><span class="lineno"> 541</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00542"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad99f141d68d1463dad7b8b11823b8b7c"> 542</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad99f141d68d1463dad7b8b11823b8b7c">unionTest</a>() {</div> |
| <div class="line"><a name="l00543"></a><span class="lineno"> 543</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bool_col, rank() over(order by id) from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00544"></a><span class="lineno"> 544</span>  <span class="stringliteral">"union select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00545"></a><span class="lineno"> 545</span>  <span class="stringliteral">"union select bool_col, bigint_col from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00546"></a><span class="lineno"> 546</span>  <span class="stringliteral">"SELECT bool_col, rank() OVER (ORDER BY id ASC) FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00547"></a><span class="lineno"> 547</span>  <span class="stringliteral">"UNION SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00548"></a><span class="lineno"> 548</span>  <span class="stringliteral">"UNION SELECT bool_col, bigint_col FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00549"></a><span class="lineno"> 549</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bool_col, int_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00550"></a><span class="lineno"> 550</span>  <span class="stringliteral">"union all select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00551"></a><span class="lineno"> 551</span>  <span class="stringliteral">"union all select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00552"></a><span class="lineno"> 552</span>  <span class="stringliteral">"union all select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00553"></a><span class="lineno"> 553</span>  <span class="stringliteral">"union all select bool_col, bigint_col from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00554"></a><span class="lineno"> 554</span>  <span class="stringliteral">"SELECT bool_col, int_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00555"></a><span class="lineno"> 555</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00556"></a><span class="lineno"> 556</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00557"></a><span class="lineno"> 557</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00558"></a><span class="lineno"> 558</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, bigint_col FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00559"></a><span class="lineno"> 559</span>  <span class="comment">// With 'order by' and 'limit' on union, and also on last select.</span></div> |
| <div class="line"><a name="l00560"></a><span class="lineno"> 560</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"(select bool_col, int_col from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00561"></a><span class="lineno"> 561</span>  <span class="stringliteral">"union all (select bool_col, int_col from functional.alltypessmall) "</span> +</div> |
| <div class="line"><a name="l00562"></a><span class="lineno"> 562</span>  <span class="stringliteral">"union all (select bool_col, bigint_col "</span> +</div> |
| <div class="line"><a name="l00563"></a><span class="lineno"> 563</span>  <span class="stringliteral">"from functional.alltypes order by 1 nulls first limit 1) "</span> +</div> |
| <div class="line"><a name="l00564"></a><span class="lineno"> 564</span>  <span class="stringliteral">"order by int_col nulls first, bool_col limit 5 + 5"</span>,</div> |
| <div class="line"><a name="l00565"></a><span class="lineno"> 565</span>  <span class="stringliteral">"SELECT bool_col, int_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00566"></a><span class="lineno"> 566</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00567"></a><span class="lineno"> 567</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, bigint_col "</span> +</div> |
| <div class="line"><a name="l00568"></a><span class="lineno"> 568</span>  <span class="stringliteral">"FROM functional.alltypes ORDER BY 1 ASC NULLS FIRST LIMIT 1 "</span> +</div> |
| <div class="line"><a name="l00569"></a><span class="lineno"> 569</span>  <span class="stringliteral">"ORDER BY int_col ASC NULLS FIRST, bool_col ASC LIMIT 5 + 5"</span>);</div> |
| <div class="line"><a name="l00570"></a><span class="lineno"> 570</span>  <span class="comment">// With 'order by' and 'limit' on union but not on last select.</span></div> |
| <div class="line"><a name="l00571"></a><span class="lineno"> 571</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bool_col, int_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00572"></a><span class="lineno"> 572</span>  <span class="stringliteral">"union all select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00573"></a><span class="lineno"> 573</span>  <span class="stringliteral">"union all (select bool_col, bigint_col from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00574"></a><span class="lineno"> 574</span>  <span class="stringliteral">"order by int_col nulls first, bool_col limit 10"</span>,</div> |
| <div class="line"><a name="l00575"></a><span class="lineno"> 575</span>  <span class="stringliteral">"SELECT bool_col, int_col FROM functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00576"></a><span class="lineno"> 576</span>  <span class="stringliteral">"UNION ALL SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00577"></a><span class="lineno"> 577</span>  <span class="stringliteral">"UNION ALL (SELECT bool_col, bigint_col FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00578"></a><span class="lineno"> 578</span>  <span class="stringliteral">"ORDER BY int_col ASC NULLS FIRST, bool_col ASC LIMIT 10"</span>);</div> |
| <div class="line"><a name="l00579"></a><span class="lineno"> 579</span>  <span class="comment">// Nested unions require parenthesis.</span></div> |
| <div class="line"><a name="l00580"></a><span class="lineno"> 580</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bool_col, int_col from functional.alltypes "</span> +</div> |
| <div class="line"><a name="l00581"></a><span class="lineno"> 581</span>  <span class="stringliteral">"union all (select bool_col, int_col from functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00582"></a><span class="lineno"> 582</span>  <span class="stringliteral">"union distinct (select bool_col, bigint_col from functional.alltypes)) "</span> +</div> |
| <div class="line"><a name="l00583"></a><span class="lineno"> 583</span>  <span class="stringliteral">"order by int_col, bool_col limit 10"</span>,</div> |
| <div class="line"><a name="l00584"></a><span class="lineno"> 584</span>  <span class="stringliteral">"SELECT bool_col, int_col FROM functional.alltypes UNION ALL "</span> +</div> |
| <div class="line"><a name="l00585"></a><span class="lineno"> 585</span>  <span class="stringliteral">"(SELECT bool_col, int_col FROM functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00586"></a><span class="lineno"> 586</span>  <span class="stringliteral">"UNION SELECT bool_col, bigint_col FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00587"></a><span class="lineno"> 587</span>  <span class="stringliteral">"ORDER BY int_col ASC, bool_col ASC LIMIT 10"</span>);</div> |
| <div class="line"><a name="l00588"></a><span class="lineno"> 588</span>  }</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>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00591"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac222935a5f235618e0fca2b7104a0b27"> 591</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac222935a5f235618e0fca2b7104a0b27">valuesTest</a>() {</div> |
| <div class="line"><a name="l00592"></a><span class="lineno"> 592</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"values(1, 'a', 1.0)"</span>, <span class="stringliteral">"VALUES(1, 'a', 1.0)"</span>);</div> |
| <div class="line"><a name="l00593"></a><span class="lineno"> 593</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"values(1 as x, 'a' y, 1.0 as z)"</span>, <span class="stringliteral">"VALUES(1 x, 'a' y, 1.0 z)"</span>);</div> |
| <div class="line"><a name="l00594"></a><span class="lineno"> 594</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"values(1, 'a'), (2, 'b'), (3, 'c')"</span>,</div> |
| <div class="line"><a name="l00595"></a><span class="lineno"> 595</span>  <span class="stringliteral">"VALUES((1, 'a'), (2, 'b'), (3, 'c'))"</span>);</div> |
| <div class="line"><a name="l00596"></a><span class="lineno"> 596</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"values(1 x, 'a' as y), (2 as y, 'b'), (3, 'c' x)"</span>,</div> |
| <div class="line"><a name="l00597"></a><span class="lineno"> 597</span>  <span class="stringliteral">"VALUES((1 x, 'a' y), (2 y, 'b'), (3, 'c' x))"</span>);</div> |
| <div class="line"><a name="l00598"></a><span class="lineno"> 598</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from (values(1, 'a'), (2, 'b')) as t"</span>,</div> |
| <div class="line"><a name="l00599"></a><span class="lineno"> 599</span>  <span class="stringliteral">"SELECT * FROM (VALUES((1, 'a'), (2, 'b'))) t"</span>);</div> |
| <div class="line"><a name="l00600"></a><span class="lineno"> 600</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"values(1, 'a'), (2, 'b') union all values(3, 'c')"</span>,</div> |
| <div class="line"><a name="l00601"></a><span class="lineno"> 601</span>  <span class="stringliteral">"VALUES((1, 'a'), (2, 'b')) UNION ALL (VALUES(3, 'c'))"</span>);</div> |
| <div class="line"><a name="l00602"></a><span class="lineno"> 602</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00603"></a><span class="lineno"> 603</span>  <span class="stringliteral">"partition (year=2009, month=4) "</span> +</div> |
| <div class="line"><a name="l00604"></a><span class="lineno"> 604</span>  <span class="stringliteral">"values(1, true, 1, 1, 10, 10, 10.0, 10.0, 'a', 'a', cast (0 as timestamp))"</span>,</div> |
| <div class="line"><a name="l00605"></a><span class="lineno"> 605</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypessmall PARTITION (year=2009, month=4) "</span> +</div> |
| <div class="line"><a name="l00606"></a><span class="lineno"> 606</span>  <span class="stringliteral">"VALUES(1, TRUE, 1, 1, 10, 10, 10.0, 10.0, 'a', 'a', CAST(0 AS TIMESTAMP))"</span>);</div> |
| <div class="line"><a name="l00607"></a><span class="lineno"> 607</span>  }</div> |
| <div class="line"><a name="l00608"></a><span class="lineno"> 608</span> </div> |
| <div class="line"><a name="l00612"></a><span class="lineno"> 612</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00613"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0b333efe7eb43963188cc0987330cd2b"> 613</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0b333efe7eb43963188cc0987330cd2b">inlineViewTest</a>() {</div> |
| <div class="line"><a name="l00614"></a><span class="lineno"> 614</span>  <span class="comment">// Test joins in an inline view.</span></div> |
| <div class="line"><a name="l00615"></a><span class="lineno"> 615</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select t.* from "</span> +</div> |
| <div class="line"><a name="l00616"></a><span class="lineno"> 616</span>  <span class="stringliteral">"(select a.* from functional.alltypes a, functional.alltypes b "</span> +</div> |
| <div class="line"><a name="l00617"></a><span class="lineno"> 617</span>  <span class="stringliteral">"where a.id = b.id) t"</span>,</div> |
| <div class="line"><a name="l00618"></a><span class="lineno"> 618</span>  <span class="stringliteral">"SELECT t.* FROM "</span> +</div> |
| <div class="line"><a name="l00619"></a><span class="lineno"> 619</span>  <span class="stringliteral">"(SELECT a.* FROM functional.alltypes a, functional.alltypes b "</span> +</div> |
| <div class="line"><a name="l00620"></a><span class="lineno"> 620</span>  <span class="stringliteral">"WHERE a.id = b.id) t"</span>);</div> |
| <div class="line"><a name="l00621"></a><span class="lineno"> 621</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select t.* from (select a.* from functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00622"></a><span class="lineno"> 622</span>  <span class="stringliteral">"cross join functional.alltypes b) t"</span>,</div> |
| <div class="line"><a name="l00623"></a><span class="lineno"> 623</span>  <span class="stringliteral">"SELECT t.* FROM (SELECT a.* FROM functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00624"></a><span class="lineno"> 624</span>  <span class="stringliteral">"CROSS JOIN functional.alltypes b) t"</span>);</div> |
| <div class="line"><a name="l00625"></a><span class="lineno"> 625</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"select t.* from (select a.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00626"></a><span class="lineno"> 626</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>,</div> |
| <div class="line"><a name="l00627"></a><span class="lineno"> 627</span>  <span class="stringliteral">"SELECT t.* FROM (SELECT a.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00628"></a><span class="lineno"> 628</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">nonSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00629"></a><span class="lineno"> 629</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"select t.* from (select a.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00630"></a><span class="lineno"> 630</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>,</div> |
| <div class="line"><a name="l00631"></a><span class="lineno"> 631</span>  <span class="stringliteral">"SELECT t.* FROM (SELECT a.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00632"></a><span class="lineno"> 632</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2">leftSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</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_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"select t.* from (select b.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00634"></a><span class="lineno"> 634</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>,</div> |
| <div class="line"><a name="l00635"></a><span class="lineno"> 635</span>  <span class="stringliteral">"SELECT t.* FROM (SELECT b.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00636"></a><span class="lineno"> 636</span>  <span class="stringliteral">"functional.alltypes b %s) t"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc">rightSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00637"></a><span class="lineno"> 637</span> </div> |
| <div class="line"><a name="l00638"></a><span class="lineno"> 638</span>  <span class="comment">// Test undoing expr substitution in select-list exprs and on clause.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select t1.int_col, t2.int_col from "</span> +</div> |
| <div class="line"><a name="l00640"></a><span class="lineno"> 640</span>  <span class="stringliteral">"(select int_col, rank() over (order by int_col) from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00641"></a><span class="lineno"> 641</span>  <span class="stringliteral">"t1 inner join "</span> +</div> |
| <div class="line"><a name="l00642"></a><span class="lineno"> 642</span>  <span class="stringliteral">"(select int_col from functional.alltypes) t2 on (t1.int_col = t2.int_col)"</span>,</div> |
| <div class="line"><a name="l00643"></a><span class="lineno"> 643</span>  <span class="stringliteral">"SELECT t1.int_col, t2.int_col FROM "</span> +</div> |
| <div class="line"><a name="l00644"></a><span class="lineno"> 644</span>  <span class="stringliteral">"(SELECT int_col, rank() OVER (ORDER BY int_col ASC) "</span> +</div> |
| <div class="line"><a name="l00645"></a><span class="lineno"> 645</span>  <span class="stringliteral">"FROM functional.alltypes) t1 INNER JOIN "</span> +</div> |
| <div class="line"><a name="l00646"></a><span class="lineno"> 646</span>  <span class="stringliteral">"(SELECT int_col FROM functional.alltypes) t2 ON (t1.int_col = t2.int_col)"</span>);</div> |
| <div class="line"><a name="l00647"></a><span class="lineno"> 647</span>  <span class="comment">// Test undoing expr substitution in aggregates and group by and having clause.</span></div> |
| <div class="line"><a name="l00648"></a><span class="lineno"> 648</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select count(t1.string_col), sum(t2.float_col) from "</span> +</div> |
| <div class="line"><a name="l00649"></a><span class="lineno"> 649</span>  <span class="stringliteral">"(select id, string_col from functional.alltypes) t1 inner join "</span> +</div> |
| <div class="line"><a name="l00650"></a><span class="lineno"> 650</span>  <span class="stringliteral">"(select id, float_col from functional.alltypes) t2 on (t1.id = t2.id) "</span> +</div> |
| <div class="line"><a name="l00651"></a><span class="lineno"> 651</span>  <span class="stringliteral">"group by t1.id, t2.id having count(t2.float_col) > 2"</span>,</div> |
| <div class="line"><a name="l00652"></a><span class="lineno"> 652</span>  <span class="stringliteral">"SELECT count(t1.string_col), sum(t2.float_col) FROM "</span> +</div> |
| <div class="line"><a name="l00653"></a><span class="lineno"> 653</span>  <span class="stringliteral">"(SELECT id, string_col FROM functional.alltypes) t1 INNER JOIN "</span> +</div> |
| <div class="line"><a name="l00654"></a><span class="lineno"> 654</span>  <span class="stringliteral">"(SELECT id, float_col FROM functional.alltypes) t2 ON (t1.id = t2.id) "</span> +</div> |
| <div class="line"><a name="l00655"></a><span class="lineno"> 655</span>  <span class="stringliteral">"GROUP BY t1.id, t2.id HAVING count(t2.float_col) > 2"</span>);</div> |
| <div class="line"><a name="l00656"></a><span class="lineno"> 656</span>  <span class="comment">// Test undoing expr substitution in order by clause.</span></div> |
| <div class="line"><a name="l00657"></a><span class="lineno"> 657</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select t1.id, t2.id from "</span> +</div> |
| <div class="line"><a name="l00658"></a><span class="lineno"> 658</span>  <span class="stringliteral">"(select id, string_col from functional.alltypes) t1 inner join "</span> +</div> |
| <div class="line"><a name="l00659"></a><span class="lineno"> 659</span>  <span class="stringliteral">"(select id, float_col from functional.alltypes) t2 on (t1.id = t2.id) "</span> +</div> |
| <div class="line"><a name="l00660"></a><span class="lineno"> 660</span>  <span class="stringliteral">"order by t1.id, t2.id nulls first"</span>,</div> |
| <div class="line"><a name="l00661"></a><span class="lineno"> 661</span>  <span class="stringliteral">"SELECT t1.id, t2.id FROM "</span> +</div> |
| <div class="line"><a name="l00662"></a><span class="lineno"> 662</span>  <span class="stringliteral">"(SELECT id, string_col FROM functional.alltypes) t1 INNER JOIN "</span> +</div> |
| <div class="line"><a name="l00663"></a><span class="lineno"> 663</span>  <span class="stringliteral">"(SELECT id, float_col FROM functional.alltypes) t2 ON (t1.id = t2.id) "</span> +</div> |
| <div class="line"><a name="l00664"></a><span class="lineno"> 664</span>  <span class="stringliteral">"ORDER BY t1.id ASC, t2.id ASC NULLS FIRST"</span>);</div> |
| <div class="line"><a name="l00665"></a><span class="lineno"> 665</span>  <span class="comment">// Test undoing expr substitution in where-clause conjuncts.</span></div> |
| <div class="line"><a name="l00666"></a><span class="lineno"> 666</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select t1.id, t2.id from "</span> +</div> |
| <div class="line"><a name="l00667"></a><span class="lineno"> 667</span>  <span class="stringliteral">"(select id, string_col from functional.alltypes) t1, "</span> +</div> |
| <div class="line"><a name="l00668"></a><span class="lineno"> 668</span>  <span class="stringliteral">"(select id, float_col from functional.alltypes) t2 "</span> +</div> |
| <div class="line"><a name="l00669"></a><span class="lineno"> 669</span>  <span class="stringliteral">"where t1.id = t2.id and t1.string_col = 'abc' and t2.float_col < 10"</span>,</div> |
| <div class="line"><a name="l00670"></a><span class="lineno"> 670</span>  <span class="stringliteral">"SELECT t1.id, t2.id FROM "</span> +</div> |
| <div class="line"><a name="l00671"></a><span class="lineno"> 671</span>  <span class="stringliteral">"(SELECT id, string_col FROM functional.alltypes) t1, "</span> +</div> |
| <div class="line"><a name="l00672"></a><span class="lineno"> 672</span>  <span class="stringliteral">"(SELECT id, float_col FROM functional.alltypes) t2 "</span> +</div> |
| <div class="line"><a name="l00673"></a><span class="lineno"> 673</span>  <span class="stringliteral">"WHERE t1.id = t2.id AND t1.string_col = 'abc' AND t2.float_col < 10"</span>);</div> |
| <div class="line"><a name="l00674"></a><span class="lineno"> 674</span>  }</div> |
| <div class="line"><a name="l00675"></a><span class="lineno"> 675</span> </div> |
| <div class="line"><a name="l00679"></a><span class="lineno"> 679</span>  <span class="comment">// TODO Fix testToSql to print the stmt after the first analysis phase and not</span></div> |
| <div class="line"><a name="l00680"></a><span class="lineno"> 680</span>  <span class="comment">// after the rewrite.</span></div> |
| <div class="line"><a name="l00681"></a><span class="lineno"> 681</span>  @Ignore(<span class="stringliteral">"Prints the rewritten statement"</span>)</div> |
| <div class="line"><a name="l00682"></a><span class="lineno"> 682</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00683"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad83420a59e2687e26417027126b6702b"> 683</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad83420a59e2687e26417027126b6702b">subqueryTest</a>() {</div> |
| <div class="line"><a name="l00684"></a><span class="lineno"> 684</span>  <span class="comment">// Nested predicates</span></div> |
| <div class="line"><a name="l00685"></a><span class="lineno"> 685</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where id in "</span> +</div> |
| <div class="line"><a name="l00686"></a><span class="lineno"> 686</span>  <span class="stringliteral">"(select id from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00687"></a><span class="lineno"> 687</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE id IN "</span> +</div> |
| <div class="line"><a name="l00688"></a><span class="lineno"> 688</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00689"></a><span class="lineno"> 689</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where id not in "</span> +</div> |
| <div class="line"><a name="l00690"></a><span class="lineno"> 690</span>  <span class="stringliteral">"(select id from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00691"></a><span class="lineno"> 691</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE id NOT IN "</span> +</div> |
| <div class="line"><a name="l00692"></a><span class="lineno"> 692</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny)"</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where bigint_col = "</span> +</div> |
| <div class="line"><a name="l00694"></a><span class="lineno"> 694</span>  <span class="stringliteral">"(select count(*) from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00695"></a><span class="lineno"> 695</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE bigint_col = "</span> +</div> |
| <div class="line"><a name="l00696"></a><span class="lineno"> 696</span>  <span class="stringliteral">"(SELECT count(*) FROM functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00697"></a><span class="lineno"> 697</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where exists "</span> +</div> |
| <div class="line"><a name="l00698"></a><span class="lineno"> 698</span>  <span class="stringliteral">"(select * from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00699"></a><span class="lineno"> 699</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE EXISTS "</span> +</div> |
| <div class="line"><a name="l00700"></a><span class="lineno"> 700</span>  <span class="stringliteral">"(SELECT * FROM functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00701"></a><span class="lineno"> 701</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where not exists "</span> +</div> |
| <div class="line"><a name="l00702"></a><span class="lineno"> 702</span>  <span class="stringliteral">"(select * from functional.alltypestiny)"</span>,</div> |
| <div class="line"><a name="l00703"></a><span class="lineno"> 703</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE NOT EXISTS "</span> +</div> |
| <div class="line"><a name="l00704"></a><span class="lineno"> 704</span>  <span class="stringliteral">"(SELECT * FROM functional.alltypestiny)"</span>);</div> |
| <div class="line"><a name="l00705"></a><span class="lineno"> 705</span>  <span class="comment">// Multiple nested predicates in the WHERE clause</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where not (id < 10 and "</span> +</div> |
| <div class="line"><a name="l00707"></a><span class="lineno"> 707</span>  <span class="stringliteral">"(int_col in (select int_col from functional.alltypestiny)) and "</span> +</div> |
| <div class="line"><a name="l00708"></a><span class="lineno"> 708</span>  <span class="stringliteral">"(string_col = (select max(string_col) from functional.alltypestiny)))"</span>,</div> |
| <div class="line"><a name="l00709"></a><span class="lineno"> 709</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE NOT (id < 10 AND "</span> +</div> |
| <div class="line"><a name="l00710"></a><span class="lineno"> 710</span>  <span class="stringliteral">"(int_col IN (SELECT int_col FROM functional.alltypestiny)) AND "</span> +</div> |
| <div class="line"><a name="l00711"></a><span class="lineno"> 711</span>  <span class="stringliteral">"(string_col = (SELECT max(string_col) FROM functional.alltypestiny)))"</span>);</div> |
| <div class="line"><a name="l00712"></a><span class="lineno"> 712</span>  <span class="comment">// Multiple nesting levels</span></div> |
| <div class="line"><a name="l00713"></a><span class="lineno"> 713</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from functional.alltypes where id in "</span> +</div> |
| <div class="line"><a name="l00714"></a><span class="lineno"> 714</span>  <span class="stringliteral">"(select id from functional.alltypestiny where int_col = "</span> +</div> |
| <div class="line"><a name="l00715"></a><span class="lineno"> 715</span>  <span class="stringliteral">"(select avg(int_col) from functional.alltypesagg))"</span>,</div> |
| <div class="line"><a name="l00716"></a><span class="lineno"> 716</span>  <span class="stringliteral">"SELECT * FROM functional.alltypes WHERE id IN "</span> +</div> |
| <div class="line"><a name="l00717"></a><span class="lineno"> 717</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny WHERE int_col = "</span> +</div> |
| <div class="line"><a name="l00718"></a><span class="lineno"> 718</span>  <span class="stringliteral">"(SELECT avg(int_col) FROM functional.alltypesagg))"</span>);</div> |
| <div class="line"><a name="l00719"></a><span class="lineno"> 719</span>  <span class="comment">// Inline view with a subquery</span></div> |
| <div class="line"><a name="l00720"></a><span class="lineno"> 720</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select * from (select id from functional.alltypes where "</span> +</div> |
| <div class="line"><a name="l00721"></a><span class="lineno"> 721</span>  <span class="stringliteral">"int_col in (select int_col from functional.alltypestiny)) t where "</span> +</div> |
| <div class="line"><a name="l00722"></a><span class="lineno"> 722</span>  <span class="stringliteral">"t.id < 10"</span>,</div> |
| <div class="line"><a name="l00723"></a><span class="lineno"> 723</span>  <span class="stringliteral">"SELECT * FROM (SELECT id FROM functional.alltypes WHERE "</span> +</div> |
| <div class="line"><a name="l00724"></a><span class="lineno"> 724</span>  <span class="stringliteral">"int_col IN (SELECT int_col FROM functional.alltypestiny)) t WHERE "</span> +</div> |
| <div class="line"><a name="l00725"></a><span class="lineno"> 725</span>  <span class="stringliteral">"t.id < 10"</span>);</div> |
| <div class="line"><a name="l00726"></a><span class="lineno"> 726</span>  <span class="comment">// Subquery in a WITH clause</span></div> |
| <div class="line"><a name="l00727"></a><span class="lineno"> 727</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select * from functional.alltypes where id in "</span> +</div> |
| <div class="line"><a name="l00728"></a><span class="lineno"> 728</span>  <span class="stringliteral">"(select id from functional.alltypestiny)) select * from t"</span>,</div> |
| <div class="line"><a name="l00729"></a><span class="lineno"> 729</span>  <span class="stringliteral">"WITH t AS (SELECT * FROM functional.alltypes WHERE id IN "</span> +</div> |
| <div class="line"><a name="l00730"></a><span class="lineno"> 730</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny)) SELECT * FROM t"</span>);</div> |
| <div class="line"><a name="l00731"></a><span class="lineno"> 731</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select * from functional.alltypes s where id in "</span> +</div> |
| <div class="line"><a name="l00732"></a><span class="lineno"> 732</span>  <span class="stringliteral">"(select id from functional.alltypestiny t where s.id = t.id)) "</span> +</div> |
| <div class="line"><a name="l00733"></a><span class="lineno"> 733</span>  <span class="stringliteral">"select * from t t1, t t2 where t1.id = t2.id"</span>,</div> |
| <div class="line"><a name="l00734"></a><span class="lineno"> 734</span>  <span class="stringliteral">"WITH t AS (SELECT * FROM functional.alltypes s WHERE id IN "</span> +</div> |
| <div class="line"><a name="l00735"></a><span class="lineno"> 735</span>  <span class="stringliteral">"(SELECT id FROM functional.alltypestiny t WHERE s.id = t.id)) "</span> +</div> |
| <div class="line"><a name="l00736"></a><span class="lineno"> 736</span>  <span class="stringliteral">"SELECT * FROM t t1, t t2 WHERE t1.id = t2.id"</span>);</div> |
| <div class="line"><a name="l00737"></a><span class="lineno"> 737</span>  }</div> |
| <div class="line"><a name="l00738"></a><span class="lineno"> 738</span> </div> |
| <div class="line"><a name="l00739"></a><span class="lineno"> 739</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00740"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3c862c924c08523c92d51a8b49970df2"> 740</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3c862c924c08523c92d51a8b49970df2">withClauseTest</a>() {</div> |
| <div class="line"><a name="l00741"></a><span class="lineno"> 741</span>  <span class="comment">// WITH clause in select stmt.</span></div> |
| <div class="line"><a name="l00742"></a><span class="lineno"> 742</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select * from functional.alltypes) select * from t"</span>,</div> |
| <div class="line"><a name="l00743"></a><span class="lineno"> 743</span>  <span class="stringliteral">"WITH t AS (SELECT * FROM functional.alltypes) SELECT * FROM t"</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select sum(int_col) over(partition by tinyint_col, "</span> +</div> |
| <div class="line"><a name="l00745"></a><span class="lineno"> 745</span>  <span class="stringliteral">"bool_col order by float_col rows between unbounded preceding and "</span> +</div> |
| <div class="line"><a name="l00746"></a><span class="lineno"> 746</span>  <span class="stringliteral">"current row) as x from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00747"></a><span class="lineno"> 747</span>  <span class="stringliteral">"select t1.x, t2.x from t t1 join t t2 on (t1.x = t2.x)"</span>,</div> |
| <div class="line"><a name="l00748"></a><span class="lineno"> 748</span>  <span class="stringliteral">"WITH t AS (SELECT sum(int_col) OVER (PARTITION BY tinyint_col, bool_col "</span> +</div> |
| <div class="line"><a name="l00749"></a><span class="lineno"> 749</span>  <span class="stringliteral">"ORDER BY float_col ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) "</span> +</div> |
| <div class="line"><a name="l00750"></a><span class="lineno"> 750</span>  <span class="stringliteral">"x FROM functional.alltypes) SELECT t1.x, t2.x FROM t t1 INNER JOIN t t2 ON "</span> +</div> |
| <div class="line"><a name="l00751"></a><span class="lineno"> 751</span>  <span class="stringliteral">"(t1.x = t2.x)"</span>);</div> |
| <div class="line"><a name="l00752"></a><span class="lineno"> 752</span>  <span class="comment">// WITH clause in select stmt with a join and an ON clause.</span></div> |
| <div class="line"><a name="l00753"></a><span class="lineno"> 753</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select * from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00754"></a><span class="lineno"> 754</span>  <span class="stringliteral">"select * from t a inner join t b on (a.int_col = b.int_col)"</span>,</div> |
| <div class="line"><a name="l00755"></a><span class="lineno"> 755</span>  <span class="stringliteral">"WITH t AS (SELECT * FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00756"></a><span class="lineno"> 756</span>  <span class="stringliteral">"SELECT * FROM t a INNER JOIN t b ON (a.int_col = b.int_col)"</span>);</div> |
| <div class="line"><a name="l00757"></a><span class="lineno"> 757</span>  <span class="comment">// WITH clause in select stmt with a join and a USING clause.</span></div> |
| <div class="line"><a name="l00758"></a><span class="lineno"> 758</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select * from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00759"></a><span class="lineno"> 759</span>  <span class="stringliteral">"select * from t a inner join t b using(int_col)"</span>,</div> |
| <div class="line"><a name="l00760"></a><span class="lineno"> 760</span>  <span class="stringliteral">"WITH t AS (SELECT * FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00761"></a><span class="lineno"> 761</span>  <span class="stringliteral">"SELECT * FROM t a INNER JOIN t b USING (int_col)"</span>);</div> |
| <div class="line"><a name="l00762"></a><span class="lineno"> 762</span>  <span class="comment">// WITH clause in a union stmt.</span></div> |
| <div class="line"><a name="l00763"></a><span class="lineno"> 763</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t1 as (select * from functional.alltypes)"</span> +</div> |
| <div class="line"><a name="l00764"></a><span class="lineno"> 764</span>  <span class="stringliteral">"select * from t1 union all select * from t1"</span>,</div> |
| <div class="line"><a name="l00765"></a><span class="lineno"> 765</span>  <span class="stringliteral">"WITH t1 AS (SELECT * FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00766"></a><span class="lineno"> 766</span>  <span class="stringliteral">"SELECT * FROM t1 UNION ALL SELECT * FROM t1"</span>);</div> |
| <div class="line"><a name="l00767"></a><span class="lineno"> 767</span>  <span class="comment">// WITH clause in values stmt.</span></div> |
| <div class="line"><a name="l00768"></a><span class="lineno"> 768</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t1 as (select * from functional.alltypes) values(1, 2), (3, 4)"</span>,</div> |
| <div class="line"><a name="l00769"></a><span class="lineno"> 769</span>  <span class="stringliteral">"WITH t1 AS (SELECT * FROM functional.alltypes) VALUES((1, 2), (3, 4))"</span>);</div> |
| <div class="line"><a name="l00770"></a><span class="lineno"> 770</span>  <span class="comment">// WITH clause in insert stmt.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t1 as (select * from functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00772"></a><span class="lineno"> 772</span>  <span class="stringliteral">"insert into functional.alltypes partition(year, month) select * from t1"</span>,</div> |
| <div class="line"><a name="l00773"></a><span class="lineno"> 773</span>  <span class="stringliteral">"WITH t1 AS (SELECT * FROM functional.alltypes) "</span> +</div> |
| <div class="line"><a name="l00774"></a><span class="lineno"> 774</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypes PARTITION (year, month) "</span> +</div> |
| <div class="line"><a name="l00775"></a><span class="lineno"> 775</span>  <span class="stringliteral">"SELECT * FROM t1"</span>);</div> |
| <div class="line"><a name="l00776"></a><span class="lineno"> 776</span>  <span class="comment">// Test joins in WITH-clause view.</span></div> |
| <div class="line"><a name="l00777"></a><span class="lineno"> 777</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select a.* from functional.alltypes a, "</span> +</div> |
| <div class="line"><a name="l00778"></a><span class="lineno"> 778</span>  <span class="stringliteral">"functional.alltypes b where a.id = b.id) select * from t"</span>,</div> |
| <div class="line"><a name="l00779"></a><span class="lineno"> 779</span>  <span class="stringliteral">"WITH t AS (SELECT a.* FROM functional.alltypes a, "</span> +</div> |
| <div class="line"><a name="l00780"></a><span class="lineno"> 780</span>  <span class="stringliteral">"functional.alltypes b WHERE a.id = b.id) SELECT * FROM t"</span>);</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select a.* from functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00782"></a><span class="lineno"> 782</span>  <span class="stringliteral">"cross join functional.alltypes b) select * from t"</span>,</div> |
| <div class="line"><a name="l00783"></a><span class="lineno"> 783</span>  <span class="stringliteral">"WITH t AS (SELECT a.* FROM functional.alltypes a "</span> +</div> |
| <div class="line"><a name="l00784"></a><span class="lineno"> 784</span>  <span class="stringliteral">"CROSS JOIN functional.alltypes b) SELECT * FROM t"</span>);</div> |
| <div class="line"><a name="l00785"></a><span class="lineno"> 785</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"with t as (select a.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00786"></a><span class="lineno"> 786</span>  <span class="stringliteral">"functional.alltypes b %s) select * from t"</span>,</div> |
| <div class="line"><a name="l00787"></a><span class="lineno"> 787</span>  <span class="stringliteral">"WITH t AS (SELECT a.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00788"></a><span class="lineno"> 788</span>  <span class="stringliteral">"functional.alltypes b %s) SELECT * FROM t"</span>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">nonSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00789"></a><span class="lineno"> 789</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"with t as (select a.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00790"></a><span class="lineno"> 790</span>  <span class="stringliteral">"functional.alltypes b %s) select * from t"</span>,</div> |
| <div class="line"><a name="l00791"></a><span class="lineno"> 791</span>  <span class="stringliteral">"WITH t AS (SELECT a.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00792"></a><span class="lineno"> 792</span>  <span class="stringliteral">"functional.alltypes b %s) SELECT * FROM t"</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_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2">leftSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00794"></a><span class="lineno"> 794</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">runTestTemplate</a>(<span class="stringliteral">"with t as (select b.* from functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00795"></a><span class="lineno"> 795</span>  <span class="stringliteral">"functional.alltypes b %s) select * from t"</span>,</div> |
| <div class="line"><a name="l00796"></a><span class="lineno"> 796</span>  <span class="stringliteral">"WITH t AS (SELECT b.* FROM functional.alltypes a %s "</span> +</div> |
| <div class="line"><a name="l00797"></a><span class="lineno"> 797</span>  <span class="stringliteral">"functional.alltypes b %s) SELECT * FROM t"</span>,</div> |
| <div class="line"><a name="l00798"></a><span class="lineno"> 798</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc">rightSemiJoinTypes_</a>, <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">joinConditions_</a>);</div> |
| <div class="line"><a name="l00799"></a><span class="lineno"> 799</span>  <span class="comment">// WITH clause in complex query with joins and and order by + limit.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"with t as (select int_col x, bigint_col y from functional.alltypestiny "</span> +</div> |
| <div class="line"><a name="l00801"></a><span class="lineno"> 801</span>  <span class="stringliteral">"order by id nulls first limit 2) "</span> +</div> |
| <div class="line"><a name="l00802"></a><span class="lineno"> 802</span>  <span class="stringliteral">"select * from t t1 left outer join t t2 on t1.y = t2.x "</span> +</div> |
| <div class="line"><a name="l00803"></a><span class="lineno"> 803</span>  <span class="stringliteral">"full outer join t t3 on t2.y = t3.x order by t1.x nulls first limit 5 * 2"</span>,</div> |
| <div class="line"><a name="l00804"></a><span class="lineno"> 804</span>  <span class="stringliteral">"WITH t AS (SELECT int_col x, bigint_col y FROM functional.alltypestiny "</span> +</div> |
| <div class="line"><a name="l00805"></a><span class="lineno"> 805</span>  <span class="stringliteral">"ORDER BY id ASC NULLS FIRST LIMIT 2) "</span> +</div> |
| <div class="line"><a name="l00806"></a><span class="lineno"> 806</span>  <span class="stringliteral">"SELECT * FROM t t1 LEFT OUTER JOIN t t2 ON t1.y = t2.x "</span> +</div> |
| <div class="line"><a name="l00807"></a><span class="lineno"> 807</span>  <span class="stringliteral">"FULL OUTER JOIN t t3 ON t2.y = t3.x ORDER BY t1.x ASC NULLS FIRST LIMIT 5 * 2"</span>);</div> |
| <div class="line"><a name="l00808"></a><span class="lineno"> 808</span>  }</div> |
| <div class="line"><a name="l00809"></a><span class="lineno"> 809</span> </div> |
| <div class="line"><a name="l00810"></a><span class="lineno"> 810</span>  <span class="comment">// Test the toSql() output of insert queries.</span></div> |
| <div class="line"><a name="l00811"></a><span class="lineno"> 811</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00812"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a161cbe1dd4ca9de30f659081e055743c"> 812</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a161cbe1dd4ca9de30f659081e055743c">insertTest</a>() {</div> |
| <div class="line"><a name="l00813"></a><span class="lineno"> 813</span>  <span class="comment">// Insert into unpartitioned table without partition clause.</span></div> |
| <div class="line"><a name="l00814"></a><span class="lineno"> 814</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypesnopart "</span> +</div> |
| <div class="line"><a name="l00815"></a><span class="lineno"> 815</span>  <span class="stringliteral">"select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, "</span> +</div> |
| <div class="line"><a name="l00816"></a><span class="lineno"> 816</span>  <span class="stringliteral">"float_col, double_col, date_string_col, string_col, timestamp_col "</span> +</div> |
| <div class="line"><a name="l00817"></a><span class="lineno"> 817</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00818"></a><span class="lineno"> 818</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypesnopart "</span> +</div> |
| <div class="line"><a name="l00819"></a><span class="lineno"> 819</span>  <span class="stringliteral">"SELECT id, bool_col, tinyint_col, "</span> +</div> |
| <div class="line"><a name="l00820"></a><span class="lineno"> 820</span>  <span class="stringliteral">"smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, "</span> +</div> |
| <div class="line"><a name="l00821"></a><span class="lineno"> 821</span>  <span class="stringliteral">"string_col, timestamp_col FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00822"></a><span class="lineno"> 822</span>  <span class="comment">// Insert into overwrite unpartitioned table without partition clause.</span></div> |
| <div class="line"><a name="l00823"></a><span class="lineno"> 823</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert overwrite table functional.alltypesnopart "</span> +</div> |
| <div class="line"><a name="l00824"></a><span class="lineno"> 824</span>  <span class="stringliteral">"select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, "</span> +</div> |
| <div class="line"><a name="l00825"></a><span class="lineno"> 825</span>  <span class="stringliteral">"float_col, double_col, date_string_col, string_col, timestamp_col "</span> +</div> |
| <div class="line"><a name="l00826"></a><span class="lineno"> 826</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00827"></a><span class="lineno"> 827</span>  <span class="stringliteral">"INSERT OVERWRITE TABLE functional.alltypesnopart "</span> +</div> |
| <div class="line"><a name="l00828"></a><span class="lineno"> 828</span>  <span class="stringliteral">"SELECT id, bool_col, tinyint_col, "</span> +</div> |
| <div class="line"><a name="l00829"></a><span class="lineno"> 829</span>  <span class="stringliteral">"smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, "</span> +</div> |
| <div class="line"><a name="l00830"></a><span class="lineno"> 830</span>  <span class="stringliteral">"string_col, timestamp_col FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00831"></a><span class="lineno"> 831</span>  <span class="comment">// Static partition.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00833"></a><span class="lineno"> 833</span>  <span class="stringliteral">"partition (year=2009, month=4)"</span> +</div> |
| <div class="line"><a name="l00834"></a><span class="lineno"> 834</span>  <span class="stringliteral">"select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, "</span> +</div> |
| <div class="line"><a name="l00835"></a><span class="lineno"> 835</span>  <span class="stringliteral">"float_col, double_col, date_string_col, string_col, timestamp_col "</span> +</div> |
| <div class="line"><a name="l00836"></a><span class="lineno"> 836</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00837"></a><span class="lineno"> 837</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00838"></a><span class="lineno"> 838</span>  <span class="stringliteral">"PARTITION (year=2009, month=4) SELECT id, "</span> +</div> |
| <div class="line"><a name="l00839"></a><span class="lineno"> 839</span>  <span class="stringliteral">"bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, "</span> +</div> |
| <div class="line"><a name="l00840"></a><span class="lineno"> 840</span>  <span class="stringliteral">"double_col, date_string_col, string_col, timestamp_col "</span> +</div> |
| <div class="line"><a name="l00841"></a><span class="lineno"> 841</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00842"></a><span class="lineno"> 842</span>  <span class="comment">// Fully dynamic partitions.</span></div> |
| <div class="line"><a name="l00843"></a><span class="lineno"> 843</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00844"></a><span class="lineno"> 844</span>  <span class="stringliteral">"partition (year, month)"</span> +</div> |
| <div class="line"><a name="l00845"></a><span class="lineno"> 845</span>  <span class="stringliteral">"select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, "</span> +</div> |
| <div class="line"><a name="l00846"></a><span class="lineno"> 846</span>  <span class="stringliteral">"float_col, double_col, date_string_col, string_col, timestamp_col, year, "</span> +</div> |
| <div class="line"><a name="l00847"></a><span class="lineno"> 847</span>  <span class="stringliteral">"month from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00848"></a><span class="lineno"> 848</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00849"></a><span class="lineno"> 849</span>  <span class="stringliteral">"PARTITION (year, month) SELECT id, bool_col, "</span> +</div> |
| <div class="line"><a name="l00850"></a><span class="lineno"> 850</span>  <span class="stringliteral">"tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, "</span> +</div> |
| <div class="line"><a name="l00851"></a><span class="lineno"> 851</span>  <span class="stringliteral">"date_string_col, string_col, timestamp_col, year, month "</span> +</div> |
| <div class="line"><a name="l00852"></a><span class="lineno"> 852</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00853"></a><span class="lineno"> 853</span>  <span class="comment">// Partially dynamic partitions.</span></div> |
| <div class="line"><a name="l00854"></a><span class="lineno"> 854</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00855"></a><span class="lineno"> 855</span>  <span class="stringliteral">"partition (year=2009, month)"</span> +</div> |
| <div class="line"><a name="l00856"></a><span class="lineno"> 856</span>  <span class="stringliteral">"select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, "</span> +</div> |
| <div class="line"><a name="l00857"></a><span class="lineno"> 857</span>  <span class="stringliteral">"float_col, double_col, date_string_col, string_col, timestamp_col, month "</span> +</div> |
| <div class="line"><a name="l00858"></a><span class="lineno"> 858</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00859"></a><span class="lineno"> 859</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypessmall "</span> +</div> |
| <div class="line"><a name="l00860"></a><span class="lineno"> 860</span>  <span class="stringliteral">"PARTITION (year=2009, month) SELECT id, "</span> +</div> |
| <div class="line"><a name="l00861"></a><span class="lineno"> 861</span>  <span class="stringliteral">"bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, "</span> +</div> |
| <div class="line"><a name="l00862"></a><span class="lineno"> 862</span>  <span class="stringliteral">"double_col, date_string_col, string_col, timestamp_col, month "</span> +</div> |
| <div class="line"><a name="l00863"></a><span class="lineno"> 863</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00864"></a><span class="lineno"> 864</span> </div> |
| <div class="line"><a name="l00865"></a><span class="lineno"> 865</span>  <span class="comment">// Permutations</span></div> |
| <div class="line"><a name="l00866"></a><span class="lineno"> 866</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypesnopart(id, bool_col, tinyint_col) "</span> +</div> |
| <div class="line"><a name="l00867"></a><span class="lineno"> 867</span>  <span class="stringliteral">" values(1, true, 0)"</span>,</div> |
| <div class="line"><a name="l00868"></a><span class="lineno"> 868</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypesnopart(id, bool_col, tinyint_col) "</span> +</div> |
| <div class="line"><a name="l00869"></a><span class="lineno"> 869</span>  <span class="stringliteral">"VALUES(1, TRUE, 0)"</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>  <span class="comment">// Permutations that mention partition column</span></div> |
| <div class="line"><a name="l00872"></a><span class="lineno"> 872</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypes(id, year, month) "</span> +</div> |
| <div class="line"><a name="l00873"></a><span class="lineno"> 873</span>  <span class="stringliteral">" values(1, 1990, 12)"</span>,</div> |
| <div class="line"><a name="l00874"></a><span class="lineno"> 874</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypes(id, year, month) "</span> +</div> |
| <div class="line"><a name="l00875"></a><span class="lineno"> 875</span>  <span class="stringliteral">"VALUES(1, 1990, 12)"</span>);</div> |
| <div class="line"><a name="l00876"></a><span class="lineno"> 876</span> </div> |
| <div class="line"><a name="l00877"></a><span class="lineno"> 877</span>  <span class="comment">// Empty permutation with no select statement</span></div> |
| <div class="line"><a name="l00878"></a><span class="lineno"> 878</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypesnopart()"</span>,</div> |
| <div class="line"><a name="l00879"></a><span class="lineno"> 879</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypesnopart()"</span>);</div> |
| <div class="line"><a name="l00880"></a><span class="lineno"> 880</span> </div> |
| <div class="line"><a name="l00881"></a><span class="lineno"> 881</span>  <span class="comment">// Permutation and explicit partition clause</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"insert into table functional.alltypes(id) "</span> +</div> |
| <div class="line"><a name="l00883"></a><span class="lineno"> 883</span>  <span class="stringliteral">" partition (year=2009, month) values(1, 12)"</span>,</div> |
| <div class="line"><a name="l00884"></a><span class="lineno"> 884</span>  <span class="stringliteral">"INSERT INTO TABLE functional.alltypes(id) "</span> +</div> |
| <div class="line"><a name="l00885"></a><span class="lineno"> 885</span>  <span class="stringliteral">"PARTITION (year=2009, month) VALUES(1, 12)"</span>);</div> |
| <div class="line"><a name="l00886"></a><span class="lineno"> 886</span>  }</div> |
| <div class="line"><a name="l00887"></a><span class="lineno"> 887</span> </div> |
| <div class="line"><a name="l00888"></a><span class="lineno"> 888</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00889"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac47ed85f7f7be98e067902415c1edbd5"> 889</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac47ed85f7f7be98e067902415c1edbd5">testAnalyticExprs</a>() {</div> |
| <div class="line"><a name="l00890"></a><span class="lineno"> 890</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(</div> |
| <div class="line"><a name="l00891"></a><span class="lineno"> 891</span>  <span class="stringliteral">"select sum(int_col) over (partition by id order by tinyint_col "</span></div> |
| <div class="line"><a name="l00892"></a><span class="lineno"> 892</span>  + <span class="stringliteral">"rows between unbounded preceding and current row) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00893"></a><span class="lineno"> 893</span>  <span class="stringliteral">"SELECT sum(int_col) OVER (PARTITION BY id ORDER BY tinyint_col ASC ROWS "</span></div> |
| <div class="line"><a name="l00894"></a><span class="lineno"> 894</span>  + <span class="stringliteral">"BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00895"></a><span class="lineno"> 895</span>  }</div> |
| <div class="line"><a name="l00896"></a><span class="lineno"> 896</span> </div> |
| <div class="line"><a name="l00901"></a><span class="lineno"> 901</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l00902"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6506774d8ac54ad38ab6bd72073243f8"> 902</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6506774d8ac54ad38ab6bd72073243f8">testExprs</a>() {</div> |
| <div class="line"><a name="l00903"></a><span class="lineno"> 903</span>  <span class="comment">// AggregateExpr.</span></div> |
| <div class="line"><a name="l00904"></a><span class="lineno"> 904</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select count(*), (count(*)), avg(int_col), (avg(int_col)), "</span> +</div> |
| <div class="line"><a name="l00905"></a><span class="lineno"> 905</span>  <span class="stringliteral">"sum(int_col), (sum(int_col)), min(int_col), (min(int_col)), "</span> +</div> |
| <div class="line"><a name="l00906"></a><span class="lineno"> 906</span>  <span class="stringliteral">"max(int_col), (max(int_col)) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00907"></a><span class="lineno"> 907</span>  <span class="stringliteral">"SELECT count(*), (count(*)), avg(int_col), (avg(int_col)), "</span> +</div> |
| <div class="line"><a name="l00908"></a><span class="lineno"> 908</span>  <span class="stringliteral">"sum(int_col), (sum(int_col)), min(int_col), (min(int_col)), "</span> +</div> |
| <div class="line"><a name="l00909"></a><span class="lineno"> 909</span>  <span class="stringliteral">"max(int_col), (max(int_col)) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00910"></a><span class="lineno"> 910</span>  <span class="comment">// ArithmeticExpr.</span></div> |
| <div class="line"><a name="l00911"></a><span class="lineno"> 911</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 1 * 1, (1 * 1), 2 / 2, (2 / 2), 3 % 3, (3 % 3), "</span> +</div> |
| <div class="line"><a name="l00912"></a><span class="lineno"> 912</span>  <span class="stringliteral">"4 DIV 4, (4 DIV 4), 5 + 5, (5 + 5), 6 - 6, (6 - 6), 7 & 7, (7 & 7), "</span> +</div> |
| <div class="line"><a name="l00913"></a><span class="lineno"> 913</span>  <span class="stringliteral">"8 | 8, (8 | 8), 9 ^ 9, (9 ^ 9), ~10, (~10)"</span>,</div> |
| <div class="line"><a name="l00914"></a><span class="lineno"> 914</span>  <span class="stringliteral">"SELECT 1 * 1, (1 * 1), 2 / 2, (2 / 2), 3 % 3, (3 % 3), "</span> +</div> |
| <div class="line"><a name="l00915"></a><span class="lineno"> 915</span>  <span class="stringliteral">"4 DIV 4, (4 DIV 4), 5 + 5, (5 + 5), 6 - 6, (6 - 6), 7 & 7, (7 & 7), "</span> +</div> |
| <div class="line"><a name="l00916"></a><span class="lineno"> 916</span>  <span class="stringliteral">"8 | 8, (8 | 8), 9 ^ 9, (9 ^ 9), ~10, (~10)"</span>);</div> |
| <div class="line"><a name="l00917"></a><span class="lineno"> 917</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select (((1 + 2) * (3 - 4) + 6) / 7)"</span>,</div> |
| <div class="line"><a name="l00918"></a><span class="lineno"> 918</span>  <span class="stringliteral">"SELECT (((1 + 2) * (3 - 4) + 6) / 7)"</span>);</div> |
| <div class="line"><a name="l00919"></a><span class="lineno"> 919</span> </div> |
| <div class="line"><a name="l00920"></a><span class="lineno"> 920</span>  <span class="comment">// CaseExpr.</span></div> |
| <div class="line"><a name="l00921"></a><span class="lineno"> 921</span>  <span class="comment">// Single case without else clause. No case expr.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select case when true then 1 end, "</span> +</div> |
| <div class="line"><a name="l00923"></a><span class="lineno"> 923</span>  <span class="stringliteral">"(case when true then 1 end)"</span>,</div> |
| <div class="line"><a name="l00924"></a><span class="lineno"> 924</span>  <span class="stringliteral">"SELECT CASE WHEN TRUE THEN 1 END, "</span> +</div> |
| <div class="line"><a name="l00925"></a><span class="lineno"> 925</span>  <span class="stringliteral">"(CASE WHEN TRUE THEN 1 END)"</span>);</div> |
| <div class="line"><a name="l00926"></a><span class="lineno"> 926</span>  <span class="comment">// Multiple cases with else clause. No case expr.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select case when true then 1 when false then 2 else 3 end, "</span> +</div> |
| <div class="line"><a name="l00928"></a><span class="lineno"> 928</span>  <span class="stringliteral">"(case when true then 1 when false then 2 else 3 end)"</span>,</div> |
| <div class="line"><a name="l00929"></a><span class="lineno"> 929</span>  <span class="stringliteral">"SELECT CASE WHEN TRUE THEN 1 WHEN FALSE THEN 2 ELSE 3 END, "</span> +</div> |
| <div class="line"><a name="l00930"></a><span class="lineno"> 930</span>  <span class="stringliteral">"(CASE WHEN TRUE THEN 1 WHEN FALSE THEN 2 ELSE 3 END)"</span>);</div> |
| <div class="line"><a name="l00931"></a><span class="lineno"> 931</span>  <span class="comment">// Multiple cases with else clause with case expr.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select case true when true then 1 when false then 2 else 3 end, "</span> +</div> |
| <div class="line"><a name="l00933"></a><span class="lineno"> 933</span>  <span class="stringliteral">"(case true when true then 1 when false then 2 else 3 end)"</span>,</div> |
| <div class="line"><a name="l00934"></a><span class="lineno"> 934</span>  <span class="stringliteral">"SELECT CASE TRUE WHEN TRUE THEN 1 WHEN FALSE THEN 2 ELSE 3 END, "</span> +</div> |
| <div class="line"><a name="l00935"></a><span class="lineno"> 935</span>  <span class="stringliteral">"(CASE TRUE WHEN TRUE THEN 1 WHEN FALSE THEN 2 ELSE 3 END)"</span>);</div> |
| <div class="line"><a name="l00936"></a><span class="lineno"> 936</span>  <span class="comment">// DECODE version of CaseExpr.</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select decode(1, 2, 3), (decode(4, 5, 6))"</span>,</div> |
| <div class="line"><a name="l00938"></a><span class="lineno"> 938</span>  <span class="stringliteral">"SELECT decode(1, 2, 3), (decode(4, 5, 6))"</span>);</div> |
| <div class="line"><a name="l00939"></a><span class="lineno"> 939</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select decode(1, 2, 3, 4, 5, 6), (decode(1, 2, 3, 4, 5, 6))"</span>,</div> |
| <div class="line"><a name="l00940"></a><span class="lineno"> 940</span>  <span class="stringliteral">"SELECT decode(1, 2, 3, 4, 5, 6), (decode(1, 2, 3, 4, 5, 6))"</span>);</div> |
| <div class="line"><a name="l00941"></a><span class="lineno"> 941</span> </div> |
| <div class="line"><a name="l00942"></a><span class="lineno"> 942</span>  <span class="comment">// CastExpr.</span></div> |
| <div class="line"><a name="l00943"></a><span class="lineno"> 943</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select cast(NULL as INT), (cast(NULL as INT))"</span>,</div> |
| <div class="line"><a name="l00944"></a><span class="lineno"> 944</span>  <span class="stringliteral">"SELECT CAST(NULL AS INT), (CAST(NULL AS INT))"</span>);</div> |
| <div class="line"><a name="l00945"></a><span class="lineno"> 945</span>  <span class="comment">// FunctionCallExpr.</span></div> |
| <div class="line"><a name="l00946"></a><span class="lineno"> 946</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select pi(), (pi()), trim('a'), (trim('a'))"</span>,</div> |
| <div class="line"><a name="l00947"></a><span class="lineno"> 947</span>  <span class="stringliteral">"SELECT pi(), (pi()), trim('a'), (trim('a'))"</span>);</div> |
| <div class="line"><a name="l00948"></a><span class="lineno"> 948</span>  <span class="comment">// LiteralExpr.</span></div> |
| <div class="line"><a name="l00949"></a><span class="lineno"> 949</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 10, (10), 20.0, (20.0), NULL, (NULL), 'abc', ('abc')"</span>,</div> |
| <div class="line"><a name="l00950"></a><span class="lineno"> 950</span>  <span class="stringliteral">"SELECT 10, (10), 20.0, (20.0), NULL, (NULL), 'abc', ('abc')"</span>);</div> |
| <div class="line"><a name="l00951"></a><span class="lineno"> 951</span>  <span class="comment">// BetweenPredicate.</span></div> |
| <div class="line"><a name="l00952"></a><span class="lineno"> 952</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 5 between 10 and 20, (5 between 10 and 20)"</span>,</div> |
| <div class="line"><a name="l00953"></a><span class="lineno"> 953</span>  <span class="stringliteral">"SELECT 5 BETWEEN 10 AND 20, (5 BETWEEN 10 AND 20)"</span>);</div> |
| <div class="line"><a name="l00954"></a><span class="lineno"> 954</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 5 not between 10 and 20, (5 not between 10 and 20)"</span>,</div> |
| <div class="line"><a name="l00955"></a><span class="lineno"> 955</span>  <span class="stringliteral">"SELECT 5 NOT BETWEEN 10 AND 20, (5 NOT BETWEEN 10 AND 20)"</span>);</div> |
| <div class="line"><a name="l00956"></a><span class="lineno"> 956</span>  <span class="comment">// BinaryPredicate.</span></div> |
| <div class="line"><a name="l00957"></a><span class="lineno"> 957</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 'a' = 'b', ('a' = 'b'), 'a' != 'b', ('a' != 'b'), "</span> +</div> |
| <div class="line"><a name="l00958"></a><span class="lineno"> 958</span>  <span class="stringliteral">"1 < 2, (1 < 2), 1 <= 2, (1 <= 2), 1 > 2, (1 > 2), 1 >= 2, (1 >= 2)"</span>,</div> |
| <div class="line"><a name="l00959"></a><span class="lineno"> 959</span>  <span class="stringliteral">"SELECT 'a' = 'b', ('a' = 'b'), 'a' != 'b', ('a' != 'b'), "</span> +</div> |
| <div class="line"><a name="l00960"></a><span class="lineno"> 960</span>  <span class="stringliteral">"1 < 2, (1 < 2), 1 <= 2, (1 <= 2), 1 > 2, (1 > 2), 1 >= 2, (1 >= 2)"</span>);</div> |
| <div class="line"><a name="l00961"></a><span class="lineno"> 961</span>  <span class="comment">// CompoundPredicate.</span></div> |
| <div class="line"><a name="l00962"></a><span class="lineno"> 962</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select true and false, (true and false), "</span> +</div> |
| <div class="line"><a name="l00963"></a><span class="lineno"> 963</span>  <span class="stringliteral">"false or true, (false or true), "</span> +</div> |
| <div class="line"><a name="l00964"></a><span class="lineno"> 964</span>  <span class="stringliteral">"!true, (!true), not false, (not false)"</span>,</div> |
| <div class="line"><a name="l00965"></a><span class="lineno"> 965</span>  <span class="stringliteral">"SELECT TRUE AND FALSE, (TRUE AND FALSE), "</span> +</div> |
| <div class="line"><a name="l00966"></a><span class="lineno"> 966</span>  <span class="stringliteral">"FALSE OR TRUE, (FALSE OR TRUE), "</span> +</div> |
| <div class="line"><a name="l00967"></a><span class="lineno"> 967</span>  <span class="stringliteral">"NOT TRUE, (NOT TRUE), NOT FALSE, (NOT FALSE)"</span>);</div> |
| <div class="line"><a name="l00968"></a><span class="lineno"> 968</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select ((true and (false or false) or true) and (false or true))"</span>,</div> |
| <div class="line"><a name="l00969"></a><span class="lineno"> 969</span>  <span class="stringliteral">"SELECT ((TRUE AND (FALSE OR FALSE) OR TRUE) AND (FALSE OR TRUE))"</span>);</div> |
| <div class="line"><a name="l00970"></a><span class="lineno"> 970</span>  <span class="comment">// InPredicate.</span></div> |
| <div class="line"><a name="l00971"></a><span class="lineno"> 971</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 5 in (4, 6, 7, 5), (5 in (4, 6, 7, 5)),"</span> +</div> |
| <div class="line"><a name="l00972"></a><span class="lineno"> 972</span>  <span class="stringliteral">"5 not in (4, 6, 7, 5), (5 not In (4, 6, 7, 5))"</span>,</div> |
| <div class="line"><a name="l00973"></a><span class="lineno"> 973</span>  <span class="stringliteral">"SELECT 5 IN (4, 6, 7, 5), (5 IN (4, 6, 7, 5)), "</span> +</div> |
| <div class="line"><a name="l00974"></a><span class="lineno"> 974</span>  <span class="stringliteral">"5 NOT IN (4, 6, 7, 5), (5 NOT IN (4, 6, 7, 5))"</span>);</div> |
| <div class="line"><a name="l00975"></a><span class="lineno"> 975</span>  <span class="comment">// IsNullPredicate.</span></div> |
| <div class="line"><a name="l00976"></a><span class="lineno"> 976</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 5 is null, (5 is null), 10 is not null, (10 is not null)"</span>,</div> |
| <div class="line"><a name="l00977"></a><span class="lineno"> 977</span>  <span class="stringliteral">"SELECT 5 IS NULL, (5 IS NULL), 10 IS NOT NULL, (10 IS NOT NULL)"</span>);</div> |
| <div class="line"><a name="l00978"></a><span class="lineno"> 978</span>  <span class="comment">// LikePredicate.</span></div> |
| <div class="line"><a name="l00979"></a><span class="lineno"> 979</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select 'a' LIKE '%b.', ('a' LIKE '%b.'), "</span> +</div> |
| <div class="line"><a name="l00980"></a><span class="lineno"> 980</span>  <span class="stringliteral">"'b' RLIKE '.c%', ('b' RLIKE '.c%'),"</span> +</div> |
| <div class="line"><a name="l00981"></a><span class="lineno"> 981</span>  <span class="stringliteral">"'d' REGEXP '.e%', ('d' REGEXP '.e%')"</span>,</div> |
| <div class="line"><a name="l00982"></a><span class="lineno"> 982</span>  <span class="stringliteral">"SELECT 'a' LIKE '%b.', ('a' LIKE '%b.'), "</span> +</div> |
| <div class="line"><a name="l00983"></a><span class="lineno"> 983</span>  <span class="stringliteral">"'b' RLIKE '.c%', ('b' RLIKE '.c%'), "</span> +</div> |
| <div class="line"><a name="l00984"></a><span class="lineno"> 984</span>  <span class="stringliteral">"'d' REGEXP '.e%', ('d' REGEXP '.e%')"</span>);</div> |
| <div class="line"><a name="l00985"></a><span class="lineno"> 985</span>  <span class="comment">// SlotRef.</span></div> |
| <div class="line"><a name="l00986"></a><span class="lineno"> 986</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select bool_col, (bool_col), int_col, (int_col) "</span> +</div> |
| <div class="line"><a name="l00987"></a><span class="lineno"> 987</span>  <span class="stringliteral">"string_col, (string_col), timestamp_col, (timestamp_col) "</span> +</div> |
| <div class="line"><a name="l00988"></a><span class="lineno"> 988</span>  <span class="stringliteral">"from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00989"></a><span class="lineno"> 989</span>  <span class="stringliteral">"SELECT bool_col, (bool_col), int_col, (int_col) "</span> +</div> |
| <div class="line"><a name="l00990"></a><span class="lineno"> 990</span>  <span class="stringliteral">"string_col, (string_col), timestamp_col, (timestamp_col) "</span> +</div> |
| <div class="line"><a name="l00991"></a><span class="lineno"> 991</span>  <span class="stringliteral">"FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00992"></a><span class="lineno"> 992</span> </div> |
| <div class="line"><a name="l00993"></a><span class="lineno"> 993</span>  <span class="comment">// TimestampArithmeticExpr.</span></div> |
| <div class="line"><a name="l00994"></a><span class="lineno"> 994</span>  <span class="comment">// Non-function-call like version.</span></div> |
| <div class="line"><a name="l00995"></a><span class="lineno"> 995</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select timestamp_col + interval 10 years, "</span> +</div> |
| <div class="line"><a name="l00996"></a><span class="lineno"> 996</span>  <span class="stringliteral">"(timestamp_col + interval 10 years) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l00997"></a><span class="lineno"> 997</span>  <span class="stringliteral">"SELECT timestamp_col + INTERVAL 10 years, "</span> +</div> |
| <div class="line"><a name="l00998"></a><span class="lineno"> 998</span>  <span class="stringliteral">"(timestamp_col + INTERVAL 10 years) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l00999"></a><span class="lineno"> 999</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select timestamp_col - interval 20 months, "</span> +</div> |
| <div class="line"><a name="l01000"></a><span class="lineno"> 1000</span>  <span class="stringliteral">"(timestamp_col - interval 20 months) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l01001"></a><span class="lineno"> 1001</span>  <span class="stringliteral">"SELECT timestamp_col - INTERVAL 20 months, "</span> +</div> |
| <div class="line"><a name="l01002"></a><span class="lineno"> 1002</span>  <span class="stringliteral">"(timestamp_col - INTERVAL 20 months) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l01003"></a><span class="lineno"> 1003</span>  <span class="comment">// Reversed interval and timestamp using addition.</span></div> |
| <div class="line"><a name="l01004"></a><span class="lineno"> 1004</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select interval 30 weeks + timestamp_col, "</span> +</div> |
| <div class="line"><a name="l01005"></a><span class="lineno"> 1005</span>  <span class="stringliteral">"(interval 30 weeks + timestamp_col) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l01006"></a><span class="lineno"> 1006</span>  <span class="stringliteral">"SELECT INTERVAL 30 weeks + timestamp_col, "</span> +</div> |
| <div class="line"><a name="l01007"></a><span class="lineno"> 1007</span>  <span class="stringliteral">"(INTERVAL 30 weeks + timestamp_col) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l01008"></a><span class="lineno"> 1008</span>  <span class="comment">// Function-call like version.</span></div> |
| <div class="line"><a name="l01009"></a><span class="lineno"> 1009</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select date_add(timestamp_col, interval 40 days), "</span> +</div> |
| <div class="line"><a name="l01010"></a><span class="lineno"> 1010</span>  <span class="stringliteral">"(date_add(timestamp_col, interval 40 days)) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l01011"></a><span class="lineno"> 1011</span>  <span class="stringliteral">"SELECT DATE_ADD(timestamp_col, INTERVAL 40 days), "</span> +</div> |
| <div class="line"><a name="l01012"></a><span class="lineno"> 1012</span>  <span class="stringliteral">"(DATE_ADD(timestamp_col, INTERVAL 40 days)) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l01013"></a><span class="lineno"> 1013</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select date_sub(timestamp_col, interval 40 hours), "</span> +</div> |
| <div class="line"><a name="l01014"></a><span class="lineno"> 1014</span>  <span class="stringliteral">"(date_sub(timestamp_col, interval 40 hours)) from functional.alltypes"</span>,</div> |
| <div class="line"><a name="l01015"></a><span class="lineno"> 1015</span>  <span class="stringliteral">"SELECT DATE_SUB(timestamp_col, INTERVAL 40 hours), "</span> +</div> |
| <div class="line"><a name="l01016"></a><span class="lineno"> 1016</span>  <span class="stringliteral">"(DATE_SUB(timestamp_col, INTERVAL 40 hours)) FROM functional.alltypes"</span>);</div> |
| <div class="line"><a name="l01017"></a><span class="lineno"> 1017</span>  }</div> |
| <div class="line"><a name="l01018"></a><span class="lineno"> 1018</span> </div> |
| <div class="line"><a name="l01022"></a><span class="lineno"> 1022</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l01023"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6ac2dec322b406a8e172f52da3b4c8a8"> 1023</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6ac2dec322b406a8e172f52da3b4c8a8">testDecimal</a>() {</div> |
| <div class="line"><a name="l01024"></a><span class="lineno"> 1024</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"select cast(1 as decimal)"</span>, <span class="stringliteral">"SELECT CAST(1 AS DECIMAL(9,0))"</span>);</div> |
| <div class="line"><a name="l01025"></a><span class="lineno"> 1025</span>  }</div> |
| <div class="line"><a name="l01026"></a><span class="lineno"> 1026</span> </div> |
| <div class="line"><a name="l01030"></a><span class="lineno"> 1030</span>  @<a class="code" href="cache-hash-test_8cc.html#a18269e3eecadb27e79614c02d898173e">Test</a></div> |
| <div class="line"><a name="l01031"></a><span class="lineno"><a class="line" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a5781398c9060a3a473f948722262cafa"> 1031</a></span>  <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a5781398c9060a3a473f948722262cafa">testSet</a>() {</div> |
| <div class="line"><a name="l01032"></a><span class="lineno"> 1032</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"set a = 1"</span>, <span class="stringliteral">"SET a='1'"</span>);</div> |
| <div class="line"><a name="l01033"></a><span class="lineno"> 1033</span>  <a class="code" href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"set `a b` = \"x y\""</span>, <span class="stringliteral">"SET `a b`='x y'"</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_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">testToSql</a>(<span class="stringliteral">"set"</span>, <span class="stringliteral">"SET"</span>);</div> |
| <div class="line"><a name="l01035"></a><span class="lineno"> 1035</span>  }</div> |
| <div class="line"><a name="l01036"></a><span class="lineno"> 1036</span> }</div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ad83420a59e2687e26417027126b6702b"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad83420a59e2687e26417027126b6702b">com.cloudera.impala.analysis.ToSqlTest.subqueryTest</a></div><div class="ttdeci">void subqueryTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00683">ToSqlTest.java:683</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a02c6f4979008ee36c7f6f71bd5bae0aa"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a02c6f4979008ee36c7f6f71bd5bae0aa">com.cloudera.impala.analysis.ToSqlTest.runTestTemplate</a></div><div class="ttdeci">void runTestTemplate(String sql, String expectedSql, String[]...testDims)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00104">ToSqlTest.java:104</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a3deb54b0c56febe58bdca9fd31129d76"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3deb54b0c56febe58bdca9fd31129d76">com.cloudera.impala.analysis.ToSqlTest.testToSql</a></div><div class="ttdeci">void testToSql(String query, String defaultDb, String expected)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00086">ToSqlTest.java:86</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a161cbe1dd4ca9de30f659081e055743c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a161cbe1dd4ca9de30f659081e055743c">com.cloudera.impala.analysis.ToSqlTest.insertTest</a></div><div class="ttdeci">void insertTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00812">ToSqlTest.java:812</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a8f40d5f258af131d465a56718782cec5"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a8f40d5f258af131d465a56718782cec5">com.cloudera.impala.analysis.ToSqlTest.TblsTestToSql</a></div><div class="ttdeci">void TblsTestToSql(String query, TableName tbl, String expectedSql)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00135">ToSqlTest.java:135</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ad9b03ecf24df395cfe675e29788d720c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad9b03ecf24df395cfe675e29788d720c">com.cloudera.impala.analysis.ToSqlTest.testToSql</a></div><div class="ttdeci">void testToSql(String query, String expected)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00082">ToSqlTest.java:82</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ad99f141d68d1463dad7b8b11823b8b7c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad99f141d68d1463dad7b8b11823b8b7c">com.cloudera.impala.analysis.ToSqlTest.unionTest</a></div><div class="ttdeci">void unionTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00542">ToSqlTest.java:542</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ac47ed85f7f7be98e067902415c1edbd5"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac47ed85f7f7be98e067902415c1edbd5">com.cloudera.impala.analysis.ToSqlTest.testAnalyticExprs</a></div><div class="ttdeci">void testAnalyticExprs()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00889">ToSqlTest.java:889</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ac222935a5f235618e0fca2b7104a0b27"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ac222935a5f235618e0fca2b7104a0b27">com.cloudera.impala.analysis.ToSqlTest.valuesTest</a></div><div class="ttdeci">void valuesTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00591">ToSqlTest.java:591</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html_a399e5acf1b8bd104705c2fb8a43fc611"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a399e5acf1b8bd104705c2fb8a43fc611">com.cloudera.impala.analysis.AnalyzerTest.catalog_</a></div><div class="ttdeci">static ImpaladCatalog catalog_</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00058">AnalyzerTest.java:58</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html">com.cloudera.impala.analysis.TableName</a></div><div class="ttdef"><b>Definition:</b> <a href="TableName_8java_source.html#l00033">TableName.java:33</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils_html_a6c9fa086559d58750e77fb02b21cedfd"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils.html#a6c9fa086559d58750e77fb02b21cedfd">com.cloudera.impala.testutil.TestUtils.createQueryContext</a></div><div class="ttdeci">static TQueryCtx createQueryContext()</div><div class="ttdef"><b>Definition:</b> <a href="TestUtils_8java_source.html#l00197">TestUtils.java:197</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a83acd749733fd195c8a3409ecd5779f2"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a83acd749733fd195c8a3409ecd5779f2">com.cloudera.impala.analysis.ToSqlTest.leftSemiJoinTypes_</a></div><div class="ttdeci">static final String[] leftSemiJoinTypes_</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00036">ToSqlTest.java:36</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ad85c892811415ce54947af88973e0a18"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad85c892811415ce54947af88973e0a18">com.cloudera.impala.analysis.ToSqlTest.joinConditions_</a></div><div class="ttdeci">static final String[] joinConditions_</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00032">ToSqlTest.java:32</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a3f3b9263cb27c13a3a44222c59368593"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3f3b9263cb27c13a3a44222c59368593">com.cloudera.impala.analysis.ToSqlTest.joinTypes_</a></div><div class="ttdeci">static final String[] joinTypes_</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00044">ToSqlTest.java:44</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest_html_a022278a60d3b447eaaddc80db5d98337"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalyzerTest.html#a022278a60d3b447eaaddc80db5d98337">com.cloudera.impala.analysis.AnalyzerTest.createAnalyzer</a></div><div class="ttdeci">Analyzer createAnalyzer(String defaultDb)</div><div class="ttdef"><b>Definition:</b> <a href="AnalyzerTest_8java_source.html#l00085">AnalyzerTest.java:85</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a0352d3431af8e7fa2abd6362862bd6fb"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0352d3431af8e7fa2abd6362862bd6fb">com.cloudera.impala.analysis.ToSqlTest.orderByTest</a></div><div class="ttdeci">void orderByTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00485">ToSqlTest.java:485</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html">com.cloudera.impala.analysis.ToSqlTest</a></div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00029">ToSqlTest.java:29</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_1TableName_html_aeba8e4c3a8552e9da915078adba3948c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1TableName.html#aeba8e4c3a8552e9da915078adba3948c">com.cloudera.impala.analysis.TableName.getDb</a></div><div class="ttdeci">String getDb()</div><div class="ttdef"><b>Definition:</b> <a href="TableName_8java_source.html#l00045">TableName.java:45</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_aca4ae64da149bb94c2551832197eb7bf"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#aca4ae64da149bb94c2551832197eb7bf">com.cloudera.impala.analysis.ToSqlTest.runTestTemplate</a></div><div class="ttdeci">void runTestTemplate(String sql, String expectedSql, int dim, Object[] testVector, String[]...testDims)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00109">ToSqlTest.java:109</a></div></div> |
| <div class="ttc" id="enumcom_1_1cloudera_1_1impala_1_1analysis_1_1JoinOperator_html"><div class="ttname"><a href="enumcom_1_1cloudera_1_1impala_1_1analysis_1_1JoinOperator.html">com.cloudera.impala.analysis.JoinOperator</a></div><div class="ttdef"><b>Definition:</b> <a href="JoinOperator_8java_source.html#l00019">JoinOperator.java:19</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ace7ea1025296ea0878bef4f82ba05e09"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ace7ea1025296ea0878bef4f82ba05e09">com.cloudera.impala.analysis.ToSqlTest.planHintsTest</a></div><div class="ttdeci">void planHintsTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00415">ToSqlTest.java:415</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_1AnalysisContext_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1AnalysisContext.html">com.cloudera.impala.analysis.AnalysisContext</a></div><div class="ttdef"><b>Definition:</b> <a href="AnalysisContext_8java_source.html#l00034">AnalysisContext.java:34</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a3c862c924c08523c92d51a8b49970df2"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a3c862c924c08523c92d51a8b49970df2">com.cloudera.impala.analysis.ToSqlTest.withClauseTest</a></div><div class="ttdeci">void withClauseTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00740">ToSqlTest.java:740</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a19f9ebed4855f6d2d8c102a326960687"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a19f9ebed4855f6d2d8c102a326960687">com.cloudera.impala.analysis.ToSqlTest.TestIdentifierQuoting</a></div><div class="ttdeci">void TestIdentifierQuoting()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00341">ToSqlTest.java:341</a></div></div> |
| <div class="ttc" id="interfacecom_1_1cloudera_1_1impala_1_1analysis_1_1ParseNode_html"><div class="ttname"><a href="interfacecom_1_1cloudera_1_1impala_1_1analysis_1_1ParseNode.html">com.cloudera.impala.analysis.ParseNode</a></div><div class="ttdef"><b>Definition:</b> <a href="ParseNode_8java_source.html#l00019">ParseNode.java:19</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a5781398c9060a3a473f948722262cafa"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a5781398c9060a3a473f948722262cafa">com.cloudera.impala.analysis.ToSqlTest.testSet</a></div><div class="ttdeci">void testSet()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l01031">ToSqlTest.java:1031</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a6ac2dec322b406a8e172f52da3b4c8a8"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6ac2dec322b406a8e172f52da3b4c8a8">com.cloudera.impala.analysis.ToSqlTest.testDecimal</a></div><div class="ttdeci">void testDecimal()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l01023">ToSqlTest.java:1023</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig_html_ac037eb9db44991e689a14a4d5d0dacf1"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig.html#ac037eb9db44991e689a14a4d5d0dacf1">com.cloudera.impala.authorization.AuthorizationConfig.createAuthDisabledConfig</a></div><div class="ttdeci">static AuthorizationConfig createAuthDisabledConfig()</div><div class="ttdef"><b>Definition:</b> <a href="AuthorizationConfig_8java_source.html#l00056">AuthorizationConfig.java:56</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a0b333efe7eb43963188cc0987330cd2b"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a0b333efe7eb43963188cc0987330cd2b">com.cloudera.impala.analysis.ToSqlTest.inlineViewTest</a></div><div class="ttdeci">void inlineViewTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00613">ToSqlTest.java:613</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_1authorization_1_1AuthorizationConfig_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1authorization_1_1AuthorizationConfig.html">com.cloudera.impala.authorization.AuthorizationConfig</a></div><div class="ttdef"><b>Definition:</b> <a href="AuthorizationConfig_8java_source.html#l00027">AuthorizationConfig.java:27</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path_html_abd0f3c7b25a10ffeb1a50d802497b07c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#abd0f3c7b25a10ffeb1a50d802497b07c">com.cloudera.impala.analysis.Path.MAP_VALUE_FIELD_NAME</a></div><div class="ttdeci">static final String MAP_VALUE_FIELD_NAME</div><div class="ttdef"><b>Definition:</b> <a href="Path_8java_source.html#l00079">Path.java:79</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a26df8bd0bab7bc981a24a59936dc8041"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26df8bd0bab7bc981a24a59936dc8041">com.cloudera.impala.analysis.ToSqlTest.aggregationTest</a></div><div class="ttdeci">void aggregationTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00460">ToSqlTest.java:460</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a1d7251ff3274dc6d2455af6db3805864"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a1d7251ff3274dc6d2455af6db3805864">com.cloudera.impala.analysis.ToSqlTest.selectListTest</a></div><div class="ttdeci">void selectListTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00146">ToSqlTest.java:146</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a21030448315556e130370c46a74a670a"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a21030448315556e130370c46a74a670a">com.cloudera.impala.analysis.ToSqlTest.TestStructFields</a></div><div class="ttdeci">void TestStructFields()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00297">ToSqlTest.java:297</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_1ToSqlTest_html_a6506774d8ac54ad38ab6bd72073243f8"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6506774d8ac54ad38ab6bd72073243f8">com.cloudera.impala.analysis.ToSqlTest.testExprs</a></div><div class="ttdeci">void testExprs()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00902">ToSqlTest.java:902</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a158f426d5f0fd3eeab05b29d20707d76"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a158f426d5f0fd3eeab05b29d20707d76">com.cloudera.impala.analysis.ToSqlTest.analyze</a></div><div class="ttdeci">static AnalysisContext.AnalysisResult analyze(String query, String defaultDb)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00066">ToSqlTest.java:66</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_af02bc01ae0d503b3ad035bf6bdd18b70"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#af02bc01ae0d503b3ad035bf6bdd18b70">com.cloudera.impala.analysis.ToSqlTest.joinTest</a></div><div class="ttdeci">void joinTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00398">ToSqlTest.java:398</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a84ae2cbc3aa440d62ae53631c8de20a4"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84ae2cbc3aa440d62ae53631c8de20a4">com.cloudera.impala.analysis.ToSqlTest.allTest</a></div><div class="ttdeci">void allTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00526">ToSqlTest.java:526</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a84a6ea03bc4af0392c83d2a853c76abc"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a84a6ea03bc4af0392c83d2a853c76abc">com.cloudera.impala.analysis.ToSqlTest.rightSemiJoinTypes_</a></div><div class="ttdeci">static final String[] rightSemiJoinTypes_</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00040">ToSqlTest.java:40</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a26c6a3e237522f7826af92e4b990fb87"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a26c6a3e237522f7826af92e4b990fb87">com.cloudera.impala.analysis.ToSqlTest.whereTest</a></div><div class="ttdeci">void whereTest()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00373">ToSqlTest.java:373</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a04d440534ef30479ea413a6841006cb6"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a04d440534ef30479ea413a6841006cb6">com.cloudera.impala.analysis.ToSqlTest.TestTableAliases</a></div><div class="ttdeci">void TestTableAliases()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00285">ToSqlTest.java:285</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path_html_a158469d3042e41b8c8b282ad383365ff"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#a158469d3042e41b8c8b282ad383365ff">com.cloudera.impala.analysis.Path.ARRAY_ITEM_FIELD_NAME</a></div><div class="ttdeci">static final String ARRAY_ITEM_FIELD_NAME</div><div class="ttdef"><b>Definition:</b> <a href="Path_8java_source.html#l00076">Path.java:76</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a390f9fb42a3945d3dde14c9146bcb351"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a390f9fb42a3945d3dde14c9146bcb351">com.cloudera.impala.analysis.ToSqlTest.nonSemiJoinTypes_</a></div><div class="ttdeci">static final String[] nonSemiJoinTypes_</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00047">ToSqlTest.java:47</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html">com.cloudera.impala.analysis.Path</a></div><div class="ttdef"><b>Definition:</b> <a href="Path_8java_source.html#l00074">Path.java:74</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a6555e14b36c1d17150f1956848878e16"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a6555e14b36c1d17150f1956848878e16">com.cloudera.impala.analysis.ToSqlTest.testChildTableRefs</a></div><div class="ttdeci">void testChildTableRefs(String childTable, String childColumn)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00225">ToSqlTest.java:225</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a62710af68405c678e3844bb2b0394856"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a62710af68405c678e3844bb2b0394856">com.cloudera.impala.analysis.ToSqlTest.isCollectionTableRef</a></div><div class="ttdeci">boolean isCollectionTableRef(String tableName)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00166">ToSqlTest.java:166</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_a67cdae37bf56131e69bd1ce674e47d9c"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#a67cdae37bf56131e69bd1ce674e47d9c">com.cloudera.impala.analysis.ToSqlTest.TestCollectionTableRefs</a></div><div class="ttdeci">void TestCollectionTableRefs()</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00305">ToSqlTest.java:305</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils_html"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1testutil_1_1TestUtils.html">com.cloudera.impala.testutil.TestUtils</a></div><div class="ttdef"><b>Definition:</b> <a href="TestUtils_8java_source.html#l00034">TestUtils.java:34</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path_html_ad287a1bd3eb082ab61e9b08b55146728"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1Path.html#ad287a1bd3eb082ab61e9b08b55146728">com.cloudera.impala.analysis.Path.MAP_KEY_FIELD_NAME</a></div><div class="ttdeci">static final String MAP_KEY_FIELD_NAME</div><div class="ttdef"><b>Definition:</b> <a href="Path_8java_source.html#l00078">Path.java:78</a></div></div> |
| <div class="ttc" id="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest_html_ad6b573ccd368d4fd064e8346139fb20e"><div class="ttname"><a href="classcom_1_1cloudera_1_1impala_1_1analysis_1_1ToSqlTest.html#ad6b573ccd368d4fd064e8346139fb20e">com.cloudera.impala.analysis.ToSqlTest.testAllTableAliases</a></div><div class="ttdeci">void testAllTableAliases(String[] tables, String[] columns)</div><div class="ttdef"><b>Definition:</b> <a href="ToSqlTest_8java_source.html#l00174">ToSqlTest.java:174</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="ToSqlTest_8java.html">ToSqlTest.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> |
