摘要: 问题:hive中数字排序是按首个数字优先排序 SELECT xxx FROM table_name ORDER BY xxx desc 排序结果: 解决:转换成浮点格式后再排序 SELECT xxx,* FROM table_name ORDER BY cast(xxx as float) desc 阅读全文
posted @ 2020-03-25 14:31 七彩木兰 阅读(781) 评论(0) 推荐(0)