Impala - Query Language Basics
Impala Data types
The following table describes the Impala data types.
|Sr.No||Data Type & Description|
This datatype stores numerical values and the range of this data type is -9223372036854775808 to 9223372036854775807. This datatype is used in create table and alter table statements.
This data type stores only true or false values and it is used in the column definition of create table statement.
This data type is a fixed length storage, it is padded with spaces, you can store up to the maximum length of 255.
This data type is used to store decimal values and it is used in create table and alter table statements.
This data type is used to store the floating point values in the range of positive or negative 4.94065645841246544e-324d -1.79769313486231570e+308.
This data type is used to store single precision floating value datatypes in the range of positive or negative 1.40129846432481707e-45 .. 3.40282346638528860e+38.
This data type is used to store 4-byte integer up to the range of -2147483648 to 2147483647.
This data type is used to store 2-byte integer up to the range of -32768 to 32767.
This is used to store string values.
This data type is used to represent a point in a time.
This data type is used to store 1-byte integer value up to the range of -128 to 127.
This data type is used to store variable length character up to the maximum length 65,535.
This is a complex data type and it is used to store variable number of ordered elements.
This is a complex data type and it is used to store variable number of key-value pairs.
This is a complex data type and used to represent multiple fields of a single item.
Comments in Impala
Comments in Impala are similar to those in SQL.In general we have two types of comments in programming languages namely Single-line Comments and Multiline Comments.
Single-line comments − Every single line that is followed by "—" is considered as a comment in Impala. Following is an example of a single-line comments in Impala.
-- Hello welcome to tutorials point.
Multiline comments − All the lines between /* and */ are considered as multiline comments in Impala. Following is an example of a multiline comments in Impala.
/* Hi this is an example Of multiline comments in Impala */