Data

​

Tables

​

Schema List

• (Refresh) — refresh the list of schemas
• + Schema — create a new schema
• + Table — create a new table
• Rename — rename the selected schema
• Delete — delete the selected schema(s)
• Memory — display the current amount of used memory by the tables and views in the selected schema(s)
• Filter — only display schemas matching the given search text and schemas containing tables and/or views matching the given search text
• Sync Mode — if enabled, record counts will be accurate but potentially slower to update

​

Table/View List

• T — table
• MV — materialized view
• LV — logical view
• ME — materialized external table

• PERS (PERSISTED) — the table exists on disk & in memory (i.e., not memory-only) and will exist across database restarts
• JOIN — a join view or materialized view that ends in a join view
• RESU (RESULT_TABLE) — results from endpoint operations like Create Projection and Create Union
• VIEW — a filtered view, a join view, or a materialized view that ends in a filtered or join view

• (Refresh) — refresh the list of tables & views
• + Table — create a new table
• Config — modify the selected table
• Rename — rename the selected table
• Move — move the selected table(s) and/or view(s) to a different schema
• Delete — delete the selected table(s) and/or view(s)
• Rebuild — rebuild the selected table(s) and/or view(s)
• Memory — display the current amount of used memory for the selected table(s) and/or view(s)
• Stats — display statistics regarding a selected column or all columns in the selected table or view, e.g., estimated cardinality, mean value, standard deviation, etc.; and recommendations for improving the structure of the table, e.g., dictionary encoding, smaller column type, etc.
• Sec — manage row- and column- security for the selected table or view
• Filter — only display tables and views matching the given search text
• Sync Mode — if enabled, record counts will be accurate but potentially slow

​

Creating

​

Defining a Tier Strategy

• Click + Group to append additional column strategy groupings to the table
• Click + Chain to append additional priority definitions to a group
• Provide a comma-separated list of columns, an eviction priority for each available tier (tiers are defined in /opt/gpudb/core/etc/gpudb.conf), and an optional predicate
  Omit Columns to apply the strategy to the entire table

Example

(
    (VRAM 1, RAM 9) WHERE last_seen > TIMESTAMPADD(DAY, -3, NOW()),
    (VRAM 1, RAM 8, DISK2 7)
),
(
    COLUMNS id, name
        (VRAM 2, RAM 10) WHERE last_seen > TIMESTAMPADD(MINUTE, -1, NOW())
)

​

Partitioning

1. Select a partition type.
2. Provide as many Key(s) as necessary. Click + to add key expressions.
3. Provide as many Definition(s) as necessary. Click + to add definitions.

Example

• partitioned by the date/time of the order
• partitions for years 2016, 2017, 2018, & 2019
• records not in that range go to the default partition

​

Configuring

• Renaming the table
• Modifying the TTL
• Renaming the non-primary/shard key columns
• Modifying the type, subtype, storage, and properties of a non-primary/shard key column
• Removing any non-primary/shard key columns
• Adding new columns
• Adjusting the tier strategy definition; see Defining a Tier Strategy for assistance.
• Adjusting the table partitioning; note that only existing range or list partitions can be adjusted

​

Moving

​

Deleting

​

Rebuilding

​

Detailed Table Information

​

WMS

• When viewing the list of tables (Data —> Tables), click the Map link in the WMS column
• When browsing a table’s datagrid, click the WMS button in the top bar

You can use the + / - on the left or the scroll wheel of your mouse to zoom in and out of an area. Click to draw a polygon on top of the map; this will act as a filter for the viewport. Click to remove any polygons on the map. Click Download PNG to download a .png file of the current viewport. Provide a table name and click Export Viewport to export the points in the current viewport to a separate table; note that if any polygon(s) were drawn on the map, only the points inside those polygons will be exported to the new table.

• double
• float
• int
• int16
• int8
• long
• timestamp (the raw epoch value will be used to render the point)
• decimal

• wkt
• wkb

​

Data Grid

• (Refresh) — refresh the table
• Add — insert a new record
• Edit — modify the selected record
• Delete — delete the selected record
• Move — move the table or view to a different schema
• Conf — modify the table or view
• CSV — export data to CSV
• Hide — hide displayed columns within the grid
• Info — display table detail
• Dist — display cross-node data distribution graph
• Stats — display statistics regarding a selected column or all columns in the table, e.g., estimated cardinality, mean value, standard deviation, etc., and recommendations for improving the structure of the table, e.g., dictionary encoding, smaller column type, etc.
• WMS — plot data from tables with geospatial data on a map
• Sec — manage row- and column- security for the table
• Order Cols — If enabled, the columns will be displayed alphabetically
• Sync Mode — if enabled, table row counts will be accurate but potentially slow

​

Export Data

​

Advanced Table Security

• When viewing the list of tables (Data —> Tables), select a table then click the Sec button in the top bar
• When browsing a table’s datagrid, click the Sec button in the top bar

​

Users

1. Navigate to the Advanced Table Security window and display the Users tab.
2. Select a user from the list.
   Row- and column-level security cannot be configured for users with the system_admin permission.
3. Apply Row Security and Column Security as necessary.
   • To apply Row Security:
     1. Click the Row Security tab.
     2. Provide a valid SQL WHERE-like expression in the Filter text field to specify entire rows the user has access to that meet the given filter condition.
   • To apply Column Security:
     1. Click the Column Security tab.
     2. Select a column from the drop-down menu.
     3. Click Add Column.
     4. Optionally, if the column is a string column, select a Transform option:
        • Mask — the column value will be masked after some length, for some width of characters, with a select character. If no mask exists for the column currently, one must be defined. Click to jump to the Columns table and define one. See Columns for more information.
        • Obfuscate — each unique original column value will be exchanged for a unique non-negative number
        Review Column-Level Security for more information on masking and obfuscation.
     5. Optionally, apply a valid SQL WHERE-like expression in the Filter text field.
     6. Repeat the previous steps for as many columns as necessary.
