in Big Data | Hadoop by
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

0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
0 votes
asked Jan 13, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Apr 6, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Jun 14, 2020 in Hive by Robindeniel
0 votes
...