Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5248

You tried to write a VarChar type when you are

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      We have weird problem while executing the query. below is the exception where we are facing the issue, the weird part is we can execute the same query while we are configuring the dev mongo database, we are only facing issue when we configure the production Mongo db, Could you please help us on this immediately.

      Query :
      SELECT q.productDetails.quantity from mongo.LAM.`Quotes` as q

      DATA_READ ERROR: You tried to write a VarChar type when you are using a ValueWriter of type NullableFloat8WriterImpl.
      Line 1
      Column 208
      Field quantity
      Fragment 0:0
      [Error Id: e13ab75b-b915-410b-8af8-50cd0bcacebe on FNB-127:31010]
      class java.sql.SQLException
      org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:232)
      org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:275)
      org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1943)
      org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:76)
      oadd.org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
      org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:465)
      oadd.org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
      org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:169)
      oadd.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
      oadd.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
      org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
      org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:322)
      org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:408)
      org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
      org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
      org.apache.zeppelin.scheduler.Job.run(Job.java:176)
      org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
      java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      java.util.concurrent.FutureTask.run(FutureTask.java:266)
      java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
      java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      java.lang.Thread.run(Thread.java:745)

      Attachments

        Activity

          People

            Unassigned Unassigned
            prasen.gupta Prasengupta
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified