On this page

Show all

Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ HetuEngine SQL Syntax/ Data Type/ Integer

Integer

Updated on 2022-11-18 GMT+08:00

View PDF

**Table 1** Integer
Name	Description	Storage Space	Value Range	Literal
TINYINT	Tiny integer	8 bits	-128 to 127	TINYINT
SMALLINT	Small integer	16 bits	-32,768 to +32,767	SMALLINT
INTEGER	Integer	32 bits	-2,147,483,648 to +2,147,483,647	INT
BIGINT	Big integer	64 bits	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807	BIGINT

Example:

--Create a table containing TINYINT data:
CREATE TABLE int_type_t1  (IT_COL1 TINYINT) ;    
--Insert data of the TINYINT type:
insert into int_type_t1  values (TINYINT'10');    
--View data:
SELECT * FROM int_type_t1;  
 it_col1    
---------   
 10  
(1 row)    
--Drop a table:
DROP TABLE int_type_t1;

Parent topic: Data Type

Previous topic: Boolean

Next topic: Fixed Precision

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback