sparksql test

package com.example.bigdata.table;

import org.apache.spark.sql.Dataset;
import org.apache.spark.sql.Row;
import org.apache.spark.sql.SaveMode;
import org.apache.spark.sql.SparkSession;

public class SQLTest {

public static void main(String[] args) {

    SparkSession spark =
            SparkSession.builder().appName("Java Spark Hive Example").master("local[*]").enableHiveSupport().getOrCreate();

    spark.sql("show databases ").show();

    spark.sql("show tables").show();

    spark.sql("create table if not exists t1 (name STRING) partitioned by (age INT) STORED AS parquet ");

    spark.sql("show tables").show();

    spark.sql("create view  if not exists t1_view as select * from t1");

    spark.sql("show tables").show();

    spark.sql("create view  if not exists t1_view as select * from t1");

    spark.sql("show tables").show();

    spark.sql("create temporary view t1_temp_view as select * from table_tt");
    spark.sql("show tables").show();

    spark.sql("select * from table_tt").show();

    spark.sql("create external table if not exists partition_t1(name STRING) partitioned by (age INT)" +
            " STORED AS orc" +
            " LOCATION 'D:/code/study/BigdataDemo/spark-table/src/test/externaldata/parti_t1/'");
    spark.sql("show tables").show();
    
    spark.sql("insert into partition_t1 partition (age = 12) select name from t1_temp_view" +
            " where t1_temp_view.age = 12");

    spark.sql("select * from partition_t1").show();

    spark.stop();
}

}