How to use Date functions in Hive Dataflow?
How to use Date functions in Hive Dataflow?
Hive Date functions are used to perform operations on Date columns in a Hive table
Add derived attribute in Source or Any transformation (ex: Expression) and open expression editor then select functions in Transforms, it will display list of all the functions available
Search for ‘DATE functions’ in all the functions
Select required function from the list and provide values as per the syntax
For Example: If a user wants to use DATEDIFF function to know the difference between two dates, Provide the start date and end date as per the requirement