Thanks! That allows me to change the column. Ryan
On Thu, Feb 25, 2010 at 9:59 AM, Edward Capriolo <[email protected]>wrote: > On Thu, Feb 25, 2010 at 9:51 AM, Edward Capriolo <[email protected]> > wrote: > > On Thu, Feb 25, 2010 at 7:22 AM, Ryan LeCompte <[email protected]> > wrote: > >> Hey guys, > >> > >> It looks like Hive 0.5.0 is not working with our existing table > definitions > >> that have a column named "first". > >> > >> When we try to reference this column or create a new table with this > column, > >> Hive fails and says that there is a missing column identifier. > >> > >> I think that Hive 0.5.0 may now have "first" as a reserved keyword of > some > >> sort? > >> > >> Is there a way to get around this? Would really like to keep this column > >> name if at all possible? > >> > >> Thanks, > >> Ryan > >> > >> > > > > I noticed this as well. Good catch Ryan > > > > Forgot to mention the workaround. I believe you can > > select `first` > > using backticks >
