有两种方法可以在配置单元中创建表：
1-创建外部表架构：

CREATE EXTERNAL TABLE IF NOT EXISTS names_text(
          student_ID INT, FirstName STRING, LastName STRING,    
          year STRING, Major STRING)
          COMMENT 'Student Names'
          ROW FORMAT DELIMITED
          FIELDS TERMINATED BY ','
          STORED AS TEXTFILE
          LOCATION '/user/andrena';

2-a）为托管表创建架构：

CREATE TABLE IF NOT EXISTS Names(
  student_ID INT, FirstName STRING, LastName STRING,    
  year STRING, Major STRING)
  COMMENT 'Student Names'
  STORED AS ORC;

b） 将外部表数据移动到托管表：

INSERT OVERWRITE TABLE Names SELECT * FROM names_text;

最后，验证配置单元仓库是否分别在外部表和内部表中存储了学生姓名：

SELECT * FROM names_text;

SELECT * from Names;