python sparksql

from pyspark.sql import SparkSession

from os.path import abspath

warehouse_location = abspath('spark-warehouse')

spark = SparkSession.builder.appName("python sparksql").config("spark.sql.warehouse.dir", warehouse_location).enableHiveSupport().getOrCreate()

spark.sql("SELECT * FROM t limit 10").show()