autophagy
commented
4 years ago Hi @Darkeye9, thanks for raising this issue.
I've not been able to replicate this so far. I grabbed a sample csv file from NOAA, just some hourly sample precipitation data: https://catalog.data.gov/dataset/u-s-hourly-precipitation-data
I ran CrateDB 4.1.1 via docker, and created the following table:
CREATE TABLE IF NOT EXISTS "doc"."precipitation" (
"DATE" TEXT,
"STATION" TEXT,
"HPCP" TEXT,
"Measurement Flag" TEXT,
"LONGITUDE" TEXT,
"Quality Flag" TEXT,
"ELEVATION" TEXT,
"LATITUDE" TEXT,
"STATION_NAME" TEXT
);I then loaded the sample csv from a HTTPS source.
cr> copy precipitation FROM 'https://www1.ncdc.noaa.gov/pub/data/cdo/samples/PRECIP_HLY_sample_csv.csv' WITH (format='csv') return summary;
[
{
"node": {
"id": "H5LkrrDBS4eBDnNygOVAig",
"name": "Wandfluhhorn"
},
"uri": "https://www1.ncdc.noaa.gov/pub/data/cdo/samples/PRECIP_HLY_sample_csv.csv",
"success_count": 3,
"error_count": 0,
"errors": {}
}
]
COPY 1 row in set (0.632 sec)Would you be able to provide me more details about the certificate of your desired target? Whether it was self signed, its certificate authority, etc. Might help us narrow down the issue.
Also, just to be sure, would you be able to tell me which version of CrateDB you're running?
Thank you!
Darkeye9
Hi all,
When trying to import a large CSV file from a HTTPS server, crate complains about certificate validation:
Maybe cratedb docker container is missing some CA configuration?
Thanks for your support.