Re: CREATE TABLE LIKE clause from different catalog or database

[Danny Chan]

Hi Dongwon ~

Table from different catalog/db is supported, you need to specify the full
path of the source table:

CREATE TABLE Orders_with_watermark (
    *...*) WITH (
    *...*)LIKE my_catalog.my_db.Orders;


Dongwon Kim <eastcirc...@gmail.com> 于2020年11月11日周三 下午2:53写道：

> Hi,
>
> Is it disallowed to refer to a table from different databases or catalogs
> when someone creates a table?
>
> According to [1], there's no way to refer to tables belonging to different
> databases or catalogs.
>
> [1]
> https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/create.html#create-table
>
> Best,
>
> Dongwon
>