CODEWITHSUNDEEP
logstashteradatalogstash-configurationteradatasqllogstash-jdbc
C.Mahfoud
C.Mahfoud

Reputation: 90

LIMIT keyword is unknown by Teradata Database

I am using jdbc_static plugin with a simple select query

jdbc_static{
        id => "JDBC_STATIC_APPLICATION_MIND_MAPPING"
        loaders => [
        {
            id => "REMOTE_MAPPING"
            query => "select field1, field2 FROM DB.view"
            local_table => "LOCAL__MAPPING_COLUMNS"
        }
        ]
...

        jdbc_user => "USR"
        jdbc_password => "PW"
        jdbc_connection_string => "jdbc:teradata://SCH/database=DB"
        jdbc_driver_class => "com.teradata.jdbc.TeraDriver"

...

I get the data from a Teradat DB, but the count query excuted by the package is causing me an issue,

The error:

[2022-09-12T11:45:36,171+02:00][ERROR][logstash.filters.jdbc.readonlydatabase] Exception occurred when executing loader Jdbc query count {:exception=>"Java::JavaSql::SQLException: [Teradata Database] [TeraJDBC 16.00.00.23] [Error 3706] [SQLState 42000] Syntax error: expected something between the word 'T1' and the 'LIMIT' keyword.", :backtrace=>["com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(com/teradata/jdbc/jdbc_4/util/ErrorFactory.java:309)", "com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(com/teradata/jdbc/jdbc_4/statemachine/ReceiveInitSubState.java:103)", "com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(com/teradata/jdbc/jdbc_4/statemachine/StatementReceiveState.java:311)", "com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(com/teradata/jdbc/jdbc_4/statemachine/StatementReceiveState.java:200)"

my logstash version is 6.5.4

Do you have a solution for that issue?

Upvotes: 0

Views: 46

Answers (0)

Related Questions