Product Release

11

October 20, 2017

1010data is excited to announce the release of 1010data Insights Platform Version 11.

This version of our production system offers many new features and enhancements to the 1010data Insights Platform web interface and associated tools. A list of these features and improvements is provided below.

See What's New in Version 11 for a high-level overview of the new features and enhancements.

Highlights

Grid interactions. Interactions have been added within the Grid View in both the Trillion-Row Spreadsheet (TRS) and Macro Language Workshop (MLW) that make it easier to perform common operations. You can now drag columns within the grid to reorder them, hide a column directly from the column header, change to a single-row view by right-clicking on a row, and view column information such as the name, label, and type by placing your pointer over the column header.

Enhanced user experience. 1010data Insights Platform Version 11 provides numerous enhancements that offer smoother, more intuitive workflows in the Trillion-Row Spreadsheet, giving you the power to perform ad hoc analysis and gain insights from your data faster than ever. New keyboard shortcuts and keyboard navigation actions allow you to move more seamlessly throughout the interface. In addition, the visual aspects of the user interface have been improved to provide more modern, sleek workspaces.

Expression Editor. The new Expression Editor makes it much easier to compose expressions when selecting rows or creating computed columns. The Expression Editor provides context-sensitive suggestions of columns, variables, and functions as you build your expression. Inline help provides contextual information about Macro Language functions and each of their arguments. Other useful features include suggestions of closing delimiters and the implied semicolon separators for function calls, highlighting of the current enclosing delimiters, and detection and highlighting of mismatched delimiters (e.g., brackets, braces, quotation marks, and parentheses).

Rollups. In the Trillion-Row Spreadsheet, a rollup can be specified in the Tabulation panel using a drag-and-drop interface, making it easy to aggregate data at multiple levels in a tabulation.

Extended operations in TRS. In addition to the Insights Platform foundational data transformation operations such as select, sort, tabulate, and link, the Trillion-Row Spreadsheet in Version 11 provides the following extended operations: bulk selection, amend by expression, select and expand rows, and string expansion.

Macro Language View. The Trillion-Row Spreadsheet now provides a Macro Language View that allows you to edit code directly within TRS and see the results of your changes in real time. In addition, the Macro Language code associated with an individual operation can be added or edited directly in the Analysis Timeline in TRS.

Uploader. Version 11 features a completely redesigned Uploader that streamlines the process of uploading files to the 1010data Insights Platform. The wizard-like interface guides you through a series of simple steps to select the file using drag-and-drop functionality, change the automatically-detected delimiters, and easily customize column information. The new interface also offers previews of the data before it is uploaded.

Scheduler. The new Scheduler provides an intuitive interface that lets you automatically run queries at the frequency of your choice and distribute reports to a set of recipients in a variety of formats including PDF, CSV, or Excel workbook files.

Group Manager. Manage your groups with this new tool in Version 11. Add new groups or update existing groups using this simple interface. The new Group Manager makes it easier to add users to a group by providing a drop-down list of Insights Platform IDs in your company.

User Manager. Company administrators can now manage Insights Platform user accounts using the new User Manager. Create new users, modify user information and preferences, and deactivate users all within the new interface.

System Statistics. Company administrators can use the System Statistics tool to see information related to overall memory usage and number of active users on the platform at any given time.

Usage Report. Available to company administrators, Usage Report provides detailed usage statistics on key metrics based on certain users or groups over a specified date range. Some of the available metrics include the total number of active sessions, average time per transaction, and highest number of concurrent sessions per week or month. Create sleek charts and export the results to an Excel workbook.

Support for 64-bit integers. Version 11 of the 1010data Insights Platform provides extensive support for 64-bit integer data. For more information, please refer to the 64-bit Integer Support FAQ.

Technical advisories

Queries that do not specify <base>. Macro Language Workshop will add a <base> operation to the beginning of queries that were saved in the legacy interface but did not explicitly specify a <base> tag. The new <base> operation will reference the table the query was associated with when it was created in the legacy interface.

Standard XML syntax. Version 11 supports standard XML syntax such as CDATA sections and comments defined with the  <!-- --> syntax. Note that queries that utilize these features will not run in versions of the Insights Platform prior to Version 11.

