incubator-hcatalog-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Travis Crawford <>
Subject Re: pig/hive case sensitivity issue
Date Fri, 29 Jun 2012 17:58:13 GMT
I started playing around with making Hive optionally case sensitive
and on the metastore side its pretty straightforward, but the
assumption is baked in at a pretty low level elsewhere in the code.
For now I think we're going to modify the scripts to use lowercase
fields. Maybe we'll revisit in the future but it would be a Whole


On Fri, Jun 29, 2012 at 9:59 AM, Alan Gates <> wrote:
> Pig has a well established, if seriously confusing, set of rules around case sensitivity,
so I'm not excited to change those rules.
> I don't know anything about the Hive option to make fields case sensitive; I haven't
tried it.
> Alan.
> On Jun 25, 2012, at 11:24 AM, Travis Crawford wrote:
>> Hey hcat gurus -
>> Has anyone run into issues with pig fields being case sensitive, but
>> hive lowercasing all field names? We have some existing data stored
>> with camelCase schemas and the pig scripts require some changes when
>> porting. Its pretty straightforward to update the scripts, but
>> confusing for users who don't realize their capitol letters are
>> swallowed by hive.
>> Looking at
>> it seems pretty straightforward to make case sensitive fields
>> optional. Or should pig deal with this automatically? Curious what
>> others are doing here.
>> --travis

View raw message