you can try
CREATE EXTERNAL TABLE product(productid String,ingesttime String, productorders array<struct<orderid:String,location:string>> ) select productid,ingesttime, productorders.orderid[0] as orderid , productorders.location[0] as location from product
