[Feature] Paimon supports Flink Connector syntax

[BoYiZhang]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

Paimon supports create table, supports the following statements, does not require create catalog

`

CREATE TABLE flink_table (
id BIGINT,
data STRING
) WITH (
'connector'='paimon',
'catalog-name'='hive_prod',
'database'='hive_db',
'table'='hive_iceberg_table',
-- 'metastore' = 'hive',
-- 'uri' = 'thrift://:', default use 'hive.metastore.uris' in HiveConf
-- 'hive-conf-dir' = '...', this is recommended in the kerberos environment
-- 'hadoop-conf-dir' = '...', this is recommended in the kerberos environment
-- 'warehouse' = 'hdfs:///path/to/warehouse', default use 'hive.metastore.warehouse.dir' in HiveConf
);

`

Solution

same as iceberg .

https://iceberg.apache.org/docs/latest/flink-connector/#a-complete-example

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[tsreaper]

We actually support creating paimon as a temporary table, but it is not recommended, because many features can only be used with catalog. You can set 'path' in the table properties to specify the table path.