May 26, 2021 impala
The following table describes the Impala data type.
Sr.No | Data type and description |
---|---|
1 |
BIGINT This data type stores values, and this data type ranges from -922337203685475808 to 9223372036854775807. This data type is used in the Create table and alter table statements. |
2 |
BOOLEAN This data type stores only true or false values, which are used for column definitions of table statements. |
3 |
CHAR This data type is a fixed-length store filled with spaces that can store a maximum length of 255. |
4 |
DECIMAL This data type is used to store the hex values and is used in the create table and alter table statements. |
5 |
DOUBLE This data type is used to store floating-point values in the range of positive or negative values 4.9406564584124544e-324d -1.79769313486231570e plus 308. |
6 |
FLOAT This data type is used to store positive or negative 1.40129846432481707e-45 . 3 .40282346638528860e and 38 range of single-precision floating-point data types. |
7 |
Int This data type is used to store 4 byte integers, ranging from -2147483648 to 2147483647. |
8 |
SMALLINT This data type is used to store 2-byte integers, ranging from -32768 to 32767. |
9 |
STRING This is used to store string values. |
10 |
TIMESTAMP This data type is used to represent points in time. |
11 |
TINYINT This data type is used to store 1 byte integer values, ranging from -128 to 127. |
12 |
VARCHAR This data type is used to store variable-length characters with a maximum length of 65,535. |
13 |
ARRAY This is a complex data type that stores a variable number of ordered elements. |
14 |
Map This is a complex data type that stores a variable number of key value pairs. |
15 |
Struct This is a complex data type that represents multiple fields for a single project. |
The comments in Impala are similar to those in SQL. I n general, we have two types of comments in the programming language, one-line comments and multi-line comments.
A single line of comments - followed by a line with " - " is treated as a comment in Impala. T he following is an example of a single-line comment in Impala.
-- Hello welcome to tutorials point.
A multi-line comment - All lines between / / and / are considered multi-line comments in Impala. T he following is an example of a multi-line comment in Impala.
/* Hi this is an example Of multiline comments in Impala */
The operators in Impala are similar to those in SQL. S ee our SQL tutorial by clicking on the link below for sql-operators.