CREATE TABLE语句
(不区分大小写)
Create Table是用于在Hive中创建表的语句,语法和示例如下:
语法:
CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.] table_name
[(col_name data_type [COMMENT col_comment], ...)]
[COMMENT table_comment]
[ROW FORMAT row_format]
[STORED AS file_format]
示例:
假设需要使用CREATE TABLE语句创建一个名为employee表,下表列出了employee表中的字段和数据类型:
创建表的语句如下:
hive> CREATE TABLE IF NOT EXISTS employee ( eid int, name String,
> salary String, destination String)
> COMMENT ‘Employee details’
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ‘\t’
> LINES TERMINATED BY ‘\n’
> STORED AS TEXTFILE;
成功创建表后,能看到以下回应:
OK
Time taken: 5.905 seconds
hive>
JDBC 程序
以下是使用JDBC程序来创建表的一个例子