Re: Unsubscribe

Thanks, Stephen On Wednesday, August 26, 2020, 07:07:05 PM PDT, Stephen Coy wrote: The instructions for all Apache mail lists are in the mail headers: List-Unsubscribe: On 27 Aug 2020, at 7:49 am, Jeff Evans wrote: That is not how you

Re: Unsubscribe

The instructions for all Apache mail lists are in the mail headers: List-Unsubscribe: On 27 Aug 2020, at 7:49 am, Jeff Evans mailto:jeffrey.wayne.ev...@gmail.com>> wrote: That is not how you unsubscribe. See here for instructions:

Re: Unsubscribe

That is not how you unsubscribe. See here for instructions: https://gist.github.com/jeff303/ba1906bb7bcb2f2501528a8bb1521b8e On Wed, Aug 26, 2020, 4:22 PM Annabel Melongo wrote: > Please remove me from the mailing list >

Unsubscribe

Please remove me from the mailing list

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

And this is a test using Oracle supplied JAVA script DataSourceSample.java with slight amendment for login/password and table. it connects ok hduser@rhes76: /home/hduser/dba/bin/ADW/src> javac -classpath ./ojdbc8.jar:. DataSourceSample.java hduser@rhes76: /home/hduser/dba/bin/ADW/src> java

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Hi Kuassi, This is the error. Only test running on local mode scala> val driverName = "oracle.jdbc.OracleDriver" driverName: String = oracle.jdbc.OracleDriver scala> var url = "jdbc:oracle:thin:@mydb_high ?TNS_ADMIN=/home/hduser/dba/bin/ADW/DBAccess" url: String = jdbc:oracle:thin:@mydb_high

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Fwiw here are our write-ups on Java connectivity to Database Cloud Services: https://www.oracle.com/database/technologies/appdev/jdbc-db-cloud.html Kuassi On 8/26/20 1:50 PM, Mich Talebzadeh wrote: Thanks Jorn, Only running in REPL in local mode This works fine connecting with ojdbc6.jar

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Thanks Jorn, Only running in REPL in local mode This works fine connecting with ojdbc6.jar to Oracle 12c. cheers LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw *

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Is the directory available on all nodes ? > Am 26.08.2020 um 22:08 schrieb kuassi.men...@oracle.com: > >  > Mich, > > All looks fine. > Perhaps some special chars in username or password? > >> it is recommended not to use such characters like '@', '.' in your password. > Best, Kuassi > On

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Mich, All looks fine. Perhaps some special chars in username or password? it is recommended not to use such characters like '@', '.' in your password. Best, Kuassi On 8/26/20 12:52 PM, Mich Talebzadeh wrote: Thanks Kuassi. This is the version of jar file that work OK with JDBC connection

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Thanks Kuassi. This is the version of jar file that work OK with JDBC connection via JAVA to ADW unzip -p ojdbc8.jar META-INF/MANIFEST.MF Manifest-Version: 1.0 Implementation-Title: JDBC *Implementation-Version: 18.3.0.0.0* sealed: true Specification-Vendor: Sun Microsystems Inc.

Re: Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Hi, From which release is the ojdbc8.jar from? 12c, 18c or 19c? I'd recommend ojdbc8.jar from the latest release. One more thing to pay attention to is the content of the ojdbc.properties file (part of the unzipped wallet) Make sure that ojdbc.properties file has been configured to use Oracle

Connecting to Oracle Autonomous Data warehouse (ADW) from Spark via JDBC

Hi, The connection from Spark to Oracle 12c etc are well established using ojdb6.jar. I am attempting to connect to Oracle Autonomous Data warehouse (ADW) version *Oracle Database 19c Enterprise Edition Release 19.0.0.0.0* Oracle document suggest using ojdbc8.jar to connect to the database

Re: Spark 3.0 using S3 taking long time for some set of TPC DS Queries

Hi Can you try using emrfs? Your study looks good best of luck. Regards Gourav On Wed, 26 Aug 2020, 12:37 Rao, Abhishek (Nokia - IN/Bangalore), < abhishek@nokia.com> wrote: > Yeah… Not sure if I’m missing any configurations which is causing this > issue. Any suggestions? > > > > Thanks and

RE: Spark 3.0 using S3 taking long time for some set of TPC DS Queries

Yeah… Not sure if I’m missing any configurations which is causing this issue. Any suggestions? Thanks and Regards, Abhishek From: Gourav Sengupta Sent: Wednesday, August 26, 2020 2:35 PM To: Rao, Abhishek (Nokia - IN/Bangalore) Cc: user@spark.apache.org Subject: Re: Spark 3.0 using S3 taking

Re: Spark 3.0 using S3 taking long time for some set of TPC DS Queries

Hi, So the results does not make sense. Regards, Gourav On Wed, Aug 26, 2020 at 9:04 AM Rao, Abhishek (Nokia - IN/Bangalore) < abhishek@nokia.com> wrote: > Hi Gourav, > > > > Yes. We’re using s3a. > > > > Thanks and Regards, > > Abhishek > > > > *From:* Gourav Sengupta > *Sent:*

RE: Spark 3.0 using S3 taking long time for some set of TPC DS Queries

Hi Gourav, Yes. We’re using s3a. Thanks and Regards, Abhishek From: Gourav Sengupta Sent: Wednesday, August 26, 2020 1:18 PM To: Rao, Abhishek (Nokia - IN/Bangalore) Cc: user@spark.apache.org Subject: Re: Spark 3.0 using S3 taking long time for some set of TPC DS Queries Hi, are you using

Re: Spark 3.0 using S3 taking long time for some set of TPC DS Queries

Hi, are you using s3a, which is not using EMRFS? In that case, these results does not make sense to me. Regards, Gourav Sengupta On Mon, Aug 24, 2020 at 12:52 PM Rao, Abhishek (Nokia - IN/Bangalore) < abhishek@nokia.com> wrote: > Hi All, > > > > We’re doing some performance comparisons