Re: CREATE TABLE LIKE clause from different catalog or database

2020-11-23 Thread Benchao Li
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

Re: CREATE TABLE LIKE clause from different catalog or database

2020-11-18 Thread Danny Chan
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,

Re: CREATE TABLE LIKE clause from different catalog or database

2020-11-16 Thread 김동원
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

Re: CREATE TABLE LIKE clause from different catalog or database

2020-11-16 Thread Dongwon Kim
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

Re: CREATE TABLE LIKE clause from different catalog or database

2020-11-13 Thread 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 于2020年11月11日周三 下午2:53写道: > Hi, > > Is it disallowed to refer to a table