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.

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