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 Bug
    • Status: Resolved
    • Priority: Major 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

      1. th.zip
        2 kB
        Naga Vijay

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development