org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY"

Pentaho BI Platform Tracking | Emanuel Teixeira | 2 years ago
  1. 0

    In a transformation, I have created a Table Input and Table Ouput. In the first settings I set the Table Input to read the table movielens and the TableOutput just read the data from Table Input and insert in a new table (called QAMovie). Then, I changed in Table Input to read ML_SDR_, and in Table Ouput I click in SQL and perform the changes in the created table, when I executed the SQL query with Alter Table several errors. The displayed error is corrected? And the error message 'Syntax error at or near (...)' is correct? See attached image. org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at org.pentaho.di.core.database.Database.execStatement(Database.java:1517) at org.pentaho.di.core.database.Database.execStatement(Database.java:1465) at org.pentaho.di.ui.core.database.dialog.SQLEditor.exec(SQLEditor.java:398) at org.pentaho.di.ui.core.database.dialog.SQLEditor.access$200(SQLEditor.java:81) at org.pentaho.di.ui.core.database.dialog.SQLEditor$7.handleEvent(SQLEditor.java:242) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:884) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8697) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7908) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.common.SStatement.execute(Unknown Source) at org.pentaho.di.core.database.Database.execStatement(Database.java:1491) ... 27 more Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" ... 34 more

    Pentaho BI Platform Tracking | 2 years ago | Emanuel Teixeira
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY"
  2. 0

    In a transformation, I have created a Table Input and Table Ouput. In the first settings I set the Table Input to read the table movielens and the TableOutput just read the data from Table Input and insert in a new table (called QAMovie). Then, I changed in Table Input to read ML_SDR_, and in Table Ouput I click in SQL and perform the changes in the created table, when I executed the SQL query with Alter Table several errors. The displayed error is corrected? And the error message 'Syntax error at or near (...)' is correct? See attached image. org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at org.pentaho.di.core.database.Database.execStatement(Database.java:1517) at org.pentaho.di.core.database.Database.execStatement(Database.java:1465) at org.pentaho.di.ui.core.database.dialog.SQLEditor.exec(SQLEditor.java:398) at org.pentaho.di.ui.core.database.dialog.SQLEditor.access$200(SQLEditor.java:81) at org.pentaho.di.ui.core.database.dialog.SQLEditor$7.handleEvent(SQLEditor.java:242) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:884) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8697) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7908) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.common.SStatement.execute(Unknown Source) at org.pentaho.di.core.database.Database.execStatement(Database.java:1491) ... 27 more Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" ... 34 more

    Pentaho BI Platform Tracking | 2 years ago | Emanuel Teixeira
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY"
  3. 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 ")"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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 ")"
  6. 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 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. com.vertica.support.exceptions.SyntaxErrorException

      [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY"

      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.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
    4. com.vertica.jdbc
      SStatement.execute
      1. com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source)
      2. com.vertica.jdbc.common.SStatement.execute(Unknown Source)
      2 frames
    5. org.pentaho.di
      SQLEditor$7.handleEvent
      1. org.pentaho.di.core.database.Database.execStatement(Database.java:1491)
      2. org.pentaho.di.core.database.Database.execStatement(Database.java:1465)
      3. org.pentaho.di.ui.core.database.dialog.SQLEditor.exec(SQLEditor.java:398)
      4. org.pentaho.di.ui.core.database.dialog.SQLEditor.access$200(SQLEditor.java:81)
      5. org.pentaho.di.ui.core.database.dialog.SQLEditor$7.handleEvent(SQLEditor.java:242)
      5 frames
    6. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      2. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      4 frames
    7. org.pentaho.di
      TransGraph.mouseDoubleClick
      1. org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:884)
      2. org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124)
      3. org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8697)
      4. org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027)
      5. org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744)
      5 frames
    8. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    9. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7908)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648)
      4 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    11. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
      1 frame