SparkSQL DDL语句之CREATE TABLE

前言

CREATE TABLE语句是用来给一个已存在的数据库中创建表的。我们平时用Hive等其他组件建表居多，本篇博客主要讲解一下SparkSQL如何进行建表。主要有三种方式：

• CREATE TABLE USING DATA_SOURCE
• CREATE TABLE USING HIVE FORMAT
• CREATE TABLE LIKE

CREATE TABLE USING DATA_SOURCE

1. 语法

   CREATE TABLE [ IF NOT EXISTS ] table_identifier
       [ ( col_name1 col_type1 [ COMMENT col_comment1 ], ... ) ]
       USING data_source
       [ OPTIONS ( key1=val1, key2=val2, ... ) ]
       [ PARTITIONED BY ( col_name1, col_name2, ... ) ]
       [ CLUSTERED BY ( col_name3, col_name4, ... ) 
           [ SORTED BY ( col_name [ ASC | DESC ], ... ) ] 
           INTO num_buckets BUCKETS ]
       [ LOCATION path ]
       [ COMMENT table_comment ]