Enclose them in backticks. alter table fb_images1 change `_c5` ref_array array<string>;
JVS On Dec 20, 2010, at 3:23 PM, Leo Alekseyev wrote: > Often I forget to name a column that results from running an > aggregation. Then, I'm stuck: describe table lists those columns by > their default names, i.e. something like _c1, but I can't seem to > query or rename those columns: > > alter table fb_images1 change _c5 ref_array array<string>; > FAILED: Parse Error: line 1:30 mismatched input '_c5' expecting > Identifier in rename column name > > Is there a resolution for this? One workaround would be to create a > new table and load the data into it, but it seems inelegant to say the > least. > > --Leo
