Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL health check does not work #17

Open
kokosing opened this issue Oct 27, 2016 · 0 comments
Open

SQL health check does not work #17

kokosing opened this issue Oct 27, 2016 · 0 comments

Comments

@kokosing
Copy link
Contributor

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, 
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant