Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE: How can I use DELIMITED and SERDE in ROW FORMAT together?

HIVE: How can I use DELIMITED and SERDE in ROW FORMAT together?

Rising Star

Dear expert,

In order to use blob, I found this tech

https://issues.apache.org/jira/browse/HIVE-637

But my question is How can I use DELIMITED and SERDE in ROW FORMAT together? like below

CREATE EXTERNAL TABLE IF NOT EXISTS TEST.EMP_PHOTO2
 (EMPNO   Char(6),
PHOTO_FORMAT   VARCHAR(10),
PICTURE1  STRING,
PICTURE2  BINARY
)
COMMENT 'table LOB test'
   ROW FORMAT DELIMITED
   FIELDS TERMINATED BY '`'
   SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
    'serialization.last.column.takes.rest'='true'
  )
   STORED AS TEXTFILE
   location '/user/hive/TEST.EMP_PHOTO';

Thanks!