'How to create a delta table with invalid characters in column headers
Looking for a work around to create delta table with invalid character (). Below is the example
CREATE TABLE `validation_log` (
`Error_Description` STRING,
`CreatedOn` STRING,
`YearStart` INT,
`YearEnd` INT,
`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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
