...
| Impala Type | Impala Range | Ultra Type | Ultra Range |
|---|---|---|---|
| STRING | Maximum of 32,767 bytes | string | Unlimited |
| INT | -2147483648 to +2147483647 | int | -2,147,483,648 to +2,147,483,647 |
| short | -32,768 to +32,767 | ||
| byte | -128 to +127 | ||
| FLOAT | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) | float | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) |
| DOUBLE | 4.94065645841246544e-324d to 1.79769313486231570e+308 (positive or negative) | double | 4.94065645841246544e-324d to 1.79769313486231570e+308d (positive or negative) |
| float | 1.40129846432481707e-45 to 3.40282346638528860e+38 (positive or negative) | ||
| BOOLEAN | TRUE or FALSE | boolean | true or false |
| BIGINT | -9223372036854775808 to +9223372036854775807 | long | -9223372036854775808 to +9223372036854775807 |
| int | -2,147,483,648 to +2,147,483,647 | ||
| short | -32,768 to +32,767 | ||
| byte | -128 to +127 | ||
| REAL | 4.94065645841246544e-324d to +1.79769313486231570e+308 (positive or negative) | double | 4.94065645841246544e-324d to 1.79769313486231570e+308d (positive or negative) |
| SMALLINT | -32768 to +32767 | short | -32,768 to +32,767 |
| byte | -128 to +127 | ||
| TINYINT | -128 to +127 | byte | -128 to +127 |
| TIMSTAMP | YYYYMMDDHH | date | yyyyMMddHH |
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
| Scroll pagebreak |
|---|