benchto icon indicating copy to clipboard operation
benchto copied to clipboard

SQL health check does not work

Open kokosing opened this issue 8 years ago • 0 comments

Even that below query fails:

select nodes_count,
case nodes_count
when 9 then 1
else 1/0
end
from (
select count(*) nodes_count from system.runtime.nodes where state = 'active'
)

with:

com.facebook.presto.spi.PrestoException: / by zero

driver continues the work:

00:12:08.372 08:41:18.885 INFO  [main] c.t.b.d.e.BenchmarkExecutionDriver - Running health check macros: [run-health-check-script, health_check/9_nodes_active.sql]
00:12:08.373 08:41:18.887 INFO  [main] c.t.b.d.m.s.ShellMacroExecutionDriver - Executing macro: 'hfab -P -R all other:querygrid_hdp_perf_cluster node.shell:"sh health_check.sh" && hfab -P -R all other:querygrid_td_perf_cluster node.shell:"sh health_check.sh"'
00:12:11.552 08:41:22.068 INFO  [main] c.t.b.d.m.q.QueryMacroExecutionDriver - Executing macro query: select nodes_count,
00:12:11.552 case nodes_count
00:12:11.552 when 9 then 1
00:12:11.552 else 1/0
00:12:11.552 end
00:12:11.552 from (
00:12:11.552 select count(*) nodes_count from system.runtime.nodes where state = 'active'
00:12:11.552 )
00:12:12.317 08:41:22.834 INFO  [main] c.t.b.d.e.BenchmarkExecutionDriver - [1 of 100] processing benchmark: Benchmark{name=presto/tpcds, 

kokosing avatar Oct 27 '16 08:10 kokosing