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

Create Index failed in Multiple version of Hive running

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.0.0
    • Fix Version/s: None
    • Component/s: Indexing, Parser
    • Labels:
      None

      Description

      Create Index in either type COMPACT or BITMAP does not work on version 1.0 when I install it in the Quick Start CDH VM used to have Hive v0.13.0 running. The same query can run successfully in 0.13.0 and 0.14.0 alone

      CREATE INDEX idx_id_employee_id
      ON TABLE employee_id (employee_id)
      AS 'COMPACT'
      WITH DEFERRED REBUILD;
      
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table not found default__employee_id_idx_id_employee_id__
      

        Issue Links

          Activity

          Hide
          willddy Will Du added a comment -

          If this is a known issue for multiple version of installation, are you going to fix it? If not, you can close it.

          Show
          willddy Will Du added a comment - If this is a known issue for multiple version of installation, are you going to fix it? If not, you can close it.
          Hide
          damien.carol Damien Carol added a comment -

          Will Du Could we clsoe this issue ?

          Show
          damien.carol Damien Carol added a comment - Will Du Could we clsoe this issue ?
          Hide
          willddy Will Du added a comment -

          This issue is about the same thing I guess. https://issues.apache.org/jira/browse/HIVE-5902

          Show
          willddy Will Du added a comment - This issue is about the same thing I guess. https://issues.apache.org/jira/browse/HIVE-5902
          Hide
          willddy Will Du added a comment -

          I do a refresh installation of Hive v1.0 and Hadoop 1.2 today. There is no such issues. In this case, I think the issue is because of the environment I used previously.

          The issues happens when I have multiple version of Hive running in the same clusters (v1.0 and v.0.13.0). Troubleshooting can start from this step.

          Show
          willddy Will Du added a comment - I do a refresh installation of Hive v1.0 and Hadoop 1.2 today. There is no such issues. In this case, I think the issue is because of the environment I used previously. The issues happens when I have multiple version of Hive running in the same clusters (v1.0 and v.0.13.0). Troubleshooting can start from this step.
          Hide
          willddy Will Du added a comment -

          sorry, I have no way to do that. But, this is very easy to reproduce in Hive 1.0

          Show
          willddy Will Du added a comment - sorry, I have no way to do that. But, this is very easy to reproduce in Hive 1.0
          Hide
          damien.carol Damien Carol added a comment -

          Will Du Could you provide the stack trace?

          Show
          damien.carol Damien Carol added a comment - Will Du Could you provide the stack trace?

            People

            • Assignee:
              Unassigned
              Reporter:
              willddy Will Du
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Development