Optimization of Multiple Correlated Queries by Detecting Similar Data Source with Hive Warehouse Vijayarajeswari R.1, Kannan M.2 1Associate Professor Department of Computer Science Engineering, Mahendra Engineering College (Autonomous), Namakkal, Tamilnadu, India 2Professor, Department of Computer Science Engineering, Mahendra Engineering College (Autonomous), Namakkal, Tamilnadu, India Online published on 16 March, 2018. Abstract Produced solitary Hive Query (HiveQL) investigating the comparative kind of task and general information from two input questions which analyze the aggregate execution time of the both inquiries. Hadoop Hive with Optimization of Multiple Query (HHOMQ) is used in the paper; another single inquiry is produced from at least two input inquiries and sample of information created utilizing DBGEN which is free database generation device. tPC-Hive inquiries are executed by information and aggregate execution time of the questions is contrasted with the execution. Hive executes single inquiry at once; various questions are given to hive by changing over them into single question. the method outcomes in lessening of task while executing the question and it additionally decrease the execution time, enhance the execution of Hive. Hive process of the organized information of data distribution center framework utilizing the method, the organized information can be process and broke down in effortlessly in convenient way. Organized information utilized for handling oLAP (online Analytical Processing) inquiries and Hive additionally supports to process oLAP questions. Hive works in concurrence with Hadoop and it process or execute inquiry on information which is stored on Hadoop. Hadoop should be running on the framework to utilize Hive inquiry. It requires enormous measure of information for testing, for illustration, information is created utilizing gave by TPC (Transaction Performance Council), DBGEN which is free instrument for information generation. tPC give the diverse kinds of questions for testing the execution inquiry execution apparatus and examination tPC-Hive inquiries are used. Top Keywords Hive Query (HiveQL), Hadoop Hive with Optimization of Multiple Query (HHOMQ), Hadoop, OLAP (Online Analytical Processing), TPC (Transaction Performance Council), TPC-Hive inquiries, DBGEN. Top |