在prestosql中，您可以使用 CREATE TABLE ... LIKE 语法。看到了吗https://prestosql.io/docs/current/sql/create-table.html.

CREATE TABLE bigger_orders (
   LIKE orders INCLUDING PROPERTIES
)

在雅典娜你云生成ddl与 SHOW CREATE TABLE database1.tablename 然后执行这个语句 database1 至 database2 . 它将复制模式，但不复制数据和分区。要填充分区，您应该在上执行msck repair table database2.tablename . 普雷斯托也是这样。
如果无法使用 MSCK REPAIR TABLE 您可以使用glue api复制它：

import boto3
glue = boto3.client('glue')
paginator = glue.get_paginator('get_partitions')
DB_NAME_SRC = 'src'
DB_NAME_DST = 'dst'
TABLE = 'tablename'

partitions = []
for page in paginator.paginate(DatabaseName=DB_NAME, TableName=TABLE):
    for partition in page['Partitions']:
        del partition['DatabaseName']
        del partition['TableName']        
        del partition['CreationTime']        
        partitions.append(partition)
print("Got %d partitions" % len(partitions))
glue.batch_create_partition(DatabaseName=DB_NAME_DST, TableName=TABLE, PartitionInputList=partitions)