hive创建分区表 指定分隔符_使用“as select”创建配置单元表或“喜欢”并指定分隔符...

Is it possible to do a

create table as select

using

row format delimited fields terminated by '|';

or to do a

create table like row format delimited fields terminated by '|';

The Language Manual seems to indicate not.. but something tickles me I had achieved this in the past.

解决方案Create Table as select (CTAS) is possible in Hive.

You can try out below command:

CREATE TABLE new_test

row format delimited

fields terminated by '|'

STORED AS RCFile

AS select * from source where col=1

Target cannot be partitioned table.

Target cannot be external table.

It copies the structure as well as the data

Create table like is also possible in Hive.

It just copies the source table definition.