Connect AWS Athena to an existing Hive Metastore

0 votes
I want to integrate AWS Athena service with an exists Hive Metastore (not AWS Glue).

Can you please let me know how to do it?
Nov 16, 2018 in AWS by findingbugs
• 3,140 points
345 views

1 answer to this question.

0 votes
Athena works only with its own metastore or the related AWS Glue metastore.

It will not work with an external metastore.

However, you can set up multiple tables or databases on the same underlying S3 storage. So if you wrote data to S3 using an external metastore, you could query those files with Athena, after setting up an appropriate database and table definition in Athena's metastore.
answered Nov 16, 2018 by Jino
• 5,560 points

Related Questions In AWS

0 votes
1 answer

How to add IAM role to an existing instance in aws?

As of AWS CLI v1.11.46,  you can ...READ MORE

answered Sep 6, 2018 in AWS by Archana
• 4,090 points
94 views
0 votes
1 answer

How to connect to an existing CloudSearch domain in boto?

You can use conn.list_domains() which will return a list ...READ MORE

answered Mar 14 in AWS by Archana
• 5,560 points
41 views
0 votes
2 answers
0 votes
1 answer

What is Metastore in Hive?

It stores metadata for Hive tables (like their schema ...READ MORE

answered Dec 20, 2018 in Big Data Hadoop by Frankie
• 9,810 points
100 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
2,648 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
275 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
13,206 views
0 votes
1 answer
+5 votes
3 answers