README 621 B

123456789101112131415161718
  1. 1) Shutdown your metastore instance.
  2. 2) Perform a backup of your Derby metastore database. Probably
  3. the easiest way of doing this is to just create a copy of the
  4. Derby database "metastore_db" directory.
  5. 3) Execute the Hive 0.6 and Hive 0.7 upgrade scripts:
  6. % ij
  7. ij version 10.4
  8. ij> CONNECT 'jdbc:derby:/Users/bob/hive/metastore_db;databaseName=metastore_db';
  9. ij> RUN 'upgrade-0.6.0.derby.sql';
  10. ij> RUN 'upgrade-0.7.0.derby.sql';
  11. ij> quit;
  12. NOTE: You may need to install the Derby 'ij' utility.
  13. Look here for installation instructions:
  14. http://db.apache.org/derby/docs/10.4/getstart/