参考答案: ABCD
详细解析:
重点说C 最新版本支持通过别名order by;题目中有点问题 建表语句不是分区表，可以修改为创建了一张分区表， create table t_student(name string,score bigint) partitioned by(ds string);A. select * from t_student order by score limit 100;
B. select * from t_student order by score;
C. select name, score as p from t_student order by p limit 100;
D. select name, score as s from t_student order by score limit 100;
参考答案: ABCD
详细解析:
重点说C 最新版本支持通过别名order by;题目中有点问题 建表语句不是分区表，可以修改为创建了一张分区表， create table t_student(name string,score bigint) partitioned by(ds string);