Hivesql⾥的limit使⽤图闻天下在hive表前1000⾏⾥，过滤出不重复的refid,imsi。错误的写法：欧尚宜家select distinct refid,imsi from HIVE_D_MT_UU_H_SPARK limit 1000;会去读取全表，把0~1000⾏的不重复refid,imsi显⽰出来。截潜流工程常艳近况正确的写法：select distinct refid,ims