I Edited "Cluster-wide Configuration Safety Valve for core-site.xml" in cm, and specified as below, but still the problem is same.
<property> <name>fs.s3.awsAccessKeyId</name> <value>AKIAJNIM5P2SASWJPHSA</value> </property> <property> <name>fs.s3.awsSecretAccessKey</name> <value>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</value> </property> FAILED: Error in metadata: MetaException(message:java.lang.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).) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Thanks, Kishore. On Mon, Apr 21, 2014 at 8:17 PM, Kishore kumar <kish...@techdigita.in>wrote: > I set the credentials from hive command line, still I am getting the > error. please help me. > > hive> set fs.s3.awsAccessKeyId = xxxxxxxxx; > hive> set fs.s3.awsSecretAccessKey = xxxxxxxxxxxxxxx; > > FAILED: Error in metadata: > MetaException(message:java.lang.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).) > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > Thanks, > Kishore. > > > > On Mon, Apr 21, 2014 at 7:33 PM, Kishore kumar <kish...@techdigita.in>wrote: > >> Hi Experts, >> >> I am trying to create table against my s3 file, I faced the below issue, >> where to set these credentials in clouderamanager4.8. I got this link ( >> http://community.cloudera.com/t5/Cloudera-Manager-Installation/AWS-Access-Key-ID-and-Secret-Access-Key-must-be-specified-as-the/td-p/495) >> after some research but please explain me clearly after edited >> "Cluster-wide Configuration Safety Valve for core-site.xml" how to >> specify the values. >> >> -- Thanks, >> >> >> *Kishore * >> > > > > -- > > *Kishore Kumar* > ITIM > > Bidstalk - Ingenius Programmatic Platform > > Email: kish...@techdigita.in| Tel: +1 415 423 8230 | Cell: +91 741 135 > 8658 | skype: kishore.alajangi | YM: kk_asn2004 | Twitter: __kishorealajangi > [image: Inline image 1] > -- *Kishore Kumar* ITIM Bidstalk - Ingenius Programmatic Platform Email: kish...@techdigita.in| Tel: +1 415 423 8230 | Cell: +91 741 135 8658 | skype: kishore.alajangi | YM: kk_asn2004 | Twitter: __kishorealajangi [image: Inline image 1]