See <https://builds.apache.org/job/Phoenix-calcite/52/changes>
Changes: [maryannxue] PHOENIX-3355 Register Phoenix built-in functions as Calcite functions ------------------------------------------ [...truncated 20087 lines...] ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayFillFunctionIT.initTable:48 » SQL Error while executing SQL "CREATE TABLE... ArrayPrependFunctionIT.testArrayPrependFunctionBigIntDesc:657->initTablesDesc:75 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionBigint:216->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionBooleanDesc:674->initTablesDesc:75 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionChar:233->initTables:58 » SQL E... ArrayPrependFunctionIT.testArrayPrependFunctionDouble:180->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionDouble2:198->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere1:504->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere2:518->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere3:532->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere4:546->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere5:560->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere6:574->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionInWhere7:588->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionIntToCharArray » Unexpected ex... ArrayPrependFunctionIT.testArrayPrependFunctionInteger:84->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionIntegerDesc:620->initTablesDesc:75 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionIntegerToDoubleArray:282->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionNulls1:121->initTableWithVarArray:36 » SQLFeatureNotSupported ArrayPrependFunctionIT.testArrayPrependFunctionNulls2:136->initTableWithVarArray:36 » SQLFeatureNotSupported ArrayPrependFunctionIT.testArrayPrependFunctionNulls3:151->initTableWithVarArray:36 » SQLFeatureNotSupported ArrayPrependFunctionIT.testArrayPrependFunctionNulls4:166->initTableWithVarArray:36 » SQLFeatureNotSupported ArrayPrependFunctionIT.testArrayPrependFunctionVarchar:102->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionVarcharDesc:639->initTablesDesc:75 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionVarcharToIntegerArray » Unexpe... ArrayPrependFunctionIT.testArrayPrependFunctionWithNestedFunctions1:300->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionWithNestedFunctions2:318->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionWithNestedFunctions3:336->initTables:58 » SQL ArrayPrependFunctionIT.testArrayPrependFunctionWithUpsert1:358 » SQL ERROR 201... ArrayPrependFunctionIT.testArrayPrependFunctionWithUpsert2:382 » SQL ERROR 201... ArrayPrependFunctionIT.testArrayPrependFunctionWithUpsert3:405 » SQL ERROR 201... ArrayPrependFunctionIT.testArrayPrependFunctionWithUpsertSelect1:433 » SQL ERR... ArrayPrependFunctionIT.testArrayPrependFunctionWithUpsertSelect2:473 » SQL ERR... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArrayToStringFunctionIT.initTables:56 » SQL Error while preparing statement [U... ArraysWithNullsIT.testArrayUpsertBigIntWithNulls:82 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertBooleanWithNulls:166 » SQL Error while prepar... ArraysWithNullsIT.testArrayUpsertCharWithNulls1:323 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertCharWithNulls2:342 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertDateWithNulls1:206 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertDateWithNulls2:225 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertDoubleWithNulls:187 » SQL Error while prepari... ArraysWithNullsIT.testArrayUpsertFloatWithNulls:103 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertIntWithNulls:38 » SQL Error while preparing s... ArraysWithNullsIT.testArrayUpsertSmallIntWithNulls:124 » SQL Error while prepa... ArraysWithNullsIT.testArrayUpsertTimeStampWithNulls1:285 » SQL Error while pre... ArraysWithNullsIT.testArrayUpsertTimeStampWithNulls2:304 » SQL Error while pre... ArraysWithNullsIT.testArrayUpsertTimeWithNulls1:245 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertTimeWithNulls2:265 » SQL Error while preparin... ArraysWithNullsIT.testArrayUpsertTinyIntWithNulls:145 » SQL Error while prepar... ArraysWithNullsIT.testArrayUpsertVarcharWithNulls:61 » SQL Error while prepari... AutoPartitionViewsIT.testAddDropColumns:327 » SQL Error while executing SQL "C... AutoPartitionViewsIT.testAddDropColumns:327 » SQL Error while executing SQL "C... AutoPartitionViewsIT.testAddDropColumns:327 » SQL Error while executing SQL "C... AutoPartitionViewsIT.testAddDropColumns:327 » SQL Error while executing SQL "C... AutoPartitionViewsIT.testViewCreationFailure:246 » SQL Error while executing S... AutoPartitionViewsIT.testViewCreationFailure:246 » SQL Error while executing S... AutoPartitionViewsIT.testViewCreationFailure:246 » SQL Error while executing S... AutoPartitionViewsIT.testViewCreationFailure:246 » SQL Error while executing S... BinaryRowKeyIT.testInsertPaddedBinaryValue:91 » SQL java.sql.SQLException: ERR... CSVCommonsLoaderIT.testCSVCommonsUpsert_MultiTenant:162 NullPointer CoalesceFunctionIT.coalesceWithSecondParamAsExpression:122 » SQL Error while e... CoalesceFunctionIT.coalesceWithSumExplicitLong:74 » SQL Error while executing ... CoalesceFunctionIT.coalesceWithSumImplicitLong:98 » SQL Error while executing ... CoalesceFunctionIT.nonTypedSecondParameterLong:147 » SQL Error while executing... CoalesceFunctionIT.nonTypedSecondParameterUnsignedDataTypes:171 » SQL Error wh... CoalesceFunctionIT.testCoalesce:52 » SQL exception while executing query: java... CoalesceFunctionIT.testImplicitSecondArgCasting:285 » SQL Error while executin... CoalesceFunctionIT.testImplicitSecondArgCastingException:256 » SQL Error while... CoalesceFunctionIT.testWithNthValueAggregationFunction:198 » SQL Error while e... CoalesceFunctionIT.wrongDataTypeOfSecondParameter:229 » SQL Error while execut... DecodeFunctionIT.nullEncoding:131 » SQL Error while executing SQL "SELECT * FR... DefaultColumnValueIT.testDefaultAllDataTypesKeyValueCol:499->testDefaultAllDataTypes:542 » SQL DefaultColumnValueIT.testDefaultAllDataTypesPrimaryKey:537->testDefaultAllDataTypes:542 » SQL DefaultColumnValueIT.testDefaultArrayWithFixedWidthNull:886 » SQL Error while ... DefaultColumnValueIT.testDefaultArrayWithNull:860 » SQL Error while executing ... DefaultColumnValueIT.testDefaultArrays:724->verifyArrays:775 » SQL Error while... DefaultColumnValueIT.testDefaultArraysPrimaryKey:770->verifyArrays:775 » SQL E... DefaultColumnValueIT.testDefaultColumnValue:63 » SQL Error while executing SQL... DefaultColumnValueIT.testDefaultColumnValueOnView:114 » SQL Error while execut... DefaultColumnValueIT.testDefaultColumnValueProjected:147 » SQL Error while exe... DefaultColumnValueIT.testDefaultCoveredColumn:933 » SQL Error while executing ... DefaultColumnValueIT.testDefaultExpression:592->verifyDefaultExpression:614 » SQL DefaultColumnValueIT.testDefaultExpressionPrimaryKey:609->verifyDefaultExpression:614 » SQL DefaultColumnValueIT.testDefaultFunctionalIndexed:1023 » SQL Error while execu... DefaultColumnValueIT.testDefaultImmutableRows:275 » SQL Error while executing ... DefaultColumnValueIT.testDefaultIndexed:961 » SQL Error while executing SQL "C... DefaultColumnValueIT.testDefaultLocalIndexed:992 » SQL Error while executing S... DefaultColumnValueIT.testDefaultMiddleKeyValueCol:441 » SQL Error while execut... DefaultColumnValueIT.testDefaultMiddlePrimaryKey:385 » SQL Error while executi... DefaultColumnValueIT.testDefaultNull:909 » SQL Error while executing SQL "CREA... DefaultColumnValueIT.testDefaultReinit:348 » SQL Error while executing SQL "CR... DefaultColumnValueIT.testDefaultSelectWhere:1055 » SQL Error while executing S... DefaultColumnValueIT.testDefaultUpsertSelectPrimaryKey:646 » SQL Error while e... DefaultColumnValueIT.testMultipleDefaults:224 » SQL Error while executing SQL ... DefaultColumnValueIT.testTrailingNullOverwritingDefault:320 » SQL Error while ... DistinctPrefixFilterIT.initTables:57->BaseTest.createTestTable:765->BaseTest.createTestTable:769->BaseTest.createTestTable:811 » SQL DistinctPrefixFilterIT.initTables:57->BaseTest.createTestTable:765->BaseTest.createTestTable:769->BaseTest.createTestTable:811 » SQL DistinctPrefixFilterIT.initTables:57->BaseTest.createTestTable:765->BaseTest.createTestTable:769->BaseTest.createTestTable:811 » SQL DistinctPrefixFilterIT.initTables:57->BaseTest.createTestTable:765->BaseTest.createTestTable:769->BaseTest.createTestTable:811 » SQL DistinctPrefixFilterIT.initTables:57->BaseTest.createTestTable:765->BaseTest.createTestTable:769->BaseTest.createTestTable:811 » SQL DynamicColumnIT.testAmbiguousStaticSelect » Unexpected exception, expected<or... DynamicColumnIT.testDynamicColums:124 » SQL Error while preparing statement [S... DynamicColumnIT.testDynamicColumsFamily:148 » SQL Error while preparing statem... DynamicColumnIT.testDynamicColumsSpecificQuery:174 » SQL Error while preparing... DynamicColumnIT.testFakeCFDynamicUpsert » Unexpected exception, expected<org.... DynamicFamilyIT.testDynamicFamilyException » Unexpected exception, expected<o... DynamicFamilyIT.testDynamicFamilyFunctionException » Unexpected exception, ex... DynamicFamilyIT.testGetCaseInsensitiveDynCol:239 » SQL Error while preparing s... DynamicUpsertIT.testAmbiguousDynamicUpsert » Unexpected exception, expected<o... DynamicUpsertIT.testAmbiguousStaticUpsert » Unexpected exception, expected<or... DynamicUpsertIT.testFakeCFDynamicUpsert » Unexpected exception, expected<org.... DynamicUpsertIT.testFullUpsert:141 » SQL Error while preparing statement [UPSE... DynamicUpsertIT.testMultiUpsert:108 » SQL Error while preparing statement [UPS... DynamicUpsertIT.testUpsert:78 » SQL Error while preparing statement [UPSERT IN... EncodeFunctionIT.testEncode:85->testEncode:77 » SQL Error while preparing stat... EncodeFunctionIT.testEncodeNullInput:92 » SQL Error while preparing statement ... EncodeFunctionIT.testNullEncodingType:121 » SQL Error while executing SQL "SEL... EvaluationOfORIT.testFalseOrFalse:42 » SQL Error while executing SQL "SELECT (... EvaluationOfORIT.testPKOrNotPKInOREvaluation:57 » SQL ExecuteStatementsIT.testCharPadding:134 » SQL ExpFunctionEnd2EndIT.testUnsignedNumber:133->testUnsignedNumberSpec:109 » SQL ... FirstValueFunctionIT.allColumnsNull:236 » SQL Error while executing SQL "SELEC... FirstValueFunctionIT.doubleDataType:147 » SQL Error while executing SQL "SELEC... FirstValueFunctionIT.floatDataType:209 » SQL Error while executing SQL "SELECT... FirstValueFunctionIT.signedLongAsBigInt:54 » SQL Error while executing SQL "SE... FirstValueFunctionIT.testSortOrderInDataCol:104 » SQL Error while executing SQ... FirstValueFunctionIT.testSortOrderInSortCol:73 » SQL Error while executing SQL... FirstValueFunctionIT.varcharFixedLenghtDatatype:178 » SQL Error while executin... GroupByCaseIT.testAvgGroupByOrderPreservingWithNoStats:444->initAvgGroupTable:449 » SQL GroupByCaseIT.testAvgGroupByOrderPreservingWithStats:415 » SQL Error while exe... GroupByCaseIT.testDistinctGroupByBug3452WithMultiTenant:541->doTestDistinctGroupByBug3452:574 » Commit GroupByCaseIT.testDistinctGroupByBug3452WithoutMultiTenant:536->doTestDistinctGroupByBug3452:574 » Commit GroupByCaseIT.testExpressionInGroupBy:102 » SQL Error while executing SQL "SEL... GroupByCaseIT.testGroupByArray:259 » SQL Error while executing SQL "UPSERT INT... GroupByCaseIT.testGroupByCase:230 » SQL Error while executing SQL "select case... GroupByCaseIT.testGroupByOrderByDescBug3451:635 » Commit java.sql.SQLException... GroupByCaseIT.testGroupByWithAliasWithSameColumnName:514 » SQL Error while exe... GroupByCaseIT.testSumGroupByOrderPreservingDesc:369 » SQL Error while preparin... HashJoinMoreIT.testBug2480:605 » SQL Error while executing SQL "upsert into ma... HashJoinMoreIT.testBug2894:671 » SQL Error while executing SQL "CREATE TABLE I... HashJoinMoreIT.testJoinOnDynamicColumns:240 » SQL HashJoinMoreIT.testJoinWithKeyRangeOptimization:325 » ColumnAlreadyExists ERRO... HashJoinMoreIT.testJoinWithMultiTenancy:497 » SQL Error while executing SQL "C... HashJoinMoreIT.testSubqueryWithoutData:477 » ClassCast org.apache.phoenix.calc... ImmutableTablePropIT.testImmutableProperty:80 » SQL ERROR 1135 (XCL35): IMMUTA... IsNullIT.testIsNullInPk:44 » SQL Error while preparing statement [UPSERT INTO ... IsNullIT.testIsNullWithLastPKColDesc:68 » SQL Error while executing SQL "UPSER... LastValueFunctionIT.charDatatype:184 » SQL Error while executing SQL "SELECT L... LastValueFunctionIT.groupMultipleValues:243 » SQL Error while executing SQL "S... LastValueFunctionIT.inOrderByClausule:331 » SQL Error while executing SQL "SEL... LastValueFunctionIT.nullValuesInAggregatingColumns:271 » SQL Error while execu... LastValueFunctionIT.nullValuesInAggregatingColumnsSecond:297 » SQL Error while... LastValueFunctionIT.signedInteger:81 » SQL Error while executing SQL "SELECT L... LastValueFunctionIT.simpleTestAscOrder:159 » SQL Error while executing SQL "SE... LastValueFunctionIT.simpleTestDescOrder:133 » SQL Error while executing SQL "S... LastValueFunctionIT.unsignedInteger:107 » SQL Error while executing SQL "SELEC... LastValueFunctionIT.unsignedLong:56 » SQL Error while executing SQL "SELECT LA... LastValueFunctionIT.varcharVariableLenghtDatatype:209 » SQL Error while execut... MD5FunctionIT.testRetrieve:48 » SQL Error while executing SQL "SELECT MD5(pk) ... MD5FunctionIT.testRetrieveCompositeKey:69 » SQL Error while executing SQL "SEL... MD5FunctionIT.testUpsert:89 » SQL Error while executing SQL "UPSERT INTO T0000... MapReduceIT.testConditionsOnSelect:91->testJob:96->upsertData:141->upsertData:152 » SQL MapReduceIT.testNoConditionsOnSelect:76->testJob:96->upsertData:141->upsertData:152 » SQL ModulusExpressionIT.testLargeNegativeDividend:92->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testLargePositiveDividend:77->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testLongMaxDividend:82->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testLongMinDividend:97->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testNullDividend:136->initTable:48 » SQL Error while prepa... ModulusExpressionIT.testNullDivisor:152->initTable:48 » SQL Error while prepar... ModulusExpressionIT.testNullEverything:174->initTable:48 » SQL Error while pre... ModulusExpressionIT.testSmallNegativeDividend:87->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testSmallPositiveDividend:72->testDividend:57->initTable:48 » SQL ModulusExpressionIT.testZeroDividend:102->testDividend:57->initTable:48 » SQL ... ModulusExpressionIT.testZeroDivisor:109->initTable:48 » SQL Error while prepar... Tests run: 447, Failures: 32, Errors: 331, Skipped: 0 [INFO] [INFO] --- maven-failsafe-plugin:2.19.1:integration-test (ClientManagedTimeTests) @ phoenix-core --- ------------------------------------------------------- T E S T S ------------------------------------------------------- Running org.apache.phoenix.end2end.ColumnProjectionOptimizationIT Running org.apache.phoenix.end2end.AggregateQueryIT Build step 'Invoke top-level Maven targets' marked build as failure Archiving artifacts No prior successful build to compare, so performing full copy of artifacts Recording test results
