Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Amiran
Partner - Contributor II
Partner - Contributor II

Connector reply error: QVX_SYNTAX_ERROR

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"

 

 

 

Screenshot 2020-12-29 162114.png

 

Does anyone know what can I do to solve it?

1 Solution

Accepted Solutions
Amiran
Partner - Contributor II
Partner - Contributor II
Author

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

View solution in original post

1 Reply
Amiran
Partner - Contributor II
Partner - Contributor II
Author

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