We need to store skill set of MCQs(which might have multiple values) in MCQs table, which of the following is the best way to store this information in case of Hive?

Question

TuteeHUB · Accepted Answer

As storing multiple values in a column of MCQs itself is a violation

TuteeHUB · Answer

Create a column in MCQs table of STRUCT data type

TuteeHUB · Answer

Create a column in MCQs table of MAP data type

TuteeHUB · Answer

Create a column in MCQs table of ARRAY data type

1.	We need to store skill set of MCQs(which might have multiple values) in MCQs table, which of the following is the best way to store this information in case of Hive?
A.	Create a column in MCQs table of STRUCT data type
B.	Create a column in MCQs table of MAP data type
C.	Create a column in MCQs table of ARRAY data type
D.	As storing multiple values in a column of MCQs itself is a violation
Answer» D. As storing multiple values in a column of MCQs itself is a violation

We need to store skill set of MCQs(which might have multiple values) in MCQs table, which of the following is the best way to store this information in case of Hive?

Discussion

No Comment Found

Related MCQs

Reply to Comment