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

SAP HANA Source and Google BigQuery Target

SAP HANA Source and Google BigQuery Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a SAP HANA source and a Google BigQuery target:
SAP HANA Source Data Type
Google BigQuery Target Data Type
alphanum(
precision
), 1 <= p <= 127
string
array
bytes
bigint
int64
binary(
size
), 1 <= s <= 2000
bytes
boolean
bool
char(
size
), 1 <= s <= 2000
string
date
date
decimal
string
decimal(1,1)
numeric
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(2,s), 1 <= s <= 2
numeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(3,s), 1 <= s <= 3
numeric
decimal(38,s), 10 <= s <= 38
bignumeric
decimal(4,s), 1 <= s <= 4
numeric
decimal(5,s), 1 <= s <= 5
numeric
decimal(6,s), 1 <= s <= 6
numeric
decimal(7,s), 1 <= s <= 7
numeric
decimal(8,s), 1 <= s <= 8
numeric
decimal(p,1), 18 <= p <= 0
int64
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
numeric
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29
bignumeric
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 32, 0 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 33, 0 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 34, 0 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 35, 0 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 36, 0 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 37, 0 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 38, 0 <= s <= 37
bignumeric
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
numeric
double
float64
float
float64
integer
int64
nchar(
size
), 1 <= s <= 2000
string
nvarchar(
size
), 1 <= s <= 5000
string
real
float64
real
float64
seconddate
datetime
shorttext(
precision
), 1 <= p <= 5000
string
smalldecimal
string
smallint
int64
st_geometry
bytes
st_point
bytes
time
time
timestamp
datetime
timestamp
string
tinyint
int64
varbinary(
size
), 1 <= s <= 5000
bytes
varchar(
size
), 1 <= s <= 5000
string

0 COMMENTS

We’d like to hear from you!