What is AWS Athena?

This will have questions on Athena

This may end up being a meta document

How do you set input format, output format, and serialization lib for Athena tables?

Search for: How do you set input format, output format, and serialization lib for Athena tables?

More on Athena is found here: local link

what is equivalent to Athena console in Apache or OpenSource?

Search for: what is equivalent to Athena console in Apache or OpenSource?

Read about Hive and Hue here

Hive Metadata is a central repository for storing all the Hive metadata information. Metadata include various types of information like the structure of tables, relations etc.

So Hive Web Interface can act as a UI to browse hive tables

Derby

MySQL

MS SQL Server

Oracle

Postgres

So what is hue then?

Search for: So what is hue then?

Bigdata Hue

Search for: Bigdata Hue

it is a web front end for managing a NUMBER of Bigdata tools and services including SQL queries.

How do I browse hive tables in Azure?

Search for: How do I browse hive tables in Azure?

Here is microsoft reference on HIVE

It seems to be viewing HiveView tool

Apache Ambari azure

Search for: Apache Ambari azure

Presto and Microsoft Azure

Search for: Presto and Microsoft Azure