Support Questions
Find answers, ask questions, and share your expertise

How to outer join child array

Contributor

Hi,

 

If i have an array B under A, but it is nullable, what's syntax to outer join, something like

 

select * from A a, outer a.B

 

Thanks

Shannon

2 REPLIES 2

Expert Contributor
Hi,

You would do something like 'select * from A a left outer join B b...'.

You can find more documentation on the topic here:
https://www.cloudera.com/documentation/enterprise/latest/topics/impala_joins.html

Cheers, Lars

Contributor

Ah, thanks.