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?

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?
Create a column in MCQs table of ARRAY data type
Well Done. Your Answer is Correct Keep it Up!
Create a column in MCQs table of STRUCT data type
Create a column in MCQs table of MAP data type
As storing multiple values in a column of MCQs itself is a violation

Leave a Reply

Your email address will not be published. Required fields are marked *