Hive Data Type Conversions

...

Source Data Type

Supported?

D s item

	Data Type
	Data Type

Notes

array

Y

Array

bigint

Y

Integer

Info

NOTE: The

D s platform

may infer bigint columns containing very large or very small values as String data type.If needed, you can disable type inference for individual schematized sources. For more information, see Import Data Page.

binary

Y

String

boolean

Y

Bool

char

Y

String

date

Y

Datetime

decimal

Y

Decimal

double

Y

Decimal

float

Y

Decimal

Info

NOTE: On import, some float columns may be interpreted as Integer data type in the

D s platform

. To fix, you can explicitly set the column's data type to Decimal in the Transformer page.

int

Y

Integer

map

Y

Object

smallint

Y

Integer

string

Y

String

struct

Y

Object

timestamp

Y

Datetime

tinyint

Y

Integer

uniontype

N

varchar

Y

String

Notes:

After a dataset has been imported using custom SQL from Hive, disabling type inference may not revert to the source data types for some columns. The workaround is to create a new imported dataset using the same custom SQL with type inference disabled before import. After the dataset is created, use it as a replacement for the corrupted instances of the previous Hive dataset.

Write/Publish

Create new table

...

Page tree

Versions Compared

Old Version 1

New Version 2

Key

Write/Publish

Create new table