hadoop - Hive 支持无符号数字数据类型

Question

我正在尝试将通常为无符号整数和无符号 Bigint 的数据加载到配置单元表中。根据 Hive 文档，我看到它只支持有符号整数和有符号大整数

INT/INTEGER (4-byte signed integer, from -2,147,483,648 to 2,147,483,647) BIGINT (8-byte signed integer, from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807)

有没有办法将无符号数值(tinyint、smallint、int、bigint)存储到 Hive 表中？

Answer 1

长篇小说:摘自Hive documentation关于DECIMAL数据类型

The DECIMAL type in Hive is based on Java's BigDecimal which is used for representing immutable arbitrary precision decimal numbers ... limited to 38 digits ...

As of Hive 0.13 users can specify scale and precision when creating tables ...
  ¤ if scale is not specified, it defaults to 0 (no fractional digits)
  ¤ if no precision is specified, it defaults to 10.

Integral literals larger than BIGINT must be handled with DECIMAL(38,0). The Postfix BD is required ...

所以 DECIMAL 绝对是您要查找的数据类型。