Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a dataset which not have date column.
As part of my requirment i need to create new column in prepare recipe by using formula now() default to current date on particular column.
The formula returns standard date format with time stamp and the storage data type is showing as date.
Actually my requirment is to store the date in date format without timestamp.
But in screen it's showing values along with timestamp and storage type as date.
I have used prepare recipe to reformat the date by removing time stamp
The colum storage type is converted into string.
When I try to change the storage type and run the recipe which is going to store in hive database, it throwing an error failed to parse date invalid format.
How to reformat the date without type stamp and the storage type needs to be date and in final table it needs to store only date and datatype needs to be date
I’m taking a look at this. Thanks for explaining your situation in detail.
Having this information will help me understand the problem a bit better.