RE: Stored proc with spark

bzadeh <m...@peridale.co.uk> Cc: user <user@spark.apache.org> Subject: Re: Stored proc with spark Thanks I will try with the options On Feb 16, 2016 9:15 PM, "Mich Talebzadeh" <m...@peridale.co.uk <mailto:m...@peridale.co.uk> > wrote: You can use JDBC to oracl

Re: Stored proc with spark

Thanks I will try with the options On Feb 16, 2016 9:15 PM, "Mich Talebzadeh" wrote: > You can use JDBC to oracle to get that data from a given table. What > Oracle stored procedure does anyway? How many tables are involved? > > JDBC is pretty neat. In example below I use

Re: Stored proc with spark

You can use JDBC to oracle to get that data from a given table. What Oracle stored procedure does anyway? How many tables are involved? JDBC is pretty neat. In example below I use JDBC to load two Dimension tables from Oracle in Spark shell and read the FACT table of 100 million rows from Hive

Re: Stored proc with spark

There are many facets to this topic, you could use Sqoop or the spark jdbc driver or oracle Hadoop loader or external tables in oracle that use coprocessors to stream directly to compressed csv files that are important by spark. Depends all on volumes, non-functional and functional

Re: Stored proc with spark

relational databases? what about sqoop? https://en.wikipedia.org/wiki/Sqoop Alonso Isidoro Roman. Mis citas preferidas (de hoy) : "Si depurar es el proceso de quitar los errores de software, entonces programar debe ser el proceso de introducirlos..." - Edsger Dijkstra My favorite quotes

Re: Stored proc with spark

Hi Gaurav, do you mean stored proc that returns a table? Regards, Gourav On Tue, Feb 16, 2016 at 9:04 AM, Gaurav Agarwal wrote: > Hi > Can I load the data into spark from oracle storedproc > > Thanks >

Stored proc with spark

Hi Can I load the data into spark from oracle storedproc Thanks