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

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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: SQL
    • Labels:
      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.1.patch
          12 kB
          Phabricator
        2. HIVE-4144.D9597.2.patch
          30 kB
          Phabricator
        3. HIVE-4144.D9597.3.patch
          30 kB
          Phabricator
        4. HIVE-4144.D9597.4.patch
          29 kB
          Phabricator
        5. D9597.5.patch
          29 kB
          Phabricator
        6. HIVE-4144.6.patch.txt
          30 kB
          Navis
        7. HIVE-4144.7.patch.txt
          33 kB
          Navis
        8. HIVE-4144.8.patch.txt
          34 kB
          Navis
        9. HIVE-4144.9.patch.txt
          35 kB
          Navis
        10. HIVE-4144.10.patch.txt
          34 kB
          Navis
        11. HIVE-4144.11.patch.txt
          35 kB
          Navis
        12. HIVE-4144.12.patch.txt
          37 kB
          Navis
        13. HIVE-4144.13.patch.txt
          37 kB
          Navis
        14. HIVE-4144.14.patch.txt
          41 kB
          Navis

          Issue Links

            Activity

              People

              • Assignee:
                navis Navis
                Reporter:
                mgrover Mark Grover
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: