Hive
What is Hive ? Hive is a data warehouse tool to analyze structured data in Hadoop. It was developed by Facebook. It resides on top of Hadoop and used to abstract Data, and makes querying and analyzing easy. It is a platform used to develop SQL type scripts to do MapReduce operations. Note - It helps in reading and writing data in Hadoop and process it without writing complex java programs. . Features : It is OLAP (Online Analytical Processing). It is fast, scalable and familiar. It is similar to SQL language for querying called HQL (Hive Query Language). It supports Data Manipulation Language and Data definition Language. It works on server-side of HDFS cluster. There are two types of tables in hive : Internal Table and External table Note: Default location is /user/hive/warehouse. Internal Table (Managed table ) : In Internal Table, Both the table schema and table data are managed by hive. The data will be located in a folder named after the table ...