This issue is resolved after exporting the HIVE home directory:- export HIVE_CONF_DIR=/etc/hive/2.4.2.0-258/0/conf After exporting the directory i got following output Initializing HiveMetaTool.. 16/09/01 06:53:54 INFO metastore.ObjectStore: ObjectStore, initialize called 16/09/01 06:53:54 INFO DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored 16/09/01 06:53:54 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 16/09/01 06:53:55 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order" 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Query: Reading in results for query "org.datanucleus.store.rdbms.query.SQLQuery@0" since the connection used is closing 16/09/01 06:53:56 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL 16/09/01 06:53:56 INFO metastore.ObjectStore: Initialized ObjectStore Listing FS Roots.. hdfs://hdptest/db_new.db hdfs://hdptest/db_new1.db hdfs://hdptest/demo_database.db And for second command output is :- /usr/hdp/2.4.2.0-258/hive/bin/schematool -dbType mysql -info WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:mysql://hdp-test/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive Hive distribution version: 1.2.1000 Metastore schema version: 1.2.1000 schemaTool completed ... View more

The best summary of the backup status and what is coming in HDP-2.5 is here: https://hortonworks.com/blog/coming-hdp-2-5-incremental-backup-restore-apache-hbase-apache-phoenix/ ... View more

Foowloing are the changes in cent os 7 :- New initialization system, systemd. New firewall control, firewalld. This adds a more dynamic and flexible way to control the firewall module in the kernel, which is still netfilter. New bootloader. GRUB2 adds rich scripting support as well as support for the new hardware options offered on modern mainboards. New default filesystem, XFS. XFS adds support for larger single filesystems, faster format times (0 seconds), integrated snapshots, and live filesystem dumps for backup without first unmounting. GNOME 3 – This only really applies to those who use RHEL/CentOS in the desktop, like me. As with any other distro, you aren’t locked into GNOME 3. I personally like it, but KDE is readily available and others can be found on EPEL. If you are used to previous versions you may want to stick with 6. 7 has a lot of command changes And in our env we are using Cent OS 7. Still Didn't face issue with performance etc.. ... View more