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
