Big Data Hive Online Assessment Test

Assume bill table as given below:



What will the output return with the following query?
SELECT product, sum(price) FROM bill GROUP BY product

Assume bill table as given below:



What will the output be return with the following query?
SELECT * FROM bill WHERE price > 1000 and quantity > 1;

Which statement is correct with the code snippet below?

   Job maxRunlength = triggerMaxDuration(hdfsConf, args);
              Job removeDuplicateJob = triggerRemoveDuplicateJob(hdfsConf, args);
              while (!removeDuplicateJob.isComplete() || !maxRunlength.isComplete()) {
                     System.out.println("Wait");
                     Thread.sleep(1000);
              }
              if(maxRunlength.isSuccessful()){
                     System.out.println("Max duration job completed successfully!");
              }
              else{
                     System.out.println("Max duration job failed!");
              }
              if (removeDuplicateJob.isSuccessful()) {
                     System.out.println("remove Duplication job completed successfully!");
                     Job jobFilter = triggerRecordFilter(hdfsConf, args);
                     while (!jobFilter.isComplete()){
                           System.out.println("Wait Filter!");
                           Thread.sleep(1000);
                     }
                     if(jobFilter.isSuccessful()){
                           System.out.println("Fillter job completed successfully!");
                           Job jobJoinAllData = triggerJoinAllData(hdfsConf, args);
                           while(!jobJoinAllData.isComplete()){
                                  System.out.println("Wait Join!");
                                  Thread.sleep(1000);
                           }
                           if(jobJoinAllData.isSuccessful()){
                                  System.out.println("Join data job completed successfully!");
                           }
                           else{
                                  System.out.println("Join data job failed!");
                           }
                     }
                     else{
                           System.out.println("Max duration job failed!");
                     }
              }
              else {
                     System.out.println("removeDuplicateJob failed!");
              }

Note: There can be multiple correct answers to this question.