[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13700265#comment-13700265 ]
Edward Capriolo commented on HIVE-4144: --------------------------------------- Navis. This is cool. I will review this soon. I did notice that there is already a Dummy input format like yours that was added to hive a while back. I think it was added to support queries only on meta-data. In any case we probably do not need two dummy Input formats in the project. > 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: HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.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=uauh2va...@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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira