Skip to main content
Question

INSERT Errors using vertica docker image

  • March 23, 2020
  • 2 replies
  • 9 views

joergschaber
Forum|alt.badge.img+2

Hi, I am using the vertica-docker image and access Vertica using the jdbc-driver with DBVisualizer or C# Vertica.Data package. I can create an example table with
CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255));
The table is created in the schema public. However, when I try to insert data using
INSERT INTO TABLE public.Persons VALUES(1, 'Max', 'Muster', 'Street_1', 'Berlin');
I get an error : [Code: 4856, SQL State: 42601] [Vertica]VJDBC ERROR: Syntax error at or near "TABLE"
Any idea? Thanks!

2 replies

DaveT
Forum|alt.badge.img
  • Participating Frequently
  • March 23, 2020
I assume you mean you downloaded the virtual image. As for the INSERT statement remove the word “TABLE”. That is not part of the INSERT syntax.

joergschaber
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • March 23, 2020

Ups, that's embarrsing. Thanks!