I am trying to install hawq, I went through the Pivotal links. But the confusion is I am not able to download apache hawq tar.
Whenever I check Pivotal link download I see End of Availability. Please help me and provide where and how to doenload Apache hawq tar.
Pivotal HDB (commercial version of Apache Hawq) has been discontinued. You would need to build Apache Hawq from their open source repo http://github.com/apache/incubator-hawq.
Here are the instructions for building Hawq https://cwiki.apache.org/confluence/display/HAWQ/Build+and+Install
I would recommend trying IBM Big SQL or seeing if you can use Apache Hive LLAP. It should meet most of your query needs.