Hadoop DP Notes
Home
Contact Us
Search
Describe TRIM function in Hive with example?
TRIM function will remove the spaces associated with a string.
Example:
TRIM(‘ Hadoop ‘);
Output:
Hadoop.
If we want to remove only leading or trailing spaces then we can specify the below commands respectively.
LTRIM(‘ Hadoop’);
RTRIM(‘Hadoop ‘);
Newer Post
Older Post
Home
What are the main components of Mapreduce Job ?
Main driver class which provides job configuration parameters. Mapper class which must extend org.apache.hadoop.mapredu...
TO_CHAR
This will be used to extract various date formats. The available date formats as follows. Syntax: to_char ( date , fo...