Hive
  1. Hive
  2. HIVE-4144

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

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: SQL
    • Labels:

      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.

      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

          Lefty Leverenz made changes -
          Labels TODOC13
          Navis made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Fix Version/s 0.13.0 [ 12324986 ]
          Resolution Fixed [ 1 ]
          Navis made changes -
          Attachment HIVE-4144.14.patch.txt [ 12627053 ]
          Navis made changes -
          Attachment HIVE-4144.13.patch.txt [ 12626617 ]
          Navis made changes -
          Attachment HIVE-4144.12.patch.txt [ 12626585 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.11.patch.txt [ 12623280 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Remote Link This issue links to "review board (Web Link)" [ 13705 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.10.patch.txt [ 12623069 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.9.patch.txt [ 12613280 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.8.patch.txt [ 12613105 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.7.patch.txt [ 12613025 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-4144.6.patch.txt [ 12611006 ]
          Navis made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Link This issue is duplicated by HIVE-178 [ HIVE-178 ]
          Phabricator made changes -
          Attachment D9597.5.patch [ 12609375 ]
          Phabricator made changes -
          Attachment HIVE-4144.D9597.4.patch [ 12599391 ]
          Phabricator made changes -
          Attachment HIVE-4144.D9597.3.patch [ 12592132 ]
          Navis made changes -
          Link This issue is related to HIVE-1558 [ HIVE-1558 ]
          Phabricator made changes -
          Attachment HIVE-4144.D9597.2.patch [ 12574942 ]
          Phabricator made changes -
          Attachment HIVE-4144.D9597.1.patch [ 12574747 ]
          Navis made changes -
          Field Original Value New Value
          Status Open [ 1 ] Patch Available [ 10002 ]
          Assignee Navis [ navis ]
          Mark Grover created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development