在Hive中,以下哪个SQL语句是错误的
(A)hive> SELECT ID, NAME, o.AMOUNT, o.DATE > FROM CUSTOMERS c > LEFT OUTER JOIN ORDERS o > ON (ID = o.CUSTOMER_ID);
(B)hive> SELECT ID, NAME, o.AMOUNT, o.DATE > FROM CUSTOMERS c > RIGHT OUTER JOIN ORDERS o > ON (ID = o.CUSTOMER_ID);
(C)hive> SELECT ID, NAME, o.AMOUNT, o.DATE > FROM CUSTOMERS c > FULL OUTER JOIN ORDERS o > ON (ID = o.CUSTOMER_ID);
(D)hive> SELECT ID, NAME, o.AMOUNT, o.DATE > FROM CUSTOMERS c > FULL OUTER JOIN ORDERS o > ON (ID = o.CUSTOMER_ID OR Name = o.Name);
参考答案
继续答题:下一题