Hive error: Error while compiling statement: FAILED: ParseException line 3:47 missing : at 'array' near '<EOF>'

0
votes

I want to create array of structure within the structure. 

CREATE EXTERNAL TABLE TEST_EXTTBL_PAGE_VISIT_MASTER
(
    PERSONALIZATION_DATA STRUCT<EXPOSED_RULES array<struct<RULE_ID:varchar(70),RULESETID:varchar(70)>>>
)
COMMENT 'Page Visit details'
row format delimited fields terminated by ','
collection items terminated by '|'
map keys terminated by ':'
lines terminated by '\n'
LOCATION 's3a://XXX';

Please suggest what im missing here.

1
hadoophivehiveql

1 Answers

0
votes

you are missing ":" after your array name

CREATE EXTERNAL TABLE TEST_EXTTBL_PAGE_VISIT_MASTER
(
    PERSONALIZATION_DATA STRUCT<EXPOSED_RULES: array<struct<RULE_ID:varchar(70),RULESETID:varchar(70)>>>
)
COMMENT 'Page Visit details'
row format delimited fields terminated by ','
collection items terminated by '|'
map keys terminated by ':'
lines terminated by '\n'
LOCATION 's3a://XXX';