What Is Bigint in Hive

BIGINT (8-byte signed integer, from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 )

What is Bigint in the Hive query?

Bigint. –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0. Decimal. Decimal. For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.

What are Hive data types?

Data Type Definition KeywordHive Data TypeDescriptionINTEGERINTEGERA signed four-byte integer.1MAP< primitive-type, data-type>An associative array of key-value pairs.REALDOUBLEA 64-bit double precision, floating-point number.SMALLINTSMALLINTA signed two-byte integer, from -32,768 to 32,767.