Thanks Deng. Unfortunately it seems that it looks for driver-class-path as well :(
For example with –jars alone I get spark-shell --master spark://50.140.197.217:7077 --jars /home/hduser/jars/ojdbc6.jar,/home/hduser/jars/jconn4.jar s: org.apache.spark.sql.DataFrame = [AMOUNT_SOLD: decimal(10,0), TIME_ID: timestamp, CHANNEL_ID: bigint] warning: there were 1 deprecation warning(s); re-run with -deprecation for details java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@rhes564:1521:mydb Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Technology Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibility. From: odeach...@gmail.com [mailto:odeach...@gmail.com] On Behalf Of Deng Ching-Mallete Sent: 15 February 2016 03:27 To: Mich Talebzadeh <m...@peridale.co.uk> Cc: user <user@spark.apache.org> Subject: Re: Passing multiple jar files to spark-shell Hi Mich, For the --jars parameter, just pass in the jars as comma-delimited. As for the --driver-class-path, make it colon-delimited -- similar to how you set multiple paths for an environment variable (e.g. --driver-class-path /home/hduser/jars/jconn4.jar:/home/hduse/jars/ojdbc6.jar). But if you're already passing the jar files via the --jars param, you shouldn't need to set them in the driver-class-path though, since they should already be automatically added to the classpath. HTH, Deng On Mon, Feb 15, 2016 at 7:35 AM, Mich Talebzadeh <m...@peridale.co.uk <mailto:m...@peridale.co.uk> > wrote: Hi, Is there anyway one can pass multiple --driver-class-path and multiple –jars to spark shell. For example something as below with two jar files entries for Oracle (ojdbc6.jar) and Sybase IQ (jcoon4,jar) spark-shell --master spark://50.140.197.217:7077 <http://50.140.197.217:7077> --driver-class-path /home/hduser/jars/jconn4.jar --driver-class-path /home/hduser/jars/ojdbc6.jar --jars /home/hduser/jars/jconn4.jar --jars /home/hduser/jars/ojdbc6.jar This works for one jar file only and you need to add the jar file to both --driver-class-path and –jars. I have not managed to work for more than one type of JAR file Thanks, Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Technology Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibility.
