Presto queries the data of Apache druid and inserts it into kudu. Occasionally, an error is reported: generic_INTERNAL_Error (65536)
java.lang.illegalargumentexception: unknown field druid.druid. Data source name. Field name: varchar
com.google.common.base.preconditions.checkargument (preconditions. Java: 216)
Check the Druid log and find the corresponding error:
unknown exception (org. Apache. Cite. Tools. Validationexception): org. Apache. Cite. Runtime. Calculecontextexception: from line 2, column 8 to line 2, column 12: column ‘field name’ not found in any table
in addition, errors are occasionally reported when using superset to obtain the data preview of the corresponding Druid data source
Problem analysis:
1. First, judge that it should be a druid problem. The same operation only occasionally reports an error. It is suspected that it is a druid broker problem
2. It is found that the results of querying the number of columns of the same data source through different brokers are inconsistent (SQL: select count (*) columncount from information_schema. Columns where table_neme = ‘data source name’). This may be because historical has not provided services to all segments when the broker is restarted by rolling (after restarting historical, the segment load is not completed, and the segment is still being loaded gradually), resulting in different schema information such as dimension indicators obtained through the segment at different times.
Solution: restart the broker after historically loading segments to ensure that the dimension indicators and other schema information obtained by the broker through segments are consistent. Subsequent restart of the broker should ensure that all segments in the cluster provide services normally.
Summary: the reason for error reporting is that the schema information obtained twice is inconsistent. The inconsistency may be caused by adding or deleting columns, or modifying column names and column data types. To solve the problem of inconsistent schema information, you can solve the current error reporting.
Read More:
- [Solved] error: ‘xcb_generic_event_t’ was not declared in this scope
- [Solved] error processing package libapache2-mod-php7.2
- [Solved] thymeleaf.TemplateEngineException processing template “main“: An error happened during template pars
- Maven Packaging ERROR: Some problems were encountered while processing the POMs
- jmeter Execute to create Chart Error: An error occurred: Error while processing samples: Mismatch between ……
- [Solved] GDAL+OPENCV often reports errors when processing remote sensing impacts
- [Solved] An error occurred while processing your request…enable the Development environment by setting …
- IDEA reports an error Could not reserve enough space for xxxxKB object heap processing
- Failed to copy files Error processing tar file [How to Solve]
- [Solved] Request processing failed; nested exception is java.lang.NullPointerException
- Error: uncaughtexception: cannot find module ‘internal / util / types’
- [Solved] Hive Error while processing statement: FAILED: Execution Error
- POI Export Excel Error: HTTP Status 500 – Request processing failed; nested exception is java.lang.NullPointerException
- [Solved] Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.
- [Solved] appium Error: An unknown server-side error occurred while processing the command
- [How to Solve] Internal: blas sgemm launch failed
- [Solved] ASP Website Error: An error occurred on the server when processing the URL.
- [Solved] ANSYS error: accelerations are exceeding internal limit
- Request processing failed; nested exception is com.alibaba.fastjson.JSONException: can not cast to J
- [Solved] HiveSQL Error: “Error while processing statement: FAILED: Execution Error, return code 2“