question Re: Hive BIGINT vs INT storage and performance? in Archives of Support Questions (Read Only)

Hive BIGINT vs INT storage and performance?

gdhawas — Thu, 23 Feb 2017 16:03:27 GMT

If I'm having a column with BIGINT as datatype and it's having a value in INT's range, then will it take all the 8bytes or just 4bytes for storing?

what about BIGINT and INT?

for example if I'm having a column with BIGINT as datatype and I'm inserting value in INT's range, will it take 8byte(as for BIGINT) or just 4bytes considering it is in INT range?

Re: Hive BIGINT vs INT storage and performance?

aervits — Fri, 24 Feb 2017 00:54:18 GMT

@Gunjan Dhawas

based by the wiki, it will take 8 bytes.

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)

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-IntegralTypes(TINYINT,SMALLINT,INT/INTEGER,BIGINT)

and https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-TypeSystem