zadeh
Cc: user
Subject: Re: Stored proc with spark
Thanks I will try with the options
On Feb 16, 2016 9:15 PM, "Mich Talebzadeh" mailto:m...@peridale.co.uk> > wrote:
You can use JDBC to oracle to get that data from a given table. What Oracle
stored procedure does anyway? How
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 JDBC to load two
> Dimen
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
va
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 requirements
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 (to
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
>