Data type conversions from DataStage to BigQuery
When writing data, the BigQuery Connector stage converts InfoSphere® DataStage® data types to BigQuery data types.
Usage
The following table shows the mapping rules between InfoSphere DataStage data types and BigQuery
data types:
| InfoSphere DataStage data types | BigQuery data types |
|---|---|
| SQL_BIGINT | INTEGER |
| SQL_BINARY | BYTES |
| SQL_BIT | BOOLEAN |
| SQL_CHAR | STRING |
| SQL_DATE | DATE |
| SQL_DECIMAL | NUMERIC |
| SQL_DOUBLE | FLOAT |
| SQL_FLOAT | FLOAT |
| SQL_INTEGER | INTEGER |
| SQL_LONGVARBINARY | BYTES |
| SQL_LONGVARCHAR | STRING |
| SQL_NUMERIC | NUMERIC |
| SQL_REAL | FLOAT |
| SQL_SMALLINT | INTEGER |
| SQL_TIME | TIME |
| SQL_TIMESTAMP | DATETIME |
| SQL_VARCHAR | STRING |
| SQL_TINYINT | INTEGER |
| SQL_VARBINARY | BYTES |
| SQL_VARCHAR | STRING |