Hive external table

How to create hive external table with data file is in amazon aws??i tried and searched google also. Durga sir plz reply

First you need to have AWS bucket along with access key and secret key. Then as part of your hive session you need to set couple of properties with access key and secret key.

Then you need to use LOCATION clause pointing to AWS bucket.

can u plz give me sample query having $access key and $secret key variables , i wl change values in that.i have free aws accout with ec2-user , i wll try there