Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?

Labels (1)
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