Column names in multi-column cross tabulations. An error message is displayed if the name attribute is specified to <tcol> in a multi-column cross tabulation. Specify label or cmlabel instead.

Tables with 64-bit integer columns. Opening a table with columns of type bigint in versions prod-9.58 and beta-10.26 or later will result in an error stating that the table is not compatible. Opening a table with columns of type bigint in versions prior to prod-9.58 and beta-10.26 is not supported and may result in session loss.

Supported browsers. Although Insights Platform Version 11 works with a number of browsers, such as Safari, Firefox, and Internet Explorer, we recommend using the latest version of Google Chrome for the best experience. See System requirements for more information.

Release details

Release details for Version 11 are organized in the following sections:

1010data Insights Platform web interface

New keyboard shortcuts have been added throughout the Insights Platform web interface, allowing you to perform actions in the interface with a simple keystroke or key combination. For example, now you can open the Computed column panel in the Trillion-Row Spreadsheet by simply pressing the = key in the New operation panel.

Keyboard navigation actions have been added to the Insights Platform web interface. Keyboard navigation actions allow you to maneuver around the interface without using your mouse. For example, you can use the Down Arrow key to move down the tree in the Object Manager or expand a folder in the object browser by pressing the Right Arrow key.

You can now minimize a maximized window by clicking the Minimize icon (MinimizeIcon.gif) within the window controls on the title bar of the window.

Multiple instances of Trillion-Row Spreadsheet or Macro Language Workshop windows are now given unique titles to help identify each window. This can be useful when selecting or referencing within tools in the workspace, such as when linking in a worksheet from TRS or when switching between windows in the window manager.

You can customize your workspace with new backgrounds available within the Appearance tab of the Workspace Settings window. The Workspace Settings window is available from the Session menu.

You can specify default associations for objects within the Associations tab of the Workspace Settings window. Associations specify a default action that is taken when opening an object of a certain type in Object Manager. For instance, you can specify whether a QuickApp is opened within a window, in standalone mode, or in Macro Language Workshop to edit its code. The Workspace Settings window is available from the Session menu.

Pop-up error messages that appear in the Insights Platform web interface can now be closed by pressing Escape or Enter.

Dashboard

Clicking the What's New icon (whats_new_icon.png) on the Welcome tab of the Dashboard opens the Insights Platform Version 11 Release Notes in a new browser tab.

Clicking the Getting Started Guide icon (gsg_icon.png) on the Welcome tab of the Dashboard opens the Trillion-Row Spreadsheet Getting Started Guide in a new browser tab.

Object Manager

Quick Queries and Parameterized Quick Queries created prior to Version 10 can now be run in the Insights Platform Version 11 web interface. These types of objects open in the Converted QuickQuery window, which allows you to open the converted QuickApp in MLW for further development, open the query in TRS, and other options for saving, exporting, or downloading the query and/or its results.

Trillion-Row Spreadsheet

The object browser in the Analyze tab now includes Parameterized Quick Queries. They are represented by a Parameterized Quick Query icon (ParameterizedQuickQueryIcon.gif). Previously, objects of this type did not appear in the object browser.

A tooltip containing column information such as the name, label, and data type is provided when you place your pointer over a column header in Grid View.

To hide a column in Grid View, place your pointer over its column header, click the drop-down arrow that appears, and select Hide from the menu. This automatically creates a corresponding Arrange columns operation in the Analysis Timeline.

In the New operation panel, pressing the equal sign (=) key is a keyboard shortcut to open the Computed column panel.

In the New operation panel, pressing the question mark (?) key is a keyboard shortcut to open the Select rows panel.

The Select rows panel offers convenient shortcuts for referencing or creating Visible Variables when in the Simple Comparison view. Now you can use Visible Variables in TRS analyses without writing any code by hand.

Column selectors in the Link tables, Sort columns, Arrange columns, and Tabulation panels now offer a filter field to limit the columns that display. This is helpful when working with a table containing many columns.

The Merge tables panel has been simplified to provide improved column matching between the tables.

Column selectors throughout TRS now consistently provide tooltips with information about the name, label, and data type of individual columns for each column biscuit in the column selector.

The Tabulation panel supports creating a rollup within the Row Breaks section, making it easy to aggregate data at multiple levels in a tabulation.

The Tabulation panel supports sorting on column breaks within the Column Breaks section.

The More Options view in the Tabulation panel has been greatly simplified and improved. Note that you must first select a Tabulation Column before the formatting fields can be modified. You may also specify a Tabulation Label for the results of the tabulation.

The Tabulation and Computed column panels now provide input verification of column names. Invalid characters in proposed column names are removed automatically, saving you from manually altering the name until all constraints are met.

The Data Dictionary view now shows tables referenced by query as well as columns.

The Bulk selection extended operation allows you to paste a list of values into a spreadsheet-like interface to specify the values for a row selection. This allows you to select rows based on multiple values without the need to specify each one individually in the Select rows panel or by editing the Macro Language code. You may also manually enter values into the spreadsheet.

The Amend by expression extended operation allows you to recompute the value of a column or specific rows of a column. Although generally this can be done with a computed column, this extended operation makes it easier, particularly if you only want to recompute specific rows.

The Select and expand rows extended operation allows you to duplicate rows in your table. You can choose the number of times that each row should appear in the table. You can also create a computed column to index expanded rows, which can make it easier when querying the subsequent data.

The String expansion extended operation splits each string in a given column based on a specified separator and expands the table so that there is one row for each portion of the split string. A new column contains the individual portions.

The Link tables and Merge tables panels now open to the folder of the current base table, if possible.

You can now overwrite an existing query when saving a TRS analysis as a Quick Query.

On the Export tab, CSV and Compressed CSV have been combined into Delimited Text. Selecting Delimited Text presents you with options that you can use to customize how your data is exported.

Selecting Microsoft Excel from the Export tab now presents you with options that you can use to customize how your data is exported.

Macro Language Workshop

When changes are made in the analysis pane in Macro Language Workshop, an orange pencil icon () is displayed in the bottom right corner of the pane. Clicking the icon saves the file.

A tooltip containing column information such as the name, label, and data type is provided when you place your pointer over a column header in Grid View.

When you place your pointer over a column header in Grid View, a drop-down arrow appears that provides the same menu as the Trillion-Row Spreadsheet. This menu allows you to sort up, sort down, or hide the column.

When you select Hide from the column header drop-down menu in Grid View, a corresponding <colord> operation is inserted in the Macro Language code in the analysis pane in Macro Language Workshop.

When you right-click on a row in Grid View, you are now presented with the same options that are offered in the Trillion-Row Spreadsheet (e.g., Copy, Select rows, Analyze, Sort).

A new View bar appears on the right side of the Results pane after a query has been run. The View bar contains the Grid View (), Single-Row View (), Spreadsheet View (), and Data Dictionary () icons, which have the same functionality as the icons in the View bar in the Results pane of TRS.

The Data Dictionary view now shows tables referenced by query as well as columns.

The keyboard shortcut Shift+Ctrl+Enter (or Shift+Cmd+Enter) creates a new Macro Language Workshop window containing only the selected code from the current MLW editor and runs that code immediately (assuming it constitutes a valid query). Alternatively, the menu item File > Export > and run selection in new MLW can be used instead of the keyboard shortcut.

The behavior of Macro Language Workshop has changed with respect to chained queries saved in versions prior to Version 10. (Chained queries are queries that have another query as their base table.) The File > Load menu option loads just the operations of the query, with a prepended <base> operation pointing to the original base query. The File > Load resolving all ops menu option (previously named Load in full) recursively loads all the operations from the query and its dependencies. This option will also discard saved text source, regenerating formatted XML from the operations. Note that this type of chained query is generally obsolete in Version 11, where base tables/queries are expected to be specified with <base> ops.

The following menu items have been moved from the File menu to the File > Export submenu: Export to new TRS, Export to save data as table, and Export to save data for FTP.

The menu item File > Export to new MLW has been added, which effectively clones your current Macro Language Workshop.

The new menu item File > Export > library to workspace installs libraries into the scope of the workspace. The exported XML should consist of <library> and/or <import> forms. Note that all operations and extended operations in the Analysis Timeline in the Trillion-Row Spreadsheet have access to any blocks defined in the workspace.

The menu item File > Export as window in workspace has been moved and renamed to Run > Render as window in workspace.

