7/4/2023 0 Comments Can i link java to r![]() Now we have our table available and we can focus on the main part of the article.įirst let us go with the option to load a database table that we populated with the flights earlier and named test_table, putting it all together and loading the data using spark_read_jdbc(): # Other options specific to the action # Write our `test_df` into a table called `test_table`ĭBI::dbWriteTable(con, "test_table", test_df, overwrite = TRUE) # Create a connection to database `testdb` ![]() We will use the and call the newly created table test_table: test_df <- nycflights13::flights If you are interested only in the Spark loading part, feel free to skip this paragraph.įor a fully reproducible example, we will use a local MySQL server instance as due to its open-source nature it is very accessible.
0 Comments
Leave a Reply. |