User Guide

10.5.1
- 10.5.4
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1

Back Next

Cassandra, ODBC, and Transformation Data types

When you import a Cassandra column family as a data object, the transformation data types corresponding to the ODBC data types appear in the Developer Tool.

The Informatica Cassandra ODBC driver reads Cassandra data and converts the Cassandra data types to ODBC data types. The Data Integration Service converts the ODBC data types to transformation data types.

The following table lists the Cassandra data types and the corresponding ODBC and transformation data types:

Cassandra Data Types	ODBC Data Types	Transformation Data Types
ASCII	Varchar	Varchar
Bigint	Bigint	Bigint
Blob	Varbinary	Varbinary
Boolean	Bit	Bit
Date	Date	Datetime
Decimal	Decimal	Decimal
Double	Double	Double
Float	Real	Real
Inet	Varchar	Varchar. Cassandra Inet data type supports IP addresses in IPv4 and IPv6 formats. Informatica Cassandra ODBC driver does not support reading or writing IP addresses in IPv6 format.
Int	Integer	Integer
Smallint	Smallint	Integer
Text	Wvarchar	Varchar
Timestamp	Varchar	Time stamp. The Informatica Cassandra ODBC driver treats the Time stamp data type values in Coordinated Universal Time (UTC) format. Range of Timestamp value is 1601-01-01 00:00:00.000 to 9999-12-31 23:59:59.999
Timeuuid	Varchar	Varchar
Tinyint	Tinyint	Integer
Uuid	Varchar	Varchar. When you use comparison operators in data of Uuid data type, enclose values of Uuid data type within single quotation marks. For example, in the following query, the value for the Uuid data type is enclosed within single quotation marks: DELETE from pc.map_nesting_tgt_vt_col_map2 where pc.map_nesting_tgt_vt_col_map2.col_uuid='152d2030-14e6-11e4-aef1-fd88d8253a43';
Varchar	Varchar	Varchar
Varint	Numeric	Numeric

The Varint data type is stored internally as Long data type in the Spark execution plan.

Rename Saved Search

Table of Contents

User Guide

User Guide

Cassandra, ODBC, and Transformation Data types

Cassandra, ODBC, and Transformation Data types