Uploaded image for project: 'Zeppelin'
  1. Zeppelin
  2. ZEPPELIN-5250

Unable to run tpcds query 1 via presto on jdbc

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.9.0, 0.10.0
    • None
    • JdbcInterpreter
    • None

    Description

      java.sql.SQLException: Error executing query
              at com.facebook.presto.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:279)
              at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:228)
              at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
              at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
              at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:770)
              at org.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:901)
              at org.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:47)
              at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110)
              at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:852)
              at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:744)
              at org.apache.zeppelin.scheduler.Job.run(Job.java:172)
              at org.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:132)
              at org.apache.zeppelin.scheduler.ParallelScheduler.lambda$runJobInScheduler$0(ParallelScheduler.java:46)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.IllegalArgumentException: ParameterKind is [TYPE] but expected [LONG]
              at com.facebook.presto.jdbc.internal.spi.type.TypeSignatureParameter.getValue(TypeSignatureParameter.java:87)
              at com.facebook.presto.jdbc.internal.spi.type.TypeSignatureParameter.getLongLiteral(TypeSignatureParameter.java:99)
              at com.facebook.presto.jdbc.ColumnInfo.setTypeInfo(ColumnInfo.java:194)
              at com.facebook.presto.jdbc.PrestoResultSet.getColumnInfo(PrestoResultSet.java:1868)
              at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:121)
              at com.facebook.presto.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:250)
              ... 15 more 

      Attachments

        Activity

          People

            Unassigned Unassigned
            zjffdu Jeff Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: