When importing data into Datameer, it is important to know which type of data you are importing or need to import. When using your data within workbooks, certain Datameer functions only work with certain types of data. Congruently, certain functions return only a specific type of data.
Also there are data requirements when using infographic widgets to visualize your data.
64-Bit integer value
Unlimited integer value
64-Bit float value
High-precision float value
|list||a collection of multiple values of one data type|
float, big decimal, integer or big integer
float, big decimal, integer, big integer, date, string or Boolean
In mathematics integers (aka whole numbers) are made up of the set of natural numbers including zero (0,1,2,3, ...) along with the negatives of natural numbers (-1,-2,-3, ...). When talking about Integers in computer programming, it is necessary to define a minimum and maximum value. Datameer uses a 64-bit integer which allows the user to represent whole numbers between -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Big integers are like integers, but they are not limited to 64 bits. They are represented using arbitray-precision arithmetic. Big integers represent only whole numbers. Big integers in Datameer are treated differently than in Hive because Datameer allows a larger range of values, so they are written as strings into a Hive table if you export.
In mathematics we have real numbers so that we can represent fractions (1/2, 12/68) or numbers with decimal places (12.75, -18.35). In Datameer we use double precision floating-point representation (aka float) to manipulate and represent real numbers. The complete range of numbers that can be represented this way is approximately 2 -1022 through (1+(1-2 -52))x2 1023.
Big decimals are similar to float values. The main advantage of this data field type is that they are exact to the number of decimal places for which they are configured, float values may be inaccurate in certain cases. If a number has more decimal places than big decimal was configured for, then the number will be rounded. The number of decimal places can be configured in
32 digits is the default precision used by Datameer for big decimal values.
In Datameer, data in the DATE primitive data type is always represented in a Gregorian, month-day-year (MDY) format (e.g., "Sep 16, 2010 02:56:39 PM"). Datameer will detect if your data should be parsed into the DATE data type during ingest. This can also be done after ingest as other data types can be converted to the DATE primitive data type using workbook functions.
Boolean data in computing has two values, either TRUE or FALSE. It is used in many logical expressions and is derived from Boolean algebra created by George Boole in the 19th century.
In Datameer multiple values can be combined into a list. Lists are a series of values of a single data type, which starts counting from zero (0).