{"id":79720,"date":"2020-08-27T09:00:24","date_gmt":"2020-08-27T03:30:24","guid":{"rendered":"https:\/\/techvidvan.com\/tutorials\/?p=79720"},"modified":"2020-08-27T09:00:24","modified_gmt":"2020-08-27T03:30:24","slug":"apache-hive-built-in-functions","status":"publish","type":"post","link":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/","title":{"rendered":"Hive Built-in Functions and their Return Type with Examples"},"content":{"rendered":"

In Apache Hive, there are various functions available for performing several tasks. These functions are known as Built-in functions. In this article, we will study Hive Built-in functions.<\/p>\n

The Hive Built-in functions are categorized as Mathematical function, Collection function, Type conversion function, Date function, Conditional function, and String function. We will study all of these Hive Built-in functions in detail.<\/p>\n

Let’s start!!!<\/p>\n

Hive Built-in Functions<\/h3>\n

Hive was designed to perform SQL like queries on the huge datasets stored in HDFS. It supports different types of data types, as well as operators that are not supported by different databases.<\/p>\n

For performing some specific mathematical and arithmetic operations, Hive provides some built-in functions. These built-in functions extract data from tables in hive and process the calculations.<\/p>\n

For using Hive built-in functions in our applications, we have to first check the application requirement. It is possible to call these hive built-in functions directly in our application.<\/p>\n

There are several types of Hive Built-in Functions such as Mathematical function, Collection function, Type conversion function, Date function, Conditional function, and String function.<\/p>\n

Now, let us study each Hive Built-in Functions in detail.<\/p>\n

1. Mathematical Functions<\/h4>\n

The Hive Built-in Mathematical functions are used for performing mathematical calculations. Most of the mathematical function returns NULL when the arguments(s) are NULL.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
abs(DOUBLE a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the absolute value of the number passed \u2018a\u2019.<\/span><\/td>\n<\/tr>\n
round(DOUBLE a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the rounded BIGINT value of the number passed \u2018a\u2019.\u00a0<\/span><\/td>\n<\/tr>\n
round(DOUBLE a, INT d)<\/td>\nDOUBLE<\/span><\/td>\nIt will return a rounded value of \u2018a\u2019 to \u2018d\u2019 decimal places.<\/span><\/td>\n<\/tr>\n
bround(DOUBLE a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the rounded BIGINT value of the number passed \u2018a\u2019 by using HALF_EVEN rounding mode. It is also known as the Gaussian rounding or the bankers’ rounding.\u00a0<\/span><\/p>\n

Example: bround(2.5) = 2, bround(3.5) = 4.<\/span><\/td>\n<\/tr>\n

bround(DOUBLE a, INT d)<\/td>\nDOUBLE<\/span><\/td>\nIt will return a rounded value of \u2018a\u2019 to \u2018d\u2019 decimal places by using HALF_EVEN rounding mode.<\/span><\/p>\n

Example: bround(8.25, 1) = 8.2, bround(8.35, 1) = 8.4.<\/span><\/td>\n<\/tr>\n

floor(DOUBLE a)<\/td>\nBIGINT<\/span><\/td>\nIt will return the maximum BIGINT value which is equal to or less than the number passed \u2018a\u2019.<\/span><\/td>\n<\/tr>\n
ceil(DOUBLE a), ceiling(DOUBLE a)<\/td>\nBIGINT<\/span><\/td>\nIt will return the minimum BIGINT value which is equal to or greater than the number passed \u2018a\u2019.<\/span><\/td>\n<\/tr>\n
rand(), rand(INT seed)<\/td>\nDOUBLE<\/span><\/td>\nIt will return a random number, which changes from row to row, and that is uniformly distributed from 0 to 1. By specifying the <\/span>seed will ensure that the generated random number sequence is deterministic.<\/span><\/td>\n<\/tr>\n
log10(DOUBLE a), log10(DECIMAL a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the base-10 logarithm of the argument passed \u2018a\u2019.\u00a0<\/span><\/td>\n<\/tr>\n
log2(DOUBLE a), log2(DECIMAL a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the base-2 logarithm of the argument passed \u2018a\u2019.\u00a0<\/span><\/td>\n<\/tr>\n
log(DOUBLE base, DOUBLE a)<\/p>\n

log(DECIMAL base, DECIMAL a)<\/td>\n

DOUBLE<\/span><\/td>\nIt will return the base-base logarithm of the argument passed \u2018a\u2019.\u00a0<\/span><\/td>\n<\/tr>\n
pow(DOUBLE a, DOUBLE p), power(DOUBLE a, DOUBLE p)<\/td>\nDOUBLE<\/span><\/td>\nIt will return a<\/span>p<\/span>.<\/span><\/td>\n<\/tr>\n
sqrt(DOUBLE a), sqrt(DECIMAL a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the square root of argument a.\u00a0<\/span><\/td>\n<\/tr>\n
bin(BIGINT a)<\/td>\nSTRING<\/span><\/td>\nIt will return the number in the binary format<\/span><\/td>\n<\/tr>\n
hex(BIGINT a) hex(STRING a) hex(BINARY a)<\/td>\nSTRING<\/span><\/td>\nIf the argument is an INT or binary, it will return the number as a STRING in the hexadecimal format. Otherwise, if the number is a STRING, then it converts each character into its hexadecimal representation and returns the resulting STRING.<\/span><\/td>\n<\/tr>\n
unhex(STRING a)<\/td>\nBINARY<\/span><\/td>\nIt is the inverse of hex. It interprets each pair of characters as a hexadecimal number and converts them to the byte representation of the number.<\/span><\/td>\n<\/tr>\n
factorial(INT a)<\/td>\nBIGINT<\/span><\/td>\nIt will return the factorial of argument \u2018a\u2019. The Valid a is [0..20].<\/span><\/td>\n<\/tr>\n
cbrt(DOUBLE a)<\/td>\nDOUBLE<\/span><\/td>\nIt will return the cube root of double value passed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2. Collection Functions<\/h4>\n

Collection functions are used for the collections. Collections means the grouping of the elements and returning the single or array of elements on the basis of the return type mentioned in the function name.<\/p>\n

The following collection functions are supported in Hive:<\/p>\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
size(Map<K.V>)<\/td>\nint<\/span><\/td>\nIt will return the number of elements in the data type map.\u00a0<\/span><\/td>\n<\/tr>\n
size(Array<T>)<\/td>\nint<\/span><\/td>\nIt will return the number of elements in the data type array.<\/span><\/td>\n<\/tr>\n
map_keys(Map<K.V>)<\/td>\narray<K><\/span><\/td>\nIt will return an unordered array that contains the keys of the input map.<\/span><\/td>\n<\/tr>\n
map_values(Map<K.V>)<\/td>\narray<V><\/span><\/td>\nIt will return an unordered array that contains the values of the input map.<\/span><\/td>\n<\/tr>\n
array_contains(Array<T>, value)<\/td>\nboolean<\/span><\/td>\nIt will return TRUE if an array contains value.<\/span><\/td>\n<\/tr>\n
sort_array(Array<T>)<\/td>\narray<t><\/span><\/td>\nIt will sort the input array in ascending order and return it.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3. Type Conversion Functions<\/h4>\n

The following Built-in Type Conversion functions are supported in Hive:<\/p>\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
binary(string|binary)<\/td>\nbinary<\/span><\/td>\nIt will cast the parameter passed into a binary.<\/span><\/td>\n<\/tr>\n
cast(expr as <type>)<\/td>\nExpected “=” to follow “type”<\/span><\/td>\nIt will convert the results of the expression \u2018expr\u2019 to the\u00a0 <type>.\u00a0<\/span><\/p>\n

For example, cast(‘1’ as BIGINT). It will convert the string ‘1’ to its integral representation.\u00a0<\/span><\/p>\n

If the conversion doesn\u2019t succeed then, NULL is returned.<\/span><\/p>\n

If cast(expr as boolean), then Hive returns true for the non-empty string.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

4. Date Functions<\/h4>\n

Date functions in Hive are used for performing Date Manipulations and Converting Date types from one type to another type.<\/p>\n

The following built-in date functions are supported in Hive:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type\u00a0<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
unix_timestamp(string date)<\/td>\nbigint<\/span><\/td>\nIt will Convert the time string in the format <\/span>yyyy-MM-dd HH:mm:ss to Unix timestamp (in seconds), by using the default timezone and the default locale. It will return 0 if failed.\u00a0<\/span><\/td>\n<\/tr>\n
unix_timestamp(string date, string pattern)<\/td>\nbigint<\/span><\/td>\nIt will convert the time string with the given pattern to the Unix timestamp (in seconds). It returns 0 if failed.\u00a0<\/span><\/td>\n<\/tr>\n
year(string date)<\/td>\nint<\/span><\/td>\nIt will return the year part of a date or a timestamp string.<\/span><\/p>\n

Example: year(“2020-05-11 00:00:00”) = 2020<\/span><\/td>\n<\/tr>\n

quarter(date\/timestamp\/string)<\/td>\nint<\/span><\/td>\nIt will return the quarter of the year for a date, timestamp, or string in the range 1 to 4.<\/span><\/p>\n

Example: quarter(‘2020-05-11’) = 2.<\/span><\/td>\n<\/tr>\n

month(string date)<\/td>\nint<\/span><\/td>\nIt will return the month part of a date or a timestamp string.<\/span><\/p>\n

Example: month(“2020-05-11 00:00:00”) = 05.<\/span><\/td>\n<\/tr>\n

day(string date) dayofmonth(date)<\/td>\nint<\/span><\/td>\nIt will return the day part of a date or a timestamp string.<\/span><\/p>\n

Example:<\/span><\/p>\n

day(“2020-05-11 00:00:00”) = 11.<\/span><\/td>\n<\/tr>\n

hour(string date)<\/td>\nint<\/span><\/td>\nIt will return the hour of the timestamp.<\/span><\/p>\n

Example: hour(‘2020-05-11 12:58:59′) = 12, hour(’12:58:59’) = 12.<\/span><\/td>\n<\/tr>\n

minute(string date)<\/td>\nint<\/span><\/td>\nIt will return the minute of the timestamp.<\/span><\/td>\n<\/tr>\n
second(string date)<\/td>\nint<\/span><\/td>\nIt will return the second of the timestamp.<\/span><\/td>\n<\/tr>\n
weekofyear(string date)<\/td>\nint<\/span><\/td>\nIt will return the week number of a timestamp string.<\/span><\/td>\n<\/tr>\n
extract(field FROM source)<\/td>\nint<\/span><\/td>\nIt will retrieve the fields such as days or hours from the source.\u00a0<\/span><\/p>\n

 <\/p>\n

Source must be a timestamp, date, interval or a string that can be converted into either a date or timestamp.\u00a0<\/span><\/p>\n

 <\/p>\n

The supported fields include: day, dayofweek, hour, minute, month, quarter, second, week and year.<\/span><\/p>\n

Examples:<\/span><\/p>\n

    \n
  1. select extract(month from “2020-05-11”) results in 05.<\/span><\/li>\n
  2. select extract(hour from “2020-05-11 05:06:07”) results in 5.<\/span><\/li>\n<\/ol>\n<\/td>\n<\/tr>\n
current_date<\/td>\ndate<\/span><\/td>\nIt will return the current date at the start of query evaluation. All the calls of the current_\u00a0 date function within the same query return the same value.<\/span><\/td>\n<\/tr>\n
current_timestamp<\/td>\ntimestamp<\/span><\/td>\nIt will return the current timestamp at the start of query evaluation. All the\u00a0 calls of the current_timestamp function within the same query return the same value.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

5. Conditional Functions<\/h4>\n

We use Conditional function for conditional values checks. The following are the built-in conditional function supported by Hive:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
if(boolean testCondition, T valueTrue, T valueFalseOrNull)<\/td>\nT<\/span><\/td>\nIt returns the valueTrue when testCondition is true. It returns valueFalse Or Null otherwise.<\/span><\/td>\n<\/tr>\n
isnull( a )<\/td>\nboolean<\/span><\/td>\nIt will return true if argument \u2018a\u2019 is NULL and false otherwise.<\/span><\/td>\n<\/tr>\n
isnotnull ( a )<\/td>\nboolean<\/span><\/td>\nIt will return true if argument \u2018a\u2019 is not NULL and false otherwise.<\/span><\/td>\n<\/tr>\n
nvl(T value, T default_value)<\/td>\nT<\/span><\/td>\nIt will return default value if the value is null. Otherwise it\u00a0 returns value.<\/span><\/td>\n<\/tr>\n
COALESCE(T v1, T v2, …)<\/td>\nT<\/span><\/td>\nIt will return the first v that is not NULL, or NULL if all v’s are NULL.<\/span><\/td>\n<\/tr>\n
CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END<\/td>\nT<\/span><\/td>\nWhen a = b, it will return c.<\/span><\/p>\n

\u00a0when a = d, it will return e;<\/span><\/p>\n

else it will return f.<\/span><\/td>\n<\/tr>\n

CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END<\/td>\nT<\/span><\/td>\nWhen a = true, it will return b;\u00a0<\/span><\/p>\n

when c = true, it will\u00a0 return d;\u00a0<\/span><\/p>\n

else it will return e.<\/span><\/td>\n<\/tr>\n

nullif( a, b )<\/td>\nT<\/span><\/td>\nIt will return NULL if a=b; otherwise returns \u2018a\u2019.<\/span><\/td>\n<\/tr>\n
assert_true(boolean condition)<\/td>\nvoid<\/span><\/td>\nIt will throw an exception if\u00a0 the ‘condition’ is not true.\u00a0 otherwise it will return NULL.\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

6. STRING Functions<\/h4>\n

We use String functions for string manipulations and string operations. The following are the built-in Hive String functions:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/strong><\/td>\nReturn Type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
ascii(string str)<\/td>\nint<\/span><\/td>\nIt will return the numeric value of the first character of argument str.<\/span><\/td>\n<\/tr>\n
concat(string|binary A, string|binary B…)<\/td>\nstring<\/span><\/td>\nIt will return the string or bytes resulting from the concatenation of\u00a0 the strings or bytes passed in as arguments in order.<\/span><\/p>\n

For example, concat(‘teddy’, ‘bear’) results in ‘teddybear’. Note: It will take any number of input strings.<\/span><\/td>\n<\/tr>\n

character_length(string str)<\/td>\nint<\/span><\/td>\nIt will return the number of UTF-8 characters contained in argument str.<\/span><\/p>\n

The function char_length is shorthand for this function.<\/span><\/td>\n<\/tr>\n

decode(binary bin, string charset)<\/td>\nstring<\/span><\/td>\nIt will decode the first argument into a String using the provided character set.\u00a0<\/span><\/p>\n

If any of the arguments is null, the result will also be null. (As of Hive <\/span>0.12.0<\/span>.)<\/span><\/td>\n<\/tr>\n

encode(string src, string charset)<\/td>\nbinary<\/span><\/td>\nIt will encode the first argument into the BINARY using the provided character set. If any of the arguments is null, then\u00a0 the result will also be null.<\/span><\/td>\n<\/tr>\n
field(val T,val1 T,val2 T,val3 T,…)<\/td>\nint<\/span><\/td>\nIt will return the index of val in the list of val1,val2,val3,… or 0 if not found.\u00a0<\/span><\/p>\n

Example:<\/span><\/p>\n

field(‘Isha’,’Isha’,’says’,’hello’) returns 1.<\/span><\/p>\n

All primitive types are supported, arguments are compared using str.equals(x).\u00a0<\/span><\/p>\n

In case, if val is NULL, the return value is 0.<\/span><\/td>\n<\/tr>\n

find_in_set(string str, string strList)<\/td>\nint<\/span><\/td>\nIt will return the first occurrence of argument str in strList where strList is a comma-delimited string.\u00a0<\/span><\/p>\n

This will return null if either argument is null.\u00a0<\/span><\/p>\n

It will return 0 if the first argument contains any commas.\u00a0<\/span><\/p>\n

Example: find_in_set(‘ab’, ‘abc,b,ab,c,def’) returns 3.<\/span><\/td>\n<\/tr>\n

instr(string str, string substr)<\/td>\nint<\/span><\/td>\nIt will return the position of the first occurrence of substr in str.\u00a0<\/span><\/p>\n

This will return null if either of the arguments are null.<\/span><\/p>\n

It will return 0 if substr could not be found in str.\u00a0<\/span><\/p>\n

Note: This is not zero based. The first character in str has index 1.<\/span><\/td>\n<\/tr>\n

in_file(string str, string filename)<\/td>\nboolean<\/span><\/td>\nIt will return true if the string str appears as the entire line in the file filename.<\/span><\/td>\n<\/tr>\n
length(string A)<\/td>\nint<\/span><\/td>\nIt will return the length of the string passed.<\/span><\/td>\n<\/tr>\n
locate(string substr, string str[, int pos])<\/td>\nint<\/span><\/td>\nIt will return the position of the first occurrence of the substr in str after position pos.<\/span><\/td>\n<\/tr>\n
lower(string A) lcase(string A)<\/td>\nstring<\/span><\/td>\nIt will return the string by converting all characters of string A to lowercase.<\/span><\/p>\n

\u00a0Example, lower(‘BaR’) results in ‘bar’.<\/span><\/td>\n<\/tr>\n

parse_url(string urlString, string partToExtract [, string keyToExtract])<\/td>\nstring<\/span><\/td>\nIt will return the specified part from the URL.\u00a0<\/span><\/p>\n

The valid values for the partToExtract include HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, and USERINFO.\u00a0<\/span><\/td>\n<\/tr>\n

repeat(string str, int n)<\/td>\nstring<\/span><\/td>\nIt will repeat str n times.<\/span><\/td>\n<\/tr>\n
regexp_extract(string subject, string pattern, int index)<\/td>\nstring<\/span><\/td>\nIt will return the string extracted using the pattern.\u00a0<\/span><\/td>\n<\/tr>\n
regexp_replace(string INITIAL_STRING, string PATTERN, string REPLACEMENT)<\/td>\nstring<\/span><\/td>\nIt will return the string resulting from replacing all the substrings in INITIAL_STRING that match the java regular expression syntax defined in PATTERN with instances of REPLACEMENT.<\/span><\/td>\n<\/tr>\n
replace(string A, string OLD, string NEW)<\/td>\nstring<\/span><\/td>\nIt will return the string \u2018A\u2019 with all the non-overlapping occurrences of the OLD replaced with the NEW.<\/span><\/p>\n

Example: select replace(“aabab”, “bab”, “Z”); returns “aaZ”.<\/span><\/td>\n<\/tr>\n

reverse(string A)<\/td>\nstring<\/span><\/td>\nIt will return the reversed string.<\/span><\/td>\n<\/tr>\n
upper(string A) ucase(string A)<\/td>\nstring<\/span><\/td>\nIt will return the string resulting from converting all the characters of string \u2018A\u2019 to uppercase.\u00a0<\/span><\/p>\n

Example: upper(‘BaR’) results in ‘BAR’<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Summary<\/h3>\n

This article had explained all the Hive Built-in functions in detail along with their return type. I hope after reading this article, you clearly understand Hive Built-in functions.<\/p>\n

The article had covered all types of Hive built-in functions such as mathematical function, collection function, type conversion function, date function, conditional function, and string function.<\/p>\n

If you still have any doubt in hive built-in function, then feel free to ask us in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Apache Hive, there are various functions available for performing several tasks. These functions are known as Built-in functions. In this article, we will study Hive Built-in functions. The Hive Built-in functions are categorized...<\/p>\n","protected":false},"author":1,"featured_media":79737,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[544],"tags":[3241,3242],"class_list":["post-79720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hadoop","tag-apache-hive-built-in-functions","tag-hive-built-in-functions"],"yoast_head":"\nHive Built-in Functions and their Return Type with Examples - TechVidvan<\/title>\n<meta name=\"description\" content=\"Learn about Hive Built-in-Functions like mathematical, collection, type conversion, date, conditional, and string function with return types and details\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hive Built-in Functions and their Return Type with Examples - TechVidvan\" \/>\n<meta property=\"og:description\" content=\"Learn about Hive Built-in-Functions like mathematical, collection, type conversion, date, conditional, and string function with return types and details\" \/>\n<meta property=\"og:url\" content=\"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"TechVidvan\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TechVidvan\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-27T03:30:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"TechVidvan Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vidvantech\" \/>\n<meta name=\"twitter:site\" content=\"@vidvantech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechVidvan Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hive Built-in Functions and their Return Type with Examples - TechVidvan","description":"Learn about Hive Built-in-Functions like mathematical, collection, type conversion, date, conditional, and string function with return types and details","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/","og_locale":"en_US","og_type":"article","og_title":"Hive Built-in Functions and their Return Type with Examples - TechVidvan","og_description":"Learn about Hive Built-in-Functions like mathematical, collection, type conversion, date, conditional, and string function with return types and details","og_url":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/","og_site_name":"TechVidvan","article_publisher":"https:\/\/www.facebook.com\/TechVidvan\/","article_published_time":"2020-08-27T03:30:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg","type":"image\/jpeg"}],"author":"TechVidvan Team","twitter_card":"summary_large_image","twitter_creator":"@vidvantech","twitter_site":"@vidvantech","twitter_misc":{"Written by":"TechVidvan Team","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#article","isPartOf":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/person\/e9c26e74dd3d87421f7ada9433b8cd22"},"headline":"Hive Built-in Functions and their Return Type with Examples","datePublished":"2020-08-27T03:30:24+00:00","mainEntityOfPage":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/"},"wordCount":2194,"commentCount":0,"publisher":{"@id":"https:\/\/techvidvan.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg","keywords":["Apache Hive Built-In Functions","Hive Built In Functions"],"articleSection":["Hadoop Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/","url":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/","name":"Hive Built-in Functions and their Return Type with Examples - TechVidvan","isPartOf":{"@id":"https:\/\/techvidvan.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#primaryimage"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg","datePublished":"2020-08-27T03:30:24+00:00","description":"Learn about Hive Built-in-Functions like mathematical, collection, type conversion, date, conditional, and string function with return types and details","breadcrumb":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#primaryimage","url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg","contentUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Apache-Hive-Built-in-Functions.jpg","width":1200,"height":628,"caption":"Apache Hive Built-in Functions"},{"@type":"BreadcrumbList","@id":"https:\/\/techvidvan.com\/tutorials\/apache-hive-built-in-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/techvidvan.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Hive Built-in Functions and their Return Type with Examples"}]},{"@type":"WebSite","@id":"https:\/\/techvidvan.com\/tutorials\/#website","url":"https:\/\/techvidvan.com\/tutorials\/","name":"TechVidvan Blogs","description":"","publisher":{"@id":"https:\/\/techvidvan.com\/tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/techvidvan.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/techvidvan.com\/tutorials\/#organization","name":"TechVidvan","url":"https:\/\/techvidvan.com\/tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2024\/03\/techvidvan-logo-200x50-1.webp","contentUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2024\/03\/techvidvan-logo-200x50-1.webp","width":200,"height":50,"caption":"TechVidvan"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TechVidvan\/","https:\/\/x.com\/vidvantech"]},{"@type":"Person","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/person\/e9c26e74dd3d87421f7ada9433b8cd22","name":"TechVidvan Team","description":"The TechVidvan Team delivers practical, beginner-friendly tutorials on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our experts are here to help you upskill and excel in today\u2019s tech industry."}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts\/79720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/comments?post=79720"}],"version-history":[{"count":0,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts\/79720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/media\/79737"}],"wp:attachment":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/media?parent=79720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/categories?post=79720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/tags?post=79720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}