TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:IllegalStateException: null
Solution:
select t1.citycode,count(distinct t1.cardno,t1.ndate) cnt,round(sum(t1.amount),2) amount from t2 inner join t1 on t1.cardno = t2.cardno group by citycode
Execute the SQL commands above and report the following error:
SQL ERROR [500051] [HY000]: [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:IllegalStateException: null
Adjust the position of count(distinct t1.cardno,t1.ndate) and there will be no problem
Read More:
- [Solved] Java.lang.IllegalStateException: Type handler was null on parameter mapping for property ‘__frch_it
- Mapper.xml Error: Error setting non null for parameter #3 with JdbcType null.
- [Solved] Java.lang.IllegalStateException: getReader() has already been called for this request
- [Solved] stream Convert list to map Error: java.lang.IllegalStateException: Duplicate key
- How to Solve Swagger error: IllegalStateException
- JUnit test classes error: java.lang.IllegalStateException: Failed to load ApplicationContext
- Eureka Error: registration status: 204 deregister status: 200
- [Solved] java.io.IOException: Got error, status=ERROR, status message, ack with firstBadLink as
- [Solved] Internal error (java.lang.IllegalStateException): Duplicate key org.jetbrains
- Caused by: java.lang.IllegalStateException (How to Fix)
- [Solved] java.lang.IllegalStateException: Cannot call sendRedirect() after the response has been committed
- mybatis Error: All elements are null [How to Solve]
- [Solved] Logstash Error: Logstash – java.lang.IllegalStateException: Logstash stopped processing because of an err
- Not showing null elements JAVA [How to Solve]
- JUnit tests mybatis-plus error: null pointer [How to Solve]
- Uncaught TypeError: Cannot read property ‘toFixed‘ of null
- [Solved] Kafka Error: Discovered coordinator XXXXX:9092 (id: 2147483647 rack: null) for group itstyle.
- Dubbo failed to register and consumer null pointer exception
- Mybatis Error: All elements are null [How to Solve]
- NULL value exception occurs when freemarker renders the page globally in the springboot project