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 <[email protected]> 写道:
>
> 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 <[email protected]
>> <mailto:[email protected]>> wrote:
>>
>> Dear all,
>> Can you tell me how did get past SQLContext load function read multiple
>> tables?
>