Many projects like this are written in Java, too: Zookeeper, Hadoop, Presto.
Go and Java both share good concurrency support, reasonable developer productivity, moderate type safety and good code generation.
Likely because of it's nature as a network first language.
Go is largely speaking a language designed to push bytes over sockets to lots of concurrent clients.
There are two more things: 1. Go has high development efficiency. So we could build complex SQL logic easily. 2. Go is easy to write concurrent code. So we could enjoy the benefit of multi-core cpu. For example, we could use multiple goroutine to scan data, do join, do aggregation.