Please see the Amazon S3 Help regarding set of the xml: <property> <name>fs.s3.awsAccessKeyId</name> <value>ID</value> </property>
<property> <name>fs.s3.awsSecretAccessKey</name> <value>SECRET</value> </property> Your connection in the plugin config needs to include the URL that looks something like this: "connection": "s3n://<accesskey>:<secret>@myname", Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn On Thu, Dec 10, 2015 at 11:38 PM, Nirav Shah <nirav.s...@games24x7.com> wrote: > Hi All, > > I am trying to query from S3. > I am getting below error. > > Error: SYSTEM ERROR: IllegalArgumentException: AWS Access Key ID and Secret > Access Key must be specified as the username or password (respectively) of > a s3 URL, or by setting the fs.s3.awsAccessKeyId or > fs.s3.awsSecretAccessKey properties (respectively). > > > Configuration : > Step 1: hadoop-2.7.1/etc/hadoop/core-site.xml in > <property> <name>fs.s3.awsAccessKeyId</name><value>key</value> > </property> > > <property> <name>fs.s3.awsSecretAccessKey</name> <value>value</value> > </property> > <property> <name>fs.s3n.awsAccessKeyId</name> > <value>key</value> </property> > <property> <name>fs.s3n.awsSecretAccessKey</name> > <value>value</value> </property> > > Step 2 : $DRILL_HOME/bin/hadoop_excludes.txt removing the line jets3t > Step 3: copy jets3t-0.9.2.jar to $DRILL_HOME/jars/3rdparty > Step 4: configuring storage plugin > "connection": "s3://g24x7.ana-p", rest is same as file plugin > > Still not able to connect. Pls help. > > Thanks, > Nirav