Hi Dongwon,
You are hitting a known bug[1] which is fixed in 1.11.3 and 1.12.0
Another tip, currently, LIKE clause cannot work with Hive table. (General
table stored in hive metastore should work)
[1] https://issues.apache.org/jira/browse/FLINK-19281
Dongwon Kim 于2020年11月17日周二 上午12:04写道:
> Hi
Yes, this is a bug which is fixed recently [1] for release 1.12 and 1.11.3
You can also switch to the source table catalog first before you execute
the CREATE TABLE LIKE DDL just like Ingo suggested.
[1] https://issues.apache.org/jira/browse/FLINK-19281
김동원 于2020年11月17日周二 上午12:19写道:
> Hi Ingo,
Hi Ingo,
Thank you for letting me know! I didn’t know that’s already discussed.
Best,
Dongwon
> 2020. 11. 17. 오전 1:12, Ingo Bürk 작성:
>
>
> Hi,
>
> I ran into the same issue today. This is fixed in 1.11.3, the corresponding
> bug was FLINK-19281.
>
> A workaround is to switch the curren
Hi Danny~
Sorry for late reply,
Let's take a look at a running example:
> EnvironmentSettings settings = EnvironmentSettings.newInstance()
> .inBatchMode()
> .build();
>
> TableEnvironment tEnv = TableEnvironment.create(settings);
>
> HiveCatalog hiveCatalog = new HiveCatalog("hive",null, arg
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 于2020年11月11日周三 下午2:53写道:
> Hi,
>
> Is it disallowed to refer to a table