[HIVE-15976] Support CURRENT_CATALOG and CURRENT_SCHEMA

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: SQL
• Assignee: László Bodor
• Reporter: Carter Shanklin
• Created: 20/Feb/17 05:48
• Updated: 17/Nov/22 08:55
• Resolved: 25/Jun/18 19:36

Description

Support these keywords for querying the current catalog and schema. SQL reference: section 6.4

oracle
CREATE TABLE CURRENT_SCHEMA (col VARCHAR2(1)); – ok
SELECT CURRENT_SCHEMA FROM DUAL; – error, ORA-00904: "CURRENT_SCHEMA": invalid identifier
SELECT CURRENT_SCHEMA() FROM DUAL; – error, ORA-00904: "CURRENT_SCHEMA": invalid identifier

postgres
CREATE TABLE CURRENT_SCHEMA (col VARCHAR(1)); – error: syntax error at or near "CURRENT_SCHEMA"
SELECT CURRENT_SCHEMA; – ok, "public"
SELECT CURRENT_SCHEMA(); – ok, "public"

mysql
CREATE TABLE CURRENT_SCHEMA (col VARCHAR(1)); – ok
SELECT CURRENT_SCHEMA; – error, Unknown column 'CURRENT_SCHEMA' in 'field list'
SELECT CURRENT_SCHEMA(); – error, FUNCTION db_9_e28e6f.CURRENT_SCHEMA does not exist

Issue Links

• is related to: HIVE-18685 Add catalogs to Hive