您可以将所有这些表存储在单个分区的表中。这种方法允许您在单个查询中加载所有数据。查询性能不会受到影响。

Create table T (
... --columns here
) 
partitioned by (id int); --new calculated partition key

使用一个查询加载数据，它将只读取源表一次：

insert overwrite table T partition(id)
select ..., --columns
       case when some_id=10385 AND other_id=10385 then 10385 
            when some_id=10386 AND other_id=10386 then 10386
            ...
            --and so on
            else 0 --default partition for records not attributed
        end as id --partition column
   from foo
  where some_id in (10385,10386) AND other_id in (10385,10386) --filter

然后可以在指定分区的查询中使用此表：

select from T where id = 10385; --you can create a view named bar_10385, it will act the same as your table. Partition pruning works fast