使用TIDB作为trino数据库，报错'CREATE TABLE ... SELECT' is not implemented yet

[TwowT969]

你好，我的项目中使用TIDB数据库与trino，但在trino执行过程中，发现trino执行的sql中包含TIDB明确不支持的CREATE TABLE tblName AS SELECT stmt 语法 ，请问有对应的解决办法吗？

[xuanyu66]

Yes, we don't support it yet. https://github.com/tidb-incubator/TiBigData/blob/master/trino/src/main/java/io/tidb/bigdata/trino/tidb/TiDBMetadata.java should implement these two interfaces in order to support 'CREATE TABLE ... SELECT'. But since TiDB doesn't support 'CREATE TABLE ... SELECT', we should use other statements to simulate the behavior of it