spark写hive的ORC表，count(*)没数据

使用spark向hive中插入数据，hive表是ORC表

spark.sql("insert overwrite table ods.ods_aaa partition(pt,id) \n" +
                    "select \n" +
                    "num,\n" +
                    "timestamp,\n" +
                    "date_formate(timestamp,'yyyy-MM-dd') as pt, \n" +
                    id + " id \n" +
                    "from bbb");

然后用SQL查询数量，结果是0

select count(*) from ods.ods_aaa;

然后查询数据，发现数据是164条

select * from ods.ods_aaa;

解决办法：在后面加 limit 1 解决

select count(*) from ods.ods_aaa limit 1;