1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
0
A DDL like that is mean to alter and actual catalog table, not an immutable view like is "study".
You also have to add some content to the column (even if it's a NULL placeholder you will fill in later).
Even better if you can set the value you need here using other columns.
For instance:
select *, 0 as AccessionNo from study
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- Wie behebe ich den Fehler „java.lang.OutOfMemoryError: Java heap space“ in einem AWS Glue-Spark-Job?AWS OFFICIALAktualisiert vor 2 Jahren
Pls accept apologies for the late response as I was busy with MVP deadlines. It actually worked. Thanks a lot @Gonzalo Herreros.
So, a follow up question. when a data catalog table is getting transformed with SQL transform, does the catalog table always referenced as a View?
They are separate things, a DDL (ALTER TABLE) updates the table, all the other transformations just exists while you make the query