hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laszlo Bodor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15976) Support CURRENT_CATALOG and CURRENT_SCHEMA
Date Wed, 13 Jun 2018 08:26:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16510777#comment-16510777
] 

Laszlo Bodor commented on HIVE-15976:
-------------------------------------

testClientTimeout failure is unrelated, uploading 05.patch to trigger a new test

> 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, HIVE-15976.04.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)

Mime
View raw message