Datadopt

Hive is a SQL Database which uses various servers like thrift, Derby, MySQL to maintain the metastore. Here in this setup MySQL server is configured as a base to maintain the metastore of Hive. SSH : -------  - ssh-keygen -t rsa -P ""  - cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys  - # ssh-add -l # Not Working the run the command  - ssh localhost   Needed Software’s - Java ,Hadoop,MySql Server Before Installing Hive you make sure all the dependent Software's are correctly Installed .If it is not Installed then you can Refer my Previous Blog to Install them. After Successfully Installing the Softwares correctly!!!! Download Hive from below Repository: https://archive.apache.org/dist/hive The following steps are required for installing Hive on your PC. Let us assume the Hive archive is downloaded onto the /Downloads directory . Here, we download Hive archive named “ ap ache-hive-2.3.0-bin.tar.gz ". Th...

MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database. Below Steps are provided for  installing MySQL 5.7.23 version on RHEL/CentOS 7/6/5 and Fedora 23/22/21 using MySQL Yum repository via YUM utility. Step 1: Adding the MySQL Yum Repository  We will use official MySQL Yum software repository, which will provides RPM packages for installing the latest version of MySQL  server, client, MySQL Utilities, MySQL Workbench, Connector/ODBC, and Connector/Python for the RHEL/CentOS 7/6/5 and Fedora 23-21. Now download and add the following MySQL Yum repository to your respective Linux distribution system’s repository list to install the latest version of MySQL.             ---------------------------------- On RHEL/CentOS 7 ---------------------------------...

If you’re wondering how to scale Apache Hive, here are the best ways to make the most of Hive performance. 1. Partitioning Tables :                                      Hive partitioning is an effective method to improve the query performance on larger tables. 2 . Compress map/reduce output : By enabling compression at various Levels we can achieve the performance improvement in Hive Queries.                                                     Inside Hive-site.xml Add these Properties               <property>                   <name> mapred.compress.map.output </name>                   < ...