Do you want to load multiple tables by using sql ? JdbcRelation now only
can load single table. It doesn't accept sql as loading command.
On Wed, Dec 2, 2015 at 4:33 PM, censj <ce...@lotuseed.com> wrote:
> hi Fengdong Yu:
> I want to use sqlContext.read.format('jdbc').options( ... ).load()
> but this function only load a table so i want to know through some
> operations load multiple tables？
>
>
> 在 2015年12月2日，16:28，Fengdong Yu <fengdo...@everstring.com> 写道：
>
> It cannot read multiple tables,
>
> but if your tables have the same columns, you can read them one by one,
> then unionAll them, such as:
>
> val df1 = sqlContext.table(“table1”)
> val df2 = sqlContext.table(“table2”)
>
> val df = df1.unionAll(df2)
>
>
>
>
>
> On Dec 2, 2015, at 4:06 PM, censj <ce...@lotuseed.com> wrote:
>
> Dear all,
> Can you tell me how did get past SQLContext load function read multiple
> tables？
>
>
>
>
--
Best Regards
Jeff Zhang
