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

ability to select across a database

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be able to select across a database for this feature to be useful.

      For eg:

      use db1
      create table foo(....);

      use db2
      select .. from db1.foo.....

        Attachments

        1. HIVE-1517.9.patch
          4.82 MB
          Siying Dong
        2. HIVE-1517.8.patch
          4.82 MB
          Siying Dong
        3. HIVE-1517.7.patch
          2 kB
          Siying Dong
        4. HIVE-1517.6.patch
          4.24 MB
          Siying Dong
        5. HIVE-1517.5.patch
          4.18 MB
          Siying Dong
        6. HIVE-1517.4.patch
          4.18 MB
          Siying Dong
        7. HIVE-1517.3.patch
          1.97 MB
          Siying Dong
        8. HIVE-1517.2.patch.txt
          50 kB
          Carl Steinbach
        9. HIVE-1517.11.patch
          4.85 MB
          Siying Dong
        10. HIVE-1517.10.patch
          4.82 MB
          Siying Dong
        11. HIVE-1517.1.patch.txt
          4 kB
          Carl Steinbach

          Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. HIVE-849 <database_name>.<table_name>.<column_name> not supported

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-1977 DESCRIBE TABLE syntax doesn't support specifying a database qualified table name

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-2228 Can't use DB qualified column names in WHERE or GROUP BY clauses

          • Major - Major loss of function.
          • Open
          requires

          New Feature - A new feature of the product, which has yet to be developed. HIVE-675 Add Database/Schema support to Hive QL

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                sdong Siying Dong
                Reporter:
                namit Namit Jain
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: