Vertica, Column "CTID" does not exist

I use

DataGrip 2017.2.2
Build #DB-172.4155.28, built on September 6, 2017
JRE: 1.8.0_152-release-915-b11 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Windows 10 10.0

With Vertica 8

Today I tried to open a table (Region) and receiver an error

[42703][2624] [Vertica][VJDBC](2624) ERROR: Column "CTID" does not exist java.lang.RuntimeException: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](2624) ERROR: Column "CTID" does not exist

The same situation with other tables.

How to solve this issue ?

4
3 comments
Avatar
Permanently deleted user

same problem

0

Please, set Generic dialect in data source properties instead of Postgres and the re-sync.

-1
Avatar
Permanently deleted user

It did not help

1

Please sign in to leave a comment.