RE: How to use Date functions in Hive Dataflow?

How to use Date functions in Hive Dataflow?

JohnGS Advanced User Asked on July 16, 2019 in Hadoop Process Platform.
Add Comment
1 Answers

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

RE: How to use Date functions in Hive Dataflow?

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

RE: How to use Date functions in Hive Dataflow?

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.