数据立方一体机SQL编程规范【云创大数据】.docxVIP

旗开得胜 旗开得胜 PAGE # PAGE # =a 7读万卷书行万里路 旗开得胜 旗开得胜 PAGE PAGE # 数据立方一体机SQL编程规范 数据立方是一个很开放的系统，支持JDBC、ODBC ,很多内容都支持用户 定制，sql语句规则如下: 1、Create Table CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name [(col_name data_ty pe [COMMENT col_comme nt], ...)] [COMMENT table_comme nt] [P ARTITIONED BY (col_name data_ty pe [COMMENT col_comme nt], ...)] [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num—buckets BUCKETS] [ROW FORMAT row_format] [STORED AS file_format] [LOCATION hdfs_path] CREATE TABLE创建一个指定名字的表。如果相同名字的表已经存在，则抛出 异常；用户可以用IF NOT EXIST选项来忽略这个异常。 EXTERNAL关键