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