The menu item Code > Remove TRS decorations has been moved to a new submenu as Code > TRS postprocessing > Remove all decorations.

There is a new Code > Enable all operations in timeline menu item that enables all rolled-back operations in a query exported from the middle of a TRS timeline.

The Code > Download query text menu item downloads the contents of the MLW editor as a text file to the client. Conversely, the Code > Upload query text menu item uploads a text file from the client into the MLW editor.

The Run > Render to static HTML target menu item runs the query and displays the results as static HTML in a new browser tab.

The keyboard shortcut Ctrl+Enter (or Cmd+Enter) now corresponds to what was last clicked on the Run menu. For example, if Run > Render standalone was last clicked, the keyboard shortcut would correspond to that action. If nothing has been clicked, the default is Run > Render. Previously, this keyboard shortcut always corresponded to Run > Render.

Cut, Copy, and Paste are now available from the right-click menu in the analysis pane in Macro Language Workshop.

Table Uploader

The new Table Uploader available from the Tools menu replaces the Quick Uploader and Custom Uploader tools that were available in Version 10.

The new Uploader tab provides a streamlined, wizard-like interface that guides you through a series of simple steps to upload your data to the 1010data Insights Platform. The new interface also offers previews of the data before it is uploaded.

The Advanced Uploader tab provides the same functionality as the Custom Uploader tool in Version 10, offering many options for fine-grained control over the data you are uploading. Additionally, you can save your customized upload configuration in a specification file and use it to save time when uploading tables with the same data format.

The Advanced Uploader now saves specifications as XML by default. It can load both old and new style specifications.

Using the Advanced Uploader, 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.

Calculator

The Expression Editor has been integrated into the Calculator to help you build valid expressions for evaluation.

Data transformation

The <sel> operation has a new syntax for selecting a disjunction of multiple boolean expressions by specifying multiple <or> child elements.

The <sel> operation has a new syntax for selecting a conjunction of multiple boolean expressions by specifying multiple <and> child elements.

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.

Application development

The favicon_ attribute has been added to <render>. This attribute accepts a URL that points to a favicon (e.g., <render favicon_="https://1010data.com/favicon.ico"/>) that can be used for the page when rendering the QuickApp for the web.

When retrieving data implicitly using the <do> clause <do valuex_="@variable" rowx_="n"> (or explicitly using action_="getdata"), n may now be negative, in which case the nth row counting backward from the last row is used.

When retrieving data implicity using the <do> clause <do valuex_="@variable" colx_="n"> (or explicitly using action_="getdata"), n may now be negative, in which case the nth column counting backward from the last column is used.

The <do> clause <do valuex_="@variable" rowx_="0"> returns column metadata (as packages).

The <do> clause <do valuex_="@variable" colx_="0"> returns a column of row numbers.

The <do> clause <do valuex_="@variable" colx_="0" rowx_="0"> returns a package of table metadata.

The <loop> contruct now offers the following alternatives to <loop with_="@var">

  • <loop withrows_="@var">
  • This attribute provides the same functionality as the with_ attribute.
  • <loop withcols_="@var">
  • After the <outer> query runs, the <inner> query is executed for each column in the result set.
  • <loop withtable_="@var" breaks_="[LIST_OF_COLUMNS]">
  • After the <outer> query is executed, the entire result set is placed as a table value in the variable specified by withtable_, and then the <inner> query is executed once (unless either the while_ or until_ attribute is also specified).
  • <loop withvalue_="@var">
  • After the <outer> query is executed, the value of the first row of the first column is placed in the variable specified by withvalue_. The <inner> query is executed once (unless either the while_ or until_ attribute is also specified).

Blocks

The <text> form expands into a text string. The <text> form expands its contents under the ordinary block code rules, but with the option of further marking the { and } scalar context delimiters for a scalar expression so that text contents of the form that contain these delimiters as literal text need not be specially marked up.

The <html> form expands into an inert <content type_="html"> form containing an HTML string. The <html> form expands its contents under the ordinary block code rules, but with the option of further marking the { and } scalar context delimiters for a scalar expression so that HTML contents of the form that contain these delimiters as literal text need not be specially marked up. In addition, attributes in the <html> tag define variables within <html> that are properly escaped for HTML.

QuickApps

