-
Notifications
You must be signed in to change notification settings - Fork 101
[BUG]: View Migrator omits a view's column list argument #1345
Copy link
Copy link
Closed
Labels
migrate/codeAbstract Syntax Trees and other dark magicAbstract Syntax Trees and other dark magicmigrate/externalgo/uc/upgrade SYNC EXTERNAL TABLES stepgo/uc/upgrade SYNC EXTERNAL TABLES step
Description
Is there an existing issue for this?
- I have searched the existing issues
Current Behavior
Using the view text instead of a show create table statement will create views; however, if the view was created with the argument column_list, it will result in an erroneous view with no errors raised.
Here is an example of a view created using the argument column list, in the image it is represented as (name,user_id), note how leveraging the view text completely resulted in a successful view creation but erroneous column names.

Expected Behavior
If a view was created and used the argument column_list, the migratory should recreate the view using the column list argument. (can be extracted using SHOW CREATE TABLE instead of the DESC EXTENDED, View Text logic.
Steps To Reproduce
No response
Cloud
Azure
Operating System
macOS
Version
latest via Databricks CLI
Relevant log output
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
migrate/codeAbstract Syntax Trees and other dark magicAbstract Syntax Trees and other dark magicmigrate/externalgo/uc/upgrade SYNC EXTERNAL TABLES stepgo/uc/upgrade SYNC EXTERNAL TABLES step
Type
Projects
Status
No status