{ "queryId" : "20230315_194318_00011_6fa45", "session" : { "queryId" : "20230315_194318_00011_6fa45", "transactionId" : "7cfaaf55-f6ad-44e2-bf33-3b0a2d5f6363", "clientTransactionSupport" : true, "user" : "admin", "groups" : [ ], "principal" : "admin", "enabledRoles" : [ ], "source" : "trino-python-client", "catalog" : "hive", "schema" : "org1234567", "path" : { }, "timeZoneKey" : 0, "locale" : "en_US", "remoteUserAddress" : "172.19.0.9", "userAgent" : "python-requests/2.28.2", "clientTags" : [ ], "clientCapabilities" : [ "PARAMETRIC_DATETIME" ], "resourceEstimates" : { }, "start" : "2023-03-15T19:43:18.060776168Z", "systemProperties" : { }, "catalogProperties" : { }, "catalogRoles" : { }, "preparedStatements" : { "st_24b0c92d9feb474cbcbac06e30057885" : "SELECT ?\n\n" }, "protocolName" : "Trino", "timeZone" : "UTC" }, "state" : "FAILED", "self" : "http://172.19.0.11:8080/v1/query/20230315_194318_00011_6fa45", "fieldNames" : [ ], "query" : "EXECUTE st_24b0c92d9feb474cbcbac06e30057885 USING DECIMAL \u00270E-10\u0027", "preparedQuery" : "SELECT ?\n\n", "queryStats" : { "createTime" : "2023-03-15T19:43:18.061Z", "executionStartTime" : "2023-03-15T19:43:18.062Z", "lastHeartbeat" : "2023-03-15T19:43:18.063Z", "endTime" : "2023-03-15T19:43:18.062Z", "elapsedTime" : "1.44ms", "queuedTime" : "194.92us", "resourceWaitingTime" : "1.24ms", "dispatchingTime" : "0.00ns", "executionTime" : "0.00ns", "analysisTime" : "1.14ms", "planningTime" : "0.00ns", "finishingTime" : "0.00ns", "totalTasks" : 0, "runningTasks" : 0, "completedTasks" : 0, "failedTasks" : 0, "totalDrivers" : 0, "queuedDrivers" : 0, "runningDrivers" : 0, "blockedDrivers" : 0, "completedDrivers" : 0, "cumulativeUserMemory" : 0.0, "failedCumulativeUserMemory" : 0.0, "userMemoryReservation" : "0B", "revocableMemoryReservation" : "0B", "totalMemoryReservation" : "0B", "peakUserMemoryReservation" : "0B", "peakRevocableMemoryReservation" : "0B", "peakTotalMemoryReservation" : "0B", "peakTaskUserMemory" : "0B", "peakTaskRevocableMemory" : "0B", "peakTaskTotalMemory" : "0B", "scheduled" : false, "totalScheduledTime" : "0.00ns", "failedScheduledTime" : "0.00ns", "totalCpuTime" : "0.00ns", "failedCpuTime" : "0.00ns", "totalBlockedTime" : "0.00ns", "fullyBlocked" : false, "blockedReasons" : [ ], "physicalInputDataSize" : "0B", "failedPhysicalInputDataSize" : "0B", "physicalInputPositions" : 0, "failedPhysicalInputPositions" : 0, "physicalInputReadTime" : "0.00ns", "failedPhysicalInputReadTime" : "0.00ns", "internalNetworkInputDataSize" : "0B", "failedInternalNetworkInputDataSize" : "0B", "internalNetworkInputPositions" : 0, "failedInternalNetworkInputPositions" : 0, "rawInputDataSize" : "0B", "failedRawInputDataSize" : "0B", "rawInputPositions" : 0, "failedRawInputPositions" : 0, "processedInputDataSize" : "0B", "failedProcessedInputDataSize" : "0B", "processedInputPositions" : 0, "failedProcessedInputPositions" : 0, "inputBlockedTime" : "0.00ns", "failedInputBlockedTime" : "0.00ns", "outputDataSize" : "0B", "failedOutputDataSize" : "0B", "outputPositions" : 0, "failedOutputPositions" : 0, "outputBlockedTime" : "0.00ns", "failedOutputBlockedTime" : "0.00ns", "physicalWrittenDataSize" : "0B", "failedPhysicalWrittenDataSize" : "0B", "stageGcStatistics" : [ ], "dynamicFiltersStats" : { "dynamicFilterDomainStats" : [ ], "lazyDynamicFilters" : 0, "replicatedDynamicFilters" : 0, "totalDynamicFilters" : 0, "dynamicFiltersCompleted" : 0 }, "operatorSummaries" : [ ], "logicalWrittenDataSize" : "0B", "writtenPositions" : 0, "spilledDataSize" : "0B" }, "setSessionProperties" : { }, "resetSessionProperties" : [ ], "setRoles" : { }, "addedPreparedStatements" : { }, "deallocatedPreparedStatements" : [ ], "clearTransactionId" : false, "failureInfo" : { "type" : "io.trino.spi.TrinoException", "message" : "line 1:51: \u00270E-10\u0027 is not a valid decimal literal", "cause" : { "type" : "java.lang.IllegalArgumentException", "message" : "Invalid decimal value \u00270E-10\u0027", "suppressed" : [ ], "stack" : [ "io.trino.spi.type.Decimals.parse(Decimals.java:80)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitDecimalLiteral(ExpressionAnalyzer.java:1064)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitDecimalLiteral(ExpressionAnalyzer.java:581)", "io.trino.sql.tree.DecimalLiteral.accept(DecimalLiteral.java:50)", "io.trino.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:27)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:604)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitParameter(ExpressionAnalyzer.java:2081)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitParameter(ExpressionAnalyzer.java:581)", "io.trino.sql.tree.Parameter.accept(Parameter.java:51)", "io.trino.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:27)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:604)", "io.trino.sql.analyzer.ExpressionAnalyzer.analyze(ExpressionAnalyzer.java:485)", "io.trino.sql.analyzer.ExpressionAnalyzer.analyzeExpression(ExpressionAnalyzer.java:3441)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeExpression(StatementAnalyzer.java:4566)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeSelectSingleColumn(StatementAnalyzer.java:4372)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeSelect(StatementAnalyzer.java:4158)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:2886)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:475)", "io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155)", "io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:492)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:500)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1437)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:475)", "io.trino.sql.tree.Query.accept(Query.java:107)", "io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:492)", "io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:454)", "io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:79)", "io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:71)", "io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:267)", "io.trino.execution.SqlQueryExecution.\u003Cinit\u003E(SqlQueryExecution.java:204)", "io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:856)", "io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:143)", "io.trino.$gen.Trino_405____20230315_190430_2.call(Unknown Source)", "com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)", "com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)", "com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)", "java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)", "java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)", "java.base/java.lang.Thread.run(Thread.java:833)" ], "errorCode" : { "code" : 65536, "name" : "GENERIC_INTERNAL_ERROR", "type" : "INTERNAL_ERROR" } }, "suppressed" : [ ], "stack" : [ "io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:48)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitDecimalLiteral(ExpressionAnalyzer.java:1067)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitDecimalLiteral(ExpressionAnalyzer.java:581)", "io.trino.sql.tree.DecimalLiteral.accept(DecimalLiteral.java:50)", "io.trino.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:27)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:604)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitParameter(ExpressionAnalyzer.java:2081)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.visitParameter(ExpressionAnalyzer.java:581)", "io.trino.sql.tree.Parameter.accept(Parameter.java:51)", "io.trino.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:27)", "io.trino.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:604)", "io.trino.sql.analyzer.ExpressionAnalyzer.analyze(ExpressionAnalyzer.java:485)", "io.trino.sql.analyzer.ExpressionAnalyzer.analyzeExpression(ExpressionAnalyzer.java:3441)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeExpression(StatementAnalyzer.java:4566)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeSelectSingleColumn(StatementAnalyzer.java:4372)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeSelect(StatementAnalyzer.java:4158)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:2886)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:475)", "io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155)", "io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:492)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:500)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1437)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:475)", "io.trino.sql.tree.Query.accept(Query.java:107)", "io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)", "io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:492)", "io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:454)", "io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:79)", "io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:71)", "io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:267)", "io.trino.execution.SqlQueryExecution.\u003Cinit\u003E(SqlQueryExecution.java:204)", "io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:856)", "io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:143)", "io.trino.$gen.Trino_405____20230315_190430_2.call(Unknown Source)", "com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)", "com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)", "com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)", "java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)", "java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)", "java.base/java.lang.Thread.run(Thread.java:833)" ], "errorLocation" : { "lineNumber" : 1, "columnNumber" : 51 }, "errorCode" : { "code" : 59, "name" : "INVALID_LITERAL", "type" : "USER_ERROR" } }, "errorCode" : { "code" : 59, "name" : "INVALID_LITERAL", "type" : "USER_ERROR" }, "warnings" : [ ], "inputs" : [ ], "referencedTables" : [ ], "routines" : [ ], "finalQueryInfo" : true, "resourceGroupId" : [ "global" ], "queryType" : "SELECT", "retryPolicy" : "NONE", "pruned" : false, "version" : { "version" : "405" }, "errorType" : "USER_ERROR", "scheduled" : false }