The new widget <widget class_="expression"> allows an Expression Editor to be included as a widget within a QuickApp.

The new widget <widget class_="spy"> detects the size of the display area used to show a QuickApp and changes values in a package variable when the dimensions of the display area change. These values can then be used to change dimensional aspects of the QuickApp.

The new widget <widget class_="value"> displays the value of its bound variable, formatted and updated whenever the variable changes. For convenience, special values are also handled: lists and packages are displayed as JSON; table values are displayed as tables; and XML is displayed in text form.

Windowed widgets (i.e., <widget class_="widget" windowed_="1">) now accept wintitlebar_="0", which creates a window with no title bar or other basic structural elements of a window, such as a window frame or window controls. (Note that a window created in this manner cannot be manually moved or resized.)

Windowed widgets are now removable by default (i.e., the global widget attribute removable_ now has a default value of 1 when used with <widget class_="widget" windowed_="1">).

The attribute itemspacing_ has been added to the radio and checklist widgets to control the spacing between items. It is specified as a typical CSS distance (i.e., a non-negative number and a measurement unit like em, px, etc.) The default is 1em, which matches prior behavior.

The attribute historyvalue_ has been added to <widget class_="field">. If a list variable is bound via this attribute, then the Up Arrow and Down Arrow keys can be used within the field to access elements from that variable's value, copying them into the field. Entering a new value automatically appends it to the history. The attribute is only applicable to plain fields (i.e., when the type_ attribute is not specified).

For <widget class_="field">, the attribute immediate_ now works when the type_ attribute is not specified (which by default creates a plain text entry field). Setting immediate_="1" automatically updates the dynamic variable associated with the value_ attribute without requiring the user to click outside the field widget or press Enter. Previously, this attribute only worked with type_="numeric".

The breaks_ attribute has been added to <widget class_="dropdown"> and <widget class_="dropdownlist">. This attribute accepts a column name. Items that have the same value in the specified column are grouped together in the drop-down list.

The slider widget now supports the attribute slidercolor_, which accepts a valid CSS color that specifies the background color of the slider.

The attribute guise_ has been added to <widget class_="button">, which allows the widget to visually appear as a button, a span of text, or an image. Regardless of the guise, the widget behaves as a button.

The attribute alttextstyle_ has been added to both <widget class_="text"> and <widget class_="button" guise_="text">, which allows the widget to change the style of the text when the user points to the widget. The alttextstyle_ attribute accepts CSS.

The attributes altcolor_ and alttext_ have been added to <widget class_="text">, which allows the widget to change the color of the text or the displayed text when the user points to the widget.

The performance of <widget class_="querytree"> has been vastly improved when selecting or expanding nodes with a large number of subnodes.

  • The attribute trunc_ has been added to <widget class_="querytree">. Accepts a 1 or 0. When trunc_="1", subnodes of fully-selected nodes are not included in the widget's value (i.e., stored in the variable(s) passed to value_ and/or pathvalue_). When trunc_="0", the behavior is as before. The default is 0.
  • If a <layer> query within a <widget class_="querytree"> yields three columns, the third column is construed as the number of children for each item (row). Including this information makes it unnecessary to issue a query to the next layer to determine whether a node has children or not, greatly improving performance when expanding nodes with a large number of children higher up in the hierarchy.
  • The attribute uniform_ has been added to <widget class_="querytree">, which specifies whether all branches in the tree are of uniform depth and there are no empty higher-level categories. Accepts a 1 or 0. When uniform_="1", it is assumed that all leaf nodes are at the same, final level in the hierarchy. When uniform_="0", the behavior is unchanged. The default is 0.

    This obviates checking whether a node has children or not (either by issuing a query or by using the third column in the <layer> query, if present), since that is determined solely by whether or not the node is generated by the last <layer> query.

The attribute textmode_ has been added to <widget class_="querytree">, which specifies whether the entries in the query tree are construed as plain text or as HTML. Valid values are plain and html. The default is plain.

The attribute listvalue_ has been added to <widget class_="querytree">. The listvalue_ attribute accepts a list-value variable, which is set to a list of lists of pairs representing a disjunction of conjunctions of disjunctive selections. The value of this variable is generally passed to the conjsel(L) function, which creates a selection expression from the list.

