14.13.7 Flattening Vector Properties

You can split the vector properties into multiple columns using the flattenAll() operation.

For example, you can flatten the vector properties for the example explained in Loading and Storing Vector Properties as shown:

• JShell
• Java

opg4j> vecFrame.flattenAll()

vecFrame.flattenAll();

The resulting flattened PgxFrame may appear as shown:

+----------------------------------------------------------------------------------------------------+
| intProp | intProp2 | vectProp_0 | vectProp_1 | vectProp_2 | stringProp | vectProp2_0 | vectProp2_1 |
+----------------------------------------------------------------------------------------------------+
| 0       | 2        | 0.1        | 0.2        | 0.3        | testProp0  | 0.1         | 0.2         |
| 1       | 1        | 0.1        | 0.2        | 0.3        | testProp10 | 0.1         | 0.2         |
| 1       | 2        | 0.1        | 0.2        | 0.3        | testProp20 | 0.1         | 0.2         |
| 2       | 3        | 0.1        | 0.2        | 0.3        | testProp30 | 0.1         | 0.2         |
| 3       | 1        | 0.1        | 0.2        | 0.3        | testProp40 | 0.1         | 0.2         |
+----------------------------------------------------------------------------------------------------+