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 
>> <mailto:ce...@lotuseed.com>> wrote:
>> 
>> Dear all,
>>     Can you tell me how did get past SQLContext load function read  multiple 
>> tables? 
> 

Reply via email to