hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunita Arvind <sunitarv...@gmail.com>
Subject unable to partition the table
Date Wed, 26 Jun 2013 22:47:36 GMT
Hi,

I am unable to create a partitioned table.
The error I get is:
FAILED: ParseException line 37:16 mismatched input
'"jobs.values.postingDate.year"' expecting Identifier near '(' in column
specification

I tried referring to the columns in various ways,
S.jobs.values.postingDate.year, with quotes, without quotes, get the same
error. Also tried creating a partition by year alone. Still get the same
error.

Here is the create table statement:

create external table linkedin_JobSearch (
jobs STRUCT<
values : ARRAY<STRUCT<
company : STRUCT<
id : STRING,
name : STRING>,
postingDate : STRUCT<
day : STRING>,
descriptionSnippet : STRING,
expirationDate : STRUCT<
......
.......
locationDescription : STRING>>>
)
PARTITIONED BY ("jobs.values.postingDate.year" STRING,
"jobs.values.postingDate.month" STRING)
ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
WITH SERDEPROPERTIES (
"company"="$.jobs.values.company.name",
"position"="$.jobs.values.position.title",
"customerJobCode"="$.jobs.values.customerJobCode",
"locationDescription"="$.jobs.values.locationDescription",
"jobPoster"="$.jobs.values.jobposter.headline"
)
LOCATION '/user/sunita/Linkedin/JobSearch';

I need to be able to partition this information. Please help.

regards
Sunita

Mime
View raw message