hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "446463844@qq.com" <446463...@qq.com>
Subject how to load ORC file into hive orc table
Date Sat, 17 Dec 2016 08:06:41 GMT
Hi All:
I create a orc table in hive

create table if not exists user_tag (
rowkey STRING , 
cate1 STRING ,
cate2 STRING ,
cate3 STRING ,
cate4 STRING 
)
PARTITIONED BY (timestamp STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS orc
LOCATION '/user/hive/warehouse/kylinlabel.db/user_tag';

and I generate a orc file in spark  and I put this file into path /user/hive/warehouse/kylinlabel.db/user_tag

/user/hive/warehouse/kylinlabel.db/user_tag/part-r-00000-920282f9-4d68-4af8-81c5-69522df3d374.orc
this is the file path.
I find there is no data in user_tag table
Why?



446463844@qq.com
Mime
View raw message