I am trying to make an exact DDL copy of a table from Oracle to Vertica. In Oracle schema I have a table with the following DDL
create table TEST
(
id int,
name# varchar2(100),
city varchar2(100));
The Equivalent Vertica DDL is
create table TEST
(
id int,
name# varchar(100),
city varchar(100));
But when i create the table in Vertica, I get the following error message.
Error:SQL Error [4856] [HY000]: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "#"
I do not see in SQLRefManual anything about column name constraints.
I cannot make changes to Column name as there will be conflict in mapping in ETL.
What can be the solution??
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.