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();
}
}