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

Select query on renamed hive acid table does not produce any output

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 4.0.0
    • Component/s: Hive

      Description

      During onRename, HMS update COMPLETED_TXN_COMPONENTS which fail with CTC_DATABASE column does not exist, upon investigation I found that enclosing quotes are missing for columns thats db query fail with this exception

      Steps to repro:
      1. create table test(id int);
      2. insert into table test values(1);
      3. alter table test rename to test1;
      3. select * from test1 produce no output

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Rajkumar Singh Rajkumar Singh
                Reporter:
                Rajkumar Singh Rajkumar Singh
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m