You mention cloudera, are you trying to execute the query from HUE? That requires altering the setting for HUE and not HIVE.
On Mon, Apr 21, 2014 at 11:12 AM, j.barrett Strausser < j.barrett.straus...@gmail.com> wrote: > Hope those aren't you actual credentials. > > > On Mon, Apr 21, 2014 at 11:05 AM, Kishore kumar <kish...@techdigita.in>wrote: > >> 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] >> > > > > -- > > > https://github.com/bearrito > @deepbearrito > -- https://github.com/bearrito @deepbearrito