I am getting 504 Gateway Time-out nginx/1.12.2..Issue in connecting Hive?

You can use Web-console or Hive console for your Hive query, You can refer this thread to know about the exact cause for this error-

https://discuss.cloudxlab.com/t/504-gateway-time-out-504-gateway-time-out-nginx-1-12-2/2712