Hive - Converting a string to bigint

hive hiveql data-conversion
activelearner picture activelearner · Mar 5, 2015 · Viewed 36.4k times · Source

Suppose I have a string like '00321' and I want to convert it into a BIGINT in Hive, how would I do it?

Follow-up question: would the resulting BIGINT value be 321 or 00321?

Answer

Jeremy Beard picture Jeremy Beard · Mar 5, 2015

You can use the CAST function to cast your STRING to a BIGINT, like so:

SELECT CAST('00321' AS BIGINT) FROM table;

As a BIGINT it will show on the screen and in delimited text files as 321.

Related questions

Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More
How to select current date in Hive SQL

How do we get the current system date in Hive? In MySQL we have select now(), can any one please help me to get the query results. I am very new to Hive, is there a proper documentation for Hive …

Read More
How to Update/Drop a Hive Partition?

After adding a partition to an external table in Hive, how can I update/drop it?

Read More