| 100 | } |
| 101 | |
| 102 | public void createTableRatings() throws DDFException { |
| 103 | manager.sql("drop table if exists ratings", "SparkSQL"); |
| 104 | |
| 105 | manager.sql("create table ratings (userid int,movieid int,score double ) " |
| 106 | + "ROW FORMAT DELIMITED FIELDS TERMINATED BY ','", "SparkSQL"); |
| 107 | |
| 108 | manager.sql("load data local inpath '../resources/test/ratings.data' into table ratings", "SparkSQL"); |
| 109 | } |
| 110 | |
| 111 | public void createTableMtcars() throws DDFException { |
| 112 | manager.sql("drop table if exists mtcars", "SparkSQL"); |