java.lang.RuntimeException

java.sql.SQLException: SYSTEM ERROR: DrillRuntimeException: Join only supports implicit casts between 1. Numeric data 2. Varchar, Varbinary data 3. Date, Timestamp data Left type: DATE, Right type: INT. Add explicit casts to avoid this error Fragment 1:20 [Error Id: cac947b3-168f-4526-a7fa-c0e19311697d on atsqa4-133.qa.lab:31010]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web54480

  • via Apache's JIRA Issue Tracker by Victoria Markman, 1 year ago
    java.sql.SQLException: SYSTEM ERROR: DrillRuntimeException: Join only supports implicit casts between 1. Numeric data 2. Varchar, Varbinary data 3. Date, Timestamp data Left type: DATE, Right type: INT. Add explicit casts to avoid this error Fragment 1:20 [Error Id: cac947b3-168f-4526-a7fa-c0e19311697d on atsqa4-133.qa.lab:31010]
  • java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: Sort doesn't currently support sorts with changing schemas Fragment 0:0 [Error Id: 86b2b995-0143-4941-a550-5f60ddb0862d on atsqa4-133.qa.lab:31010]
  • via mapr.com by Unknown author, 10 months ago
    java.sql.SQLException: DATA_READ ERROR: You tried to start when you are using a ValueWriter of type NullableVarCharWriterImpl. File /Users/vince/src/drill-data-prep-example/schema-change/data/vince.json Record 1 Line 1 Column 127 Field flavors Fragment 0:0 [Error Id: 2c9020c1-cfcf-42e2-926c-d00962ceb7f9 on 192.168.56.1:31010]
  • Stack trace

    • java.lang.RuntimeException: java.sql.SQLException: SYSTEM ERROR: DrillRuntimeException: Join only supports implicit casts between 1. Numeric data 2. Varchar, Varbinary data 3. Date, Timestamp data Left type: DATE, Right type: INT. Add explicit casts to avoid this error Fragment 1:20 [Error Id: cac947b3-168f-4526-a7fa-c0e19311697d on atsqa4-133.qa.lab:31010] at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) at sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:87) at sqlline.TableOutputFormat.print(TableOutputFormat.java:118) at sqlline.SqlLine.print(SqlLine.java:1583) at sqlline.Commands.execute(Commands.java:852) at sqlline.Commands.sql(Commands.java:751) at sqlline.SqlLine.dispatch(SqlLine.java:738) at sqlline.SqlLine.begin(SqlLine.java:612) at sqlline.SqlLine.start(SqlLine.java:366) at sqlline.SqlLine.main(SqlLine.java:259)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.