• Ramandeep Kaur

Today the industry and companies are analyzing petabytes of data every day , But the data is still growing and analysis with the help of traditional RDBMS solutions becomes expensive and time taking. Hadoop is a popular solution for handing large amount of data which store huge amount of data on a cluster of commodity hardware machines and process these data by using mapreduce which process the data paralley. But HAdoop mapreduce support java programming language and for data analyst its very time taking taking process to write large program for process the data. In these paper we proposed a hive(SQL on Hadoop) which is a analytical tools and runs on top of the hadoop. In these we porposed various file format such as textfile, sequence file, RC(Record Columnar) and ORC (Optimized Record Columnar) files through which we can enhance the performance of SQL on Hadoop system.

Hadoop, hive, file format, textfile, sequence file, RC file, ORC file, performance optimization, SQL-on-Hadoop

"ENHANCE PERFORMANCE OF SQL-ON-HADOOP SYSTEM BY USING VARIOUS FILE FORMATS", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.6, Issue 1, page no.386-391, January-2019, Available :http://www.jetir.org/papers/JETIR1901047.pdf

"ENHANCE PERFORMANCE OF SQL-ON-HADOOP SYSTEM BY USING VARIOUS FILE FORMATS", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.6, Issue 1, page no. pp386-391, January-2019, Available at : http://www.jetir.org/papers/JETIR1901047.pdf