Enter the HiveQL script below into Hive console window and click SUBMIT button. Make sure that you have created the sampletable ...