[
https://issues.apache.org/jira/browse/HIVE-26227?focusedWorklogId=773358&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-773358
]
ASF GitHub Bot logged work on HIVE-26227:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 23/May/22 08:48
Start Date: 23/May/22 08:48
Worklog Time Spent: 10m
Work Description: pvary commented on code in PR #3288:
URL: https://github.com/apache/hive/pull/3288#discussion_r879182487
##########
ql/src/test/queries/clientpositive/perf/cbo_query49.q:
##########
@@ -45,10 +45,10 @@ select
union
select
'catalog' as channel
- ,catalog.item
- ,catalog.return_ratio
- ,catalog.return_rank
- ,catalog.currency_rank
+ ,`catalog`.item
Review Comment:
This is a backward incompatible change. Could we make the `catalog` a
non-reserved keyword?
Issue Time Tracking
-------------------
Worklog Id: (was: 773358)
Time Spent: 40m (was: 0.5h)
> 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: 40m
> 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.7#820007)
