请问这个sql语句报错了,要怎样才能指定分区呢?
select count(*) from loadTable('dfs://db1','table1','202311M')
用where条件指定分区,类似下面:
select count(*) from loadTable('dfs://db1','table1') where month(date)=2023.11M