Output is not showing for joins on screen

Hi Team,

When working on joins its showing execution completed successfully , but output of the join is not showing on the hive console but output is getting displayed when trying to retrive columns from a single table.Verified the column names of both tables.

Hi @madasu_ashalatha,

can you please share the code snippet which you tried.

Hi Shubam,

PFA.

tablestructure

@madasu_ashalatha,

There is no records in your customers table hence the query is not showing any result.

where as in customers1 table all the records are present,so for now try with customers1 table-

select o.*, c.* from orders o, customers1 c where o.order_customer_id=c.customer_id limit 10;