How to handle Vertica Columns having Dot(.)
We have a requirement where we are building Vertica Flex tables from JSON files. As its automatically getting created we have few column names like:
Now I am not able to select those columns directly using the column names, Ex:
Select temp.source,temp.email,temp.name, temp.id from temp_table;
YThe above statement gives me error saying, column temp does not exit. I know its because of Dot(.) present in between the column name. Now if I put the column names with in quote(" ") like below, I am not getting that error
Select "temp.source","temp.email","temp.name", "temp.id" from temp_table;
Is there any other way of handling this without adding quotes or updating the column names.
Any help would be much appreciated.