Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Netezza Source and Databricks Delta Target

Netezza Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a Netezza source and a Databricks Delta target:
Netezza Source Data Type
Databricks Delta Target Data Type
bigint
long
boolean
boolean
byteint
integer
char(
size
), 1 <= s <= 64000
string
date
string
double
double
integer
integer
interval
string
nchar(
size
), 1 <= s <= 16000
string
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38
nvarchar(
size
), 1 <= s <= 16000
string
real
float
smallint
integer
st_geometry(
precision
), 1 <= p <= 63001
binary
time
string
timestamp
timestamp
timetz
string
varbinary(
size
), 1 <= s <= 64000
binary
varchar(
size
), 1 <= s <= 64000
string

0 COMMENTS

We’d like to hear from you!