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

smhumayun

Environment: 

vertica-7.2.3_ovf

VMware-player-12.1.1-3770994

Windows 10

apache spark-1.6.2

vertica-jdbc-7.2.3-0

 

Code:

 

Properties jdbcProperties = new Properties();
jdbcProperties.put("driver", "com.vertica.jdbc.Driver");
jdbcProperties.put("user", "testuser");
jdbcProperties.put("password", "testpassword");
dataFrame
        .write()
        .mode(SaveMode.Overwrite)
        .jdbc("jdbc:vertica://xxx.xxx.xxx.xxx:5433/testdb", "testtable", jdbcProperties);

 

Error:

 

java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type "TEXT" does not exist
        at com.vertica.util.ServerErrorData.buildException(Unknown Source)
        at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
        at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
        at com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source)
        at com.vertica.jdbc.common.SStatement.executeUpdate(Unknown Source)
        at org.apache.spark.sql.DataFrameWriter.jdbc(DataFrameWriter.scala:302)
        at com.conurets.etl.parsers.SiteDataParser.parse(SiteDataParser.java:132)
        at com.conurets.etl.EtlRunner.<init>(EtlRunner.java:29)
        at com.conurets.etl.EtlRunner.main(EtlRunner.java:39)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.spark.deploy.SparkSubmit$.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:731)
        at org.apache.spark.deploy.SparkSubmit$.doRunMain$1(SparkSubmit.scala:181)
        at org.apache.spark.deploy.SparkSubmit$.submit(SparkSubmit.scala:206)
        at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:121)
        at org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala)
Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type "TEXT" does not exist
        ... 18 more

 

Amit2413

Hi, Did you get any solution to your query because i am getting the same error while trying with my code

Bryan_H

Could you describe your environment? Are you using more recent JDBC and Spark connectors available from Maven Central or https://github.com/vertica/spark-connector ?