Worksheet window with tables

This section provides an overview of the Worksheet window that contains tables. The exact contents of the Worksheet window depend on your tables and might be different from the window contents described in this section.

The following screenshot explains the purpose of each user interface element in a worksheet containing one table.

NOTE: The vertical scrollbar enables you to quickly locate a desired row or section of a table. Occasionally, due to a slow network connection, the rows might be empty when you scroll. This does not indicate a problem, as data will be displayed gradually in the table cells.

The column prefix in this example has a green background color. You can display a list of colors and choose a desired color, as shown in the following partial screenshot.

TIP: The background color is applied to all column headers with the same prefix. Using different colors for different prefixes makes it easy to identify the origins of the columns. For example, if after a Join operation, some column names are prefixed with airlines13 and some are prefixed with airlines14, apply the green color to the airlines13 prefix and purple to the airlines14 prefix.

Skew value

At the top of the worksheet window, a skew value is displayed for the table you are currently working on. The value is an indicator for how evenly data in the table is distributed across the nodes. The value ranges from 0 to 100. If it is 0, data is perfectly distributed across all nodes. If it is 100, all data is on one node.

To see how data is distributed, click Skew. A modal window is displayed to show detailed information related to data distribution.

Recommendation: Data distribution is a factor affecting cluster performance. The more evenly data is distributed, the faster the operations run on the cluster. If you experience a slow operation on your table, check to see if a high skew is the cause of the low performance. If so, and if you run this operation frequently, contact Xcalar for information about improving performance through operationalizing. You can also refer to the Xcalar community forum and knowledge base to obtain tips on how to reduce skew.

Menus displayable in the worksheet

Several menus can be displayed when you view a worksheet containing one or multiple tables.

Column drop-down menu

You can start most of the data operations from the column drop-down menu. The exact options in this menu depend on the column's data type. To display the menu, you can right-click the column header or click the triangle in the lower right corner of the column header. For simplicity, Xcalar Design documentation instructs you to right click the column header to display the menu. The following partial screenshot shows an example of the column drop-down menu.

Cell pop-up menu

You can right click on a table cell to display a pop-up menu. The exact options in this menu depend on the column's data type. The following partial screenshot shows an example of a cell pop-up menu. The options in this menu are explained in Cell options.

Table drop-down menu

You can start operations that affect the entire table from the table drop-down menu. To display this menu, click anywhere in the title bar of the table (but not on the table title) or click the triangle in the lower right corner of the table title bar. For simplicity, Xcalar Design documentation instructs you to click the table title bar. The following partial screen shows an example of the table drop-down menu. The options in this menu are explained in Table options.

Go to top