Answer to Question #297830 in Databases | SQL | Oracle | MS Access for Talha

Question

Consider the following MYSQL table named “Students”. 

stu_id class Rep Study_Group Gender

001 12 Muhammad Ali Science Male

002 11 Arham Arts Male

003 12 Maham Science Female

004 12 Maira Arts Female

005 11 Abdullah Science Male

• Write a HiveQL statement (query) that will create a database named “CS441” and a table in Hive named as “Students” having the same fields as mentioned in the “Students” table. Fields should be terminated by ‘\t’ and lines (rows) should be terminated by ‘\n’. 

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order