I’m trying to use sql query on azure-databricks with distinct sort and aliasesSELECT DISTINCT album.ArtistId AS my_alias
FROM album ORDER BY album.ArtistIdThe problem is that if I add an alias then I can not use not aliased name in the order by ...
I’m trying to use sql query on azure-databricks with distinct sort and aliasesSELECT DISTINCT album.ArtistId AS my_alias
FROM album ORDER BY album.ArtistIdThe problem is that if I add an alias then I can not use not aliased name in the order by cla...
Hi, I noticed unexpected behavior for Date type. If year value is less then 1000 then filtering do not work.
Steps:create table test (date Date); insert into test values ('0001-01-01'); select * from test where date = '0001-01-01'
Returns 0 rows....