any update on the HIVE multiple outer join issue… Its impacting our Hadoop POC. ...
any update on the HIVE multiple outer join issue… Its impacting our Hadoop POC.
Following query is not working in 2.0 sandbox but works in 1.3 sandbox.
Its working for only one level of OJ..
The table is created in HCatalog
from belk_view_reg_no_tran_no o
left outer join belk_view_store_no_tran_no a
on (o.Transaction_no = a.Transaction_no and o.register = a.register )
left outer join belk_view_temp_input_file_as_table c
on (o.Transaction_no = c.Transaction_no and o.register = c.register and c.line_type = ‘ 13’ )
left outer join belk_view_transaction_type d
on (o.Transaction_no = d.Transaction_no and o.register = d.register)
left outer join belk_view_tran_no_assoc_name e
on (o.Transaction_no = e.Transaction_no and o.register = e.register)
left outer join belk_view_tran_no_tender f
on (o.Transaction_no = f.Transaction_no and o.register = f.register)
left outer join belk_view_tran_no_cust_phone_no g
on (o.Transaction_no = g.Transaction_no and o.register = g.register)
The forum ‘Hortonworks Sandbox’ is closed to new topics and replies.
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world