Hive SQL

dasmrin
Posts: 3
Joined: Thu Dec 17, 2015 7:10 am

Hive SQL

Postby dasmrin » Wed Jan 06, 2016 12:02 pm

Hi,

For all hive queries, mapreduce jobs are not showing in the screen. Please explain

Thanks,
Mrinmoy

Tags:

edupristine
Finance Junkie
Posts: 722
Joined: Wed Apr 09, 2014 6:28 am

Re: Hive SQL

Postby edupristine » Tue Apr 05, 2016 7:17 am

Hi Dasmrin

The queries which doesn’t need data filtering or processing will not trigger mapreduce job.
Eg:
Show tables;
select * from table;
describe table;
If we use show tables, it is just listing the table names stored in the metadata, this will not trigger MR job.
If we use select * from table, it is just listing the contents of the entire file, it is just like Hadoop cat command. This doesn’t need a processing. So this also will not trigger MR job.
Commands like Describe command, drop command etc will not trigger MR job because this also doesn’t need any data processing.


Return to “Big Data & Hadoop”



cron

Disclaimer

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.