The warning for
select d_date as ‘date’ from date_dim;
is hard to locate than it should be.
Error: Error while compiling statement: FAILED: ParseException line 1:18 cannot recognize input near 'as' 'date' 'from' in selection target (state=42000,code=40000)