Select statement is just selecting the data(schema on read) from the HDFS it doesn't perform any map reduce job underneath.
But when you do insert statement it will trigger an Map only job with an application id, when ever an application id is created that means for those jobs we can view from TEZ view (or) from Resource Manager.
Insert a record into Table:-
I'm having a text_table with 5 columns in it.
I'm trying to insert a record into the table and an app id application_1508861912312_4126, so when i go to TEZ view (or) Resource Manager search for the applicationid and we can view the application, time taken to complete the application.
hive# insert into text_table values('2','2017-11-10','bar','09:00:00','2017-12-23 09:00:00.0');
INFO : Tez session hasn't been created yet. Opening session
INFO : Dag name: insert into text_table values...09:00:00.0')(Stage-1)
INFO : Status: Running (Executing on YARN cluster with App id application_1508861912312_4126)
INFO : Map 1: -/-
INFO : Map 1: 0/1
INFO : Map 1: 0(+1)/1
INFO : Map 1: 1/1
INFO : Loading data to table default.text_table from hdfs:/user/yashu/text_table/.hive-staging_hive_2017-12-23_12-31-19_205_322427679820504794-22055/-ext-10000
INFO : Table default.text_table stats: [numFiles=4, numRows=4, totalSize=184, rawDataSize=180]
No rows affected (11.679 seconds)
Select from Table:-
when we run select statement there is no application id got created and this job status we cannot view either from tez view (or) resource manager
If you want to compare the response time of select queries
1.By using Ambari Hive View won't display the execution time of the query.
Hive View Execution:-
Logs Tab Hive View:-
If you click on Logs tab also there is no logs for the query.
It is impossible compare the time taken for select query to execute, because for select queries there is no map reduce job is going to be initialized, if application id is not created then we cannot compare them programatically.
2.Another way to get at least the execution times for select query is running from hive from command line(not from ambari hive view)
Open Hive from command line and execute the select query.
Onceselect query finishes at bottom of the results hive shows how many rows has been selected with the response time will be displayed.