How does I get geometry informations from MySQL db
28 views
Skip to first unread message
redfa...@gmail.com
Mar 31, 2020, 1:47:57 PM3/31/20
to Metatron Discovery User Group
I've create a table in Mysql with a geometry column where I store a point element.
Mysql produce an element with description geometry B, it's a WKB element,
in Metatron when I try to create a Datasource using
- Table (option) reading information using the table contents native from db I got a message It must be in WKT format.
- Query (option) using a sql statement SELECT AsWKT(Posizione) FROM `test1` I see the right data in format like POINT(42.35122196 13.39843823) and everything seems good until the final step where I got a failure with a long log (see the tail of this message)
I've tried not only the aswkt function but also the ST_ASTEXT, ST_ASWKT and ASTEXT with the same results.
Did yo've any suggestion?
thanks
2020-03-31T23:42:18,983 INFO [main] io.druid.cli.Main - Starting with default timezone[UTC], properties[]
2020-03-31T23:42:19,122 INFO [main] io.druid.guice.PropertiesModule - Loading properties from _common/common.runtime.properties (file:/usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3/conf/druid/_common/common.runtime.properties)
2020-03-31T23:42:19,147 INFO [main] org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 5.1.3.Final
2020-03-31T23:42:19,393 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [object] is registered with class [class io.druid.segment.serde.ComplexMetricSerde$Dummy]
2020-03-31T23:42:19,399 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [hyperUnique] is registered with class [class io.druid.query.aggregation.hyperloglog.HyperUniquesSerde]
2020-03-31T23:42:19,401 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [array] is registered with class [class io.druid.query.aggregation.ArrayMetricSerde]
2020-03-31T23:42:19,401 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [string] is registered with class [class io.druid.segment.serde.StringMetricSerde]
2020-03-31T23:42:19,402 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [decimal] is registered with class [class io.druid.query.aggregation.DecimalMetricSerde]
2020-03-31T23:42:19,408 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketch] is registered with class [class io.druid.query.aggregation.hll.HllSketchMergeComplexMetricSerde]
2020-03-31T23:42:19,409 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketchBuild] is registered with class [class io.druid.query.aggregation.hll.HllSketchBuildComplexMetricSerde]
2020-03-31T23:42:19,409 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketchMerge] is registered with class [class io.druid.query.aggregation.hll.HllSketchMergeComplexMetricSerde]
2020-03-31T23:42:19,520 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.ExtensionsConfig] from props[druid.extensions.] as [ExtensionsConfig{searchCurrentClassloader=true, directory='extensions', hadoopDependenciesDir='hadoop-dependencies', hadoopContainerDruidClasspath='null', loadList=[druid-jdbc-firehose, druid-histogram, druid-datasketches, druid-hive-extensions, mysql-metadata-storage, druid-hdfs-storage, druid-range, druid-area, druid-stats, druid-jdbc-firehose, druid-orc-extensions, druid-kafka-indexing-service, druid-lucene-extensions, druid-geotools-extensions]}]
2020-03-31T23:42:19,736 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-jdbc-firehose] for class [io.druid.firehose.jdbc.JDBCFirehoseDruidModule]
2020-03-31T23:42:19,738 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-histogram] for class [io.druid.query.aggregation.histogram.ApproximateHistogramDruidModule]
2020-03-31T23:42:19,743 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-datasketches] for class [io.druid.query.aggregation.stats.DruidStatsModule]
2020-03-31T23:42:19,744 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-datasketches] for class [io.druid.query.aggregation.datasketches.theta.SketchModule]
2020-03-31T23:42:19,745 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-hive-extensions] for class [io.druid.hive.HiveDruidModule]
2020-03-31T23:42:19,746 INFO [main] io.druid.initialization.Initialization - Found extension module [mysql-metadata-storage] for class [io.druid.metadata.storage.mysql.MySQLMetadataStorageModule]
2020-03-31T23:42:19,747 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-hdfs-storage] for class [io.druid.storage.hdfs.HdfsStorageDruidModule]
2020-03-31T23:42:19,749 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-range] for class [io.druid.query.aggregation.range.MetricRangeModule]
2020-03-31T23:42:19,750 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-area] for class [io.druid.query.aggregation.area.MetricAreaModule]
2020-03-31T23:42:19,755 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-orc-extensions] for class [io.druid.data.OrcExtensionsModule]
2020-03-31T23:42:19,756 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-kafka-indexing-service] for class [io.druid.indexing.kafka.KafkaIndexTaskModule]
2020-03-31T23:42:19,757 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-lucene-extensions] for class [io.druid.segment.lucene.LuceneExtensionModule]
2020-03-31T23:42:19,758 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-geotools-extensions] for class [io.druid.data.GeoToolsDruidModule]
2020-03-31T23:42:19,787 WARN [main] io.druid.initialization.Log4jShutterDownerModule - Shutdown callback registry expected class [io.druid.common.config.Log4jShutdown] found [org.apache.logging.log4j.core.util.DefaultShutdownCallbackRegistry]. Skipping shutdown registry
2020-03-31T23:42:20,082 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [metricArea] is registered with class [class io.druid.query.aggregation.area.MetricAreaSerde]
2020-03-31T23:42:20,291 WARN [main] org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
2020-03-31T23:42:20,528 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramFoldingSerde]
2020-03-31T23:42:20,529 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateCompactHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramCompactFoldingSerde]
2020-03-31T23:42:20,532 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateBase64Histogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramBase64FoldingSerde]
2020-03-31T23:42:20,533 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateBase64CompactHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramBase64CompactFoldingSerde]
2020-03-31T23:42:20,534 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [metricRange] is registered with class [class io.druid.query.aggregation.range.MetricRangeSerde]
2020-03-31T23:42:20,544 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketch] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchMergeComplexMetricSerde]
2020-03-31T23:42:20,544 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketchMerge] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchMergeComplexMetricSerde]
2020-03-31T23:42:20,545 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketchBuild] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchBuildComplexMetricSerde]
2020-03-31T23:42:20,546 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [variance] is registered with class [class io.druid.query.aggregation.variance.VarianceSerde]
2020-03-31T23:42:20,547 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [varianceCombined] is registered with class [class io.druid.query.aggregation.variance.VarianceCombinedSerde]
2020-03-31T23:42:20,549 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [pearson] is registered with class [class io.druid.query.aggregation.corr.PearsonSerde]
2020-03-31T23:42:20,550 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [covariance] is registered with class [class io.druid.query.aggregation.covariance.CovarianceSerde]
2020-03-31T23:42:20,552 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [kurtosis] is registered with class [class io.druid.query.aggregation.kurtosis.KurtosisSerde]
2020-03-31T23:42:20,843 INFO [main] io.druid.jackson.FunctionInitializer - finding expression functions..
2020-03-31T23:42:20,848 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.BuiltinFunctions]
2020-03-31T23:42:20,886 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.PredicateFunctions]
2020-03-31T23:42:20,891 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.DateTimeFunctions]
2020-03-31T23:42:20,902 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.ExcelFunctions]
2020-03-31T23:42:20,948 INFO [main] io.druid.math.expr.Parser - registering functions in user library [org.geohex.geohex4j.GeoHexFunctions]
2020-03-31T23:42:20,949 INFO [main] io.druid.math.expr.Parser - > 'geohex_to_boundary_wkt' is registered with class GeoHexToBoundaryWKT
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'geohex_to_boundary' is registered with class GeoHexToBoundary
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'geom_to_geohex' is registered with class GeomToGeoHex
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'to_geohex' is registered with class ToGeoHex
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.ShapeFunctions]
2020-03-31T23:42:21,031 INFO [main] io.druid.math.expr.Parser - > 'shape_withindistance' is registered with class WithinDistance
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_equalsexact' is registered with class ShapeEqualsExact
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_equals' is registered with class ShapeEquals
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_disjoint' is registered with class ShapeDisjoint
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_crosses' is registered with class ShapeCrosses
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_touches' is registered with class ShapeTouches
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_within' is registered with class ShapeWithin
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_overlaps' is registered with class ShapeOverlaps
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_contains' is registered with class ShapeContains
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_coveredby' is registered with class ShapeCoveredBy
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_covers' is registered with class ShapeCovers
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_intersects' is registered with class ShapeIntersects
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_union' is registered with class ShapeUnion
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_intersection' is registered with class Intersection
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_difference' is registered with class Difference
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_coordinates_yx' is registered with class CoordinatesYX
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_coordinates_xy' is registered with class CoordinatesXY
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_centroid_yx' is registered with class CentroidYX
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_centroid_xy' is registered with class CentroidXY
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_length' is registered with class Length
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_area' is registered with class Area
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_reverse' is registered with class Reverse
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_envelop' is registered with class Envelop
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_convexhull' is registered with class ConvexHull
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_boundary' is registered with class Boundary
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_togeojson' is registered with class ToGeoJson
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_towkt' is registered with class ToWKT
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromgeojson' is registered with class FromGeoJson
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromwkt' is registered with class FromWKT
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromlonlat' is registered with class FromLonLat
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromlatlon' is registered with class FromLatLon
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.sql.SQLFunctions]
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_shift' is registered with class TimestampShiftExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_parse' is registered with class TimestampParseExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_format' is registered with class TimestampFormatExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_floor' is registered with class TimestampFloorExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_extract' is registered with class TimestampExtractFunc
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_ceil' is registered with class TimestampCeilExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.ModuleBuiltinFunctions]
2020-03-31T23:42:21,037 INFO [main] io.druid.math.expr.Parser - > 'haversin_meter' is registered with class HaversinMeter
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'lookup' is registered with class LookupFunc
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'lookupmap' is registered with class LookupMapFunc
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'truncatedrecent' is registered with class TruncatedRecent
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.H3Functions]
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_boundary_wkt' is registered with class H3ToBoundaryWKT
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_boundary' is registered with class H3ToBoundary
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_center_wkt' is registered with class H3ToCenterWKT
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_center' is registered with class H3ToCenter
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'to_h3_address' is registered with class ToH3Address
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'geom_to_h3' is registered with class GeomToH3
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'to_h3' is registered with class ToH3
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.data.GeoToolsFunctions]
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_smooth' is registered with class Smooth
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_transform' is registered with class Transform
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_buffer' is registered with class Buffer
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'lonlat.to4326' is registered with class LonLatTo4326
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.GeoHashFunctions]
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_boundary_wkt' is registered with class GeoHashToBoundaryWKT
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_boundary' is registered with class GeoHashToBoundary
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_center_wkt' is registered with class GeoHashToCenterWKT
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_center' is registered with class GeoHashToCenter
2020-03-31T23:42:21,047 INFO [main] io.druid.math.expr.Parser - > 'geom_to_geohash' is registered with class GeomToGeoHash
2020-03-31T23:42:21,047 INFO [main] io.druid.math.expr.Parser - > 'to_geohash' is registered with class ToGeoHash
2020-03-31T23:42:21,085 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.DruidMonitorSchedulerConfig] from props[druid.monitoring.] as [io.druid.server.metrics.DruidMonitorSchedulerConfig@7235f92b]
2020-03-31T23:42:21,091 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.MonitorsConfig] from props[druid.monitoring.] as [MonitorsConfig{monitors=[]}]
2020-03-31T23:42:21,110 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.DruidNode] from props[druid.] as [DruidNode{serviceName='druid/middleManager', serviceType='peon', host='localhost', port=8100}]
2020-03-31T23:42:21,111 INFO [main] io.druid.server.metrics.MetricsModule - Adding monitor[io.druid.query.ExecutorServiceMonitor@36ab3814]
2020-03-31T23:42:21,215 INFO [main] io.druid.server.metrics.MetricsModule - Adding monitor[io.druid.server.initialization.jetty.JettyServerModule$JettyMonitor@3b7c80c6]
2020-03-31T23:42:21,223 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.log.StartupLoggingConfig] from props[druid.startup.logging.] as [io.druid.server.log.StartupLoggingConfig@7a8341c1]
2020-03-31T23:42:21,223 INFO [main] io.druid.cli.CliPeon - Starting up with processors[8], memory[465.567.744].
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * awt.toolkit: sun.awt.X11.XToolkit
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.extensions.loadList: ["druid-jdbc-firehose", "druid-histogram", "druid-datasketches", "druid-hive-extensions", "mysql-metadata-storage", "druid-hdfs-storage", "druid-range", "druid-area", "druid-stats", "druid-jdbc-firehose", "druid-orc-extensions", "druid-kafka-indexing-service", "druid-lucene-extensions", "druid-geotools-extensions"]
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.host: localhost
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.logs.directory: var/druid/indexing-logs
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.logs.type: file
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.baseTaskDir: var/druid/task
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.defaultHadoopCoordinates: ["org.apache.hadoop:hadoop-client:2.7.3"]
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.hadoopWorkingPath: var/druid/hadoop-tmp
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.connectURI: jdbc:derby://localhost:1527/var/druid/metadata.db;create=true
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.host: localhost
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.port: 1527
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.type: derby
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metrics.emitter.dimension.dataSource: a_vmipt
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metrics.emitter.dimension.taskId: index_a_vmipt_2020-03-31T23:42:18.421Z
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.port: 8100
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.processing.buffer.sizeBytes: 536870912
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.processing.numThreads: 2
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.selectors.coordinator.serviceName: druid/coordinator
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.selectors.indexing.serviceName: druid/overlord
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.server.http.numThreads: 25
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.service: druid/middleManager
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.startup.logging.logProperties: true
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.storage.storageDirectory: var/druid/segments
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.storage.type: local
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.worker.capacity: 10
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.zk.paths.base: /druid
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.zk.service.host: localhost
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.encoding: UTF-8
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.encoding.pkg: sun.io
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.separator: /
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.awt.graphicsenv: sun.awt.X11GraphicsEnvironment
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.awt.printerjob: sun.print.PSPrinterJob
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.class.path: conf/druid/_common:conf/druid:conf/druid/single:lib/druid-processing-0.9.1-SNAPSHOT.jar:lib/javax.el-3.0.0.jar:lib/lucene-core-6.2.0.jar:lib/tesla-aether-0.0.5.jar:lib/aws-java-sdk-ssm-1.10.21.jar:lib/netty-reactive-streams-1.0.8.jar:lib/aggdesigner-algorithm-6.0.jar:lib/xmlbeans-2.6.0.jar:lib/classmate-1.0.0.jar:lib/netty-buffer-4.0.52.Final.jar:lib/jetty-servlets-9.3.24.v20180605.jar:lib/aws-java-sdk-cloudwatchmetrics-1.10.21.jar:lib/log4j-slf4j-impl-2.5.jar:lib/derbyclient-10.11.1.1.jar:lib/aws-java-sdk-elasticloadbalancing-1.10.21.jar:lib/aws-java-sdk-cloudwatch-1.10.21.jar:lib/aws-java-sdk-codecommit-1.10.21.jar:lib/aws-java-sdk-ses-1.10.21.jar:lib/google-http-client-1.20.0.jar:lib/aws-java-sdk-ecs-1.10.21.jar:lib/aether-impl-0.9.0.M2.jar:lib/aws-java-sdk-cloudfront-1.10.21.jar:lib/mysql-connector-java-5.1.38.jar:lib/commons-csv-1.6.jar:lib/jetty-server-9.3.24.v20180605.jar:lib/jetty-util-9.3.24.v20180605.jar:lib/aws-java-sdk-lambda-1.10.21.jar:lib/jackson-jaxrs-json-provider-2.4.6.jar:lib/jersey-guice-1.19.jar:lib/aopalliance-1.0.jar:lib/aws-java-sdk-storagegateway-1.10.21.jar:lib/jackson-module-jaxb-annotations-2.4.6.jar:lib/aws-java-sdk-emr-1.10.21.jar:lib/maven-repository-metadata-3.1.1.jar:lib/maven-aether-provider-3.1.1.jar:lib/netty-codec-dns-2.0.37.jar:lib/commons-logging-1.1.1.jar:lib/jetty-io-9.3.24.v20180605.jar:lib/aws-java-sdk-workspaces-1.10.21.jar:lib/log4j-1.2-api-2.5.jar:lib/plexus-interpolation-1.19.jar:lib/aws-java-sdk-support-1.10.21.jar:lib/log4j-core-2.5.jar:lib/aws-java-sdk-directory-1.10.21.jar:lib/activation-1.1.1.jar:lib/async-http-client-netty-utils-2.0.37.jar:lib/jts-io-1.14.0.jar:lib/aws-java-sdk-cognitosync-1.10.21.jar:lib/antlr4-runtime-4.5.1.jar:lib/bcprov-jdk15on-1.52.jar:lib/commons-dbcp2-2.0.1.jar:lib/curator-client-2.10.0.jar:lib/base64-2.3.8.jar:lib/curator-framework-2.10.0.jar:lib/aws-java-sdk-config-1.10.21.jar:lib/druid-indexing-hadoop-0.9.1-SNAPSHOT.jar:lib/javax.el-api-3.0.0.jar:lib/aws-java-sdk-sns-1.10.21.jar:lib/jackson-core-2.4.6.jar:lib/opencsv-2.3.jar:lib/jackson-databind-2.4.6.jar:lib/zookeeper-3.4.8.jar:lib/druid-console-0.9.1-SNAPSHOT.jar:lib/poi-ooxml-schemas-3.13.jar:lib/aws-java-sdk-s3-1.10.21.jar:lib/aws-java-sdk-directconnect-1.10.21.jar:lib/aws-java-sdk-route53-1.10.21.jar:lib/aether-spi-0.9.0.M2.jar:lib/aws-java-sdk-elastictranscoder-1.10.21.jar:lib/javax.servlet-api-3.1.0.jar:lib/xercesImpl-2.11.0.jar:lib/netty-transport-native-epoll-4.0.52.Final-linux-x86_64.jar:lib/netty-handler-4.0.52.Final.jar:lib/aws-java-sdk-simpleworkflow-1.10.21.jar:lib/aws-java-sdk-sqs-1.10.21.jar:lib/commons-cli-1.2.jar:lib/aws-java-sdk-ec2-1.10.21.jar:lib/aether-connector-okhttp-0.0.9.jar:lib/aws-java-sdk-cloudsearch-1.10.21.jar:lib/validation-api-1.1.0.Final.jar:lib/h2-1.3.175.jar:lib/guice-servlet-4.1.0.jar:lib/aws-java-sdk-importexport-1.10.21.jar:lib/guice-4.1.0.jar:lib/rhino-1.7R5.jar:lib/aws-java-sdk-machinelearning-1.10.21.jar:lib/poi-3.13.jar:lib/aws-java-sdk-opsworks-1.10.21.jar:lib/commons-pool2-2.2.jar:lib/protobuf-java-3.1.0.jar:lib/jsr311-api-1.1.1.jar:lib/mapdb-1.0.8.jar:lib/aws-java-sdk-glacier-1.10.21.jar:lib/druid-server-0.9.1-SNAPSHOT.jar:lib/avatica-core-1.12.0.jar:lib/commons-pool-1.6.jar:lib/aether-util-0.9.0.M2.jar:lib/jetty-continuation-9.3.24.v20180605.jar:lib/aws-java-sdk-elasticbeanstalk-1.10.21.jar:lib/jvm-attach-api-1.2.jar:lib/aws-java-sdk-dynamodb-1.10.21.jar:lib/esri-geometry-api-2.0.0.jar:lib/maven-settings-builder-3.1.1.jar:lib/aether-connector-file-0.9.0.M2.jar:lib/json-path-2.1.0.jar:lib/aws-java-sdk-elasticache-1.10.21.jar:lib/jersey-servlet-1.19.jar:lib/httpclient-4.5.1.jar:lib/sketches-core-0.12.0.jar:lib/derbynet-10.11.1.1.jar:lib/lucene-sandbox-6.2.0.jar:lib/reactive-streams-1.0.0.jar:lib/jetty-security-9.3.24.v20180605.jar:lib/lucene-queryparser-6.2.0.jar:lib/jcl-over-slf4j-1.7.12.jar:lib/okhttp-1.0.2.jar:lib/avatica-server-1.12.0.jar:lib/commons-io-2.4.jar:lib/memory-0.12.0.jar:lib/aws-java-sdk-codedeploy-1.10.21.jar:lib/jackson-core-asl-1.9.13.jar:lib/aws-java-sdk-cognitoidentity-1.10.21.jar:lib/geoip2-0.4.0.jar:lib/spymemcached-2.11.7.jar:lib/netty-transport-4.0.52.Final.jar:lib/janino-2.7.6.jar:lib/google-http-client-jackson2-1.15.0-rc.jar:lib/xlsx-streamer-1.0.1.jar:lib/aether-api-0.9.0.M2.jar:lib/commons-math3-3.6.1.jar:lib/airline-0.7.jar:lib/jackson-dataformat-smile-2.4.6.jar:lib/netty-common-4.0.52.Final.jar:lib/calcite-server-1.17.0.jar:lib/commons-codec-1.7.jar:lib/netty-all-4.1.11.Final.jar:lib/aws-java-sdk-kinesis-1.10.21.jar:lib/avatica-metrics-1.12.0.jar:lib/druid-indexing-service-0.9.1-SNAPSHOT.jar:lib/joda-time-2.8.2.jar:lib/aws-java-sdk-cloudhsm-1.10.21.jar:lib/jetty-proxy-9.3.24.v20180605.jar:lib/log4j-api-2.5.jar:lib/jts-core-1.14.0.jar:lib/aws-java-sdk-logs-1.10.21.jar:lib/xml-apis-1.4.01.jar:lib/druid-common-0.9.1-SNAPSHOT.jar:lib/jetty-http-9.3.24.v20180605.jar:lib/netty-3.10.6.Final.jar:lib/jackson-jaxrs-smile-provider-2.4.6.jar:lib/netty-codec-http-4.0.52.Final.jar:lib/aws-java-sdk-cloudtrail-1.10.21.jar:lib/calcite-linq4j-1.17.0.jar:lib/aws-java-sdk-sts-1.10.21.jar:lib/jackson-jaxrs-base-2.4.6.jar:lib/curator-x-discovery-2.10.0.jar:lib/log4j-jul-2.5.jar:lib/netty-resolver-dns-2.0.37.jar:lib/aws-java-sdk-1.10.21.jar:lib/commons-collections-3.2.1.jar:lib/wagon-provider-api-2.4.jar:lib/poi-ooxml-3.13.jar:lib/jetty-client-9.3.24.v20180605.jar:lib/config-magic-0.9.jar:lib/aws-java-sdk-core-1.10.21.jar:lib/jersey-core-1.19.jar:lib/calcite-core-1.17.0.jar:lib/guice-multibindings-4.1.0.jar:lib/extendedset-1.3.10.jar:lib/jsr305-2.0.1.jar:lib/aws-java-sdk-swf-libraries-1.10.21.jar:lib/java-xmlbuilder-1.1.jar:lib/compress-lzf-1.0.3.jar:lib/stax-api-1.0.1.jar:lib/jersey-server-1.19.jar:lib/jackson-datatype-guava-2.4.6.jar:lib/maven-model-3.1.1.jar:lib/jackson-datatype-joda-2.4.6.jar:lib/maven-settings-3.1.1.jar:lib/plexus-utils-3.0.15.jar:lib/aws-java-sdk-devicefarm-1.10.21.jar:lib/commons-lang3-3.2.jar:lib/jboss-logging-3.1.3.GA.jar:lib/bytebuffer-collections-0.2.5.jar:lib/commons-lang-2.6.jar:lib/aws-java-sdk-simpledb-1.10.21.jar:lib/lz4-1.3.0.jar:lib/aws-java-sdk-rds-1.10.21.jar:lib/aws-java-sdk-codepipeline-1.10.21.jar:lib/aws-java-sdk-kms-1.10.21.jar:lib/lucene-analyzers-common-6.2.0.jar:lib/netty-resolver-2.0.37.jar:lib/aws-java-sdk-autoscaling-1.10.21.jar:lib/jline-3.2.0.jar:lib/druid-aws-common-0.9.1-SNAPSHOT.jar:lib/RoaringBitmap-0.5.18.jar:lib/maven-model-builder-3.1.1.jar:lib/hibernate-validator-5.1.3.Final.jar:lib/druid-services-0.9.1-SNAPSHOT.jar:lib/slf4j-api-1.7.12.jar:lib/jdbi-2.63.1.jar:lib/maxminddb-0.2.0.jar:lib/java-util-1.3.3.jar:lib/jetty-servlet-9.3.24.v20180605.jar:lib/httpcore-4.4.3.jar:lib/jackson-mapper-asl-1.9.13.jar:lib/async-http-client-2.0.37.jar:lib/aws-java-sdk-iam-1.10.21.jar:lib/jackson-annotations-2.4.6.jar:lib/jets3t-0.9.4.jar:lib/druid-sql-0.9.1-SNAPSHOT.jar:lib/commons-compiler-2.7.6.jar:lib/aws-java-sdk-redshift-1.10.21.jar:lib/disruptor-3.3.0.jar:lib/curator-recipes-2.10.0.jar:lib/javax.inject-1.jar:lib/irc-api-1.0-0014.jar:lib/aws-java-sdk-cloudformation-1.10.21.jar:lib/aws-java-sdk-datapipeline-1.10.21.jar:lib/lucene-queries-6.2.0.jar:lib/aws-java-sdk-efs-1.10.21.jar:lib/guava-16.0.1.jar:lib/netty-codec-4.0.52.Final.jar:lib/derby-10.11.1.1.jar:/usr/local/Cellar/hadoop/2.7.2/libexec/etc/hadoop
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.class.version: 52.0
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.endorsed.dirs: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/endorsed
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.ext.dirs: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/ext:/usr/java/packages/lib/ext
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.home: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.io.tmpdir: /tmp
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.runtime.name: OpenJDK Runtime Environment
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.runtime.version: 1.8.0_232-b09
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.name: Java Platform API Specification
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.vendor: Oracle Corporation
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.version: 1.8
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.util.logging.manager: org.apache.logging.log4j.jul.LogManager
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor.url: http://java.oracle.com/
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor.url.bug: http://bugreport.sun.com/bugreport/
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.version: 1.8.0_232
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.info: mixed mode
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.name: OpenJDK 64-Bit Server VM
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.name: Java Virtual Machine Specification
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.version: 1.8
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.version: 25.232-b09
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * line.separator:
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * log4j.shutdownCallbackRegistry: io.druid.common.config.Log4jShutdown
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * log4j.shutdownHookEnabled: true
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.arch: amd64
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.name: Linux
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.version: 4.18.0-80.11.2.el8_0.x86_64
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * path.separator: :
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.arch.data.model: 64
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.boot.class.path: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/resources.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/rt.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jsse.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jce.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/charsets.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jfr.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/classes
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.boot.library.path: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/amd64
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.cpu.endian: little
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.cpu.isalist:
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.io.unicode.encoding: UnicodeLittle
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.java.command: io.druid.cli.Main internal peon var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/task.json var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/b4be4bcd-b4cd-47f9-9f0a-0e0c332e3967/status.json --queryable
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.java.launcher: SUN_STANDARD
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.jnu.encoding: UTF-8
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.management.compiler: HotSpot 64-Bit Tiered Compilers
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.os.patch.level: unknown
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.country: IT
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.dir: /usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.home: /root
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.language: it
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.name: root
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.timezone: UTC
2020-03-31T23:42:21,236 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.common.config.TaskConfig] from props[druid.indexer.task.] as [io.druid.indexing.common.config.TaskConfig@2e4389ed]
2020-03-31T23:42:21,239 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.http.DruidHttpClientConfig] from props[druid.global.http.] as [io.druid.guice.http.DruidHttpClientConfig@6bbab114]
2020-03-31T23:42:21,287 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.indexing.IndexingServiceSelectorConfig] from props[druid.selectors.indexing.] as [io.druid.client.indexing.IndexingServiceSelectorConfig@4a1a256d]
2020-03-31T23:42:21,290 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.curator.CuratorConfig] from props[druid.zk.service.] as [io.druid.curator.CuratorConfig@69de5bed]
2020-03-31T23:42:21,293 WARN [main] org.apache.curator.retry.ExponentialBackoffRetry - maxRetries too large (30). Pinning to 29
2020-03-31T23:42:21,311 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.CuratorDiscoveryConfig] from props[druid.discovery.curator.] as [io.druid.server.initialization.CuratorDiscoveryConfig@2b73bd6b]
2020-03-31T23:42:21,329 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.common.RetryPolicyConfig] from props[druid.peon.taskActionClient.retry.] as [io.druid.indexing.common.RetryPolicyConfig@e9474f]
2020-03-31T23:42:21,331 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.segment.loading.LocalDataSegmentPusherConfig] from props[druid.storage.] as [io.druid.segment.loading.LocalDataSegmentPusherConfig@77cb452c]
2020-03-31T23:42:21,332 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.storage.hdfs.HdfsDataSegmentPusherConfig] from props[druid.storage.] as [io.druid.storage.hdfs.HdfsDataSegmentPusherConfig@6c8fe7a4]
2020-03-31T23:42:21,337 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.DruidServerConfig] from props[druid.server.] as [io.druid.client.DruidServerConfig@7a2fce12]
2020-03-31T23:42:21,340 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.BatchDataSegmentAnnouncerConfig] from props[druid.announcer.] as [io.druid.server.initialization.BatchDataSegmentAnnouncerConfig@11787b64]
2020-03-31T23:42:21,342 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ZkPathsConfig] from props[druid.zk.paths.] as [io.druid.server.initialization.ZkPathsConfig@22e2266d]
2020-03-31T23:42:21,346 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.server.coordination.DataSegmentAnnouncerProvider] from props[druid.announcer.] as [io.druid.server.coordination.BatchDataSegmentAnnouncerProvider@19b02dfd]
2020-03-31T23:42:21,347 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.coordinator.CoordinatorSelectorConfig] from props[druid.selectors.coordinator.] as [io.druid.client.coordinator.CoordinatorSelectorConfig@570ba13]
2020-03-31T23:42:21,349 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.segment.realtime.plumber.CoordinatorBasedSegmentHandoffNotifierConfig] from props[druid.segment.handoff.] as [io.druid.segment.realtime.plumber.CoordinatorBasedSegmentHandoffNotifierConfig@8e25d3f]
2020-03-31T23:42:21,353 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.client.cache.CacheProvider] from props[druid.cache.bitmap.] as [io.druid.client.cache.LocalCacheProvider@3e900e1a]
2020-03-31T23:42:21,362 INFO [main] io.druid.client.cache.MapCache - Creating local cache with size 0
2020-03-31T23:42:21,366 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [${base_path}.fifo] on [io.druid.query.DruidProcessingConfig#isFifo()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [druid.computation.buffer.poolCacheMaxCount, ${base_path}.buffer.poolCacheMaxCount] on [io.druid.query.DruidProcessingConfig#poolCacheMaxCount()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [${base_path}.columnCache.sizeBytes] on [io.druid.query.DruidProcessingConfig#columnCacheSizeBytes()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [536870912] for [druid.processing.buffer.sizeBytes] on [io.druid.query.DruidProcessingConfig#intermediateComputeSizeBytes()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [2] for [druid.processing.numThreads] on [io.druid.query.DruidProcessingConfig#getNumThreads()]
2020-03-31T23:42:21,369 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning default value [processing-%s] for [${base_path}.formatString] on [com.metamx.common.concurrent.ExecutorServiceConfig#getFormatString()]
2020-03-31T23:42:21,428 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.search.search.SearchQueryConfig] from props[druid.query.search.] as [io.druid.query.search.search.SearchQueryConfig@7aaad0]
2020-03-31T23:42:21,430 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.metadata.SegmentMetadataQueryConfig] from props[druid.query.segmentMetadata.] as [io.druid.query.metadata.SegmentMetadataQueryConfig@6cbb175]
2020-03-31T23:42:21,432 INFO [main] io.druid.guice.DruidProcessingModule - Starting with max direct memory 1.908.932.608 bytes, 2 processor with intermediate buffer 536.870.912 bytes
2020-03-31T23:42:21,439 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.groupby.GroupByQueryConfig] from props[druid.query.groupBy.] as [io.druid.query.groupby.GroupByQueryConfig@2f995afc]
2020-03-31T23:42:21,441 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.select.SelectQueryConfig] from props[druid.query.select.] as [io.druid.query.select.SelectQueryConfig@1ef31f71]
2020-03-31T23:42:21,442 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.topn.TopNQueryConfig] from props[druid.query.topN.] as [io.druid.query.topn.TopNQueryConfig@6f6cc7da]
2020-03-31T23:42:21,443 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.JoinQueryConfig] from props[druid.query.join.] as [io.druid.query.JoinQueryConfig@44aa2e13]
2020-03-31T23:42:21,446 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.QueryConfig] from props[druid.query.] as [io.druid.query.QueryConfig@4b41587d]
2020-03-31T23:42:21,456 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.client.cache.CacheProvider] from props[druid.cache.] as [io.druid.client.cache.LocalCacheProvider@4962b41e]
2020-03-31T23:42:21,456 INFO [main] io.druid.client.cache.MapCache - Creating local cache with size 0
2020-03-31T23:42:21,459 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.cache.CacheConfig] from props[druid.realtime.cache.] as [io.druid.client.cache.CacheConfig@3ebc955b]
2020-03-31T23:42:21,470 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ServerConfig] from props[druid.server.http.] as [ServerConfig{numThreads=25, maxIdleTime=PT5M}]
2020-03-31T23:42:21,472 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.server.log.RequestLoggerProvider] from props[druid.request.logging.] as [io.druid.server.log.RequestLoggerProvider$Logging@402f8592]
2020-03-31T23:42:21,474 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.security.AuthConfig] from props[druid.auth.] as [AuthConfig{enabled=false}]
2020-03-31T23:42:21,481 INFO [main] org.eclipse.jetty.util.log - Logging initialized @3046ms
2020-03-31T23:42:21,563 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.lookup.LookupConfig] from props[druid.lookup.] as [LookupConfig{snapshotWorkingDir=''}]
2020-03-31T23:42:21,566 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.lookup.LookupListeningAnnouncerConfig] from props[druid.lookup.] as [ListeningAnnouncerConfig{listenersPath='/druid/listeners'}]
2020-03-31T23:42:21,567 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.emitter.service.ServiceEmitter.start()] on object[ServiceEmitter{serviceDimensions={service=druid/middleManager, host=localhost:8100, version=0.9.1-SNAPSHOT}, emitter=com.metamx.emitter.core.NoopEmitter@5c3d4f05}].
2020-03-31T23:42:21,567 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.metrics.MonitorScheduler.start()] on object[com.metamx.metrics.MonitorScheduler@119290b9].
2020-03-31T23:42:21,570 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.http.client.NettyHttpClient.start()] on object[com.metamx.http.client.NettyHttpClient@256bb5be].
2020-03-31T23:42:21,570 INFO [main] io.druid.curator.CuratorModule - Starting Curator
2020-03-31T23:42:21,570 INFO [main] org.apache.curator.framework.imps.CuratorFrameworkImpl - Starting
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.4.8--1, built on 02/06/2016 03:18 GMT
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:host.name=localhost
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.version=1.8.0_232
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.home=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=conf/druid/_common:conf/druid:conf/druid/single:lib/druid-processing-0.9.1-SNAPSHOT.jar:lib/javax.el-3.0.0.jar:lib/lucene-core-6.2.0.jar:lib/tesla-aether-0.0.5.jar:lib/aws-java-sdk-ssm-1.10.21.jar:lib/netty-reactive-streams-1.0.8.jar:lib/aggdesigner-algorithm-6.0.jar:lib/xmlbeans-2.6.0.jar:lib/classmate-1.0.0.jar:lib/netty-buffer-4.0.52.Final.jar:lib/jetty-servlets-9.3.24.v20180605.jar:lib/aws-java-sdk-cloudwatchmetrics-1.10.21.jar:lib/log4j-slf4j-impl-2.5.jar:lib/derbyclient-10.11.1.1.jar:lib/aws-java-sdk-elasticloadbalancing-1.10.21.jar:lib/aws-java-sdk-cloudwatch-1.10.21.jar:lib/aws-java-sdk-codecommit-1.10.21.jar:lib/aws-java-sdk-ses-1.10.21.jar:lib/google-http-client-1.20.0.jar:lib/aws-java-sdk-ecs-1.10.21.jar:lib/aether-impl-0.9.0.M2.jar:lib/aws-java-sdk-cloudfront-1.10.21.jar:lib/mysql-connector-java-5.1.38.jar:lib/commons-csv-1.6.jar:lib/jetty-server-9.3.24.v20180605.jar:lib/jetty-util-9.3.24.v20180605.jar:lib/aws-java-sdk-lambda-1.10.21.jar:lib/jackson-jaxrs-json-provider-2.4.6.jar:lib/jersey-guice-1.19.jar:lib/aopalliance-1.0.jar:lib/aws-java-sdk-storagegateway-1.10.21.jar:lib/jackson-module-jaxb-annotations-2.4.6.jar:lib/aws-java-sdk-emr-1.10.21.jar:lib/maven-repository-metadata-3.1.1.jar:lib/maven-aether-provider-3.1.1.jar:lib/netty-codec-dns-2.0.37.jar:lib/commons-logging-1.1.1.jar:lib/jetty-io-9.3.24.v20180605.jar:lib/aws-java-sdk-workspaces-1.10.21.jar:lib/log4j-1.2-api-2.5.jar:lib/plexus-interpolation-1.19.jar:lib/aws-java-sdk-support-1.10.21.jar:lib/log4j-core-2.5.jar:lib/aws-java-sdk-directory-1.10.21.jar:lib/activation-1.1.1.jar:lib/async-http-client-netty-utils-2.0.37.jar:lib/jts-io-1.14.0.jar:lib/aws-java-sdk-cognitosync-1.10.21.jar:lib/antlr4-runtime-4.5.1.jar:lib/bcprov-jdk15on-1.52.jar:lib/commons-dbcp2-2.0.1.jar:lib/curator-client-2.10.0.jar:lib/base64-2.3.8.jar:lib/curator-framework-2.10.0.jar:lib/aws-java-sdk-config-1.10.21.jar:lib/druid-indexing-hadoop-0.9.1-SNAPSHOT.jar:lib/javax.el-api-3.0.0.jar:lib/aws-java-sdk-sns-1.10.21.jar:lib/jackson-core-2.4.6.jar:lib/opencsv-2.3.jar:lib/jackson-databind-2.4.6.jar:lib/zookeeper-3.4.8.jar:lib/druid-console-0.9.1-SNAPSHOT.jar:lib/poi-ooxml-schemas-3.13.jar:lib/aws-java-sdk-s3-1.10.21.jar:lib/aws-java-sdk-directconnect-1.10.21.jar:lib/aws-java-sdk-route53-1.10.21.jar:lib/aether-spi-0.9.0.M2.jar:lib/aws-java-sdk-elastictranscoder-1.10.21.jar:lib/javax.servlet-api-3.1.0.jar:lib/xercesImpl-2.11.0.jar:lib/netty-transport-native-epoll-4.0.52.Final-linux-x86_64.jar:lib/netty-handler-4.0.52.Final.jar:lib/aws-java-sdk-simpleworkflow-1.10.21.jar:lib/aws-java-sdk-sqs-1.10.21.jar:lib/commons-cli-1.2.jar:lib/aws-java-sdk-ec2-1.10.21.jar:lib/aether-connector-okhttp-0.0.9.jar:lib/aws-java-sdk-cloudsearch-1.10.21.jar:lib/validation-api-1.1.0.Final.jar:lib/h2-1.3.175.jar:lib/guice-servlet-4.1.0.jar:lib/aws-java-sdk-importexport-1.10.21.jar:lib/guice-4.1.0.jar:lib/rhino-1.7R5.jar:lib/aws-java-sdk-machinelearning-1.10.21.jar:lib/poi-3.13.jar:lib/aws-java-sdk-opsworks-1.10.21.jar:lib/commons-pool2-2.2.jar:lib/protobuf-java-3.1.0.jar:lib/jsr311-api-1.1.1.jar:lib/mapdb-1.0.8.jar:lib/aws-java-sdk-glacier-1.10.21.jar:lib/druid-server-0.9.1-SNAPSHOT.jar:lib/avatica-core-1.12.0.jar:lib/commons-pool-1.6.jar:lib/aether-util-0.9.0.M2.jar:lib/jetty-continuation-9.3.24.v20180605.jar:lib/aws-java-sdk-elasticbeanstalk-1.10.21.jar:lib/jvm-attach-api-1.2.jar:lib/aws-java-sdk-dynamodb-1.10.21.jar:lib/esri-geometry-api-2.0.0.jar:lib/maven-settings-builder-3.1.1.jar:lib/aether-connector-file-0.9.0.M2.jar:lib/json-path-2.1.0.jar:lib/aws-java-sdk-elasticache-1.10.21.jar:lib/jersey-servlet-1.19.jar:lib/httpclient-4.5.1.jar:lib/sketches-core-0.12.0.jar:lib/derbynet-10.11.1.1.jar:lib/lucene-sandbox-6.2.0.jar:lib/reactive-streams-1.0.0.jar:lib/jetty-security-9.3.24.v20180605.jar:lib/lucene-queryparser-6.2.0.jar:lib/jcl-over-slf4j-1.7.12.jar:lib/okhttp-1.0.2.jar:lib/avatica-server-1.12.0.jar:lib/commons-io-2.4.jar:lib/memory-0.12.0.jar:lib/aws-java-sdk-codedeploy-1.10.21.jar:lib/jackson-core-asl-1.9.13.jar:lib/aws-java-sdk-cognitoidentity-1.10.21.jar:lib/geoip2-0.4.0.jar:lib/spymemcached-2.11.7.jar:lib/netty-transport-4.0.52.Final.jar:lib/janino-2.7.6.jar:lib/google-http-client-jackson2-1.15.0-rc.jar:lib/xlsx-streamer-1.0.1.jar:lib/aether-api-0.9.0.M2.jar:lib/commons-math3-3.6.1.jar:lib/airline-0.7.jar:lib/jackson-dataformat-smile-2.4.6.jar:lib/netty-common-4.0.52.Final.jar:lib/calcite-server-1.17.0.jar:lib/commons-codec-1.7.jar:lib/netty-all-4.1.11.Final.jar:lib/aws-java-sdk-kinesis-1.10.21.jar:lib/avatica-metrics-1.12.0.jar:lib/druid-indexing-service-0.9.1-SNAPSHOT.jar:lib/joda-time-2.8.2.jar:lib/aws-java-sdk-cloudhsm-1.10.21.jar:lib/jetty-proxy-9.3.24.v20180605.jar:lib/log4j-api-2.5.jar:lib/jts-core-1.14.0.jar:lib/aws-java-sdk-logs-1.10.21.jar:lib/xml-apis-1.4.01.jar:lib/druid-common-0.9.1-SNAPSHOT.jar:lib/jetty-http-9.3.24.v20180605.jar:lib/netty-3.10.6.Final.jar:lib/jackson-jaxrs-smile-provider-2.4.6.jar:lib/netty-codec-http-4.0.52.Final.jar:lib/aws-java-sdk-cloudtrail-1.10.21.jar:lib/calcite-linq4j-1.17.0.jar:lib/aws-java-sdk-sts-1.10.21.jar:lib/jackson-jaxrs-base-2.4.6.jar:lib/curator-x-discovery-2.10.0.jar:lib/log4j-jul-2.5.jar:lib/netty-resolver-dns-2.0.37.jar:lib/aws-java-sdk-1.10.21.jar:lib/commons-collections-3.2.1.jar:lib/wagon-provider-api-2.4.jar:lib/poi-ooxml-3.13.jar:lib/jetty-client-9.3.24.v20180605.jar:lib/config-magic-0.9.jar:lib/aws-java-sdk-core-1.10.21.jar:lib/jersey-core-1.19.jar:lib/calcite-core-1.17.0.jar:lib/guice-multibindings-4.1.0.jar:lib/extendedset-1.3.10.jar:lib/jsr305-2.0.1.jar:lib/aws-java-sdk-swf-libraries-1.10.21.jar:lib/java-xmlbuilder-1.1.jar:lib/compress-lzf-1.0.3.jar:lib/stax-api-1.0.1.jar:lib/jersey-server-1.19.jar:lib/jackson-datatype-guava-2.4.6.jar:lib/maven-model-3.1.1.jar:lib/jackson-datatype-joda-2.4.6.jar:lib/maven-settings-3.1.1.jar:lib/plexus-utils-3.0.15.jar:lib/aws-java-sdk-devicefarm-1.10.21.jar:lib/commons-lang3-3.2.jar:lib/jboss-logging-3.1.3.GA.jar:lib/bytebuffer-collections-0.2.5.jar:lib/commons-lang-2.6.jar:lib/aws-java-sdk-simpledb-1.10.21.jar:lib/lz4-1.3.0.jar:lib/aws-java-sdk-rds-1.10.21.jar:lib/aws-java-sdk-codepipeline-1.10.21.jar:lib/aws-java-sdk-kms-1.10.21.jar:lib/lucene-analyzers-common-6.2.0.jar:lib/netty-resolver-2.0.37.jar:lib/aws-java-sdk-autoscaling-1.10.21.jar:lib/jline-3.2.0.jar:lib/druid-aws-common-0.9.1-SNAPSHOT.jar:lib/RoaringBitmap-0.5.18.jar:lib/maven-model-builder-3.1.1.jar:lib/hibernate-validator-5.1.3.Final.jar:lib/druid-services-0.9.1-SNAPSHOT.jar:lib/slf4j-api-1.7.12.jar:lib/jdbi-2.63.1.jar:lib/maxminddb-0.2.0.jar:lib/java-util-1.3.3.jar:lib/jetty-servlet-9.3.24.v20180605.jar:lib/httpcore-4.4.3.jar:lib/jackson-mapper-asl-1.9.13.jar:lib/async-http-client-2.0.37.jar:lib/aws-java-sdk-iam-1.10.21.jar:lib/jackson-annotations-2.4.6.jar:lib/jets3t-0.9.4.jar:lib/druid-sql-0.9.1-SNAPSHOT.jar:lib/commons-compiler-2.7.6.jar:lib/aws-java-sdk-redshift-1.10.21.jar:lib/disruptor-3.3.0.jar:lib/curator-recipes-2.10.0.jar:lib/javax.inject-1.jar:lib/irc-api-1.0-0014.jar:lib/aws-java-sdk-cloudformation-1.10.21.jar:lib/aws-java-sdk-datapipeline-1.10.21.jar:lib/lucene-queries-6.2.0.jar:lib/aws-java-sdk-efs-1.10.21.jar:lib/guava-16.0.1.jar:lib/netty-codec-4.0.52.Final.jar:lib/derby-10.11.1.1.jar:/usr/local/Cellar/hadoop/2.7.2/libexec/etc/hadoop
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/tmp
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA>
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.name=Linux
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.arch=amd64
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.version=4.18.0-80.11.2.el8_0.x86_64
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.name=root
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.home=/root
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost sessionTimeout=30000 watcher=org.apache.curator.ConnectionState@2589d787
2020-03-31T23:42:21,586 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.discovery.ServerDiscoverySelector.start() throws java.lang.Exception] on object[io.druid.curator.discovery.ServerDiscoverySelector@8641b7d].
2020-03-31T23:42:21,588 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
2020-03-31T23:42:21,593 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Socket connection established to localhost/127.0.0.1:2181, initiating session
2020-03-31T23:42:21,597 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x170ab8be1ef0038, negotiated timeout = 30000
2020-03-31T23:42:21,599 INFO [main-EventThread] org.apache.curator.framework.state.ConnectionStateManager - State change: CONNECTED
2020-03-31T23:42:21,670 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.announcement.Announcer.start()] on object[io.druid.curator.announcement.Announcer@224d86d2].
2020-03-31T23:42:21,670 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.discovery.ServerDiscoverySelector.start() throws java.lang.Exception] on object[io.druid.curator.discovery.ServerDiscoverySelector@a3cba3a].
2020-03-31T23:42:21,673 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.indexing.worker.executor.ExecutorLifecycle.start() throws java.lang.InterruptedException] on object[io.druid.indexing.worker.executor.ExecutorLifecycle@10817f46].
2020-03-31T23:42:21,706 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Running with task: {
"type" : "index",
"id" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"resource" : {
"availabilityGroup" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"requiredCapacity" : 1
},
"spec" : {
"dataSchema" : {
"dataSource" : "a_vmipt",
"parser" : {
"type" : "csv.stream",
"timestampSpec" : {
"column" : "current_datetime",
"missingValue" : "2020-03-31T23:42:18.419Z",
"invalidValue" : "2020-03-31T23:42:18.419Z",
"replaceWrongColumn" : true
},
"dimensionsSpec" : {
"dimensions" : [ ],
"dimensionExclusions" : [ ],
"spatialDimensions" : [ ]
},
"columns" : [ "AsWKT(Posizione)" ]
},
"metricsSpec" : [ {
"type" : "relay",
"name" : "AsWKT(Posizione)",
"columnName" : "AsWKT(Posizione)",
"typeName" : "struct(lat:double,lon:double)"
} ],
"enforceType" : true,
"granularitySpec" : {
"type" : "uniform",
"segmentGranularity" : "MONTH",
"queryGranularity" : "MONTH",
"rollup" : false,
"append" : false,
"intervals" : [ "2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z" ]
},
"evaluations" : [ {
"outputName" : "AsWKT(Posizione)",
"expressions" : [ "shape_centroid_YX(shape_fromWKT( AsWKT(Posizione) ))", "struct(\"_\"[0],\"_\"[1])" ]
} ]
},
"ioConfig" : {
"type" : "index",
"firehose" : {
"type" : "local",
"baseDir" : "/tmp",
"filter" : "temp_ds__a_vmipt_1585698138416.csv",
"parser" : null
}
},
"tuningConfig" : {
"type" : "index",
"targetPartitionSize" : 5000000,
"indexSpec" : {
"bitmap" : {
"type" : "roaring"
},
"dimensionSketches" : {
"type" : "none"
},
"secondaryIndexing" : {
"AsWKT(Posizione)" : {
"type" : "lucene",
"textAnalyzer" : "standard",
"strategies" : [ {
"type" : "latlon",
"fieldName" : "coord",
"latitude" : "lat",
"longitude" : "lon",
"crs" : null
} ]
}
},
"allowNullForNumbers" : false
},
"buildV9Directly" : true,
"ignoreInvalidRows" : true,
"maxRowsInMemory" : 75000,
"maxOccupationInMemory" : -1
}
},
"context" : {
"druid.task.runner.dedicated.host" : "localhost:8091"
},
"groupId" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"dataSource" : "a_vmipt",
"interval" : "2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z"
}
2020-03-31T23:42:21,707 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Attempting to lock file[var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/lock].
2020-03-31T23:42:21,708 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Acquired lock file[var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/lock] in 1ms.
2020-03-31T23:42:21,719 INFO [main] io.druid.indexing.common.actions.RemoteTaskActionClient - Submitting action for task[index_a_vmipt_2020-03-31T23:42:18.421Z] to overlord[http://localhost:8090/druid/indexer/v1/action]: LockTryAcquireAction{interval=2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z}
2020-03-31T23:42:21,727 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,787 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.ThreadPoolTaskRunner - Running task: index_a_vmipt_2020-03-31T23:42:18.421Z
2020-03-31T23:42:21,788 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] location changed to [TaskLocation{host='localhost', port=8100}].
2020-03-31T23:42:21,789 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] status changed to [RUNNING].
2020-03-31T23:42:21,790 INFO [task-runner-0-priority-0] io.druid.indexing.common.actions.RemoteTaskActionClient - Submitting action for task[index_a_vmipt_2020-03-31T23:42:18.421Z] to overlord[http://localhost:8090/druid/indexer/v1/action]: LockListAction{}
2020-03-31T23:42:21,793 INFO [main] org.eclipse.jetty.server.Server - jetty-9.3.24.v20180605, build timestamp: 2018-06-05T17:11:56Z, git hash: 84205aa28f11a4f31f2a3b86d1bba2cc8ab69827
2020-03-31T23:42:21,830 ERROR [task-runner-0-priority-0] io.druid.indexing.overlord.ThreadPoolTaskRunner - Exception while running task[IndexTask{id=index_a_vmipt_2020-03-31T23:42:18.421Z, type=index, dataSource=a_vmipt}]
com.metamx.common.IAE: function 'AsWKT' is not defined.
at io.druid.math.expr.ExprListenerImpl.exitFunctionExpr(ExprListenerImpl.java:318) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.math.expr.antlr.ExprParser$FunctionExprContext.exitRule(ExprParser.java:226) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at org.antlr.v4.runtime.tree.ParseTreeWalker.exitRule(ParseTreeWalker.java:71) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:54) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at io.druid.math.expr.Parser.parse(Parser.java:173) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.math.expr.Parser.parse(Parser.java:136) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.Evaluation$1.apply(Evaluation.java:96) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.Evaluation$1.apply(Evaluation.java:94) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at com.google.common.collect.Lists$TransformingRandomAccessList$1.transform(Lists.java:582) ~[guava-16.0.1.jar:?]
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) ~[guava-16.0.1.jar:?]
at java.util.AbstractCollection.toArray(AbstractCollection.java:141) ~[?:1.8.0_232]
at java.util.ArrayList.<init>(ArrayList.java:178) ~[?:1.8.0_232]
at com.google.common.collect.Lists.newArrayList(Lists.java:129) ~[guava-16.0.1.jar:?]
at io.druid.data.input.Evaluation.toEvaluator(Evaluation.java:92) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.InputRowParsers.wrap(InputRowParsers.java:90) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.segment.indexing.DataSchema.getParser(DataSchema.java:127) ~[druid-server-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.segment.indexing.IngestionSpec.getParser(IngestionSpec.java:66) ~[druid-server-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.common.task.IndexTask.getDataIntervals(IndexTask.java:297) ~[druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.common.task.IndexTask.run(IndexTask.java:223) ~[druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.overlord.ThreadPoolTaskRunner$ThreadPoolTaskRunnerCallable.call(ThreadPoolTaskRunner.java:472) [druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.overlord.ThreadPoolTaskRunner$ThreadPoolTaskRunnerCallable.call(ThreadPoolTaskRunner.java:444) [druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
2020-03-31T23:42:21,833 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] status changed to [FAILED].
2020-03-31T23:42:21,836 INFO [task-runner-0-priority-0] io.druid.indexing.worker.executor.ExecutorLifecycle - Task completed with status: {
"id" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"status" : "FAILED",
"duration" : 46,
"reason" : "Exception: [io.druid.math.expr.ExprListenerImpl.exitFunctionExpr(ExprListenerImpl.java:318), io.druid.math.expr.antlr.ExprParser$FunctionExprContext.exitRule(ExprParser.java:226), org.antlr.v4.runtime.tree.ParseTreeWalker.exitRule(ParseTreeWalker.java:71), org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:54), org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52), ... more]"
}
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering com.fasterxml.jackson.jaxrs.json.JacksonJsonProvider as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering com.fasterxml.jackson.jaxrs.smile.JacksonSmileProvider as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering io.druid.server.initialization.jetty.CustomExceptionMapper as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering io.druid.server.StatusResource as a root resource class
2020-03-31T23:42:21,876 INFO [main] com.sun.jersey.server.impl.application.WebApplicationImpl - Initiating Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM'
2020-03-31T23:42:21,936 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.initialization.jetty.CustomExceptionMapper to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:21,938 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding com.fasterxml.jackson.jaxrs.json.JacksonJsonProvider to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:21,943 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding com.fasterxml.jackson.jaxrs.smile.JacksonSmileProvider to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:22,151 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.PeonResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,161 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.security.StateResourceFilter to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,164 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.SegmentListerResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,165 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.segment.realtime.firehose.ChatHandlerResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,167 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.query.lookup.LookupListeningResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,168 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.query.lookup.LookupIntrospectionResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,170 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.security.ConfigResourceFilter to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,171 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.StatusResource to GuiceManagedComponentProvider with the scope "Undefined"
2020-03-31T23:42:22,183 WARN [main] com.sun.jersey.spi.inject.Errors - The following warnings have been detected with resource and/or provider classes:
WARNING: A HTTP GET method, public void io.druid.server.http.SegmentListerResource.getSegments(long,long,long,javax.servlet.http.HttpServletRequest) throws java.io.IOException, MUST return a non-void type.
2020-03-31T23:42:22,189 INFO [main] org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@5f935d49{/,null,AVAILABLE}
2020-03-31T23:42:22,195 INFO [main] org.eclipse.jetty.server.AbstractConnector - Started ServerConnector@7910f355{HTTP/1.1,[http/1.1]}{0.0.0.0:8100}
2020-03-31T23:42:22,195 INFO [main] org.eclipse.jetty.server.Server - Started @3761ms
2020-03-31T23:42:22,195 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.query.lookup.LookupReferencesManager.start()] on object[io.druid.query.lookup.LookupReferencesManager@34ab26a].
2020-03-31T23:42:22,195 INFO [main] io.druid.query.lookup.LookupReferencesManager - Started lookup factory references manager
2020-03-31T23:42:22,196 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.server.listener.announcer.ListenerResourceAnnouncer.start()] on object[io.druid.query.lookup.LookupResourceListenerAnnouncer@12209826].
2020-03-31T23:42:22,206 INFO [main] io.druid.server.listener.announcer.ListenerResourceAnnouncer - Announcing start time on [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,209 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.server.listener.announcer.ListenerResourceAnnouncer.stop()] on object[io.druid.query.lookup.LookupResourceListenerAnnouncer@12209826].
2020-03-31T23:42:22,209 INFO [main] io.druid.curator.announcement.Announcer - unannouncing [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,218 INFO [main] io.druid.server.listener.announcer.ListenerResourceAnnouncer - Unannouncing start time on [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,218 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.query.lookup.LookupReferencesManager.stop()] on object[io.druid.query.lookup.LookupReferencesManager@34ab26a].
2020-03-31T23:42:22,218 INFO [main] io.druid.query.lookup.LookupReferencesManager - Stopping lookup factory references manager
2020-03-31T23:42:22,220 INFO [main] org.eclipse.jetty.server.AbstractConnector - Stopped ServerConnector@7910f355{HTTP/1.1,[http/1.1]}{0.0.0.0:8100}
2020-03-31T23:42:22,221 INFO [main] org.eclipse.jetty.server.handler.ContextHandler - Stopped o.e.j.s.ServletContextHandler@5f935d49{/,null,UNAVAILABLE}
2020-03-31T23:42:22,223 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.indexing.worker.executor.ExecutorLifecycle.stop() throws java.lang.Exception] on object[io.druid.indexing.worker.executor.ExecutorLifecycle@10817f46].
2020-03-31T23:42:22,223 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.indexing.overlord.ThreadPoolTaskRunner.stop()] on object[io.druid.indexing.overlord.ThreadPoolTaskRunner@138a85d3].
2020-03-31T23:42:22,224 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.discovery.ServerDiscoverySelector.stop() throws java.io.IOException] on object[io.druid.curator.discovery.ServerDiscoverySelector@a3cba3a].
2020-03-31T23:42:22,227 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.announcement.Announcer.stop()] on object[io.druid.curator.announcement.Announcer@224d86d2].
2020-03-31T23:42:22,228 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.discovery.ServerDiscoverySelector.stop() throws java.io.IOException] on object[io.druid.curator.discovery.ServerDiscoverySelector@8641b7d].
2020-03-31T23:42:22,228 INFO [main] io.druid.curator.CuratorModule - Stopping Curator
2020-03-31T23:42:22,229 INFO [Curator-Framework-0] org.apache.curator.framework.imps.CuratorFrameworkImpl - backgroundOperationsLoop exiting
2020-03-31T23:42:22,231 INFO [main] org.apache.zookeeper.ZooKeeper - Session: 0x170ab8be1ef0038 closed
2020-03-31T23:42:22,231 INFO [main-EventThread] org.apache.zookeeper.ClientCnxn - EventThread shut down for session: 0x170ab8be1ef0038
2020-03-31T23:42:22,231 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.http.client.NettyHttpClient.stop()] on object[com.metamx.http.client.NettyHttpClient@256bb5be].
2020-03-31T23:42:22,241 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.metrics.MonitorScheduler.stop()] on object[com.metamx.metrics.MonitorScheduler@119290b9].
2020-03-31T23:42:22,241 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.emitter.service.ServiceEmitter.close() throws java.io.IOException] on object[ServiceEmitter{serviceDimensions={service=druid/middleManager, host=localhost:8100, version=0.9.1-SNAPSHOT}, emitter=com.metamx.emitter.core.NoopEmitter@5c3d4f05}].
2020-03-31T23:42:22,241 INFO [main] io.druid.cli.CliPeon - Finished peon task
2020-03-31T23:42:19,122 INFO [main] io.druid.guice.PropertiesModule - Loading properties from _common/common.runtime.properties (file:/usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3/conf/druid/_common/common.runtime.properties)
2020-03-31T23:42:19,147 INFO [main] org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 5.1.3.Final
2020-03-31T23:42:19,393 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [object] is registered with class [class io.druid.segment.serde.ComplexMetricSerde$Dummy]
2020-03-31T23:42:19,399 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [hyperUnique] is registered with class [class io.druid.query.aggregation.hyperloglog.HyperUniquesSerde]
2020-03-31T23:42:19,401 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [array] is registered with class [class io.druid.query.aggregation.ArrayMetricSerde]
2020-03-31T23:42:19,401 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [string] is registered with class [class io.druid.segment.serde.StringMetricSerde]
2020-03-31T23:42:19,402 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [decimal] is registered with class [class io.druid.query.aggregation.DecimalMetricSerde]
2020-03-31T23:42:19,408 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketch] is registered with class [class io.druid.query.aggregation.hll.HllSketchMergeComplexMetricSerde]
2020-03-31T23:42:19,409 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketchBuild] is registered with class [class io.druid.query.aggregation.hll.HllSketchBuildComplexMetricSerde]
2020-03-31T23:42:19,409 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [HLLSketchMerge] is registered with class [class io.druid.query.aggregation.hll.HllSketchMergeComplexMetricSerde]
2020-03-31T23:42:19,520 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.ExtensionsConfig] from props[druid.extensions.] as [ExtensionsConfig{searchCurrentClassloader=true, directory='extensions', hadoopDependenciesDir='hadoop-dependencies', hadoopContainerDruidClasspath='null', loadList=[druid-jdbc-firehose, druid-histogram, druid-datasketches, druid-hive-extensions, mysql-metadata-storage, druid-hdfs-storage, druid-range, druid-area, druid-stats, druid-jdbc-firehose, druid-orc-extensions, druid-kafka-indexing-service, druid-lucene-extensions, druid-geotools-extensions]}]
2020-03-31T23:42:19,736 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-jdbc-firehose] for class [io.druid.firehose.jdbc.JDBCFirehoseDruidModule]
2020-03-31T23:42:19,738 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-histogram] for class [io.druid.query.aggregation.histogram.ApproximateHistogramDruidModule]
2020-03-31T23:42:19,743 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-datasketches] for class [io.druid.query.aggregation.stats.DruidStatsModule]
2020-03-31T23:42:19,744 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-datasketches] for class [io.druid.query.aggregation.datasketches.theta.SketchModule]
2020-03-31T23:42:19,745 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-hive-extensions] for class [io.druid.hive.HiveDruidModule]
2020-03-31T23:42:19,746 INFO [main] io.druid.initialization.Initialization - Found extension module [mysql-metadata-storage] for class [io.druid.metadata.storage.mysql.MySQLMetadataStorageModule]
2020-03-31T23:42:19,747 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-hdfs-storage] for class [io.druid.storage.hdfs.HdfsStorageDruidModule]
2020-03-31T23:42:19,749 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-range] for class [io.druid.query.aggregation.range.MetricRangeModule]
2020-03-31T23:42:19,750 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-area] for class [io.druid.query.aggregation.area.MetricAreaModule]
2020-03-31T23:42:19,755 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-orc-extensions] for class [io.druid.data.OrcExtensionsModule]
2020-03-31T23:42:19,756 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-kafka-indexing-service] for class [io.druid.indexing.kafka.KafkaIndexTaskModule]
2020-03-31T23:42:19,757 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-lucene-extensions] for class [io.druid.segment.lucene.LuceneExtensionModule]
2020-03-31T23:42:19,758 INFO [main] io.druid.initialization.Initialization - Found extension module [druid-geotools-extensions] for class [io.druid.data.GeoToolsDruidModule]
2020-03-31T23:42:19,787 WARN [main] io.druid.initialization.Log4jShutterDownerModule - Shutdown callback registry expected class [io.druid.common.config.Log4jShutdown] found [org.apache.logging.log4j.core.util.DefaultShutdownCallbackRegistry]. Skipping shutdown registry
2020-03-31T23:42:20,082 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [metricArea] is registered with class [class io.druid.query.aggregation.area.MetricAreaSerde]
2020-03-31T23:42:20,291 WARN [main] org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
2020-03-31T23:42:20,528 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramFoldingSerde]
2020-03-31T23:42:20,529 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateCompactHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramCompactFoldingSerde]
2020-03-31T23:42:20,532 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateBase64Histogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramBase64FoldingSerde]
2020-03-31T23:42:20,533 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [approximateBase64CompactHistogram] is registered with class [class io.druid.query.aggregation.histogram.ApproximateHistogramBase64CompactFoldingSerde]
2020-03-31T23:42:20,534 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [metricRange] is registered with class [class io.druid.query.aggregation.range.MetricRangeSerde]
2020-03-31T23:42:20,544 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketch] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchMergeComplexMetricSerde]
2020-03-31T23:42:20,544 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketchMerge] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchMergeComplexMetricSerde]
2020-03-31T23:42:20,545 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [thetaSketchBuild] is registered with class [class io.druid.query.aggregation.datasketches.theta.SketchBuildComplexMetricSerde]
2020-03-31T23:42:20,546 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [variance] is registered with class [class io.druid.query.aggregation.variance.VarianceSerde]
2020-03-31T23:42:20,547 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [varianceCombined] is registered with class [class io.druid.query.aggregation.variance.VarianceCombinedSerde]
2020-03-31T23:42:20,549 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [pearson] is registered with class [class io.druid.query.aggregation.corr.PearsonSerde]
2020-03-31T23:42:20,550 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [covariance] is registered with class [class io.druid.query.aggregation.covariance.CovarianceSerde]
2020-03-31T23:42:20,552 INFO [main] io.druid.segment.serde.ComplexMetrics - Serde for type [kurtosis] is registered with class [class io.druid.query.aggregation.kurtosis.KurtosisSerde]
2020-03-31T23:42:20,843 INFO [main] io.druid.jackson.FunctionInitializer - finding expression functions..
2020-03-31T23:42:20,848 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.BuiltinFunctions]
2020-03-31T23:42:20,886 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.PredicateFunctions]
2020-03-31T23:42:20,891 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.DateTimeFunctions]
2020-03-31T23:42:20,902 INFO [main] io.druid.math.expr.Parser - registering functions in built-in library [io.druid.math.expr.ExcelFunctions]
2020-03-31T23:42:20,948 INFO [main] io.druid.math.expr.Parser - registering functions in user library [org.geohex.geohex4j.GeoHexFunctions]
2020-03-31T23:42:20,949 INFO [main] io.druid.math.expr.Parser - > 'geohex_to_boundary_wkt' is registered with class GeoHexToBoundaryWKT
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'geohex_to_boundary' is registered with class GeoHexToBoundary
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'geom_to_geohex' is registered with class GeomToGeoHex
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - > 'to_geohex' is registered with class ToGeoHex
2020-03-31T23:42:20,950 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.ShapeFunctions]
2020-03-31T23:42:21,031 INFO [main] io.druid.math.expr.Parser - > 'shape_withindistance' is registered with class WithinDistance
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_equalsexact' is registered with class ShapeEqualsExact
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_equals' is registered with class ShapeEquals
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_disjoint' is registered with class ShapeDisjoint
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_crosses' is registered with class ShapeCrosses
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_touches' is registered with class ShapeTouches
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_within' is registered with class ShapeWithin
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_overlaps' is registered with class ShapeOverlaps
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_contains' is registered with class ShapeContains
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_coveredby' is registered with class ShapeCoveredBy
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_covers' is registered with class ShapeCovers
2020-03-31T23:42:21,032 INFO [main] io.druid.math.expr.Parser - > 'shape_intersects' is registered with class ShapeIntersects
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_union' is registered with class ShapeUnion
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_intersection' is registered with class Intersection
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_difference' is registered with class Difference
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_coordinates_yx' is registered with class CoordinatesYX
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_coordinates_xy' is registered with class CoordinatesXY
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_centroid_yx' is registered with class CentroidYX
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_centroid_xy' is registered with class CentroidXY
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_length' is registered with class Length
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_area' is registered with class Area
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_reverse' is registered with class Reverse
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_envelop' is registered with class Envelop
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_convexhull' is registered with class ConvexHull
2020-03-31T23:42:21,033 INFO [main] io.druid.math.expr.Parser - > 'shape_boundary' is registered with class Boundary
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_togeojson' is registered with class ToGeoJson
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_towkt' is registered with class ToWKT
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromgeojson' is registered with class FromGeoJson
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromwkt' is registered with class FromWKT
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromlonlat' is registered with class FromLonLat
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - > 'shape_fromlatlon' is registered with class FromLatLon
2020-03-31T23:42:21,034 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.sql.SQLFunctions]
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_shift' is registered with class TimestampShiftExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_parse' is registered with class TimestampParseExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_format' is registered with class TimestampFormatExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_floor' is registered with class TimestampFloorExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_extract' is registered with class TimestampExtractFunc
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - > 'timestamp_ceil' is registered with class TimestampCeilExprMacro
2020-03-31T23:42:21,036 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.ModuleBuiltinFunctions]
2020-03-31T23:42:21,037 INFO [main] io.druid.math.expr.Parser - > 'haversin_meter' is registered with class HaversinMeter
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'lookup' is registered with class LookupFunc
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'lookupmap' is registered with class LookupMapFunc
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - > 'truncatedrecent' is registered with class TruncatedRecent
2020-03-31T23:42:21,038 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.H3Functions]
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_boundary_wkt' is registered with class H3ToBoundaryWKT
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_boundary' is registered with class H3ToBoundary
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_center_wkt' is registered with class H3ToCenterWKT
2020-03-31T23:42:21,041 INFO [main] io.druid.math.expr.Parser - > 'h3_to_center' is registered with class H3ToCenter
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'to_h3_address' is registered with class ToH3Address
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'geom_to_h3' is registered with class GeomToH3
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - > 'to_h3' is registered with class ToH3
2020-03-31T23:42:21,042 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.data.GeoToolsFunctions]
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_smooth' is registered with class Smooth
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_transform' is registered with class Transform
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'shape_buffer' is registered with class Buffer
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - > 'lonlat.to4326' is registered with class LonLatTo4326
2020-03-31T23:42:21,044 INFO [main] io.druid.math.expr.Parser - registering functions in user library [io.druid.query.GeoHashFunctions]
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_boundary_wkt' is registered with class GeoHashToBoundaryWKT
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_boundary' is registered with class GeoHashToBoundary
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_center_wkt' is registered with class GeoHashToCenterWKT
2020-03-31T23:42:21,046 INFO [main] io.druid.math.expr.Parser - > 'geohash_to_center' is registered with class GeoHashToCenter
2020-03-31T23:42:21,047 INFO [main] io.druid.math.expr.Parser - > 'geom_to_geohash' is registered with class GeomToGeoHash
2020-03-31T23:42:21,047 INFO [main] io.druid.math.expr.Parser - > 'to_geohash' is registered with class ToGeoHash
2020-03-31T23:42:21,085 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.DruidMonitorSchedulerConfig] from props[druid.monitoring.] as [io.druid.server.metrics.DruidMonitorSchedulerConfig@7235f92b]
2020-03-31T23:42:21,091 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.MonitorsConfig] from props[druid.monitoring.] as [MonitorsConfig{monitors=[]}]
2020-03-31T23:42:21,110 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.DruidNode] from props[druid.] as [DruidNode{serviceName='druid/middleManager', serviceType='peon', host='localhost', port=8100}]
2020-03-31T23:42:21,111 INFO [main] io.druid.server.metrics.MetricsModule - Adding monitor[io.druid.query.ExecutorServiceMonitor@36ab3814]
2020-03-31T23:42:21,215 INFO [main] io.druid.server.metrics.MetricsModule - Adding monitor[io.druid.server.initialization.jetty.JettyServerModule$JettyMonitor@3b7c80c6]
2020-03-31T23:42:21,223 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.log.StartupLoggingConfig] from props[druid.startup.logging.] as [io.druid.server.log.StartupLoggingConfig@7a8341c1]
2020-03-31T23:42:21,223 INFO [main] io.druid.cli.CliPeon - Starting up with processors[8], memory[465.567.744].
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * awt.toolkit: sun.awt.X11.XToolkit
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.extensions.loadList: ["druid-jdbc-firehose", "druid-histogram", "druid-datasketches", "druid-hive-extensions", "mysql-metadata-storage", "druid-hdfs-storage", "druid-range", "druid-area", "druid-stats", "druid-jdbc-firehose", "druid-orc-extensions", "druid-kafka-indexing-service", "druid-lucene-extensions", "druid-geotools-extensions"]
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.host: localhost
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.logs.directory: var/druid/indexing-logs
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.logs.type: file
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.baseTaskDir: var/druid/task
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.defaultHadoopCoordinates: ["org.apache.hadoop:hadoop-client:2.7.3"]
2020-03-31T23:42:21,224 INFO [main] io.druid.cli.CliPeon - * druid.indexer.task.hadoopWorkingPath: var/druid/hadoop-tmp
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.connectURI: jdbc:derby://localhost:1527/var/druid/metadata.db;create=true
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.host: localhost
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.connector.port: 1527
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metadata.storage.type: derby
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metrics.emitter.dimension.dataSource: a_vmipt
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.metrics.emitter.dimension.taskId: index_a_vmipt_2020-03-31T23:42:18.421Z
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.port: 8100
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.processing.buffer.sizeBytes: 536870912
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.processing.numThreads: 2
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.selectors.coordinator.serviceName: druid/coordinator
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.selectors.indexing.serviceName: druid/overlord
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.server.http.numThreads: 25
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.service: druid/middleManager
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.startup.logging.logProperties: true
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.storage.storageDirectory: var/druid/segments
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.storage.type: local
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.worker.capacity: 10
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.zk.paths.base: /druid
2020-03-31T23:42:21,225 INFO [main] io.druid.cli.CliPeon - * druid.zk.service.host: localhost
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.encoding: UTF-8
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.encoding.pkg: sun.io
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * file.separator: /
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.awt.graphicsenv: sun.awt.X11GraphicsEnvironment
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.awt.printerjob: sun.print.PSPrinterJob
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.class.path: conf/druid/_common:conf/druid:conf/druid/single:lib/druid-processing-0.9.1-SNAPSHOT.jar:lib/javax.el-3.0.0.jar:lib/lucene-core-6.2.0.jar:lib/tesla-aether-0.0.5.jar:lib/aws-java-sdk-ssm-1.10.21.jar:lib/netty-reactive-streams-1.0.8.jar:lib/aggdesigner-algorithm-6.0.jar:lib/xmlbeans-2.6.0.jar:lib/classmate-1.0.0.jar:lib/netty-buffer-4.0.52.Final.jar:lib/jetty-servlets-9.3.24.v20180605.jar:lib/aws-java-sdk-cloudwatchmetrics-1.10.21.jar:lib/log4j-slf4j-impl-2.5.jar:lib/derbyclient-10.11.1.1.jar:lib/aws-java-sdk-elasticloadbalancing-1.10.21.jar:lib/aws-java-sdk-cloudwatch-1.10.21.jar:lib/aws-java-sdk-codecommit-1.10.21.jar:lib/aws-java-sdk-ses-1.10.21.jar:lib/google-http-client-1.20.0.jar:lib/aws-java-sdk-ecs-1.10.21.jar:lib/aether-impl-0.9.0.M2.jar:lib/aws-java-sdk-cloudfront-1.10.21.jar:lib/mysql-connector-java-5.1.38.jar:lib/commons-csv-1.6.jar:lib/jetty-server-9.3.24.v20180605.jar:lib/jetty-util-9.3.24.v20180605.jar:lib/aws-java-sdk-lambda-1.10.21.jar:lib/jackson-jaxrs-json-provider-2.4.6.jar:lib/jersey-guice-1.19.jar:lib/aopalliance-1.0.jar:lib/aws-java-sdk-storagegateway-1.10.21.jar:lib/jackson-module-jaxb-annotations-2.4.6.jar:lib/aws-java-sdk-emr-1.10.21.jar:lib/maven-repository-metadata-3.1.1.jar:lib/maven-aether-provider-3.1.1.jar:lib/netty-codec-dns-2.0.37.jar:lib/commons-logging-1.1.1.jar:lib/jetty-io-9.3.24.v20180605.jar:lib/aws-java-sdk-workspaces-1.10.21.jar:lib/log4j-1.2-api-2.5.jar:lib/plexus-interpolation-1.19.jar:lib/aws-java-sdk-support-1.10.21.jar:lib/log4j-core-2.5.jar:lib/aws-java-sdk-directory-1.10.21.jar:lib/activation-1.1.1.jar:lib/async-http-client-netty-utils-2.0.37.jar:lib/jts-io-1.14.0.jar:lib/aws-java-sdk-cognitosync-1.10.21.jar:lib/antlr4-runtime-4.5.1.jar:lib/bcprov-jdk15on-1.52.jar:lib/commons-dbcp2-2.0.1.jar:lib/curator-client-2.10.0.jar:lib/base64-2.3.8.jar:lib/curator-framework-2.10.0.jar:lib/aws-java-sdk-config-1.10.21.jar:lib/druid-indexing-hadoop-0.9.1-SNAPSHOT.jar:lib/javax.el-api-3.0.0.jar:lib/aws-java-sdk-sns-1.10.21.jar:lib/jackson-core-2.4.6.jar:lib/opencsv-2.3.jar:lib/jackson-databind-2.4.6.jar:lib/zookeeper-3.4.8.jar:lib/druid-console-0.9.1-SNAPSHOT.jar:lib/poi-ooxml-schemas-3.13.jar:lib/aws-java-sdk-s3-1.10.21.jar:lib/aws-java-sdk-directconnect-1.10.21.jar:lib/aws-java-sdk-route53-1.10.21.jar:lib/aether-spi-0.9.0.M2.jar:lib/aws-java-sdk-elastictranscoder-1.10.21.jar:lib/javax.servlet-api-3.1.0.jar:lib/xercesImpl-2.11.0.jar:lib/netty-transport-native-epoll-4.0.52.Final-linux-x86_64.jar:lib/netty-handler-4.0.52.Final.jar:lib/aws-java-sdk-simpleworkflow-1.10.21.jar:lib/aws-java-sdk-sqs-1.10.21.jar:lib/commons-cli-1.2.jar:lib/aws-java-sdk-ec2-1.10.21.jar:lib/aether-connector-okhttp-0.0.9.jar:lib/aws-java-sdk-cloudsearch-1.10.21.jar:lib/validation-api-1.1.0.Final.jar:lib/h2-1.3.175.jar:lib/guice-servlet-4.1.0.jar:lib/aws-java-sdk-importexport-1.10.21.jar:lib/guice-4.1.0.jar:lib/rhino-1.7R5.jar:lib/aws-java-sdk-machinelearning-1.10.21.jar:lib/poi-3.13.jar:lib/aws-java-sdk-opsworks-1.10.21.jar:lib/commons-pool2-2.2.jar:lib/protobuf-java-3.1.0.jar:lib/jsr311-api-1.1.1.jar:lib/mapdb-1.0.8.jar:lib/aws-java-sdk-glacier-1.10.21.jar:lib/druid-server-0.9.1-SNAPSHOT.jar:lib/avatica-core-1.12.0.jar:lib/commons-pool-1.6.jar:lib/aether-util-0.9.0.M2.jar:lib/jetty-continuation-9.3.24.v20180605.jar:lib/aws-java-sdk-elasticbeanstalk-1.10.21.jar:lib/jvm-attach-api-1.2.jar:lib/aws-java-sdk-dynamodb-1.10.21.jar:lib/esri-geometry-api-2.0.0.jar:lib/maven-settings-builder-3.1.1.jar:lib/aether-connector-file-0.9.0.M2.jar:lib/json-path-2.1.0.jar:lib/aws-java-sdk-elasticache-1.10.21.jar:lib/jersey-servlet-1.19.jar:lib/httpclient-4.5.1.jar:lib/sketches-core-0.12.0.jar:lib/derbynet-10.11.1.1.jar:lib/lucene-sandbox-6.2.0.jar:lib/reactive-streams-1.0.0.jar:lib/jetty-security-9.3.24.v20180605.jar:lib/lucene-queryparser-6.2.0.jar:lib/jcl-over-slf4j-1.7.12.jar:lib/okhttp-1.0.2.jar:lib/avatica-server-1.12.0.jar:lib/commons-io-2.4.jar:lib/memory-0.12.0.jar:lib/aws-java-sdk-codedeploy-1.10.21.jar:lib/jackson-core-asl-1.9.13.jar:lib/aws-java-sdk-cognitoidentity-1.10.21.jar:lib/geoip2-0.4.0.jar:lib/spymemcached-2.11.7.jar:lib/netty-transport-4.0.52.Final.jar:lib/janino-2.7.6.jar:lib/google-http-client-jackson2-1.15.0-rc.jar:lib/xlsx-streamer-1.0.1.jar:lib/aether-api-0.9.0.M2.jar:lib/commons-math3-3.6.1.jar:lib/airline-0.7.jar:lib/jackson-dataformat-smile-2.4.6.jar:lib/netty-common-4.0.52.Final.jar:lib/calcite-server-1.17.0.jar:lib/commons-codec-1.7.jar:lib/netty-all-4.1.11.Final.jar:lib/aws-java-sdk-kinesis-1.10.21.jar:lib/avatica-metrics-1.12.0.jar:lib/druid-indexing-service-0.9.1-SNAPSHOT.jar:lib/joda-time-2.8.2.jar:lib/aws-java-sdk-cloudhsm-1.10.21.jar:lib/jetty-proxy-9.3.24.v20180605.jar:lib/log4j-api-2.5.jar:lib/jts-core-1.14.0.jar:lib/aws-java-sdk-logs-1.10.21.jar:lib/xml-apis-1.4.01.jar:lib/druid-common-0.9.1-SNAPSHOT.jar:lib/jetty-http-9.3.24.v20180605.jar:lib/netty-3.10.6.Final.jar:lib/jackson-jaxrs-smile-provider-2.4.6.jar:lib/netty-codec-http-4.0.52.Final.jar:lib/aws-java-sdk-cloudtrail-1.10.21.jar:lib/calcite-linq4j-1.17.0.jar:lib/aws-java-sdk-sts-1.10.21.jar:lib/jackson-jaxrs-base-2.4.6.jar:lib/curator-x-discovery-2.10.0.jar:lib/log4j-jul-2.5.jar:lib/netty-resolver-dns-2.0.37.jar:lib/aws-java-sdk-1.10.21.jar:lib/commons-collections-3.2.1.jar:lib/wagon-provider-api-2.4.jar:lib/poi-ooxml-3.13.jar:lib/jetty-client-9.3.24.v20180605.jar:lib/config-magic-0.9.jar:lib/aws-java-sdk-core-1.10.21.jar:lib/jersey-core-1.19.jar:lib/calcite-core-1.17.0.jar:lib/guice-multibindings-4.1.0.jar:lib/extendedset-1.3.10.jar:lib/jsr305-2.0.1.jar:lib/aws-java-sdk-swf-libraries-1.10.21.jar:lib/java-xmlbuilder-1.1.jar:lib/compress-lzf-1.0.3.jar:lib/stax-api-1.0.1.jar:lib/jersey-server-1.19.jar:lib/jackson-datatype-guava-2.4.6.jar:lib/maven-model-3.1.1.jar:lib/jackson-datatype-joda-2.4.6.jar:lib/maven-settings-3.1.1.jar:lib/plexus-utils-3.0.15.jar:lib/aws-java-sdk-devicefarm-1.10.21.jar:lib/commons-lang3-3.2.jar:lib/jboss-logging-3.1.3.GA.jar:lib/bytebuffer-collections-0.2.5.jar:lib/commons-lang-2.6.jar:lib/aws-java-sdk-simpledb-1.10.21.jar:lib/lz4-1.3.0.jar:lib/aws-java-sdk-rds-1.10.21.jar:lib/aws-java-sdk-codepipeline-1.10.21.jar:lib/aws-java-sdk-kms-1.10.21.jar:lib/lucene-analyzers-common-6.2.0.jar:lib/netty-resolver-2.0.37.jar:lib/aws-java-sdk-autoscaling-1.10.21.jar:lib/jline-3.2.0.jar:lib/druid-aws-common-0.9.1-SNAPSHOT.jar:lib/RoaringBitmap-0.5.18.jar:lib/maven-model-builder-3.1.1.jar:lib/hibernate-validator-5.1.3.Final.jar:lib/druid-services-0.9.1-SNAPSHOT.jar:lib/slf4j-api-1.7.12.jar:lib/jdbi-2.63.1.jar:lib/maxminddb-0.2.0.jar:lib/java-util-1.3.3.jar:lib/jetty-servlet-9.3.24.v20180605.jar:lib/httpcore-4.4.3.jar:lib/jackson-mapper-asl-1.9.13.jar:lib/async-http-client-2.0.37.jar:lib/aws-java-sdk-iam-1.10.21.jar:lib/jackson-annotations-2.4.6.jar:lib/jets3t-0.9.4.jar:lib/druid-sql-0.9.1-SNAPSHOT.jar:lib/commons-compiler-2.7.6.jar:lib/aws-java-sdk-redshift-1.10.21.jar:lib/disruptor-3.3.0.jar:lib/curator-recipes-2.10.0.jar:lib/javax.inject-1.jar:lib/irc-api-1.0-0014.jar:lib/aws-java-sdk-cloudformation-1.10.21.jar:lib/aws-java-sdk-datapipeline-1.10.21.jar:lib/lucene-queries-6.2.0.jar:lib/aws-java-sdk-efs-1.10.21.jar:lib/guava-16.0.1.jar:lib/netty-codec-4.0.52.Final.jar:lib/derby-10.11.1.1.jar:/usr/local/Cellar/hadoop/2.7.2/libexec/etc/hadoop
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.class.version: 52.0
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.endorsed.dirs: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/endorsed
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.ext.dirs: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/ext:/usr/java/packages/lib/ext
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.home: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.io.tmpdir: /tmp
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.runtime.name: OpenJDK Runtime Environment
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.runtime.version: 1.8.0_232-b09
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.name: Java Platform API Specification
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.vendor: Oracle Corporation
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.specification.version: 1.8
2020-03-31T23:42:21,226 INFO [main] io.druid.cli.CliPeon - * java.util.logging.manager: org.apache.logging.log4j.jul.LogManager
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor.url: http://java.oracle.com/
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vendor.url.bug: http://bugreport.sun.com/bugreport/
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.version: 1.8.0_232
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.info: mixed mode
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.name: OpenJDK 64-Bit Server VM
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.name: Java Virtual Machine Specification
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.specification.version: 1.8
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.vendor: Oracle Corporation
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * java.vm.version: 25.232-b09
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * line.separator:
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * log4j.shutdownCallbackRegistry: io.druid.common.config.Log4jShutdown
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * log4j.shutdownHookEnabled: true
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.arch: amd64
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.name: Linux
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * os.version: 4.18.0-80.11.2.el8_0.x86_64
2020-03-31T23:42:21,227 INFO [main] io.druid.cli.CliPeon - * path.separator: :
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.arch.data.model: 64
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.boot.class.path: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/resources.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/rt.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jsse.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jce.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/charsets.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/jfr.jar:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/classes
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.boot.library.path: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre/lib/amd64
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.cpu.endian: little
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.cpu.isalist:
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.io.unicode.encoding: UnicodeLittle
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.java.command: io.druid.cli.Main internal peon var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/task.json var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/b4be4bcd-b4cd-47f9-9f0a-0e0c332e3967/status.json --queryable
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.java.launcher: SUN_STANDARD
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.jnu.encoding: UTF-8
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.management.compiler: HotSpot 64-Bit Tiered Compilers
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * sun.os.patch.level: unknown
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.country: IT
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.dir: /usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.home: /root
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.language: it
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.name: root
2020-03-31T23:42:21,228 INFO [main] io.druid.cli.CliPeon - * user.timezone: UTC
2020-03-31T23:42:21,236 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.common.config.TaskConfig] from props[druid.indexer.task.] as [io.druid.indexing.common.config.TaskConfig@2e4389ed]
2020-03-31T23:42:21,239 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.http.DruidHttpClientConfig] from props[druid.global.http.] as [io.druid.guice.http.DruidHttpClientConfig@6bbab114]
2020-03-31T23:42:21,287 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.indexing.IndexingServiceSelectorConfig] from props[druid.selectors.indexing.] as [io.druid.client.indexing.IndexingServiceSelectorConfig@4a1a256d]
2020-03-31T23:42:21,290 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.curator.CuratorConfig] from props[druid.zk.service.] as [io.druid.curator.CuratorConfig@69de5bed]
2020-03-31T23:42:21,293 WARN [main] org.apache.curator.retry.ExponentialBackoffRetry - maxRetries too large (30). Pinning to 29
2020-03-31T23:42:21,311 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.CuratorDiscoveryConfig] from props[druid.discovery.curator.] as [io.druid.server.initialization.CuratorDiscoveryConfig@2b73bd6b]
2020-03-31T23:42:21,329 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.common.RetryPolicyConfig] from props[druid.peon.taskActionClient.retry.] as [io.druid.indexing.common.RetryPolicyConfig@e9474f]
2020-03-31T23:42:21,331 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.segment.loading.LocalDataSegmentPusherConfig] from props[druid.storage.] as [io.druid.segment.loading.LocalDataSegmentPusherConfig@77cb452c]
2020-03-31T23:42:21,332 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.storage.hdfs.HdfsDataSegmentPusherConfig] from props[druid.storage.] as [io.druid.storage.hdfs.HdfsDataSegmentPusherConfig@6c8fe7a4]
2020-03-31T23:42:21,337 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.DruidServerConfig] from props[druid.server.] as [io.druid.client.DruidServerConfig@7a2fce12]
2020-03-31T23:42:21,340 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.BatchDataSegmentAnnouncerConfig] from props[druid.announcer.] as [io.druid.server.initialization.BatchDataSegmentAnnouncerConfig@11787b64]
2020-03-31T23:42:21,342 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ZkPathsConfig] from props[druid.zk.paths.] as [io.druid.server.initialization.ZkPathsConfig@22e2266d]
2020-03-31T23:42:21,346 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.server.coordination.DataSegmentAnnouncerProvider] from props[druid.announcer.] as [io.druid.server.coordination.BatchDataSegmentAnnouncerProvider@19b02dfd]
2020-03-31T23:42:21,347 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.coordinator.CoordinatorSelectorConfig] from props[druid.selectors.coordinator.] as [io.druid.client.coordinator.CoordinatorSelectorConfig@570ba13]
2020-03-31T23:42:21,349 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.segment.realtime.plumber.CoordinatorBasedSegmentHandoffNotifierConfig] from props[druid.segment.handoff.] as [io.druid.segment.realtime.plumber.CoordinatorBasedSegmentHandoffNotifierConfig@8e25d3f]
2020-03-31T23:42:21,353 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.client.cache.CacheProvider] from props[druid.cache.bitmap.] as [io.druid.client.cache.LocalCacheProvider@3e900e1a]
2020-03-31T23:42:21,362 INFO [main] io.druid.client.cache.MapCache - Creating local cache with size 0
2020-03-31T23:42:21,366 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [${base_path}.fifo] on [io.druid.query.DruidProcessingConfig#isFifo()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [druid.computation.buffer.poolCacheMaxCount, ${base_path}.buffer.poolCacheMaxCount] on [io.druid.query.DruidProcessingConfig#poolCacheMaxCount()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [${base_path}.columnCache.sizeBytes] on [io.druid.query.DruidProcessingConfig#columnCacheSizeBytes()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [536870912] for [druid.processing.buffer.sizeBytes] on [io.druid.query.DruidProcessingConfig#intermediateComputeSizeBytes()]
2020-03-31T23:42:21,368 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [2] for [druid.processing.numThreads] on [io.druid.query.DruidProcessingConfig#getNumThreads()]
2020-03-31T23:42:21,369 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning default value [processing-%s] for [${base_path}.formatString] on [com.metamx.common.concurrent.ExecutorServiceConfig#getFormatString()]
2020-03-31T23:42:21,428 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.search.search.SearchQueryConfig] from props[druid.query.search.] as [io.druid.query.search.search.SearchQueryConfig@7aaad0]
2020-03-31T23:42:21,430 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.metadata.SegmentMetadataQueryConfig] from props[druid.query.segmentMetadata.] as [io.druid.query.metadata.SegmentMetadataQueryConfig@6cbb175]
2020-03-31T23:42:21,432 INFO [main] io.druid.guice.DruidProcessingModule - Starting with max direct memory 1.908.932.608 bytes, 2 processor with intermediate buffer 536.870.912 bytes
2020-03-31T23:42:21,439 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.groupby.GroupByQueryConfig] from props[druid.query.groupBy.] as [io.druid.query.groupby.GroupByQueryConfig@2f995afc]
2020-03-31T23:42:21,441 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.select.SelectQueryConfig] from props[druid.query.select.] as [io.druid.query.select.SelectQueryConfig@1ef31f71]
2020-03-31T23:42:21,442 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.topn.TopNQueryConfig] from props[druid.query.topN.] as [io.druid.query.topn.TopNQueryConfig@6f6cc7da]
2020-03-31T23:42:21,443 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.JoinQueryConfig] from props[druid.query.join.] as [io.druid.query.JoinQueryConfig@44aa2e13]
2020-03-31T23:42:21,446 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.QueryConfig] from props[druid.query.] as [io.druid.query.QueryConfig@4b41587d]
2020-03-31T23:42:21,456 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.client.cache.CacheProvider] from props[druid.cache.] as [io.druid.client.cache.LocalCacheProvider@4962b41e]
2020-03-31T23:42:21,456 INFO [main] io.druid.client.cache.MapCache - Creating local cache with size 0
2020-03-31T23:42:21,459 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.client.cache.CacheConfig] from props[druid.realtime.cache.] as [io.druid.client.cache.CacheConfig@3ebc955b]
2020-03-31T23:42:21,470 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ServerConfig] from props[druid.server.http.] as [ServerConfig{numThreads=25, maxIdleTime=PT5M}]
2020-03-31T23:42:21,472 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[interface io.druid.server.log.RequestLoggerProvider] from props[druid.request.logging.] as [io.druid.server.log.RequestLoggerProvider$Logging@402f8592]
2020-03-31T23:42:21,474 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.security.AuthConfig] from props[druid.auth.] as [AuthConfig{enabled=false}]
2020-03-31T23:42:21,481 INFO [main] org.eclipse.jetty.util.log - Logging initialized @3046ms
2020-03-31T23:42:21,563 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.lookup.LookupConfig] from props[druid.lookup.] as [LookupConfig{snapshotWorkingDir=''}]
2020-03-31T23:42:21,566 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.query.lookup.LookupListeningAnnouncerConfig] from props[druid.lookup.] as [ListeningAnnouncerConfig{listenersPath='/druid/listeners'}]
2020-03-31T23:42:21,567 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.emitter.service.ServiceEmitter.start()] on object[ServiceEmitter{serviceDimensions={service=druid/middleManager, host=localhost:8100, version=0.9.1-SNAPSHOT}, emitter=com.metamx.emitter.core.NoopEmitter@5c3d4f05}].
2020-03-31T23:42:21,567 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.metrics.MonitorScheduler.start()] on object[com.metamx.metrics.MonitorScheduler@119290b9].
2020-03-31T23:42:21,570 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.http.client.NettyHttpClient.start()] on object[com.metamx.http.client.NettyHttpClient@256bb5be].
2020-03-31T23:42:21,570 INFO [main] io.druid.curator.CuratorModule - Starting Curator
2020-03-31T23:42:21,570 INFO [main] org.apache.curator.framework.imps.CuratorFrameworkImpl - Starting
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.4.8--1, built on 02/06/2016 03:18 GMT
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:host.name=localhost
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.version=1.8.0_232
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.home=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el8_0.x86_64/jre
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=conf/druid/_common:conf/druid:conf/druid/single:lib/druid-processing-0.9.1-SNAPSHOT.jar:lib/javax.el-3.0.0.jar:lib/lucene-core-6.2.0.jar:lib/tesla-aether-0.0.5.jar:lib/aws-java-sdk-ssm-1.10.21.jar:lib/netty-reactive-streams-1.0.8.jar:lib/aggdesigner-algorithm-6.0.jar:lib/xmlbeans-2.6.0.jar:lib/classmate-1.0.0.jar:lib/netty-buffer-4.0.52.Final.jar:lib/jetty-servlets-9.3.24.v20180605.jar:lib/aws-java-sdk-cloudwatchmetrics-1.10.21.jar:lib/log4j-slf4j-impl-2.5.jar:lib/derbyclient-10.11.1.1.jar:lib/aws-java-sdk-elasticloadbalancing-1.10.21.jar:lib/aws-java-sdk-cloudwatch-1.10.21.jar:lib/aws-java-sdk-codecommit-1.10.21.jar:lib/aws-java-sdk-ses-1.10.21.jar:lib/google-http-client-1.20.0.jar:lib/aws-java-sdk-ecs-1.10.21.jar:lib/aether-impl-0.9.0.M2.jar:lib/aws-java-sdk-cloudfront-1.10.21.jar:lib/mysql-connector-java-5.1.38.jar:lib/commons-csv-1.6.jar:lib/jetty-server-9.3.24.v20180605.jar:lib/jetty-util-9.3.24.v20180605.jar:lib/aws-java-sdk-lambda-1.10.21.jar:lib/jackson-jaxrs-json-provider-2.4.6.jar:lib/jersey-guice-1.19.jar:lib/aopalliance-1.0.jar:lib/aws-java-sdk-storagegateway-1.10.21.jar:lib/jackson-module-jaxb-annotations-2.4.6.jar:lib/aws-java-sdk-emr-1.10.21.jar:lib/maven-repository-metadata-3.1.1.jar:lib/maven-aether-provider-3.1.1.jar:lib/netty-codec-dns-2.0.37.jar:lib/commons-logging-1.1.1.jar:lib/jetty-io-9.3.24.v20180605.jar:lib/aws-java-sdk-workspaces-1.10.21.jar:lib/log4j-1.2-api-2.5.jar:lib/plexus-interpolation-1.19.jar:lib/aws-java-sdk-support-1.10.21.jar:lib/log4j-core-2.5.jar:lib/aws-java-sdk-directory-1.10.21.jar:lib/activation-1.1.1.jar:lib/async-http-client-netty-utils-2.0.37.jar:lib/jts-io-1.14.0.jar:lib/aws-java-sdk-cognitosync-1.10.21.jar:lib/antlr4-runtime-4.5.1.jar:lib/bcprov-jdk15on-1.52.jar:lib/commons-dbcp2-2.0.1.jar:lib/curator-client-2.10.0.jar:lib/base64-2.3.8.jar:lib/curator-framework-2.10.0.jar:lib/aws-java-sdk-config-1.10.21.jar:lib/druid-indexing-hadoop-0.9.1-SNAPSHOT.jar:lib/javax.el-api-3.0.0.jar:lib/aws-java-sdk-sns-1.10.21.jar:lib/jackson-core-2.4.6.jar:lib/opencsv-2.3.jar:lib/jackson-databind-2.4.6.jar:lib/zookeeper-3.4.8.jar:lib/druid-console-0.9.1-SNAPSHOT.jar:lib/poi-ooxml-schemas-3.13.jar:lib/aws-java-sdk-s3-1.10.21.jar:lib/aws-java-sdk-directconnect-1.10.21.jar:lib/aws-java-sdk-route53-1.10.21.jar:lib/aether-spi-0.9.0.M2.jar:lib/aws-java-sdk-elastictranscoder-1.10.21.jar:lib/javax.servlet-api-3.1.0.jar:lib/xercesImpl-2.11.0.jar:lib/netty-transport-native-epoll-4.0.52.Final-linux-x86_64.jar:lib/netty-handler-4.0.52.Final.jar:lib/aws-java-sdk-simpleworkflow-1.10.21.jar:lib/aws-java-sdk-sqs-1.10.21.jar:lib/commons-cli-1.2.jar:lib/aws-java-sdk-ec2-1.10.21.jar:lib/aether-connector-okhttp-0.0.9.jar:lib/aws-java-sdk-cloudsearch-1.10.21.jar:lib/validation-api-1.1.0.Final.jar:lib/h2-1.3.175.jar:lib/guice-servlet-4.1.0.jar:lib/aws-java-sdk-importexport-1.10.21.jar:lib/guice-4.1.0.jar:lib/rhino-1.7R5.jar:lib/aws-java-sdk-machinelearning-1.10.21.jar:lib/poi-3.13.jar:lib/aws-java-sdk-opsworks-1.10.21.jar:lib/commons-pool2-2.2.jar:lib/protobuf-java-3.1.0.jar:lib/jsr311-api-1.1.1.jar:lib/mapdb-1.0.8.jar:lib/aws-java-sdk-glacier-1.10.21.jar:lib/druid-server-0.9.1-SNAPSHOT.jar:lib/avatica-core-1.12.0.jar:lib/commons-pool-1.6.jar:lib/aether-util-0.9.0.M2.jar:lib/jetty-continuation-9.3.24.v20180605.jar:lib/aws-java-sdk-elasticbeanstalk-1.10.21.jar:lib/jvm-attach-api-1.2.jar:lib/aws-java-sdk-dynamodb-1.10.21.jar:lib/esri-geometry-api-2.0.0.jar:lib/maven-settings-builder-3.1.1.jar:lib/aether-connector-file-0.9.0.M2.jar:lib/json-path-2.1.0.jar:lib/aws-java-sdk-elasticache-1.10.21.jar:lib/jersey-servlet-1.19.jar:lib/httpclient-4.5.1.jar:lib/sketches-core-0.12.0.jar:lib/derbynet-10.11.1.1.jar:lib/lucene-sandbox-6.2.0.jar:lib/reactive-streams-1.0.0.jar:lib/jetty-security-9.3.24.v20180605.jar:lib/lucene-queryparser-6.2.0.jar:lib/jcl-over-slf4j-1.7.12.jar:lib/okhttp-1.0.2.jar:lib/avatica-server-1.12.0.jar:lib/commons-io-2.4.jar:lib/memory-0.12.0.jar:lib/aws-java-sdk-codedeploy-1.10.21.jar:lib/jackson-core-asl-1.9.13.jar:lib/aws-java-sdk-cognitoidentity-1.10.21.jar:lib/geoip2-0.4.0.jar:lib/spymemcached-2.11.7.jar:lib/netty-transport-4.0.52.Final.jar:lib/janino-2.7.6.jar:lib/google-http-client-jackson2-1.15.0-rc.jar:lib/xlsx-streamer-1.0.1.jar:lib/aether-api-0.9.0.M2.jar:lib/commons-math3-3.6.1.jar:lib/airline-0.7.jar:lib/jackson-dataformat-smile-2.4.6.jar:lib/netty-common-4.0.52.Final.jar:lib/calcite-server-1.17.0.jar:lib/commons-codec-1.7.jar:lib/netty-all-4.1.11.Final.jar:lib/aws-java-sdk-kinesis-1.10.21.jar:lib/avatica-metrics-1.12.0.jar:lib/druid-indexing-service-0.9.1-SNAPSHOT.jar:lib/joda-time-2.8.2.jar:lib/aws-java-sdk-cloudhsm-1.10.21.jar:lib/jetty-proxy-9.3.24.v20180605.jar:lib/log4j-api-2.5.jar:lib/jts-core-1.14.0.jar:lib/aws-java-sdk-logs-1.10.21.jar:lib/xml-apis-1.4.01.jar:lib/druid-common-0.9.1-SNAPSHOT.jar:lib/jetty-http-9.3.24.v20180605.jar:lib/netty-3.10.6.Final.jar:lib/jackson-jaxrs-smile-provider-2.4.6.jar:lib/netty-codec-http-4.0.52.Final.jar:lib/aws-java-sdk-cloudtrail-1.10.21.jar:lib/calcite-linq4j-1.17.0.jar:lib/aws-java-sdk-sts-1.10.21.jar:lib/jackson-jaxrs-base-2.4.6.jar:lib/curator-x-discovery-2.10.0.jar:lib/log4j-jul-2.5.jar:lib/netty-resolver-dns-2.0.37.jar:lib/aws-java-sdk-1.10.21.jar:lib/commons-collections-3.2.1.jar:lib/wagon-provider-api-2.4.jar:lib/poi-ooxml-3.13.jar:lib/jetty-client-9.3.24.v20180605.jar:lib/config-magic-0.9.jar:lib/aws-java-sdk-core-1.10.21.jar:lib/jersey-core-1.19.jar:lib/calcite-core-1.17.0.jar:lib/guice-multibindings-4.1.0.jar:lib/extendedset-1.3.10.jar:lib/jsr305-2.0.1.jar:lib/aws-java-sdk-swf-libraries-1.10.21.jar:lib/java-xmlbuilder-1.1.jar:lib/compress-lzf-1.0.3.jar:lib/stax-api-1.0.1.jar:lib/jersey-server-1.19.jar:lib/jackson-datatype-guava-2.4.6.jar:lib/maven-model-3.1.1.jar:lib/jackson-datatype-joda-2.4.6.jar:lib/maven-settings-3.1.1.jar:lib/plexus-utils-3.0.15.jar:lib/aws-java-sdk-devicefarm-1.10.21.jar:lib/commons-lang3-3.2.jar:lib/jboss-logging-3.1.3.GA.jar:lib/bytebuffer-collections-0.2.5.jar:lib/commons-lang-2.6.jar:lib/aws-java-sdk-simpledb-1.10.21.jar:lib/lz4-1.3.0.jar:lib/aws-java-sdk-rds-1.10.21.jar:lib/aws-java-sdk-codepipeline-1.10.21.jar:lib/aws-java-sdk-kms-1.10.21.jar:lib/lucene-analyzers-common-6.2.0.jar:lib/netty-resolver-2.0.37.jar:lib/aws-java-sdk-autoscaling-1.10.21.jar:lib/jline-3.2.0.jar:lib/druid-aws-common-0.9.1-SNAPSHOT.jar:lib/RoaringBitmap-0.5.18.jar:lib/maven-model-builder-3.1.1.jar:lib/hibernate-validator-5.1.3.Final.jar:lib/druid-services-0.9.1-SNAPSHOT.jar:lib/slf4j-api-1.7.12.jar:lib/jdbi-2.63.1.jar:lib/maxminddb-0.2.0.jar:lib/java-util-1.3.3.jar:lib/jetty-servlet-9.3.24.v20180605.jar:lib/httpcore-4.4.3.jar:lib/jackson-mapper-asl-1.9.13.jar:lib/async-http-client-2.0.37.jar:lib/aws-java-sdk-iam-1.10.21.jar:lib/jackson-annotations-2.4.6.jar:lib/jets3t-0.9.4.jar:lib/druid-sql-0.9.1-SNAPSHOT.jar:lib/commons-compiler-2.7.6.jar:lib/aws-java-sdk-redshift-1.10.21.jar:lib/disruptor-3.3.0.jar:lib/curator-recipes-2.10.0.jar:lib/javax.inject-1.jar:lib/irc-api-1.0-0014.jar:lib/aws-java-sdk-cloudformation-1.10.21.jar:lib/aws-java-sdk-datapipeline-1.10.21.jar:lib/lucene-queries-6.2.0.jar:lib/aws-java-sdk-efs-1.10.21.jar:lib/guava-16.0.1.jar:lib/netty-codec-4.0.52.Final.jar:lib/derby-10.11.1.1.jar:/usr/local/Cellar/hadoop/2.7.2/libexec/etc/hadoop
2020-03-31T23:42:21,575 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/tmp
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA>
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.name=Linux
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.arch=amd64
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.version=4.18.0-80.11.2.el8_0.x86_64
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.name=root
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.home=/root
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/usr/local/druid-0.9.1-SNAPSHOT.201910281504-hadoop-2.7.3
2020-03-31T23:42:21,576 INFO [main] org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost sessionTimeout=30000 watcher=org.apache.curator.ConnectionState@2589d787
2020-03-31T23:42:21,586 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.discovery.ServerDiscoverySelector.start() throws java.lang.Exception] on object[io.druid.curator.discovery.ServerDiscoverySelector@8641b7d].
2020-03-31T23:42:21,588 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
2020-03-31T23:42:21,593 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Socket connection established to localhost/127.0.0.1:2181, initiating session
2020-03-31T23:42:21,597 INFO [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x170ab8be1ef0038, negotiated timeout = 30000
2020-03-31T23:42:21,599 INFO [main-EventThread] org.apache.curator.framework.state.ConnectionStateManager - State change: CONNECTED
2020-03-31T23:42:21,670 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.announcement.Announcer.start()] on object[io.druid.curator.announcement.Announcer@224d86d2].
2020-03-31T23:42:21,670 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.curator.discovery.ServerDiscoverySelector.start() throws java.lang.Exception] on object[io.druid.curator.discovery.ServerDiscoverySelector@a3cba3a].
2020-03-31T23:42:21,673 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.indexing.worker.executor.ExecutorLifecycle.start() throws java.lang.InterruptedException] on object[io.druid.indexing.worker.executor.ExecutorLifecycle@10817f46].
2020-03-31T23:42:21,706 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Running with task: {
"type" : "index",
"id" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"resource" : {
"availabilityGroup" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"requiredCapacity" : 1
},
"spec" : {
"dataSchema" : {
"dataSource" : "a_vmipt",
"parser" : {
"type" : "csv.stream",
"timestampSpec" : {
"column" : "current_datetime",
"missingValue" : "2020-03-31T23:42:18.419Z",
"invalidValue" : "2020-03-31T23:42:18.419Z",
"replaceWrongColumn" : true
},
"dimensionsSpec" : {
"dimensions" : [ ],
"dimensionExclusions" : [ ],
"spatialDimensions" : [ ]
},
"columns" : [ "AsWKT(Posizione)" ]
},
"metricsSpec" : [ {
"type" : "relay",
"name" : "AsWKT(Posizione)",
"columnName" : "AsWKT(Posizione)",
"typeName" : "struct(lat:double,lon:double)"
} ],
"enforceType" : true,
"granularitySpec" : {
"type" : "uniform",
"segmentGranularity" : "MONTH",
"queryGranularity" : "MONTH",
"rollup" : false,
"append" : false,
"intervals" : [ "2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z" ]
},
"evaluations" : [ {
"outputName" : "AsWKT(Posizione)",
"expressions" : [ "shape_centroid_YX(shape_fromWKT( AsWKT(Posizione) ))", "struct(\"_\"[0],\"_\"[1])" ]
} ]
},
"ioConfig" : {
"type" : "index",
"firehose" : {
"type" : "local",
"baseDir" : "/tmp",
"filter" : "temp_ds__a_vmipt_1585698138416.csv",
"parser" : null
}
},
"tuningConfig" : {
"type" : "index",
"targetPartitionSize" : 5000000,
"indexSpec" : {
"bitmap" : {
"type" : "roaring"
},
"dimensionSketches" : {
"type" : "none"
},
"secondaryIndexing" : {
"AsWKT(Posizione)" : {
"type" : "lucene",
"textAnalyzer" : "standard",
"strategies" : [ {
"type" : "latlon",
"fieldName" : "coord",
"latitude" : "lat",
"longitude" : "lon",
"crs" : null
} ]
}
},
"allowNullForNumbers" : false
},
"buildV9Directly" : true,
"ignoreInvalidRows" : true,
"maxRowsInMemory" : 75000,
"maxOccupationInMemory" : -1
}
},
"context" : {
"druid.task.runner.dedicated.host" : "localhost:8091"
},
"groupId" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"dataSource" : "a_vmipt",
"interval" : "2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z"
}
2020-03-31T23:42:21,707 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Attempting to lock file[var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/lock].
2020-03-31T23:42:21,708 INFO [main] io.druid.indexing.worker.executor.ExecutorLifecycle - Acquired lock file[var/druid/task/index_a_vmipt_2020-03-31T23:42:18.421Z/lock] in 1ms.
2020-03-31T23:42:21,719 INFO [main] io.druid.indexing.common.actions.RemoteTaskActionClient - Submitting action for task[index_a_vmipt_2020-03-31T23:42:18.421Z] to overlord[http://localhost:8090/druid/indexer/v1/action]: LockTryAcquireAction{interval=2019-09-30T23:42:18.419Z/2020-09-30T23:42:18.419Z}
2020-03-31T23:42:21,727 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,750 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,751 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,752 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,753 INFO [main] com.metamx.http.client.pool.ChannelResourceFactory - Generating: http://localhost:8090
2020-03-31T23:42:21,787 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.ThreadPoolTaskRunner - Running task: index_a_vmipt_2020-03-31T23:42:18.421Z
2020-03-31T23:42:21,788 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] location changed to [TaskLocation{host='localhost', port=8100}].
2020-03-31T23:42:21,789 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] status changed to [RUNNING].
2020-03-31T23:42:21,790 INFO [task-runner-0-priority-0] io.druid.indexing.common.actions.RemoteTaskActionClient - Submitting action for task[index_a_vmipt_2020-03-31T23:42:18.421Z] to overlord[http://localhost:8090/druid/indexer/v1/action]: LockListAction{}
2020-03-31T23:42:21,793 INFO [main] org.eclipse.jetty.server.Server - jetty-9.3.24.v20180605, build timestamp: 2018-06-05T17:11:56Z, git hash: 84205aa28f11a4f31f2a3b86d1bba2cc8ab69827
2020-03-31T23:42:21,830 ERROR [task-runner-0-priority-0] io.druid.indexing.overlord.ThreadPoolTaskRunner - Exception while running task[IndexTask{id=index_a_vmipt_2020-03-31T23:42:18.421Z, type=index, dataSource=a_vmipt}]
com.metamx.common.IAE: function 'AsWKT' is not defined.
at io.druid.math.expr.ExprListenerImpl.exitFunctionExpr(ExprListenerImpl.java:318) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.math.expr.antlr.ExprParser$FunctionExprContext.exitRule(ExprParser.java:226) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at org.antlr.v4.runtime.tree.ParseTreeWalker.exitRule(ParseTreeWalker.java:71) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:54) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52) ~[antlr4-runtime-4.5.1.jar:4.5.1]
at io.druid.math.expr.Parser.parse(Parser.java:173) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.math.expr.Parser.parse(Parser.java:136) ~[druid-common-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.Evaluation$1.apply(Evaluation.java:96) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.Evaluation$1.apply(Evaluation.java:94) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at com.google.common.collect.Lists$TransformingRandomAccessList$1.transform(Lists.java:582) ~[guava-16.0.1.jar:?]
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) ~[guava-16.0.1.jar:?]
at java.util.AbstractCollection.toArray(AbstractCollection.java:141) ~[?:1.8.0_232]
at java.util.ArrayList.<init>(ArrayList.java:178) ~[?:1.8.0_232]
at com.google.common.collect.Lists.newArrayList(Lists.java:129) ~[guava-16.0.1.jar:?]
at io.druid.data.input.Evaluation.toEvaluator(Evaluation.java:92) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.data.input.InputRowParsers.wrap(InputRowParsers.java:90) ~[druid-processing-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.segment.indexing.DataSchema.getParser(DataSchema.java:127) ~[druid-server-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.segment.indexing.IngestionSpec.getParser(IngestionSpec.java:66) ~[druid-server-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.common.task.IndexTask.getDataIntervals(IndexTask.java:297) ~[druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.common.task.IndexTask.run(IndexTask.java:223) ~[druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.overlord.ThreadPoolTaskRunner$ThreadPoolTaskRunnerCallable.call(ThreadPoolTaskRunner.java:472) [druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at io.druid.indexing.overlord.ThreadPoolTaskRunner$ThreadPoolTaskRunnerCallable.call(ThreadPoolTaskRunner.java:444) [druid-indexing-service-0.9.1-SNAPSHOT.jar:0.9.1-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
2020-03-31T23:42:21,833 INFO [task-runner-0-priority-0] io.druid.indexing.overlord.TaskRunnerUtils - Task [index_a_vmipt_2020-03-31T23:42:18.421Z] status changed to [FAILED].
2020-03-31T23:42:21,836 INFO [task-runner-0-priority-0] io.druid.indexing.worker.executor.ExecutorLifecycle - Task completed with status: {
"id" : "index_a_vmipt_2020-03-31T23:42:18.421Z",
"status" : "FAILED",
"duration" : 46,
"reason" : "Exception: [io.druid.math.expr.ExprListenerImpl.exitFunctionExpr(ExprListenerImpl.java:318), io.druid.math.expr.antlr.ExprParser$FunctionExprContext.exitRule(ExprParser.java:226), org.antlr.v4.runtime.tree.ParseTreeWalker.exitRule(ParseTreeWalker.java:71), org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:54), org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52), ... more]"
}
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering com.fasterxml.jackson.jaxrs.json.JacksonJsonProvider as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering com.fasterxml.jackson.jaxrs.smile.JacksonSmileProvider as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering io.druid.server.initialization.jetty.CustomExceptionMapper as a provider class
2020-03-31T23:42:21,873 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Registering io.druid.server.StatusResource as a root resource class
2020-03-31T23:42:21,876 INFO [main] com.sun.jersey.server.impl.application.WebApplicationImpl - Initiating Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM'
2020-03-31T23:42:21,936 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.initialization.jetty.CustomExceptionMapper to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:21,938 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding com.fasterxml.jackson.jaxrs.json.JacksonJsonProvider to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:21,943 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding com.fasterxml.jackson.jaxrs.smile.JacksonSmileProvider to GuiceManagedComponentProvider with the scope "Singleton"
2020-03-31T23:42:22,151 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.PeonResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,161 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.security.StateResourceFilter to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,164 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.SegmentListerResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,165 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.segment.realtime.firehose.ChatHandlerResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,167 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.query.lookup.LookupListeningResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,168 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.query.lookup.LookupIntrospectionResource to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,170 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.http.security.ConfigResourceFilter to GuiceInstantiatedComponentProvider
2020-03-31T23:42:22,171 INFO [main] com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory - Binding io.druid.server.StatusResource to GuiceManagedComponentProvider with the scope "Undefined"
2020-03-31T23:42:22,183 WARN [main] com.sun.jersey.spi.inject.Errors - The following warnings have been detected with resource and/or provider classes:
WARNING: A HTTP GET method, public void io.druid.server.http.SegmentListerResource.getSegments(long,long,long,javax.servlet.http.HttpServletRequest) throws java.io.IOException, MUST return a non-void type.
2020-03-31T23:42:22,189 INFO [main] org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@5f935d49{/,null,AVAILABLE}
2020-03-31T23:42:22,195 INFO [main] org.eclipse.jetty.server.AbstractConnector - Started ServerConnector@7910f355{HTTP/1.1,[http/1.1]}{0.0.0.0:8100}
2020-03-31T23:42:22,195 INFO [main] org.eclipse.jetty.server.Server - Started @3761ms
2020-03-31T23:42:22,195 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.query.lookup.LookupReferencesManager.start()] on object[io.druid.query.lookup.LookupReferencesManager@34ab26a].
2020-03-31T23:42:22,195 INFO [main] io.druid.query.lookup.LookupReferencesManager - Started lookup factory references manager
2020-03-31T23:42:22,196 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.server.listener.announcer.ListenerResourceAnnouncer.start()] on object[io.druid.query.lookup.LookupResourceListenerAnnouncer@12209826].
2020-03-31T23:42:22,206 INFO [main] io.druid.server.listener.announcer.ListenerResourceAnnouncer - Announcing start time on [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,209 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.server.listener.announcer.ListenerResourceAnnouncer.stop()] on object[io.druid.query.lookup.LookupResourceListenerAnnouncer@12209826].
2020-03-31T23:42:22,209 INFO [main] io.druid.curator.announcement.Announcer - unannouncing [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,218 INFO [main] io.druid.server.listener.announcer.ListenerResourceAnnouncer - Unannouncing start time on [/druid/listeners/lookups/__default/localhost:8100]
2020-03-31T23:42:22,218 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.query.lookup.LookupReferencesManager.stop()] on object[io.druid.query.lookup.LookupReferencesManager@34ab26a].
2020-03-31T23:42:22,218 INFO [main] io.druid.query.lookup.LookupReferencesManager - Stopping lookup factory references manager
2020-03-31T23:42:22,220 INFO [main] org.eclipse.jetty.server.AbstractConnector - Stopped ServerConnector@7910f355{HTTP/1.1,[http/1.1]}{0.0.0.0:8100}
2020-03-31T23:42:22,221 INFO [main] org.eclipse.jetty.server.handler.ContextHandler - Stopped o.e.j.s.ServletContextHandler@5f935d49{/,null,UNAVAILABLE}
2020-03-31T23:42:22,223 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.indexing.worker.executor.ExecutorLifecycle.stop() throws java.lang.Exception] on object[io.druid.indexing.worker.executor.ExecutorLifecycle@10817f46].
2020-03-31T23:42:22,223 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.indexing.overlord.ThreadPoolTaskRunner.stop()] on object[io.druid.indexing.overlord.ThreadPoolTaskRunner@138a85d3].
2020-03-31T23:42:22,224 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.discovery.ServerDiscoverySelector.stop() throws java.io.IOException] on object[io.druid.curator.discovery.ServerDiscoverySelector@a3cba3a].
2020-03-31T23:42:22,227 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.announcement.Announcer.stop()] on object[io.druid.curator.announcement.Announcer@224d86d2].
2020-03-31T23:42:22,228 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void io.druid.curator.discovery.ServerDiscoverySelector.stop() throws java.io.IOException] on object[io.druid.curator.discovery.ServerDiscoverySelector@8641b7d].
2020-03-31T23:42:22,228 INFO [main] io.druid.curator.CuratorModule - Stopping Curator
2020-03-31T23:42:22,229 INFO [Curator-Framework-0] org.apache.curator.framework.imps.CuratorFrameworkImpl - backgroundOperationsLoop exiting
2020-03-31T23:42:22,231 INFO [main] org.apache.zookeeper.ZooKeeper - Session: 0x170ab8be1ef0038 closed
2020-03-31T23:42:22,231 INFO [main-EventThread] org.apache.zookeeper.ClientCnxn - EventThread shut down for session: 0x170ab8be1ef0038
2020-03-31T23:42:22,231 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.http.client.NettyHttpClient.stop()] on object[com.metamx.http.client.NettyHttpClient@256bb5be].
2020-03-31T23:42:22,241 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.metrics.MonitorScheduler.stop()] on object[com.metamx.metrics.MonitorScheduler@119290b9].
2020-03-31T23:42:22,241 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking stop method[public void com.metamx.emitter.service.ServiceEmitter.close() throws java.io.IOException] on object[ServiceEmitter{serviceDimensions={service=druid/middleManager, host=localhost:8100, version=0.9.1-SNAPSHOT}, emitter=com.metamx.emitter.core.NoopEmitter@5c3d4f05}].
2020-03-31T23:42:22,241 INFO [main] io.druid.cli.CliPeon - Finished peon task
Reply all
Reply to author
Forward
0 new messages