Details
-
Bug
-
Resolution: Cannot Reproduce
-
Major
-
6.2.0
-
None
Description
I exported the transformation SQL from the VQT model. When I tried to import the SQL into a new VQT model, it gave the appearance it completed successfully, but none of the tables were defined. There were no errors or exceptions found in the log. Whoa... I just found a warning: Could not parse the following row: Agg3|SELECT|SELECT COUNT FROM BQT1.SmallA.
The format of the exported file is not the same as that of the Metadata Text Importer, so to use that route the file must be edited. (The export version takes into account the SELECT, INSERT, UPDATE, DELETE possibilities.) BTW, this had issues as well, but that's another JIRA.
Attachments
Issue Links
- is blocked by
-
TEIIDDES-1001 Merge the "Transformations - Import/Export SQL " actions with the Import Text Files > Relational Virtual Tables feature
- Closed