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 . <nitinpathak...@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.jos...@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. >> >