Exasol Connector

Exasol Connector

Exasol and transformation data types

Exasol and transformation data types

The following table lists the Exasol data types that Data Integration supports and the corresponding transformation data types:
Exasol Data Type
Transformation Data Type
Range and Description
Bigint
Big integer
-9.99999999999999E+16 to 9.99999999999999E+17 .
Precision of 18, scale of 0.
Decimal value.
Boolean
String
You can specify the text for both options. When added to a form, the field properties control whether the attribute is displayed as two radio buttons, a check box, or a list. Input must be True or False.
Char
String
1 to 104857600 characters.
Date
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision of 29, scale of 9 (precision to nanosecond).
Decimal
Decimal
You can specify the level of precision up to ten decimal places and the minimum and maximum values from -1,000,000,000 to 1,000,000,000.
Double
Double
Double-precision floating-point numeric value. Precision 15.
Int
Integer
-999999999 to 999999999.
Precision of 9, scale of 0.
Decimal value.
Interval Year to Month
Big integer
-999999999-11 to 999999999-11.
Interval Day to Sec
Big integer
-999999999 23:59:59.999 to 999999999 23:59:59.999.
Timestamp
Time
January 1,0001 00:00:00 to December 31,9999 23:59:59.997997.
Timestamp with local TZ
Time
January 1,0001 00:00:00 to December 31,9999 23:59:59.997997.
Varchar
String
1 to 104857600 characters.
The following table lists the aliases for Exasol Decimal data types:
Exasol Decimal Data Type
Exasol Data Type
Description
Decimal (9,0)
Integer
To enable the alias data type, specify the following entry in the query:
'EXA_TYPE_ALIAS=INTEGER'
Decimal (18,0)
Bigint
To enable the alias data type, specify the following entry in the query:
'EXA_TYPE_ALIAS=BIGINT'
Example of a query to enable alias data types
Create table aliasdataTable (intColumn D(9,0) comment is 'EXA_TYPE_ALIAS=INTEGER', bigintColumn decimal(18,0) comment is 'EXA_TYPE_ALIAS=BIGINT');