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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

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]
via mapr.com by Unknown author, 1 year 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]
via Stack Overflow by sake
, 1 year ago
java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 4 bytes, but had 2
via Stack Overflow by chhaya vishwakarma
, 1 year ago
org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108 (XCL08): Cache of region boundaries are out of date.
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)