Member since
02-06-2025
1
Post
0
Kudos Received
0
Solutions
02-06-2025
08:57 PM
Please note that the previous text was translated using a translator, so it might sound a bit awkward. I apologize for any confusion. I’m encountering an issue where everything runs fine initially, but sometimes I experience this error. Could anyone help me understand what might be causing it? [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: ExecuteStatement failed: out of sequence response: expected 6 but got 5, SQL state: HY000, Query: select * from (SELECT tool_path,tag,act_time,value,row_number() over (partition by tool_path,tag order by act_time desc) as rownum FROM `X`.`Y` WHERE (tag like 'A%' or tag like 'B%' or tag like 'C%' or tag like 'D%' or tag like 'E%' or tag like 'F%' or tag like 'G%' or tag like 'H%' or tag like 'I%' or tag like 'J%' or tag like 'K%' or tag like 'L%' or tag like 'M%' or tag like 'N%' or tag like 'O%' or tag like 'P%' or tag like 'Q%' or tag like 'R%' or tag like 'S%' or tag like 'T%' or tag like 'U%') and act_time BETWEEN DATE_SUB(NOW(), INTERVAL 2 HOUR) AND NOW() and param_type = 'M') a where rownum=1.
... View more
Labels:
- Labels:
-
Apache Impala