Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I get this error when trying to load a table from Snowflake with around 400 mil rows,
It happens even when I am trying to load the first 100 rows,
all the other tables are loaded perfectly, the problem is just with this one
The following error occurred:
Connector reply error: QVX_SYNTAX_ERROR: *Failed to process query: Could not parse line 1:7 mismatched input '"SECTION_ACCESS_REDUCTION"' expecting {'*', ESCAPED_ID, ID}Could not parse line 16:11 token recognition error at: '.'Could not parse line 16:5 mismatched input '"QLIK"' expecting ID
The error occurred here:
SELECT "SECTION_ACCESS_REDUCTION",
"SOURCE_DB",
"PROJECT_ID",
"PROJECT_NAME",
"LOCALE_MAPPER",
"LOCATION_ID",
"LOCATION_NAME",
"AL_LOCATION_ID",
"START_DATE",
"TEMPERATURE",
"HUMIDITY",
"WIND_SPEED",
"RADIATION",
"PRECIPITATION",
"NDVI_INDEX"
FROM "QLIK"."VW_INSURANCE_METEOROLOGICAL_MEASUREMENTS_DAILY"
Does anyone know what can I do to solve it?
The problem was that I was changing to GeoAnalytic connection but was trying to load from Snowflake connection,
when I change it to the right connection order its solved it
The problem was that I was changing to GeoAnalytic connection but was trying to load from Snowflake connection,
when I change it to the right connection order its solved it