You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (JIRA)" <ji...@apache.org> on 2013/10/21 09:42:43 UTC

[jira] [Updated] (HIVE-4144) Add "select database()" command to show the current database

     [ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phabricator updated HIVE-4144:
------------------------------

    Attachment: D9597.5.patch

navis updated the revision "HIVE-4144 [jira] Add "select database()" command to show the current database".

  Rebased to trunk

Reviewers: JIRA

REVISION DETAIL
  https://reviews.facebook.net/D9597

CHANGE SINCE LAST DIFF
  https://reviews.facebook.net/D9597?vs=38637&id=42015#toc

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/mr/ExecDriver.java
  ql/src/java/org/apache/hadoop/hive/ql/io/NullRowsInputFormat.java
  ql/src/java/org/apache/hadoop/hive/ql/io/OneNullRowInputFormat.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/udf/generic/UDFCurrentDB.java
  ql/src/test/queries/clientpositive/select_dummy_source.q
  ql/src/test/queries/clientpositive/udf_current_database.q
  ql/src/test/results/clientpositive/select_dummy_source.q.out
  ql/src/test/results/clientpositive/show_functions.q.out
  ql/src/test/results/clientpositive/udf_current_database.q.out

To: JIRA, navis


> Add "select database()" command to show the current database
> ------------------------------------------------------------
>
>                 Key: HIVE-4144
>                 URL: https://issues.apache.org/jira/browse/HIVE-4144
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Mark Grover
>            Assignee: Navis
>         Attachments: D9597.5.patch, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch
>
>
> A recent hive-user mailing list conversation asked about having a command to show the current database.
> http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauH2vAHng@mail.gmail.com%3E
> MySQL seems to have a command to do so:
> {code}
> select database();
> {code}
> http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database
> We should look into having something similar in Hive.



--
This message was sent by Atlassian JIRA
(v6.1#6144)