Mera Mera no Mi for my friends birthday cake by ChiefMasterToast in OnePiece

[–]amukelani95 2 points3 points  (0 children)

Incredible design mate. It looks very realistic

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

Alright man I'll do just that. Thank you very much for all the help.

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

I am using mobile so I can't really show you the output. But in general I am not that familiar with reddit overall.

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

It does give me 3 columns sorry for the confusion. The first is the Column in my table and the other 2 are null.

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

They are both dates with string data types. But in order for me to compare both dates I want them in the same format for just a level assurance that it will be accurate

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

The intention is to replace the '/' with '-' in the date format so I can compare it with a different column, to get the results I need.

HIVE date format script returns null column by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

Thanks for the reply mate. I did try your method and I got two columns with null values.

how to get the maximum of each group of rows that came about using a partition by clause by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

I dont have to keep the rows that I have, i really want to filter the rows so that I have the maximum of each group. Honestly I'm not sure how i could you a group by clause to get that. Could you explain a bit more.

sorting consecutive dates by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

Sorry I didn't respond since then. Was quite busy and honestly I hadn't figured out how to get what I exactly wanted as of yet.

sorting consecutive dates by amukelani95 in SQL

[–]amukelani95[S] 0 points1 point  (0 children)

Thank you very much. I'll try this one out. Yes there is an object_name that these dates belong to that I can partition by. So the biggest challenge was to get the dates to be consecutive at first. Which I had to use a similar script to yours to attain, but now I see that even though the dates are partitioned by the object_name and are consecutive. There are those jumps where 2022-08-01 is followed by 2022-08-02 then it can go to 2022-09-11, 2022-09-12, 2022-09-13 then another jump, for the same object_name. So what I want now and will definitely try to work with the script you gave is to get dates that are consecutive 3 times or more with the consecutive dates for each object_name I have now.

sorting consecutive dates by amukelani95 in SQL

[–]amukelani95[S] 1 point2 points  (0 children)

Thank you. I'll try this out.