@Mohammed Syam 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. Once select query finishes at bottom of the results hive shows how many rows has been selected with the response time will be displayed. Example:- hive# select * from text_table; +----------------+----------------+------------------+----------------+------------------------+--+ | text_table.id | text_table.dt | text_table.name | text_table.ts | text_table.dtts | +----------------+----------------+------------------+----------------+------------------------+--+ | 1 | 2017-10-10 | hcc | 12:00:00 | 2017-10-10 12:00:00.0 | | 1 | 2017-10-11 | foo | 12:00:00 | 2017-10-11 12:00:00.0 | | 1 | 2017-10-12 | foo | 12:00:00 | 2017-10-12 12:00:00.0 | | 2 | 2017-11-10 | bar | 09:00:00 | 2017-12-23 09:00:00.0 | +----------------+----------------+------------------+----------------+------------------------+--+ 4 rows selected (0.105 seconds) Scroll down to the last line in the above snippet and you can view that 4 rows and execution time is 0.105 seconds. If you are running from Hive from command line hive displays how many rows are displayed and what is the execution time for the query as a last line in results. If you are using Ambari Hive View won't display these stats also. Only way to compare results of select query is Execute your select from Hive command lines and compare them manually. ... View more

Hi @Shu I am trying to create the directory with current time stamp in hdfs and as above I tried but did not work since it doesnt have extract_date what should I use to get the desire output ? Right now my flow is : ListHDFS -----> Updateattribute ----->PutHDFS. any suggestions please ? ... View more

@Shu : There was a culprit record ending up with new line. Thanks for assisting. escapeJson() is working perfect now. thanks. ... View more

@Shu that did the trick! Many thanks for your help and your patience as well. ... View more

Thank you very much for your help, I didn't consider the expression support. ... View more

@balalaika For that case you need to specify Demarcator property as Shift+enter Configs:- For merge content reference https://community.hortonworks.com/questions/149047/nifi-how-to-handle-with-mergecontent-processor.html ... View more

@Ranith Ranawaka After Attributes to Json processor use Replace Text processor with Search Value "clientid"\s+:\s+"(.*)" Replacement Value "clientid" : $1 Replacement Strategy Regex Replace Evaluation Mode Entire text Configs:- Input:- { "clientid" : "2", "id":"1", "name":"HCC" } Output:- { "clientid" : 2, "id":"1", "name":"HCC" } So we are searching for the value of client id and replacing the value without quotes by using replace text processor. ... View more