| |
| <!DOCTYPE html> |
| <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> |
| <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> |
| <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> |
| <!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]--> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| <title>ALTER VIEW - Spark 3.4.3 Documentation</title> |
| |
| |
| |
| |
| <link rel="stylesheet" href="css/bootstrap.min.css"> |
| <style> |
| body { |
| padding-top: 60px; |
| padding-bottom: 40px; |
| } |
| </style> |
| <meta name="viewport" content="width=device-width"> |
| <link rel="stylesheet" href="css/main.css"> |
| |
| <script src="js/vendor/modernizr-2.6.1-respond-1.1.0.min.js"></script> |
| |
| <link rel="stylesheet" href="css/pygments-default.css"> |
| <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.css" /> |
| <link rel="stylesheet" href="css/docsearch.css"> |
| |
| |
| <!-- Matomo --> |
| <script> |
| var _paq = window._paq = window._paq || []; |
| /* tracker methods like "setCustomDimension" should be called before "trackPageView" */ |
| _paq.push(["disableCookies"]); |
| _paq.push(['trackPageView']); |
| _paq.push(['enableLinkTracking']); |
| (function() { |
| var u="https://analytics.apache.org/"; |
| _paq.push(['setTrackerUrl', u+'matomo.php']); |
| _paq.push(['setSiteId', '40']); |
| var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0]; |
| g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s); |
| })(); |
| </script> |
| <!-- End Matomo Code --> |
| |
| |
| </head> |
| <body> |
| <!--[if lt IE 7]> |
| <p class="chromeframe">You are using an outdated browser. <a href="https://browsehappy.com/">Upgrade your browser today</a> or <a href="http://www.google.com/chromeframe/?redirect=true">install Google Chrome Frame</a> to better experience this site.</p> |
| <![endif]--> |
| |
| <!-- This code is taken from http://twitter.github.com/bootstrap/examples/hero.html --> |
| |
| <nav class="navbar fixed-top navbar-expand-md navbar-light bg-light" id="topbar"> |
| <div class="container"> |
| <div class="navbar-header"> |
| <div class="navbar-brand"><a href="index.html"> |
| <img src="img/spark-logo-hd.png" style="height:50px;"/></a><span class="version">3.4.3</span> |
| </div> |
| </div> |
| <button class="navbar-toggler" type="button" data-toggle="collapse" |
| data-target="#navbarCollapse" aria-controls="navbarCollapse" |
| aria-expanded="false" aria-label="Toggle navigation"> |
| <span class="navbar-toggler-icon"></span> |
| </button> |
| <div class="collapse navbar-collapse" id="navbarCollapse"> |
| <ul class="navbar-nav"> |
| <!--TODO(andyk): Add class="active" attribute to li some how.--> |
| <li class="nav-item"><a href="index.html" class="nav-link">Overview</a></li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarQuickStart" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Programming Guides</a> |
| <div class="dropdown-menu" aria-labelledby="navbarQuickStart"> |
| <a class="dropdown-item" href="quick-start.html">Quick Start</a> |
| <a class="dropdown-item" href="rdd-programming-guide.html">RDDs, Accumulators, Broadcasts Vars</a> |
| <a class="dropdown-item" href="sql-programming-guide.html">SQL, DataFrames, and Datasets</a> |
| <a class="dropdown-item" href="structured-streaming-programming-guide.html">Structured Streaming</a> |
| <a class="dropdown-item" href="streaming-programming-guide.html">Spark Streaming (DStreams)</a> |
| <a class="dropdown-item" href="ml-guide.html">MLlib (Machine Learning)</a> |
| <a class="dropdown-item" href="graphx-programming-guide.html">GraphX (Graph Processing)</a> |
| <a class="dropdown-item" href="sparkr.html">SparkR (R on Spark)</a> |
| <a class="dropdown-item" href="api/python/getting_started/index.html">PySpark (Python on Spark)</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarAPIDocs" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">API Docs</a> |
| <div class="dropdown-menu" aria-labelledby="navbarAPIDocs"> |
| <a class="dropdown-item" href="api/scala/org/apache/spark/index.html">Scala</a> |
| <a class="dropdown-item" href="api/java/index.html">Java</a> |
| <a class="dropdown-item" href="api/python/index.html">Python</a> |
| <a class="dropdown-item" href="api/R/index.html">R</a> |
| <a class="dropdown-item" href="api/sql/index.html">SQL, Built-in Functions</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarDeploying" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Deploying</a> |
| <div class="dropdown-menu" aria-labelledby="navbarDeploying"> |
| <a class="dropdown-item" href="cluster-overview.html">Overview</a> |
| <a class="dropdown-item" href="submitting-applications.html">Submitting Applications</a> |
| <div class="dropdown-divider"></div> |
| <a class="dropdown-item" href="spark-standalone.html">Spark Standalone</a> |
| <a class="dropdown-item" href="running-on-mesos.html">Mesos</a> |
| <a class="dropdown-item" href="running-on-yarn.html">YARN</a> |
| <a class="dropdown-item" href="running-on-kubernetes.html">Kubernetes</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarMore" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">More</a> |
| <div class="dropdown-menu" aria-labelledby="navbarMore"> |
| <a class="dropdown-item" href="configuration.html">Configuration</a> |
| <a class="dropdown-item" href="monitoring.html">Monitoring</a> |
| <a class="dropdown-item" href="tuning.html">Tuning Guide</a> |
| <a class="dropdown-item" href="job-scheduling.html">Job Scheduling</a> |
| <a class="dropdown-item" href="security.html">Security</a> |
| <a class="dropdown-item" href="hardware-provisioning.html">Hardware Provisioning</a> |
| <a class="dropdown-item" href="migration-guide.html">Migration Guide</a> |
| <div class="dropdown-divider"></div> |
| <a class="dropdown-item" href="building-spark.html">Building Spark</a> |
| <a class="dropdown-item" href="https://spark.apache.org/contributing.html">Contributing to Spark</a> |
| <a class="dropdown-item" href="https://spark.apache.org/third-party-projects.html">Third Party Projects</a> |
| </div> |
| </li> |
| |
| <li class="nav-item"> |
| <input type="text" id="docsearch-input" placeholder="Search the docs…"> |
| </li> |
| </ul> |
| <!--<span class="navbar-text navbar-right"><span class="version-text">v3.4.3</span></span>--> |
| </div> |
| </div> |
| </nav> |
| |
| <div class="container-wrapper"> |
| |
| |
| |
| <div class="left-menu-wrapper"> |
| <div class="left-menu"> |
| <h3><a href="sql-programming-guide.html">Spark SQL Guide</a></h3> |
| |
| <ul> |
| |
| <li> |
| <a href="sql-getting-started.html"> |
| |
| Getting Started |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-data-sources.html"> |
| |
| Data Sources |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-performance-tuning.html"> |
| |
| Performance Tuning |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-distributed-sql-engine.html"> |
| |
| Distributed SQL Engine |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-pyspark-pandas-with-arrow.html"> |
| |
| PySpark Usage Guide for Pandas with Apache Arrow |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-migration-old.html"> |
| |
| Migration Guide |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref.html"> |
| |
| SQL Reference |
| |
| </a> |
| </li> |
| |
| |
| |
| <ul> |
| |
| <li> |
| <a href="sql-ref-ansi-compliance.html"> |
| |
| ANSI Compliance |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-datatypes.html"> |
| |
| Data Types |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-datetime-pattern.html"> |
| |
| Datetime Pattern |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-number-pattern.html"> |
| |
| Number Pattern |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-functions.html"> |
| |
| Functions |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-identifier.html"> |
| |
| Identifiers |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-literals.html"> |
| |
| Literals |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-null-semantics.html"> |
| |
| Null Semantics |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-syntax.html"> |
| |
| SQL Syntax |
| |
| </a> |
| </li> |
| |
| |
| |
| <ul> |
| |
| <li> |
| <a href="sql-ref-syntax.html#ddl-statements"> |
| |
| Data Definition Statements |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-syntax.html#dml-statements"> |
| |
| Data Manipulation Statements |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-syntax.html#data-retrieval-statements"> |
| |
| Data Retrieval(Queries) |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref-syntax.html#auxiliary-statements"> |
| |
| Auxiliary Statements |
| |
| </a> |
| </li> |
| |
| |
| |
| </ul> |
| |
| |
| |
| </ul> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions.html"> |
| |
| Error Conditions |
| |
| </a> |
| </li> |
| |
| |
| |
| </ul> |
| |
| </div> |
| </div> |
| |
| <input id="nav-trigger" class="nav-trigger" checked type="checkbox"> |
| <label for="nav-trigger"></label> |
| <div class="content-with-sidebar mr-3" id="content"> |
| |
| <h1 class="title">ALTER VIEW</h1> |
| |
| |
| <h3 id="description">Description</h3> |
| |
| <p>The <code class="language-plaintext highlighter-rouge">ALTER VIEW</code> statement can alter metadata associated with the view. It can change the definition of the view, change |
| the name of a view to a different name, set and unset the metadata of the view by setting <code class="language-plaintext highlighter-rouge">TBLPROPERTIES</code>.</p> |
| |
| <h4 id="rename-view">RENAME View</h4> |
| <p>Renames the existing view. If the new view name already exists in the source database, a <code class="language-plaintext highlighter-rouge">TableAlreadyExistsException</code> is thrown. This operation |
| does not support moving the views across databases.</p> |
| |
| <p>If the view is cached, the command clears cached data of the view and all its dependents that refer to it. View’s cache will be lazily filled when the next time the view is accessed. The command leaves view’s dependents as uncached.</p> |
| |
| <h4 id="syntax">Syntax</h4> |
| <div class="language-sql highlighter-rouge"><div class="highlight"><pre class="highlight"><code><span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">view_identifier</span> <span class="k">RENAME</span> <span class="k">TO</span> <span class="n">view_identifier</span> |
| </code></pre></div></div> |
| |
| <h4 id="parameters">Parameters</h4> |
| <ul> |
| <li> |
| <p><strong>view_identifier</strong></p> |
| |
| <p>Specifies a view name, which may be optionally qualified with a database name.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ database_name. ] view_name</code></p> |
| </li> |
| </ul> |
| |
| <h4 id="set-view-properties">SET View Properties</h4> |
| <p>Set one or more properties of an existing view. The properties are the key value pairs. If the properties’ keys exist, |
| the values are replaced with the new values. If the properties’ keys do not exist, the key value pairs are added into |
| the properties.</p> |
| |
| <h4 id="syntax-1">Syntax</h4> |
| <div class="language-sql highlighter-rouge"><div class="highlight"><pre class="highlight"><code><span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">view_identifier</span> <span class="k">SET</span> <span class="n">TBLPROPERTIES</span> <span class="p">(</span> <span class="n">property_key</span> <span class="o">=</span> <span class="n">property_val</span> <span class="p">[</span> <span class="p">,</span> <span class="p">...</span> <span class="p">]</span> <span class="p">)</span> |
| </code></pre></div></div> |
| |
| <h4 id="parameters-1">Parameters</h4> |
| <ul> |
| <li> |
| <p><strong>view_identifier</strong></p> |
| |
| <p>Specifies a view name, which may be optionally qualified with a database name.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ database_name. ] view_name</code></p> |
| </li> |
| <li> |
| <p><strong>property_key</strong></p> |
| |
| <p>Specifies the property key. The key may consists of multiple parts separated by dot.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ key_part1 ] [ .key_part2 ] [ ... ]</code></p> |
| </li> |
| </ul> |
| |
| <h4 id="unset-view-properties">UNSET View Properties</h4> |
| <p>Drop one or more properties of an existing view. If the specified keys do not exist, an exception is thrown. Use |
| <code class="language-plaintext highlighter-rouge">IF EXISTS</code> to avoid the exception.</p> |
| |
| <h4 id="syntax-2">Syntax</h4> |
| <div class="language-sql highlighter-rouge"><div class="highlight"><pre class="highlight"><code><span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">view_identifier</span> <span class="n">UNSET</span> <span class="n">TBLPROPERTIES</span> <span class="p">[</span> <span class="n">IF</span> <span class="k">EXISTS</span> <span class="p">]</span> <span class="p">(</span> <span class="n">property_key</span> <span class="p">[</span> <span class="p">,</span> <span class="p">...</span> <span class="p">]</span> <span class="p">)</span> |
| </code></pre></div></div> |
| |
| <h4 id="parameters-2">Parameters</h4> |
| <ul> |
| <li> |
| <p><strong>view_identifier</strong></p> |
| |
| <p>Specifies a view name, which may be optionally qualified with a database name.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ database_name. ] view_name</code></p> |
| </li> |
| <li> |
| <p><strong>property_key</strong></p> |
| |
| <p>Specifies the property key. The key may consists of multiple parts separated by dot.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ key_part1 ] [ .key_part2 ] [ ... ]</code></p> |
| </li> |
| </ul> |
| |
| <h4 id="alter-view-as-select">ALTER View AS SELECT</h4> |
| <p><code class="language-plaintext highlighter-rouge">ALTER VIEW view_identifier AS SELECT</code> statement changes the definition of a view. The <code class="language-plaintext highlighter-rouge">SELECT</code> statement must be valid, |
| and the <code class="language-plaintext highlighter-rouge">view_identifier</code> must exist.</p> |
| |
| <h4 id="syntax-3">Syntax</h4> |
| <div class="language-sql highlighter-rouge"><div class="highlight"><pre class="highlight"><code><span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">view_identifier</span> <span class="k">AS</span> <span class="n">select_statement</span> |
| </code></pre></div></div> |
| |
| <p>Note that <code class="language-plaintext highlighter-rouge">ALTER VIEW</code> statement does not support <code class="language-plaintext highlighter-rouge">SET SERDE</code> or <code class="language-plaintext highlighter-rouge">SET SERDEPROPERTIES</code> properties.</p> |
| |
| <h4 id="parameters-3">Parameters</h4> |
| <ul> |
| <li> |
| <p><strong>view_identifier</strong></p> |
| |
| <p>Specifies a view name, which may be optionally qualified with a database name.</p> |
| |
| <p><strong>Syntax:</strong> <code class="language-plaintext highlighter-rouge">[ database_name. ] view_name</code></p> |
| </li> |
| <li> |
| <p><strong>select_statement</strong></p> |
| |
| <p>Specifies the definition of the view. Check <a href="sql-ref-syntax-qry-select.html">select_statement</a> for details.</p> |
| </li> |
| </ul> |
| |
| <h3 id="examples">Examples</h3> |
| |
| <div class="language-sql highlighter-rouge"><div class="highlight"><pre class="highlight"><code><span class="c1">-- Rename only changes the view name.</span> |
| <span class="c1">-- The source and target databases of the view have to be the same.</span> |
| <span class="c1">-- Use qualified or unqualified name for the source and target view.</span> |
| <span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v1</span> <span class="k">RENAME</span> <span class="k">TO</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| |
| <span class="c1">-- Verify that the new view is created.</span> |
| <span class="k">DESCRIBE</span> <span class="k">TABLE</span> <span class="n">EXTENDED</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">col_name</span><span class="o">|</span><span class="n">data_type</span> <span class="o">|</span><span class="k">comment</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">c1</span><span class="o">|</span> <span class="nb">int</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="n">c2</span><span class="o">|</span> <span class="n">string</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|#</span> <span class="n">Detailed</span> <span class="k">Table</span> <span class="n">Information</span><span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Database</span><span class="o">|</span> <span class="n">tempdb1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span><span class="o">|</span> <span class="n">v2</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| |
| <span class="c1">-- Before ALTER VIEW SET TBLPROPERTIES</span> |
| <span class="k">DESC</span> <span class="k">TABLE</span> <span class="n">EXTENDED</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">col_name</span><span class="o">|</span> <span class="n">data_type</span><span class="o">|</span><span class="k">comment</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">c1</span><span class="o">|</span> <span class="nb">int</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="n">c2</span><span class="o">|</span> <span class="n">string</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|#</span> <span class="n">Detailed</span> <span class="k">Table</span> <span class="n">Information</span><span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Database</span><span class="o">|</span> <span class="n">tempdb1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span><span class="o">|</span> <span class="n">v2</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span> <span class="n">Properties</span><span class="o">|</span> <span class="p">[....]</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| |
| <span class="c1">-- Set properties in TBLPROPERTIES</span> |
| <span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span> <span class="k">SET</span> <span class="n">TBLPROPERTIES</span> <span class="p">(</span><span class="s1">'created.by.user'</span> <span class="o">=</span> <span class="nv">"John"</span><span class="p">,</span> <span class="s1">'created.date'</span> <span class="o">=</span> <span class="s1">'01-01-2001'</span> <span class="p">);</span> |
| |
| <span class="c1">-- Use `DESCRIBE TABLE EXTENDED tempdb1.v2` to verify</span> |
| <span class="k">DESC</span> <span class="k">TABLE</span> <span class="n">EXTENDED</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">----------------------------+-----------------------------------------------------+-------+</span> |
| <span class="o">|</span> <span class="n">col_name</span><span class="o">|</span> <span class="n">data_type</span><span class="o">|</span><span class="k">comment</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+-----------------------------------------------------+-------+</span> |
| <span class="o">|</span> <span class="n">c1</span><span class="o">|</span> <span class="nb">int</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="n">c2</span><span class="o">|</span> <span class="n">string</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|#</span> <span class="n">Detailed</span> <span class="k">Table</span> <span class="n">Information</span><span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Database</span><span class="o">|</span> <span class="n">tempdb1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span><span class="o">|</span> <span class="n">v2</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span> <span class="n">Properties</span><span class="o">|</span><span class="p">[</span><span class="n">created</span><span class="p">.</span><span class="k">by</span><span class="p">.</span><span class="k">user</span><span class="o">=</span><span class="n">John</span><span class="p">,</span> <span class="n">created</span><span class="p">.</span><span class="nb">date</span><span class="o">=</span><span class="mi">01</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">2001</span><span class="p">,</span> <span class="p">....]</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+-----------------------------------------------------+-------+</span> |
| |
| <span class="c1">-- Remove the key `created.by.user` and `created.date` from `TBLPROPERTIES`</span> |
| <span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span> <span class="n">UNSET</span> <span class="n">TBLPROPERTIES</span> <span class="p">(</span><span class="s1">'created.by.user'</span><span class="p">,</span> <span class="s1">'created.date'</span><span class="p">);</span> |
| |
| <span class="c1">--Use `DESC TABLE EXTENDED tempdb1.v2` to verify the changes</span> |
| <span class="k">DESC</span> <span class="k">TABLE</span> <span class="n">EXTENDED</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">col_name</span><span class="o">|</span> <span class="n">data_type</span><span class="o">|</span><span class="k">comment</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| <span class="o">|</span> <span class="n">c1</span><span class="o">|</span> <span class="nb">int</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="n">c2</span><span class="o">|</span> <span class="n">string</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|#</span> <span class="n">Detailed</span> <span class="k">Table</span> <span class="n">Information</span><span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Database</span><span class="o">|</span> <span class="n">tempdb1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span><span class="o">|</span> <span class="n">v2</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span> <span class="n">Properties</span><span class="o">|</span> <span class="p">[....]</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+----------+-------+</span> |
| |
| <span class="c1">-- Change the view definition</span> |
| <span class="k">ALTER</span> <span class="k">VIEW</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span> <span class="k">AS</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v1</span><span class="p">;</span> |
| |
| <span class="c1">-- Use `DESC TABLE EXTENDED` to verify</span> |
| <span class="k">DESC</span> <span class="k">TABLE</span> <span class="n">EXTENDED</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v2</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">----------------------------+---------------------------+-------+</span> |
| <span class="o">|</span> <span class="n">col_name</span><span class="o">|</span> <span class="n">data_type</span><span class="o">|</span><span class="k">comment</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+---------------------------+-------+</span> |
| <span class="o">|</span> <span class="n">c1</span><span class="o">|</span> <span class="nb">int</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="n">c2</span><span class="o">|</span> <span class="n">string</span><span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|#</span> <span class="n">Detailed</span> <span class="k">Table</span> <span class="n">Information</span><span class="o">|</span> <span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Database</span><span class="o">|</span> <span class="n">tempdb1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Table</span><span class="o">|</span> <span class="n">v2</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">Type</span><span class="o">|</span> <span class="k">VIEW</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">View</span> <span class="nb">Text</span><span class="o">|</span> <span class="k">select</span> <span class="o">*</span> <span class="k">from</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">|</span> <span class="k">View</span> <span class="n">Original</span> <span class="nb">Text</span><span class="o">|</span> <span class="k">select</span> <span class="o">*</span> <span class="k">from</span> <span class="n">tempdb1</span><span class="p">.</span><span class="n">v1</span><span class="o">|</span> <span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+---------------------------+-------+</span> |
| </code></pre></div></div> |
| |
| <h3 id="related-statements">Related Statements</h3> |
| |
| <ul> |
| <li><a href="sql-ref-syntax-aux-describe-table.html">describe-table</a></li> |
| <li><a href="sql-ref-syntax-ddl-create-view.html">create-view</a></li> |
| <li><a href="sql-ref-syntax-ddl-drop-view.html">drop-view</a></li> |
| <li><a href="sql-ref-syntax-aux-show-views.html">show-views</a></li> |
| </ul> |
| |
| |
| </div> |
| |
| <!-- /container --> |
| </div> |
| |
| <script src="js/vendor/jquery-3.5.1.min.js"></script> |
| <script src="js/vendor/bootstrap.bundle.min.js"></script> |
| <script src="js/vendor/anchor.min.js"></script> |
| <script src="js/main.js"></script> |
| <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.js"></script> |
| <script type="text/javascript"> |
| // DocSearch is entirely free and automated. DocSearch is built in two parts: |
| // 1. a crawler which we run on our own infrastructure every 24 hours. It follows every link |
| // in your website and extract content from every page it traverses. It then pushes this |
| // content to an Algolia index. |
| // 2. a JavaScript snippet to be inserted in your website that will bind this Algolia index |
| // to your search input and display its results in a dropdown UI. If you want to find more |
| // details on how works DocSearch, check the docs of DocSearch. |
| docsearch({ |
| apiKey: 'd62f962a82bc9abb53471cb7b89da35e', |
| appId: 'RAI69RXRSK', |
| indexName: 'apache_spark', |
| inputSelector: '#docsearch-input', |
| enhancedSearchInput: true, |
| algoliaOptions: { |
| 'facetFilters': ["version:3.4.3"] |
| }, |
| debug: false // Set debug to true if you want to inspect the dropdown |
| }); |
| |
| </script> |
| |
| <!-- MathJax Section --> |
| <script type="text/x-mathjax-config"> |
| MathJax.Hub.Config({ |
| TeX: { equationNumbers: { autoNumber: "AMS" } } |
| }); |
| </script> |
| <script> |
| // Note that we load MathJax this way to work with local file (file://), HTTP and HTTPS. |
| // We could use "//cdn.mathjax...", but that won't support "file://". |
| (function(d, script) { |
| script = d.createElement('script'); |
| script.type = 'text/javascript'; |
| script.async = true; |
| script.onload = function(){ |
| MathJax.Hub.Config({ |
| tex2jax: { |
| inlineMath: [ ["$", "$"], ["\\\\(","\\\\)"] ], |
| displayMath: [ ["$$","$$"], ["\\[", "\\]"] ], |
| processEscapes: true, |
| skipTags: ['script', 'noscript', 'style', 'textarea', 'pre'] |
| } |
| }); |
| }; |
| script.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + |
| 'cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.1/MathJax.js' + |
| '?config=TeX-AMS-MML_HTMLorMML'; |
| d.getElementsByTagName('head')[0].appendChild(script); |
| }(document)); |
| </script> |
| </body> |
| </html> |