我想知道是否可以从存储在Hadoop文件系统(users.tbl)中的ORC格式文件创建Hive表。据说ORC格式优于文本格式,因此我想知道是否可以使用“stored as orc tblproperties”和“location”属性创建一个Hive表,使其从HDFS文件中读取数据,并以ORC格式存储。下面是示例代码:
create table if not exists users
(USERID BIGINT,
NAME STRING,
EMAIL STRING,
CITY STRING)
STORED AS ORC TBLPROPERTIES ("orc.compress"="SNAPPY")
LOCATION '/tables/users/users.tbl';
替换为文本:
create table if not exists users
(USERID BIGINT,
NAME STRING,
EMAIL STRING,
CITY STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE
LOCATION '/tables/users/users.tbl';