www.HadoopExam.com

HadoopExam Learning Resources

CCD-410 Certifcation CCA-500 Hadoop Administrator Exam HBase Certifcation CCB-400 Data Science Certifcation Hadoop Training with Hands On Lab Hadoop Package Deal

Hive Query to share load over map and reducer

i have 3-files, say A,B,C with a common column in hdfs. Wrote Hadoop program to get results. Now, I'm trying to use Hive queries to get output on same files. I'm successful in getting the required o/p. But, failed to make use of reducer. Where as in Hadoop i did since, its java. How do i write a Hive query, in such a way that i could use reducer as well. Also, the time taken by Hive is comparatively more to Hadoop. But Hive is faster, from some reading i have done. Hive query i've executed isSELECT B.name, A.date, A.time, A.number, B.units FROM A JOIN B ON (A.id = B.id) WHERE A.person_id=142106;

Also, i would take opportunity to ask preferable link to understand hive concepts. Appreciate it.

You have no rights to post comments

You are here: Home Question & Answer Hadoop Questions Hive Query to share load over map and reducer