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

Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: Metastore
    • Labels:
      None
    • Environment:

      hadoop 1.2.1

      hive 0.12.0

      Description

      Hi,

      I am facing this situation for the below mentioned hql file -

      > Hive MySQL Metastore is used for table t1

      > Hive MySQL Metastore is not used for table t2 (derby.log is created in the directory)

      ----------

      – database pp_test_hive_metastore

      drop database if exists pp_test_hive_metastore cascade;

      create database pp_test_hive_metastore;

      use pp_test_hive_metastore;

      – table t1

      create table t1 ( id int, name string );

      LOAD DATA LOCAL INPATH 'testHiveMetastore.txt' OVERWRITE INTO TABLE t1;

      select * from t1;

      select count from t1;

      – table t2

      create table t2 ( id int, name string );

      INSERT OVERWRITE TABLE t2 SELECT t.* FROM t1 t;

      select * from t2;

      select count from t2;

      – done

      quit;

      ---------------

      Testing Procedure : Comment/Uncomment the lines for table t2

        Attachments

        1. th.zip
          2 kB
          Naga Vijay

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nagahive Naga Vijay
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: