CODEWITHSUNDEEP
amazon-s3amazon-web-serviceshiveelastic-map-reduce
asquare
asquare

Reputation: 77

Running HIVE queries directly from S3 input files

I am using Interative Hive Session in Elastice Map Reduce to run Hive. Previously I was loading data from S3 into Hive tables.Now, I want to run some scripts on S3 input files without loading data into Hive Tables.

Is this possible?If yes then how can this be achieved?

Upvotes: 0

Views: 990

Answers (1)

prestomation
prestomation

Reputation: 7440

You can run queries on data right in S3. 

CREATE EXTERNAL TABLE mydata (key STRING, value INT) ROW FORMAT DELIMITED FIELDS  TERMINATED BY '\n' LOCATION 's3n://mys3bucket/';

or similar

Upvotes: 1

Related Questions