Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
828
|
| Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
| NUMERIC DATA TYPES | |||||
| BIGINT | INTEGERS | X | X | X | 8 byte integer |
| INT | INTEGERS | X | X | X | 4 byte integer |
| SMALLINT | INTEGERS | X | X | X | 2 byte integer. Range from |
| TINYINT | INTEGERS | X | X | X | 1 byte integer |
| DECIMAL | INTEGERS | X | X | X | Variable-precision decimal. Only available starting with Hive 0.11.0 Decimal type is limited to 38 digits in Hive |
| DOUBLE | INTEGERS | X | X | X | approximately -10308 to 10308 |
| FLOAT | INTEGERS | X | X | X | Specifies a signed four-byte, floating-point number. |
| BOOLEAN | |||||
| BOOLEAN | BOOLEAN | X | X | X | true or false |
| CHARACTER DATA TYPES | |||||
| STRING | STRINGS | X | X | X | Character strings enclosed within single or double quotes with maximum length 2 gigabytes. Sequence of characters in a specified character set. |
| DATE & TIME DATA TYPES | |||||
| TIMESTAMP | INTEGERS, STRING | X | X | X | Timestamps are interpreted to be timezoneless and stored as an offset from the UNIX epoch. Convenience UDFs for conversion to and from timezones are provided (to_utc_timestamp, from_utc_timestamp). Only available starting with Hive 0.8.0 |
| DATE | Form of date is {{YYYY-MM-DD}} and ranges from 0000-01-01 to 9999-12-31. Only available starting with Hive 0.12.0 | ||||
| BINARY LARGE OBJECTS | |||||
| BINARY | BLOBs | X | X | X | Arbitrary bytes(no validation), expressed as hexadecimal |
| COMPLEX TYPES | |||||
| ARRAY | n/a | X | X | X | A collection of one or more ordered elements (indexable lists). ARRAY<data_type>. Elements can be accessed using the [n] notation where n is an index (zero-based) into the array. For example for an array A having the elements ['a', 'b', 'c'], A[1] retruns 'b'. |
| MAP | n/a | X | X | X | A collection of (key-value tuples) of the form MAP<primitive_type, data_type>.The elements are accessed using ['element name'] notation |
| STRUCT | n/a | X | X | X | A collection of one or more elements of form STRUCT<col_name : data_type [COMMENT col_comment], ...> The elements within the type can be accessed using the DOT (.) notation. |
| UNION | n/a | X | X | X | A collection of one or more elements of form UNIONTYPE<data_type, data_type, ...> |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017