[jira] [Work logged] (HIVE-26227) Add support of catalog related statements for Hive ql

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26227?focusedWorklogId=809823&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-809823 ]

ASF GitHub Bot logged work on HIVE-26227:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 18/Sep/22 00:26
            Start Date: 18/Sep/22 00:26
    Worklog Time Spent: 10m 
      Work Description: github-actions[bot] commented on PR #3288:
URL: https://github.com/apache/hive/pull/3288#issuecomment-1250162086

   This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
   Feel free to reach out on the dev@hive.apache.org list if the patch is in need of reviews.




Issue Time Tracking
-------------------

    Worklog Id:     (was: 809823)
    Time Spent: 1h  (was: 50m)

> Add support of catalog related statements for Hive ql
> -----------------------------------------------------
>
>                 Key: HIVE-26227
>                 URL: https://issues.apache.org/jira/browse/HIVE-26227
>             Project: Hive
>          Issue Type: Task
>          Components: Hive
>            Reporter: Wechar
>            Assignee: Wechar
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 4.0.0-alpha-2
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> Catalog concept is proposed to Hive 3.0 to allow different systems to connect to different catalogs in the metastore. But so far we can not query catalog through Hive ql, this task aims to implement the ddl statements related to catalog.
> *Create Catalog*
> {code:sql}
> CREATE CATALOG [IF NOT EXISTS] catalog_name
> LOCATION hdfs_path
> [COMMENT catalog_comment];
> {code}
> LOCATION is required for creating a new catalog now.
> *Alter Catalog*
> {code:sql}
> ALTER CATALOG catalog_name SET LOCATION hdfs_path;
> {code}
> Only location metadata can be altered for catalog.
> *Drop Catalog*
> {code:sql}
> DROP CATALOG [IF EXISTS] catalog_name;
> {code}
> DROP CATALOG is always RESTRICT, which means DROP CATALOG will fail if there are non-default databases in the catalog.
> *Show Catalogs*
> {code:sql}
> SHOW CATALOGS [LIKE 'identifier_with_wildcards'];
> {code}
> SHOW CATALOGS lists all of the catalogs defined in the metastore.
> The optional LIKE clause allows the list of catalogs to be filtered using a regular expression.
> *Describe Catalog*
> {code:sql}
> DESC[RIBE] CATALOG [EXTENDED] cat_name;
> {code}
> DESCRIBE CATALOG shows the name of the catalog, its comment (if one has been set), and its root location on the filesystem.
> EXTENDED also shows the create time.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)