Categories

Apr 24 in Big Data | Hadoop

Q:

There are several types of built-in Hive Functions.

  • String Functions

    • concat()- used for concatenation.
    • lower()/upper() - to convert upper to lower and vice-versa.
    • trim() - to remove whitespaces.
  • Date Functions

    • to-date() - to convert string to date format.
    • year()/month()/day() - to retieve the year,month,day respectively.
  • Mathematical Functions

    • round()/rand() - to get the round off value, generate sequence of random numbers respectively.
    • sqrt()/abs() - to get the square root and absolute value of the operation respectively.
  • Collection Functions

    • size(Map<K.V>) - will represent elements number in map type.
    • size(Array<T>) - will represent elements in array type.
  • Conditional Functions

    • ISNULL(X) - it will return boolean type.

    • ISNOTNULL(X) - it will return boolean type.

Related questions

Madanswer
Apr 3 in Big Data | Hadoop
Apr 24 in Big Data | Hadoop
May 7 in Big Data | Hadoop
...