Hi ,
I have configured mysql metastore. issues is on s3 supporting jar. On Tue, Oct 25, 2016 at 4:43 PM, dv akhil <dvakh...@gmail.com> wrote: > Hi, > which metastore are you using for hive? . Have you copied the jar > containing the JDBC driver for your metadata db into hive's lib dir? > > > down voteaccepted > > > > On Tue, Oct 25, 2016 at 4:29 PM, Rajendra Bhat <rajhalk...@gmail.com> > wrote: > >> hive> list jars; >> /opt/apache-hive-2.0.1-bin/lib/hadoop-aws-2.7.1.jar >> /opt/apache-hive-2.0.1-bin/lib/aws-java-sdk-1.7.4.jar >> hive> >> >> >> On Tue, Oct 25, 2016 at 4:27 PM, Rajendra Bhat <rajhalk...@gmail.com> >> wrote: >> >>> yes, I have added the jar on hive prompt. >>> >>> On Tue, Oct 25, 2016 at 4:25 PM, aft <aft...@gmail.com> wrote: >>> >>>> On Tue, Oct 25, 2016 at 6:11 AM, Rajendra Bhat <rajhalk...@gmail.com> >>>> wrote: >>>> > Hi, >>>> > >>>> > i am getting below error on create extrnal table. I have copied >>>> > hadoop-aws-2.7.1.jar and aws-java-sdk-1.7.4.jar to hive_home/lib >>>> folder. >>>> > please let me know where should need to place supporting jar.. >>>> > >>>> > >>>> > hive> create external table kv (key int, value string) location >>>> > 's3a://myntra-datasciences/cip/test'; >>>> > FAILED: Execution Error, return code 1 from >>>> > org.apache.hadoop.hive.ql.exec.DDLTask. >>>> > MetaException(message:java.lang.RuntimeException: >>>> > java.lang.ClassNotFoundException: Class >>>> > org.apache.hadoop.fs.s3a.S3AFileSystem not found) >>>> >>>> Have you added the jars at hive prompt with "add jar " command? >>>> >>>> > >>>> > -- >>>> > Thanks and >>>> > Regards >>>> > >>>> > Rajendra Bhat >>>> >>> >>> >>> >>> -- >>> Thanks and >>> Regards >>> >>> Rajendra Bhat >>> >> >> >> >> -- >> Thanks and >> Regards >> >> Rajendra Bhat >> > > -- Thanks and Regards Rajendra Bhat