The attribute overflow_ has been added for a plain <layout> (i.e., one that does not have a type_ specified). The overflow_ attribute specifies the behavior when the contents exceeds the bounds of the layout.

When the label_ attribute is supplied to a plain <layout>, and that layout is scrollable, the label is now shown in a static bar across the top that does not move even if the rest of the layout is scrolled. This contrasts with earlier behavior, in which the label was initially at the top but could be scrolled out of view. Also, a labelheight_ attribute is available to change the amount of space reserved for the label. The default is 25.

For <layout type_="window" modal_="1">, there is now an implicit default center_="1" attribute, which can be overridden with center_="0". The default for non-modal window layouts is still center_="0".

The attribute titlebar_ has been added to <layout type_="window">. This attribute determines whether or not to display the window with a title bar, which may be desirable when creating modal dialogs with modal_="1". Accepts a 1 or 0. The default is 1.

Functions

Object functions can be used to check the existence, type, and accessibility of objects such as folders, tables, and queries on the 1010data Insights Platform. The following object functions have been added.

  • obj_exists(path)
  • Returns a boolean value that indicates if the object at the given path exists on the 1010data Insights Platform.
  • obj_isfolder(path)
  • Returns a boolean value that indicates if the object at the given path is a folder.
  • obj_istable(path)
  • Returns a boolean value that indicates if the object at the given path is a table.
  • obj_isphysical(path)
  • Returns a boolean value that indicates if the object at the given path is a physical table saved on the 1010data Insights Platform.
  • obj_istemp(path)
  • Returns a boolean value that indicates if the object at the given path is a temporary table in the user's session.
  • obj_isquery(path)
  • Returns a boolean value that indicates if the object at the given path is a query.
  • obj_own(path)
  • Returns a boolean value that indicates if the object at the given path is owned by the current user.
  • obj_readable(path)
  • Returns a boolean value that indicates if the object at the given path can be accessed by the current user.
  • obj_runnable(path)
  • Returns a boolean value that indicates if the object at the given path can be opened by the current user.
  • obj_writable(path)
  • Returns a boolean value that indicates if the object at the given path can be modified and saved by the current user.
  • obj_type(path)
  • Returns the type of the object at the given path.
  • obj_parent(path)
  • Returns the name of the folder in which the object at the given path is contained.
  • obj_owner(path)
  • Returns the owner of the object at the given path.
  • obj_title(path)
  • Returns the title of the object at the given path.
  • obj_sdesc(path)
  • Returns the short description of the object at the given path.
  • obj_ldesc(path)
  • Returns the long description of the object at the given path.
  • obj_mode(path)
  • Returns the display mode of the object at the given path.
  • obj_name(path)
  • Returns the name of the object at the given path.
  • obj_inherits(path)
  • Returns a boolean value that indicates if user access to the object at the given path is inherited from the parent folder.
  • obj_users(path)
  • Returns the list of users that have specifically been given permission to access the object at the given path.
  • obj_uploaders(path)
  • Returns the list of users that have specifically been given permission to save or upload objects to the folder at the given path.
  • obj_children(path)
  • Returns the list of objects contained within the folder at the given path.
  • obj_parents(path)
  • Returns the hierarchical list of folders in which the object at the given path is contained.

The function goodcolname(X) returns a boolean value indicating whether a given string would be a valid/recommended column name.

The function goodname(X) returns a boolean value indicating whether a given string would be a valid name for a table, folder, or query.

The function goodpath(X) returns a boolean value indicating whether a given string would be a valid path.

The function enhtml(X;Z) has been added, which returns an HTML-encoded version of the given string by escaping characters such as <, >, and &.

The function conjsel(L) has been added, which returns a selection expression that consists of the conjunction of the pairs of columns and associated values specified in the given list-value. This function is generally intended for use with the value of the listvalue_ attribute returned by the querytree widget. Together with the expanded selection form for <sel> in Version 11, this allows efficient application of a querytree-generated selection.

A Poisson regression can now be generated by g_glm(G;S;Y;XX;Z) by setting the Z parameter to 'fit_type' 'poisson'.

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

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 Platform 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

TenUp can load 64-bit integers (e.g., SQL_BIGINT) as a 1010data bigint column. 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.

SDKs

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.

1010data API

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.