Re: Case sensitiveness of hive partition column

2015-05-12 Thread Sarath Chandra
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 . wrote: > Hi Sarath, > > Hive columns are case sensitive.I've notic

Re: Case sensitiveness of hive partition column

2015-05-12 Thread nitinpathakala .
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 h

Case sensitiveness of hive partition column

2015-05-12 Thread Sarath Chandra
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 loc