Re: Getting Slow Query Performance!

2013-03-12 Thread bejoy_ks
queries that ulilize indexing would be faster in sql server than in hive. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Gobinda Paul Date: Tue, 12 Mar 2013 15:09:31 To: user@hive.apache.org Reply-To: user@hive.apache.org Subject: Getting Slow

Re: Getting Slow Query Performance!

2013-03-12 Thread bejoy_ks
ulilize indexing would be faster in sql server than in hive. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Gobinda Paul Date: Tue, 12 Mar 2013 15:09:31 To: user@hive.apache.org Reply-To: user@hive.apache.org Subject: Getting Slow Query Performance

RE: Getting Slow Query Performance!

2013-03-12 Thread Bennie Schut
nnie. From: Gobinda Paul [mailto:gobi...@live.com] Sent: Tuesday, March 12, 2013 11:01 AM To: user@hive.apache.org Subject: RE: Getting Slow Query Performance! Thnx for your reply , i am new to hadoop and hive .My goal is to process a big data using hadoop, this is my university project ( Data Mi

RE: Getting Slow Query Performance!

2013-03-12 Thread Gobinda Paul
many node is required to show the performance and what type of configuration is required for each node. From: bsc...@ebuddy.com To: user@hive.apache.org CC: gobi...@live.com Date: Tue, 12 Mar 2013 10:40:33 +0100 Subject: RE: Getting Slow Query Performance! Generally a single hadoop machine

RE: Getting Slow Query Performance!

2013-03-12 Thread Bennie Schut
fter tweaking the configs. From: Gobinda Paul [mailto:gobi...@live.com] Sent: Tuesday, March 12, 2013 10:10 AM To: user@hive.apache.org Subject: Getting Slow Query Performance! i use sqoop to import 30GB data ( two table employee(aprox 21 GB) and salary(aprox 9GB ) into hadoop(Single Node) via hi

Getting Slow Query Performance!

2013-03-12 Thread Gobinda Paul
i use sqoop to import 30GB data ( two table employee(aprox 21 GB) and salary(aprox 9GB ) into hadoop(Single Node) via hive. i run a sample query like SELECT EMPLOYEE.ID,EMPLOYEE.NAME,EMPLOYEE.DEPT,SALARY.AMOUNT FROM EMPLOYEE JOIN SALARY WHERE EMPLOYEE.ID=SALARY.EMPLOYEE_ID AND SALARY.AMOUN