Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

解析hive创建表时不能识别STORED BY #5968

Closed
HandSomeMan111111 opened this issue Jun 6, 2024 · 3 comments
Closed

解析hive创建表时不能识别STORED BY #5968

HandSomeMan111111 opened this issue Jun 6, 2024 · 3 comments

Comments

@HandSomeMan111111
Copy link

解析hive创建表时不能识别STORED BY

报错为

语句是
CREATE TABLE IF NOT EXISTS test.tests(\n id bigint COMMENT 'from deserializer', \n job_group bigint COMMENT 'from deserializer', \n job_id bigint COMMENT 'from deserializer', \n ums_ts_ bigint COMMENT 'from deserializer') comment 'test'\nROW FORMAT SERDE \n 'org.apache.paimon.hive.PaimonSerDe' \nSTORED BY \n 'org.apache.paimon.hive.PaimonStorageHandler'

我在issue列表里面看到这个问题已经被closed,
issue 列表为#4622
但是即使我升级到最新的1.2.3版本也还是有问题

@lizongbo
Copy link
Collaborator

看了下官方有两种语法,,目前只支持STORED AS,近期我加一下适配。

[STORED AS file_format]
| STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)]

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

@HandSomeMan111111
Copy link
Author

我看这个问题之前有人提交过,然后代码已经被merge了,但是我在新的版本里面没发现
ps 预计哪个版本可以使用呢

lizongbo added a commit to lizongbo/druid that referenced this issue Jun 14, 2024
lizongbo added a commit that referenced this issue Jun 14, 2024
优化hive STORED BY的解析 #5968
@lizongbo
Copy link
Collaborator

我看这个问题之前有人提交过,然后代码已经被merge了,但是我在新的版本里面没发现 ps 预计哪个版本可以使用呢

等 1.2.24

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants