[Vertica][VJDBC](5108) ERROR: Type "TEXT" does not exist

I'm working on Pyspark. I need to save a DataFrame to vertica table. But I got error:

[Vertica]VJDBC ERROR: Type "TEXT" does not exist

My DataFrame has some columns with string type, but vertica has VARCHAR.

root
|-- STARTHOUR: timestamp (nullable = true)
|-- CELL: string (nullable = true)
|-- Risk1: integer (nullable = true)
|-- Risk2: integer (nullable = true)
|-- Risk3: integer (nullable = true)
|-- MGRSID: string (nullable = true)
|-- LAT: double (nullable = true)
|-- LONG: double (nullable = true)
|-- ALERT_TYPE: string (nullable = true)

Do you have any solution? I saw some where mentioned solution with Scala. But I'm looking for solution on Pyspark. Any help is appreciated.

Thanks,
Helen

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file