Major Description
This query:
SELECT * FROM splunk.data LIMIT 1000
fails sometimes with the following error:
VALIDATION ERROR: HTTP 401 -- call not properly authenticated (com.splunk.HttpException) HTTP 401 -- call not properly authenticated com.splunk.HttpException.create():8
{
"id": {
"part1": 2268975635403754500,
"part2": -3379215825344213000
},
"type": 1,
"start": 1619196589746,
"end": 1619196589763,
"query": "SELECT * FROM splunk.ddr LIMIT 1000",
"foreman": {
"address": "eadd7105aa7a",
"userPort": 31010,
"controlPort": 31011,
"dataPort": 31012,
"version": "1.19.0-SNAPSHOT",
"state": 0
},
"state": 4,
"totalFragments": 0,
"finishedFragments": 0,
"user": "anonymous",
"error": "VALIDATION ERROR: HTTP 401 -- call not properly authenticated\n\n",
"verboseError": "VALIDATION ERROR: HTTP 401 -- call not properly authenticated\n\n\n\n (com.splunk.HttpException) HTTP 401 -- call not properly authenticated\n com.splunk.HttpException.create():84\n com.splunk.HttpService.send():500\n com.splunk.Service.send():1295\n com.splunk.HttpService.get():169\n com.splunk.ResourceCollection.list():288\n com.splunk.ResourceCollection.refresh():331\n com.splunk.ResourceCollection.refresh():29\n com.splunk.Resource.validate():186\n com.splunk.ResourceCollection.validate():356\n com.splunk.ResourceCollection.keySet():279\n org.apache.drill.exec.store.splunk.SplunkSchemaFactory$SplunkSchema.registerIndexes():114\n org.apache.drill.exec.store.splunk.SplunkSchemaFactory$SplunkSchema.<init>():72\n org.apache.drill.exec.store.splunk.SplunkSchemaFactory.registerSchemas():60\n org.apache.drill.exec.store.splunk.SplunkStoragePlugin.registerSchemas():60\n org.apache.calcite.jdbc.DynamicRootSchema.loadSchemaFactory():87\n org.apache.calcite.jdbc.DynamicRootSchema.getImplicitSubSchema():72\n org.apache.calcite.jdbc.CalciteSchema.getSubSchema():265\n org.apache.calcite.sql.validate.SqlValidatorUtil.getSchema():1050\n org.apache.drill.exec.planner.sql.conversion.DrillCalciteCatalogReader.isValidSchema():171\n org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom():55\n org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3383\n org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60\n org.apache.calcite.sql.validate.AbstractNamespace.validate():84\n org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():1009\n org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():969\n org.apache.calcite.sql.SqlSelect.validate():216\n org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():944\n org.apache.calcite.sql.validate.SqlValidatorImpl.validate():651\n org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate():189\n org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():641\n org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():195\n org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():169\n org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():283\n org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():163\n org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan():128\n org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():93\n org.apache.drill.exec.work.foreman.Foreman.runSQL():592\n org.apache.drill.exec.work.foreman.Foreman.run():273\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():748\n",
"errorId": "ff2561d4-b71f-445d-98ea-ccc93b8ede8e",
"optionsJson": "[ {\n \"kind\" : \"LONG\",\n \"accessibleScopes\" : \"ALL\",\n \"name\" : \"exec.query.max_rows\",\n \"num_val\" : 0,\n \"scope\" : \"QUERY\"\n} ]",
"planEnd": 1619196589760,
"queueWaitEnd": 0,
"totalCost": 0,
"queueName": "-",
"queryId": "1f7d0551-a041-cbe0-d11a-9d1c56facfcf"
}