Help Center > > User Guide> MRS Cluster Component Operation Guide> Using CarbonData> About CarbonData Table

About CarbonData Table

Updated at: Nov 06, 2019 GMT+08:00


CarbonData tables are similar to tables in the relational database management system (RDBMS). RDBMS tables consist of rows and columns to store data. CarbonData tables have fixed columns and also store structured data. In CarbonData, data is saved in entity files.

Data Types Supported

CarbonData tables support the following data types:

  • Int
  • String
  • BigInt
  • Decimal
  • Double
  • TimeStamp

Table 1 describes the details about the data types.

Table 1 CarbonData data types

Data Type



4-byte signed integer ranging from -2,147,483,648 to 2,147,483,647


If non-dictionary columns have Int data, the data is saved as BigInt data in the table.


The maximum character string length is 100,000.


Data is saved using the 64-bit technology. The value ranges from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.


The default value is (10,0) and maximum value is (38,38).


If a query condition is used, users can add BD after the number to obtain accurate results. For example, select * from carbon_table where num = 1234567890123456.22BD.


Data is saved using the 64-bit technology. The value ranges from 4.9E-324 to 1.7976931348623157E308.


The default format is yyyy-MM-dd HH:mm:ss.

Measurement of all Int data is processed and displayed using the BigInt data type.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel