Hello, I want to create a table in Hive and then load a CSV file content into it all by means of Spark SQL. I saw in the docs the example with the .txt file BUT can we do instead something like the following to accomplish what i want? :
String warehouseLocation = new File("spark-warehouse").getAbsolutePath();SparkSession spark = SparkSession .builder() .appName("Java Spark Hive Example") .config("spark.sql.warehouse.dir", warehouseLocation) .enableHiveSupport() .getOrCreate(); spark.sql("CREATE TABLE IF NOT EXISTS csvFile USING hive");spark.sql("LOAD DATA LOCAL INPATH 'C:/Users/Me/Documents/examples/src/main/resources/data.csv' INTO TABLE csvFile");