Data types

Blazing SQL engine supports most of the same data types that RAPIDS cudf supports supports.

The table below shows all the data types supported with their mapping to cuDF.

Data types

Data Kind

Scalar

cuDF Alias

BlazingSQL Support

SQL Equivalent

Integer

np.int8, np.int16, np.int32, np.int64, np.uint8, np.uint16, np.uint32, np.uint64

'int8', 'int16', 'int32', 'int64', 'uint8', 'uint16', 'uint32', 'uint64'

'int8', 'int16', 'int32', 'int64', 'uint8', 'uint16', 'uint32', 'uint64'

TINYINT, SMALLINT, INT, BIGINT

Float

np.float32, np.float64

'float32', 'float64'

'float32', 'float64'

DECIMAL, FLOAT, DOUBLE

Strings

str

'string', 'object'

'string', 'object'

VARCHAR

Datetime

np.datetime64

'datetime64[s]', 'datetime64[ms]', 'datetime64[us]', 'datetime64[ns]'

'datetime64[s]', 'datetime64[ms]', 'datetime64[us]', 'datetime64[ns]'

TIMESTAMP

Timedelta (duration type)

np.timedelta64

'timedelta64[s]', 'timedelta64[ms]', 'timedelta64[us]', 'timedelta64[ns]'

Currently not supported

Categorical

'category'

Convert to 'string' before creating table

VARCHAR

Boolean

np.bool

'bool'

'bool'

BOOLEAN

Note: All dtypes above are Nullable

SQL API Reference Querying data