java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type “TEXT” does not exist

sparkexpert.com | 4 months ago
  1. 0

    loading parquet file into vertica database using spark

    Stack Overflow | 1 year ago | indicoder
    java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type “TEXT” does not exist
  2. 0

    Save apache spark dataframe to database – Spark Expert

    sparkexpert.com | 4 months ago
    java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type “TEXT” does not exist
  3. 0

    Re: Exporting to non standard databases

    apache.org | 11 months ago
    java.io.IOException: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ","
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Does Vertica support parquet files??? - HPE Developer Community

    hpe.com | 6 months ago
    java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](5108) ERROR: Type "TEXT" does not exist
  6. 0

    If we run a simple transformation that read data and publish in database using Vertica Bulk Loader, the transformation is hanged til we click in stop the transformation execution. *Steps to Reproduce* # Open spoon # Create a transformation # Add a CSV input step and Vertica Bulk Loader step. # Hop the steps # Configure the CSV input step to read data from a csv file (see attached) # Connect the Vertica step to a database instance # Checked the option Specify Database Fields and do not add any field. # Save the transformation and run it *Actual Result* An error occurs running the transformation but the transformation stills executing, doesn't stop until user press to stop. {code} 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : SQL Error during statement execution. 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.util.ServerErrorData.buildException(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:260) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at java.lang.Thread.run(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ... 6 more {code} *Expected Result* The transformation should stop after an error is detected.

    Pentaho BI Platform Tracking | 1 year ago | Emanuel Teixeira
    java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")"

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

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

      at com.vertica.util.ServerErrorData.buildException()
    2. com.vertica.util
      ServerErrorData.buildException
      1. com.vertica.util.ServerErrorData.buildException(Unknown Source)
      1 frame
    3. com.vertica.io
      ProtocolStream.readExpectedMessage
      1. com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
      1 frame
    4. com.vertica.dataengine
      VDataEngine.prepare
      1. com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
      2. com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
      3. com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
      3 frames
    5. com.vertica.jdbc
      SConnection.prepareStatement
      1. com.vertica.jdbc.common.SPreparedStatement.<init>(Unknown Source)
      2. com.vertica.jdbc.jdbc4.S4PreparedStatement.<init>(Unknown Source)
      3. com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.<init>(Unknown Source)
      4. com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
      5. com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)
      5 frames
    6. Spark Project SQL
      DataFrame.createJDBCTable
      1. org.apache.spark.sql.DataFrameWriter.jdbc(DataFrameWriter.scala:275)
      2. org.apache.spark.sql.DataFrame.createJDBCTable(DataFrame.scala:1611)
      2 frames
    7. com.sparkread.SparkVertica
      JdbctoVertica.main
      1. com.sparkread.SparkVertica.JdbctoVertica.main(JdbctoVertica.java:51)
      1 frame