The generated hive DDL of Adding column is wrong #257
-
If trying to add a column,right ddl must be ALTER TABLE table ADD COLUMNS (newColumn String COMMENT 'comments') but dbeaver will generate ALTER TABLE test.table ADD newColumn VARCHAR(100); |
Beta Was this translation helpful? Give feedback.
Replies: 5 comments
-
What database? Different databases have different syntax. |
Beta Was this translation helpful? Give feedback.
-
Unfortunately DBeaver doesn't support Hive-specific DDL (yet, maybe). |
Beta Was this translation helpful? Give feedback.
-
I think if you don't remove hive support,this bug should be kept open |
Beta Was this translation helpful? Give feedback.
-
If I will keep all not-implemented features for all unsupported databases open then there will be zillions of open issues with blurry status. It is hard to manage big number of open issues. |
Beta Was this translation helpful? Give feedback.
Unfortunately DBeaver doesn't support Hive-specific DDL (yet, maybe).
Generated DDL conforms SQL-92 standard.
To generate Hive-specific DDL we'll need to make new driver extension, at the moment there are no plans to make it for Hive (or there are too many other more prioritized databases to support).
You can make feature request for Hive extension. But I can't say when I'll have a time to work on it...