登录  注册

首页->智网工程师中级

在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);

参考答案
继续答题:下一题
微考学堂微考学社

更多智网工程师中级试题

考试