Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4144

Add "select database()" command to show the current database

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • SQL
    • None

    Description

      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:

      select database();
      

      http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database

      We should look into having something similar in Hive.

      Attachments

        1. HIVE-4144.D9597.4.patch
          29 kB
          Phabricator
        2. HIVE-4144.D9597.3.patch
          30 kB
          Phabricator
        3. HIVE-4144.D9597.2.patch
          30 kB
          Phabricator
        4. HIVE-4144.D9597.1.patch
          12 kB
          Phabricator
        5. HIVE-4144.9.patch.txt
          35 kB
          Navis Ryu
        6. HIVE-4144.8.patch.txt
          34 kB
          Navis Ryu
        7. HIVE-4144.7.patch.txt
          33 kB
          Navis Ryu
        8. HIVE-4144.6.patch.txt
          30 kB
          Navis Ryu
        9. HIVE-4144.14.patch.txt
          41 kB
          Navis Ryu
        10. HIVE-4144.13.patch.txt
          37 kB
          Navis Ryu
        11. HIVE-4144.12.patch.txt
          37 kB
          Navis Ryu
        12. HIVE-4144.11.patch.txt
          35 kB
          Navis Ryu
        13. HIVE-4144.10.patch.txt
          34 kB
          Navis Ryu
        14. D9597.5.patch
          29 kB
          Phabricator

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            navis Navis Ryu Assign to me
            mgrover Mark Grover
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment