Product: Aqua Data Studio
Version: 16.0.0-dev-39
Build #: 41109
Build Date: 2014-Nov-17 06:11:40 PM
Operating Environment: Linux (3.13.0-39-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=595,066,880; Free=196,404,928; CPUs=8
Database: Vertica 7.0.2
Steps to reproduce:
Create a flex table using below script:
Create flex table test(a int , b int)
GO
After creating flex table Go to Tables node & expand it.Expand Columns node
Right click on single column
You will observe that Script object to window as options are not present for Single column
The options are provided when user selects multiple columns & right clicks on them
Select Multiple columns & right click on it,Select Script object to window as->Create
Add another column to the table through create script generated for columns
Refresh columns node
You will observe that Column gets created & gets added to Columns node
Right click on created flex table & select Script object to window as->Create
You will observe that newly added column does not get added to generated create table script
Please refer attached screenshot(16.0_vertica_flextable.png)
Also if user creates a primary key on a,drops the primary key & again creates primary key on a,b & if column definition of b is changed to "not null" then column b does not get added to create table script generated by option script object to window as->Create i.e if column definition of any column present in flex table changes then that column does not get scripted in create table script
This only happens in case of flex tables
|
|
138 KB
See 11539 for more information. The Flex Table feature creates a different kind of table designed especially for loading and querying unstructured data, also called semi-structured data in HP Vertica.
We will add more options to scripting to Flex Tables based on user feedback.
Issue #12780 |
| Closed |
Completion |
| No due date |
| No fixed build |
| No time estimate |
See 11539 for more information. The Flex Table feature creates a different kind of table designed especially for loading and querying unstructured data, also called semi-structured data in HP Vertica.
We will add more options to scripting to Flex Tables based on user feedback.