Re: jdbcRRD and dataframe

2016-07-25 Thread Marco Colombo
Thanks, I would submit an improvement Il lunedì 25 luglio 2016, Mich Talebzadeh ha scritto: > I don't think there is. > > it would be a viable request using collection pool through DF to connect > to an RDBMS > > cheers > > Dr Mich Talebzadeh > > > > LinkedIn * >

Re: jdbcRRD and dataframe

2016-07-25 Thread Mich Talebzadeh
I don't think there is. it would be a viable request using collection pool through DF to connect to an RDBMS cheers Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: jdbcRRD and dataframe

2016-07-25 Thread Marco Colombo
>From getConnection I'm handling a connection pool. I see no option for that in docs Regards Il lunedì 25 luglio 2016, Mich Talebzadeh ha scritto: > Hi Marco, > > what is in your UDF getConnection and why not use DF itself? > > I guess it is all connection attributes

Re: jdbcRRD and dataframe

2016-07-25 Thread Mich Talebzadeh
Hi Marco, what is in your UDF getConnection and why not use DF itself? I guess it is all connection attributes val c = HiveContext.load("jdbc", Map("url" -> _ORACLEserver, "dbtable" -> "(SELECT to_char(CHANNEL_ID) AS CHANNEL_ID, CHANNEL_DESC FROM sh.channels)", "user" -> _username, "password"

jdbcRRD and dataframe

2016-07-25 Thread Marco Colombo
Hi all, I was using JdbcRRD and signature for constructure was accepting a function to get a DB connection. This is very useful to provide my own connection handler. I'm valuating to move to daraframe, but I cannot how to provide such function and migrate my code. I want to use my own