How to create a delta table with invalid characters in column headers

Viewed 171

Looking for a work around to create delta table with invalid character (). Below is the example

CREATE TABLE `log` (
  `Error_Description` STRING,
  `Age(months)` STRING,
  `%Role` STRING)
 USING Delta
Error in SQL statement: AnalysisException: Attribute name "Age(months)" 
contains invalid character(s) among " ,;{}()\n\t=". Please use alias to rename it.
0 Answers
Related