[
https://issues.apache.org/jira/browse/TRAFODION-2550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15986846#comment-15986846
]
ASF GitHub Bot commented on TRAFODION-2550:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1073#discussion_r113730462
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc ---
@@ -48,6 +49,326 @@ to connect to and issue SQL utilities, see the
{docs-url}/client_installation/index.html[_{project-name} Client
Installation Guide_].
<<<
+[[cleanup_statement]]
+== CLEANUP Statement
+
+The CLEANUP Statement cleans up objects whose information is inconsistent
in the metadata. This command can be used to clean up individual objects or all
objects in a schema. This command can also be used to locate all inconsistent
objects in the Trafodion metadata and then clean them up.
+
+Inconsistent objects can be cleaned up and removed from the metadata and
HBase by using one of the following options.
+
+```
+CLEANUP {obj-type} {obj-name} [ ,UID {object-uid} ]
--- End diff --
Reading parser/sqlparser.y, it looks like [ , RETURN DETAILS ] is supported
for CLEANUP obj-type obj-name as well but oddly not when [ , UID object-uid ]
is present. So perhaps modify this to CLEANUP obj-type obj-name [ , UID
object-uid | , RETURN DETAILS ] ?
> update sql reference manual about metadata clean up command
> -----------------------------------------------------------
>
> Key: TRAFODION-2550
> URL: https://issues.apache.org/jira/browse/TRAFODION-2550
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: liu ming
> Assignee: Liu Yu
>
> please refer to
> https://cwiki.apache.org/confluence/display/TRAFODION/Metadata+Cleanup
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
