hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sarath Chandra <sarathchandra.jos...@algofusiontech.com>
Subject Re: Case sensitiveness of hive partition column
Date Tue, 12 May 2015 11:45:19 GMT
Thanks Nitin. I'm using 0.13.1 version.
I think they documentation needs to be updated to highlight this so that
beginner users like me doesn't need to struggle to figure it out.


On Tue, May 12, 2015 at 5:09 PM, nitinpathakala . <nitinpathakala@gmail.com>
wrote:

> Hi Sarath,
>
> Hive columns are case sensitive.I've noticed it in hive 0.14 version.I
> remember column name was insensitive for earlier versions.
>
> Regards,
> Nitin
> On May 12, 2015 5:03 PM, "Sarath Chandra" <
> sarathchandra.josyam@algofusiontech.com> wrote:
>
>> Hi All,
>>
>> I've created a external table in hive as -
>> create table table1(...) partitioned by(CONTEXT_ID string) row format
>> delimited fields terminated by '\\;' location '/user/sarath/table1/';
>>
>> Then I created a HDFS folder as '/user/sarath/table1/CONTEXT_ID=A123' and
>> copied the data file to this location.
>>
>> I altered the table from hive shell to add this partition as -
>> alter table table1 add partition(CONTEXT_ID='A123');
>>
>> When I tried "select * from table1" I was not getting any data.
>>
>> I searched several blogs and did several trials. Then I figured out that
>> if I change the case of partition column from "CONTEXT_ID" to "context_id"
>> and create HDFS folder with the same case then it works.
>>
>> I was of opinion that hive column names are case insensitive in Hive. Is
>> there something I'm missing?
>>
>> Regards,
>> Sarath.
>>
>

Mime
View raw message