In Table DDL, i am using varchar(20) for the column but the data from pandas is varchar(80) for the same column.
I am using pandas_to_vertica function for ingesting data.
How could i populate the below same error using verticapy.
Due to this records are getting dropped.
This error i see while running manual insert in vertica:
SQL Error [8682] [22001]: [Vertica]VJDBC ERROR: String of 61 octets is too long for type Varchar(20) for column name
Using similar code:
resp=pandas_to_vertica(df,
name = {table},
cursor = cur,
schema = "schema",
insert = True
)
print(resp)