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

add test case for use of index from not-current database

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.14.0
    • Indexing
    • None

    Description

      In hive 0.13, the following sequence fails -

      create database index_test_db;
      
      use index_test_db;
      create table testtb (id int, name string);
      create index id_index on table testtb (id) as 'COMPACT' WITH DEFERRED REBUILD  in table testdb_id_idx_tb;
      
      use default;
      select * from index_test_db.testtb where id>2;
      -- fails here with error "Table not found testdb_id_idx_tb" 
      

      HIVE-4064 fixed the problem. It will be useful to have a test case that verifies the fix.

      Attachments

        1. HIVE-8475-0.13.1.patch
          5 kB
          Thejas Nair
        2. HIVE-8475.1.patch
          3 kB
          Thejas Nair

        Issue Links

          Activity

            thejas Thejas Nair added a comment - - edited

            HIVE-8475-0.13.1.patch - patch for anyone interested in backporting the relevant portion of fix to 0.13 branch. (not for commit)

            thejas Thejas Nair added a comment - - edited HIVE-8475 -0.13.1.patch - patch for anyone interested in backporting the relevant portion of fix to 0.13 branch. (not for commit)
            thejas Thejas Nair added a comment -

            HIVE-8475.1.patch - patch with just test case for trunk

            thejas Thejas Nair added a comment - HIVE-8475 .1.patch - patch with just test case for trunk
            thejas Thejas Nair added a comment -

            Verified manually that the test passed. I don't think we need to run this patch through the whole test suite, specially with the backlog we have right now.

            thejas Thejas Nair added a comment - Verified manually that the test passed. I don't think we need to run this patch through the whole test suite, specially with the backlog we have right now.

            +1

            vgumashta Vaibhav Gumashta added a comment - +1
            thejas Thejas Nair added a comment -

            vikram.dixit It will be useful to add this test case in 0.14 as well, to make sure there is no regression.

            thejas Thejas Nair added a comment - vikram.dixit It will be useful to add this test case in 0.14 as well, to make sure there is no regression.
            thejas Thejas Nair added a comment -

            Patch committed to 0.14 branch and trunk.
            Thanks for the review Vaibhav!

            thejas Thejas Nair added a comment - Patch committed to 0.14 branch and trunk. Thanks for the review Vaibhav!
            thejas Thejas Nair added a comment -

            This has been fixed in 0.14 release. Please open new jira if you see any issues.

            thejas Thejas Nair added a comment - This has been fixed in 0.14 release. Please open new jira if you see any issues.

            People

              thejas Thejas Nair
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: