0

I have a table which has a colums a:Int b:array<struct<c:int, d:int>>

I cannot view the complex column b when I select *. What query should I use to unpack it using join?

user239457
  • 1,766
  • 1
  • 16
  • 26
  • Possible duplicate of [Impala select \* does not show all details of table](https://stackoverflow.com/questions/41623711/impala-select-does-not-show-all-details-of-table) – mazaneicha Nov 24 '19 at 19:57

1 Answers1

0

select a, b.c, b.d from table,table.b

user239457
  • 1,766
  • 1
  • 16
  • 26