[client-v2] Fix handling HTTP error status codes

[dizider]

Summary

A HTTP requests to clickhouse which ended with server error (>500) throw a ServerException.

Checklist

Delete items not relevant to your PR:

• [ ] Unit and integration tests covering the common scenarios were added

Closes: #1874

[CLAassistant]

All committers have signed the CLA.

[chernser]

@dizider Thank you for the contribution! Will review shortly.