Error reporting reason:
From is not preceded by a space
An extra space is added after row
After looking for the error for a long time, I thought it was an environmental problem or a problem with the POM. As a result, I was careless. Now I don’t know why the first from added a space less. Why would I report an error
If you encounter this problem, in addition to the methods given online, you can take a look at your own code
The first line is the wrong codes:
"select * from" +"(select * ,ROW_NUMBER() over(partition by windowEnd order by cnt desc)as row_num" +"from agg)" +"where row _num <= 5");
"select * from " +"(select * ,ROW_NUMBER() over (partition by windowEnd order by cnt desc) as row_num" +" from agg) " +" where row_num <= 5 ");
Similar Posts:
- Error: not a group by expression [How to Solve]
- Oracle error: not a group by expression [How to Solve]
- [Solved] Insufficient Oracle table space: ora-01653: unable to extend table
- [How to Solve] for the right syntax to use near ”X”
- Mac open terminal error – bash:: command not found
- [Thinkphp6] Connect to SQL Server and use subquery to report error: when subquery is not introduced with exists, only one expression can be specified in the selection list
- How to Solve ORA-30926 Error: unable to get a stable set of rows in the source tables
- [Solved] java.lang.Long cannot be cast to java.lang.Integer
- [Solved] HIVE Error: need to specify partition columns because…
- Common problems and solutions of checkstyle error reporting