4. Click Save and confirm the update for the selected user.
   Click Reset to reset the modified security settings to the previously saved settings. Click Clear to remove any saved settings.

​

Roles

1. Navigate to the Advanced Table Security window and display the Roles tab.
2. Select a role from the list.
   Row- and column-level security cannot be configured for roles with the system_admin permission.
3. Apply Row Security and Column Security as necessary.
   • To apply Row Security:
     1. Click the Row Security tab.
     2. Provide a valid SQL WHERE-like expression in the Filter text field to specify entire rows the user has access to that meet the given filter condition.
   • To apply Column Security:
     1. Click the Column Security tab.
     2. Select a column from the drop-down menu.
     3. Click Add Column.
     4. Optionally, if the column is a string column, select a Transform option:
        • Mask — the column value will be masked after some length, for some width of characters, with a select character. If no mask exists for the column currently, one must be defined. Click to jump to the Columns table and define one. See Columns for more information.
        • Obfuscate — each unique original column value will be exchanged for a unique non-negative number
        Review Column-Level Security for more information on masking and obfuscation.
     5. Optionally, apply a valid SQL WHERE-like expression in the Filter text field.
     6. Repeat the previous steps for as many columns as necessary.
4. Click Save and confirm the update for the selected role.
   Click Reset to reset the modified security settings to the previously saved settings. Click Clear to remove any saved settings.

​

Columns

1. Navigate to the Advanced Table Security window and display the Columns tab.
2. Select a valid column from the list.
3. Specify a Start Position for the mask.
4. Specify the # of Masked Characters.
5. Specify the Mask Character.
6. Optionally, type into the Preview field to preview the mask before saving.
7. Click Save and confirm the column mask.

​

Example

• Can see full information for their own username
• Can only see the last 4 of an SSN and an obfuscated salary for employees outside of their assigned department

1. From the employees table, click Sec along the top, and then select jsmith from the Users list.
2. On the right side of the window, under Row Security, input the filter for the engineering department:
3. Click Column Security and input the obfuscated salary column & the masked ssn column:
4. Click the icon next to Mask to configure the masking values:
5. Click Save.

​

Graphs

• Create — create a new graph
• Query — run a query against an existing graph
• Solve — run a solver algorithm against an existing graph
• Match — run a matching algorithm against an existing graph

On any of the interfaces described below, click History to view previous requests made to that particular interface, view details about each request, reload a request, or view WMS for the request (if Enable Graph Draw was set to True)

​

Create

1. Provide a name for the graph.
2. Choose whether the graph should be directed
3. Optionally, select a desired node configuration from the Nodes drop-down menu and click Add +. For each identifier that appears after adding the configuration to the graph, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
4. Select a desired edge configuration from the Edges drop-down menu and click Add +. For each identifier that appears after adding the configuration to the graph, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
5. Select a desired weight configuration from the Weights drop-down menu and click Add +. For each identifier that appears after adding the configuration to the graph, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
6. Optionally, select a desired restriction configuration from the Restrictions drop-down menu and click Add +. For each identifier that appears after adding the configuration to the graph, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
7. Adjust the options as desired.
8. Click Create New Graph.

​

Query

1. Select an existing graph from the Graph Name drop-down menu.
2. Select a desired query configuration from the Queries drop-down menu and click Add +. For each query identifier that appears after adding the configuration, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the query identifier. Repeat as necessary.
   If you select QUERY_NODE_WKTPOINT, you can click to open the graph in the WMS viewer and manually select point(s) on the map.
3. Optionally, select a desired restriction configuration from the Restrictions drop-down menu and click Add +. For each identifier that appears after adding the configuration, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
4. Provide an adjacency table name into which the results will be output.
5. Provide the number of rings (or hops) for the query.
6. Adjust the options as desired.
7. Click Query Graph.

​

Solve

1. Select an existing graph from the Graph Name drop-down menu.
2. Optionally, select a desired weight configuration from the Weights on Edges drop-down menu and click Add +. For each identifier that appears after adding the configuration, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
3. Optionally, select a desired restriction configuration from the Restrictions drop-down menu and click Add +. For each identifier that appears after adding the configuration, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
4. Select a solver from the Solver Type drop-down menu.
5. Select a node type from the Source Nodes drop-down menu and click Add +. For each field that appears after adding the node type, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary. If adding multiple source nodes, they should all be of the same type.
   If you select NODE_WKTPOINT, you can click to open the graph in the WMS viewer and manually select point(s) on the map.
6. Select a node type from the Destination Nodes drop-down menu and click Add +. For each field that appears after adding the node type, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary. If adding multiple source nodes, they should all be of the same type.
   If you select NODE_WKTPOINT, you can click to open the graph in the WMS viewer and manually select point(s) on the map.
7. Provide a solution table name into which the results will be output.
8. Adjust the options as desired.
9. Click Solve Graph. A WMS request of the solution(s) will open. Click a solution route to see the start () and end () points:

​

Match

1. Select an existing graph from the Graph Name drop-down menu.
2. Select a sample points configuration from the Sample Points drop-down menu and click Add +. For each field that appears after adding the configuration, provide a column name, expression, or raw value (as outlined in Components and Identifiers) to use with the identifier. Repeat as necessary.
3. Select a solver from the Solve Method drop-down menu.
4. Provide a solution table name into which the results will be output.
5. Adjust the options as desired.
6. Click Match Graph.

​

Import