org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException:错误

在java查询的时候报错：

org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [userId] during auto-discovery of a native-sql query
    at org.hibernate.loader.custom.CustomLoader.validateAliases(CustomLoader.java:508)
    at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:485)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:2214)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:2170)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
    at org.hibernate.loader.Loader.doQuery(Loader.java:938)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
 

检查后原因是，select查询的时候写了重复的userId字段，

如：

select user_id as userId,task_date as taskDate,user_id as userId,task_number as taskNumber from table_A

删掉重复的即可！