0.139/index.html


<!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/html; charset=utf-8" />
    
    <title>Presto Documentation &mdash; Presto 0.139 Documentation</title>
    
    <link rel="stylesheet" href="_static/presto.css" type="text/css" />
    <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
    
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '',
        VERSION:     '0.139',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="_static/jquery.js"></script>
    <script type="text/javascript" src="_static/underscore.js"></script>
    <script type="text/javascript" src="_static/doctools.js"></script>
    <link rel="top" title="Presto 0.139 Documentation" href="#" />
    <link rel="next" title="1. Overview" href="overview.html" /> 
  </head>
  <body>
<div class="header">
    <h1 class="heading"><a href="#">
        <span>Presto 0.139 Documentation</span></a></h1>
    <h2 class="heading"><span>Presto Documentation</span></h2>
</div>
<div class="topnav">
    
<p class="nav">
    <span class="left">
        &nbsp;
    </span>
    <span class="right">
        <a href="overview.html">1. Overview</a> &raquo;
    </span>
</p>

</div>
<div class="content">
    
  <div class="section" id="presto-documentation">
<h1>Presto Documentation</h1>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="overview.html">1. Overview</a><ul>
<li class="toctree-l2"><a class="reference internal" href="overview/use-cases.html">1.1. Use Cases</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="installation.html">2. Installation</a><ul>
<li class="toctree-l2"><a class="reference internal" href="installation/deployment.html">2.1. Deploying Presto</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation/cli.html">2.2. Command Line Interface</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation/jdbc.html">2.3. JDBC Driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation/verifier.html">2.4. Presto Verifier</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation/benchmark-driver.html">2.5. Benchmark Driver</a></li>
<li class="toctree-l2"><a class="reference internal" href="installation/tableau.html">2.6. Web Connector for Tableau</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="admin.html">3. Administration</a><ul>
<li class="toctree-l2"><a class="reference internal" href="admin/web-interface.html">3.1. Web Interface</a></li>
<li class="toctree-l2"><a class="reference internal" href="admin/tuning.html">3.2. Tuning Presto</a></li>
<li class="toctree-l2"><a class="reference internal" href="admin/queue.html">3.3. Queue Configuration</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="connector.html">4. Connectors</a><ul>
<li class="toctree-l2"><a class="reference internal" href="connector/blackhole.html">4.1. Black Hole Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/cassandra.html">4.2. Cassandra Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/hive.html">4.3. Hive Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/jmx.html">4.4. JMX Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/kafka.html">4.5. Kafka Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/kafka-tutorial.html">4.6. Kafka Connector Tutorial</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/mysql.html">4.7. MySQL Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/postgresql.html">4.8. PostgreSQL Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/redis.html">4.9. Redis Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/system.html">4.10. System Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="connector/tpch.html">4.11. TPCH Connector</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="functions.html">5. Functions and Operators</a><ul>
<li class="toctree-l2"><a class="reference internal" href="functions/logical.html">5.1. Logical Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/comparison.html">5.2. Comparison Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/conditional.html">5.3. Conditional Expressions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/conversion.html">5.4. Conversion Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/math.html">5.5. Mathematical Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/bitwise.html">5.6. Bitwise Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/string.html">5.7. String Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/binary.html">5.8. Binary Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/datetime.html">5.9. Date and Time Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/regexp.html">5.10. Regular Expression Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/json.html">5.11. JSON Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/url.html">5.12. URL Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/aggregate.html">5.13. Aggregate Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/window.html">5.14. Window Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/color.html">5.15. Color Functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/array.html">5.16. Array Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/map.html">5.17. Map Functions and Operators</a></li>
<li class="toctree-l2"><a class="reference internal" href="functions/teradata.html">5.18. Teradata Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="language.html">6. SQL Language</a><ul>
<li class="toctree-l2"><a class="reference internal" href="language/types.html">6.1. Data Types</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="sql.html">7. SQL Statement Syntax</a><ul>
<li class="toctree-l2"><a class="reference internal" href="sql/alter-table.html">7.1. ALTER TABLE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/call.html">7.2. CALL</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/commit.html">7.3. COMMIT</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/create-table.html">7.4. CREATE TABLE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/create-table-as.html">7.5. CREATE TABLE AS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/create-view.html">7.6. CREATE VIEW</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/delete.html">7.7. DELETE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/describe.html">7.8. DESCRIBE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/drop-table.html">7.9. DROP TABLE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/drop-view.html">7.10. DROP VIEW</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/explain.html">7.11. EXPLAIN</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/insert.html">7.12. INSERT</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/reset-session.html">7.13. RESET SESSION</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/rollback.html">7.14. ROLLBACK</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/select.html">7.15. SELECT</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/set-session.html">7.16. SET SESSION</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-catalogs.html">7.17. SHOW CATALOGS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-columns.html">7.18. SHOW COLUMNS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-functions.html">7.19. SHOW FUNCTIONS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-partitions.html">7.20. SHOW PARTITIONS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-schemas.html">7.21. SHOW SCHEMAS</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-session.html">7.22. SHOW SESSION</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/show-tables.html">7.23. SHOW TABLES</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/start-transaction.html">7.24. START TRANSACTION</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/use.html">7.25. USE</a></li>
<li class="toctree-l2"><a class="reference internal" href="sql/values.html">7.26. VALUES</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="migration.html">8. Migration</a><ul>
<li class="toctree-l2"><a class="reference internal" href="migration/from-hive.html">8.1. Migrating From Hive</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="develop.html">9. Developer Guide</a><ul>
<li class="toctree-l2"><a class="reference internal" href="develop/spi-overview.html">9.1. SPI Overview</a></li>
<li class="toctree-l2"><a class="reference internal" href="develop/example-http.html">9.2. Example HTTP Connector</a></li>
<li class="toctree-l2"><a class="reference internal" href="develop/types.html">9.3. Type System</a></li>
<li class="toctree-l2"><a class="reference internal" href="develop/functions.html">9.4. Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="release.html">10. Release Notes</a><ul>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.139.html">10.1. Release 0.139</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.138.html">10.2. Release 0.138</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.137.html">10.3. Release 0.137</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.136.html">10.4. Release 0.136</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.135.html">10.5. Release 0.135</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.134.html">10.6. Release 0.134</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.133.html">10.7. Release 0.133</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.132.html">10.8. Release 0.132</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.131.html">10.9. Release 0.131</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.130.html">10.10. Release 0.130</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.129.html">10.11. Release 0.129</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.128.html">10.12. Release 0.128</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.127.html">10.13. Release 0.127</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.126.html">10.14. Release 0.126</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.125.html">10.15. Release 0.125</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.124.html">10.16. Release 0.124</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.123.html">10.17. Release 0.123</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.122.html">10.18. Release 0.122</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.121.html">10.19. Release 0.121</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.120.html">10.20. Release 0.120</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.119.html">10.21. Release 0.119</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.118.html">10.22. Release 0.118</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.117.html">10.23. Release 0.117</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.116.html">10.24. Release 0.116</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.115.html">10.25. Release 0.115</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.114.html">10.26. Release 0.114</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.113.html">10.27. Release 0.113</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.112.html">10.28. Release 0.112</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.111.html">10.29. Release 0.111</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.110.html">10.30. Release 0.110</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.109.html">10.31. Release 0.109</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.108.html">10.32. Release 0.108</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.107.html">10.33. Release 0.107</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.106.html">10.34. Release 0.106</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.105.html">10.35. Release 0.105</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.104.html">10.36. Release 0.104</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.103.html">10.37. Release 0.103</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.102.html">10.38. Release 0.102</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.101.html">10.39. Release 0.101</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.100.html">10.40. Release 0.100</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.99.html">10.41. Release 0.99</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.98.html">10.42. Release 0.98</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.97.html">10.43. Release 0.97</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.96.html">10.44. Release 0.96</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.95.html">10.45. Release 0.95</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.94.html">10.46. Release 0.94</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.93.html">10.47. Release 0.93</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.92.html">10.48. Release 0.92</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.91.html">10.49. Release 0.91</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.90.html">10.50. Release 0.90</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.89.html">10.51. Release 0.89</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.88.html">10.52. Release 0.88</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.87.html">10.53. Release 0.87</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.86.html">10.54. Release 0.86</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.85.html">10.55. Release 0.85</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.84.html">10.56. Release 0.84</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.83.html">10.57. Release 0.83</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.82.html">10.58. Release 0.82</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.81.html">10.59. Release 0.81</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.80.html">10.60. Release 0.80</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.79.html">10.61. Release 0.79</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.78.html">10.62. Release 0.78</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.77.html">10.63. Release 0.77</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.76.html">10.64. Release 0.76</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.75.html">10.65. Release 0.75</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.74.html">10.66. Release 0.74</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.73.html">10.67. Release 0.73</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.72.html">10.68. Release 0.72</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.71.html">10.69. Release 0.71</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.70.html">10.70. Release 0.70</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.69.html">10.71. Release 0.69</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.68.html">10.72. Release 0.68</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.67.html">10.73. Release 0.67</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.66.html">10.74. Release 0.66</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.65.html">10.75. Release 0.65</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.64.html">10.76. Release 0.64</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.63.html">10.77. Release 0.63</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.62.html">10.78. Release 0.62</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.61.html">10.79. Release 0.61</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.60.html">10.80. Release 0.60</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.59.html">10.81. Release 0.59</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.58.html">10.82. Release 0.58</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.57.html">10.83. Release 0.57</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.56.html">10.84. Release 0.56</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.55.html">10.85. Release 0.55</a></li>
<li class="toctree-l2"><a class="reference internal" href="release/release-0.54.html">10.86. Release 0.54</a></li>
</ul>
</li>
</ul>
</div>
</div>


</div>
<div class="bottomnav">
    
<p class="nav">
    <span class="left">
        &nbsp;
    </span>
    <span class="right">
        <a href="overview.html">1. Overview</a> &raquo;
    </span>
</p>

</div>

    <div class="footer">
    </div>
  </body>
</html>