0

I have the attached table structure :Table structure for table account_report How do I select all the columns from this table as I want the output to be: msg_src_id ,cntry_cd ,hldr_org_addrs ,hldr_idv_tins ,hldr_idv_nms ,pmts

Thanks! Sammy

Samir Parmar
  • 21
  • 1
  • 3
  • HiI have tried to use impala sql by using left outer joins and I am able to expand /extract the table as desired. But we are using SAS DI which does not have an interface with Impala as yet in our org and hence the necessity to use Hive QL. – Samir Parmar Aug 30 '18 at 03:42
  • Use lateral view + explode to select from array columns, like in this answer: https://stackoverflow.com/a/51846380/2700344 – leftjoin Aug 30 '18 at 04:37

0 Answers0