hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>LEFTOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>RIGHTOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>FULLOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>FULLOUTERJOINORDERSo>ON(ID=o.CUSTOMER_IDORName=o.Name);
hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>FROMCUSTOMERSc>LEFTOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>RIGHTOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>FULLOUTERJOINORDERSo>ON(ID=o.CUSTOMER_ID); hive>SELECTID,NAME,o.AMOUNT,o.DATE>FROMCUSTOMERSc>FULLOUTERJOINORDERSo>ON(ID=o.CUSTOMER_IDORName=o.Name);