Initialize Metastore DB from backup.

fhueske · fhueske · commit 950ea8ad495e · 2020-04-17T23:38:39.000+02:00
diff --git a/metastore-image/Dockerfile b/metastore-image/Dockerfile
@@ -18,10 +18,6 @@
 
 FROM openjdk:8-jre
 
-#COPY ./archive/apache-hive-2.3.6-bin.tar.gz /opt
-#COPY ./archive/db-derby-10.10.2.0-bin.tar.gz /opt
-#COPY ./archive/hadoop-2.9.2.tar.gz /opt
-
 # Copy binary distributions from Apache servers/mirrors
 RUN cd /opt && \
     wget http://apache.lauf-forum.at/hadoop/common/hadoop-2.9.2/hadoop-2.9.2.tar.gz && \
@@ -43,6 +39,12 @@ RUN cd /opt && \
     cp /opt/db-derby-10.10.2.0-bin/lib/derbytools.jar /opt/apache-hive-2.3.6-bin/lib 
 
 COPY hive-conf/hive-site.xml /opt/apache-hive-2.3.6-bin/conf
+
+# Copy metastore_db backup file and restore it
+COPY ./metastore_db_backup.tar /
+RUN cd /; \
+    tar xf /metastore_db_backup.tar; \
+    rm /metastore_db_backup.tar;
     
 ENV HADOOP_HOME /opt/hadoop-2.9.2
 ENV DERBY_INSTALL /opt/db-derby-10.10.2.0-bin
diff --git a/metastore-image/docker-entrypoint.sh b/metastore-image/docker-entrypoint.sh
@@ -3,8 +3,8 @@
 # start Derby
 /opt/db-derby-10.10.2.0-bin/bin/startNetworkServer -h 0.0.0.0 &
 
-# create Metastore schema
-/opt/apache-hive-2.3.6-bin/bin/schematool -initSchema -dbType derby
+# create Metastore schema. Not needed because we restored a database backup
+# /opt/apache-hive-2.3.6-bin/bin/schematool -initSchema -dbType derby
 
 # start Metastore
 /opt/apache-hive-2.3.6-bin/bin/hive --service metastore -p 9083
diff --git a/metastore-image/metastore_db_backup.tar b/metastore-image/metastore_db_backup.tar
