Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. & table properties, types, domains, etc.
MIT License
172
stars
39
forks
source link
The parser fails to parse columns with space in them #238
The first column with a space has issues in parsing {'name': 'week', 'type': 'ending string', 'size': None, 'references': None, 'unique': False, 'nullable': True, 'default': None, 'check': None}
@soujyosen hi, thanks for opening the issue, can you provide link to the documentation - what DB is supports creating column names without quotes and with spaces in names?
DDL: CREATE EXTERNAL TABLE IF NOT EXISTS competitor_analytics.wtp_weekly_unique_hirer_by_billing_paid_budget_sheet_target (
week ending
string,dbhk
string,jsmy
string,jssg
string,jsid
string,jsph
string,dbth
string,total
string ) COMMENT 'Active CSV target benchmarking data uploads for Weekly Trading Pack. Updated on a yearly and need-based frequency. Sourced from Microsoft Shared Folder and JobSeeker Dashboard.' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' LOCATION 's3://demo/path' TBLPROPERTIES ("skip.header.line.count" = "1");The first column with a space has issues in parsing {'name': '
week', 'type': 'ending
string', 'size': None, 'references': None, 'unique': False, 'nullable': True, 'default': None, 'check': None}