Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- #Create Pandas DataFrame
- pd_person = pd.DataFrame({'PERSONID':'0','LASTNAME':'Doe','FIRSTNAME':'John','ADDRESS':'Museumplein','CITY':'Amsterdam'}, index=[0])
- #Create Spark DataFrame from Pandas
- df_person = sqlContext.createDataFrame(pd_person)
- #Writing Spark DataFrame to local Oracle Expression Edition 11.2.0.2
- #This uses the relatively older Spark jdbc DataFrameWriter api
- df_person.write.jdbc(url='jdbc:oracle:thin:@127.0.0.1:1521:XE', table='HR.PERSONS', mode='append', properties={'driver':'oracle.jdbc.driver.OracleDriver', 'user' : 'SYSTEM', 'password' : 'password'})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement