title: Select all columns of a Hive Struct
body: <p>I have a requirement to select * from all columns from a hive struct. </p>
  
  <p>Hive create table script is here below</p>
  
  <p><a href="https://i.stack.imgur.com/6wjtS.jpg" rel="noreferrer">Create Table script</a></p>
  
  <p>Select * from the table displays each struct as a column
  <a href="https://i.stack.imgur.com/X4xNZ.jpg" rel="noreferrer">select * from table</a></p>
  
  <p>The requirement i have is to display all fields of a struct collection as a column in hive.</p>
  
  <p>The users shouldnt have to write column names individually. Does anyone have a UDF to do this?</p>