Support for 64-bit integers. Version 11 of the 1010data Insights Platform provides extensive support for 64-bit integer data. The Trillion-Row Spreadsheet now visually identifies columns of type big integer, which can be used in operations such as tabulations, linking, and merges. The Custom Uploader supports uploading data into columns of type big integer. Many of the functions and operators in the 1010data Macro Language can now operate on columns containing 64-bit integer values. TenUp now provides the ability to load 64-bit integers (e.g., SQL_BIGINT) as a 1010data bigint column. TenDo and the 1010data .NET, Java, and Python SDKs can download 64-bit integer data. See the Release details section below. For more information, please refer to the 64-bit Integer Support FAQ.

Column promotion. In prime-11.25 and prime-11.26, when performing a logical and (&) or a logical or (|) on two columns of type bigint, the type of the resultant column is incorrectly identified as integer. However, the underlying type of the column, which is bigint, is correct. This will be fixed in prime-11.27; the resultant column will be correctly identified as bigint.

The types attribute for the <table> operation now accepts the value j to specify a column of type big integer in the new table.

Operators used in selection expressions and value expressions in Macro Language code can now take 64-bit literals and columns of type big integer as operands.

Columns of type bigint can be specified as the G argument in g_functions such as g_sum(G;S;O;X). In addition, many of the 1010data functions that operate on columns of type integer will also work with bigint columns. Refer to the Function Reference in the 1010data Reference Manual for details on which function arguments can accept values or columns of type big integer.

TenDo can now download 64-bit integer data.

When using the -d option, columns of type bigint in query results received from the 1010data Insights Plaform via TenDo will be indicated by the letter j. See the section titled "Specifying the Output Format" in the Output Control topic of the TenDo User's Guide.

TenUp can load 64-bit integers (e.g., SQL_BIGINT) as a 1010data bigint column. In order to ensure that data of this type is loaded properly, use the --use-long-ints switch to indicate the data contains 64-bit integers. Currently, you can only load 64-bit integers from ODBC databases. See the section titled "Loading from ODBC-compliant databases" in the Basic Usage topic of the TenUp User's Guide.

The 1010data .NET, Java, and Python SDKs allow you to download values in 1010data bigint columns as native language-specific 64-bit integer values. See the AllTypes sample project included in the installation download for the .NET and Java SDKs for examples. For more information, refer to the Getting Started topic of the .NET SDK User's Guide and Java SDK User's Guide. For more information about the Python SDK, see the Python SDK User's Guide.

The addtab transaction accepts the value J for the contents of a <type> element in the input specification for a column containing 64-bit integers.

The validate transaction accepts the value J for the contents of a <type> element in the input specification for a column containing 64-bit integers.

The Table Tree XML specification used by the 1010data API for tables on the 1010data Insights Platform now supports columns of type big integer. The type attribute in a <th> element accepts the value j to indicate columns that may contain 64-bit integer values.

There are several locations in the web interface that indicate the data type of a column, including the new type of big integer. Some of the most common locations include the following:

• Grid View
When viewing a table in the Grid View () of the Trillion-Row Spreadsheet or the Macro Language Workshop, place your cursor over a column header to view its data type.
• Spreadsheet View
When viewing a table in the Spreadsheet View () of the Trillion-Row Spreadsheet or the Macro Language Workshop, right-click a cell in the table and select Show column info from the menu.
• Data Dictionary
The column data type is displayed in the Data Dictionary view () in the results pane in both the Trillion-Row Spreadsheet and Macro Language Workshop.
• Column biscuits
In certain panels in the analysis timeline, and within the data columns panel of the Chart Builder, columns are displayed as biscuits. Each column biscuit is color coded so that you can quickly determine its data type. In addition, you can also place your cursor over a biscuit to view its data type.

For more information about each of the different ways of determining the data type of a column listed above, see the Determine the data type of a column topic in the 1010data Insights Platform User’s Guide.
To learn about the different column data types available in the Insights Platform, see the Data types topic in the 1010data Insights Platform User’s Guide.

Using the custom upload feature in the web interface, you can upload data into columns of type big integer. You define a column of type big integer from the Type drop-down list in the Column Information section of the Custom Uploader tab in the Upload Table window. For more information, see the Column Information topic in the 1010data Insights Platform User’s Guide.