Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Format yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

Solved!
Ash7
Level 1
Format yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

Hello,

I want to create a hive dataset to extract only the row with a "dat_trt" >= system date - 2 days.

cap_dataiku_1.PNG

 

cap_dataiku_0.PNG

Which sql function I should use please.

Thanks

0 Kudos
1 Solution
Liev
Dataiker Alumni

Hi @Ash7 

While this is a Hive (and not DSS) question, you can refer to threads such as this one for some guidance and options. It seems it will depend on your Hive version of course. 

You can try these things out in a Hive notebook in DSS as well.

Good luck!

View solution in original post

0 Kudos
2 Replies
Liev
Dataiker Alumni

Hi @Ash7 

While this is a Hive (and not DSS) question, you can refer to threads such as this one for some guidance and options. It seems it will depend on your Hive version of course. 

You can try these things out in a Hive notebook in DSS as well.

Good luck!

View solution in original post

0 Kudos
Ash7
Level 1
Author

thanks

0 Kudos
Labels (1)
A banner prompting to get Dataiku DSS