You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I tried to read data from a s3 source. The bucket had one csv file. Attached the sample csv file.
In the attached file there are 2 colums starting with upper case (Age and Credit_rating). For those 2 columns the duck db does not have data. (attached screenshot)
If i change all the column names to lower case then everything works fine.
And also if the column names are hyphen separated then "missing column" error is thrown. TestData.csv
The text was updated successfully, but these errors were encountered:
@divyagowdab - This is very helpful feedback - thank you.
We will see if I can reproduce this using the File source, and will report back.
aaronsteers
changed the title
If the column names in the data source are not in lower case then the data inserted in duckdb will be empty
🐛 Bug: Mixed case column names in S3 source results in empty data when loaded to DuckDB
Mar 7, 2024
aaronsteers
changed the title
🐛 Bug: Mixed case column names in S3 source results in empty data when loaded to DuckDB
🐛 Bug: Mixed case column names from Source S3 is causing empty data when loaded to DuckDB
Mar 7, 2024
I tried to read data from a s3 source. The bucket had one csv file. Attached the sample csv file.
In the attached file there are 2 colums starting with upper case (Age and Credit_rating). For those 2 columns the duck db does not have data. (attached screenshot)
If i change all the column names to lower case then everything works fine.
And also if the column names are hyphen separated then "missing column" error is thrown.
TestData.csv
The text was updated successfully, but these errors were encountered: