what is the expectation in HPDCP

[#1]

what is the expectation in actual exam as far as Hive queries are concerned.

Do they need to be just executed or saved as well

[#2]

IIRC what's required is to have a correct requested output in a right place in HDFS. So you don't need to save it. However, you will save a lot of time if you save your Hive code in a script so that you can easily re-run it if needed. Good luck!

[#3 · Accepted solution]

@Hemant Javeri - you must follow the task instructions as stated in the exam. The instructions will clearly state the filename that you are supposed to save your query or code in. For example, task #3 might tell you to save your Hive query in a text file named /home/horton/solutions/task3 on the local filesystem.

We do not care how you write or execute the script - you can use the Hive shell, Hive View in Ambari, write the query in a text editor using vi or gedit, etc. But you must run the script, it must generate the desired output, and you must save the query or code in the specified text file.