[
https://issues.apache.org/jira/browse/HIVE-15976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laszlo Bodor updated HIVE-15976:
--------------------------------
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
was:Support these keywords for querying the current catalog and schema. SQL
reference: section 6.4
> Support CURRENT_CATALOG and CURRENT_SCHEMA
> ------------------------------------------
>
> Key: HIVE-15976
> URL: https://issues.apache.org/jira/browse/HIVE-15976
> Project: Hive
> Issue Type: Sub-task
> Components: SQL
> Reporter: Carter Shanklin
> Assignee: Laszlo Bodor
> Priority: Major
> Attachments: HIVE-15976.01.patch, HIVE-15976.02.patch,
> HIVE-15976.03.patch
>
>
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
