See <https://builds.apache.org/job/Phoenix-encode-columns/52/changes>
Changes:
[samarth] PHOENIX-3589 Aggregate query is not blocked when projected columns are
------------------------------------------
[...truncated 761 lines...]
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 81.842 sec - in
org.apache.phoenix.trace.PhoenixTracingEndToEndIT
Tests run: 102, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 732.741 sec -
in org.apache.phoenix.end2end.SortMergeJoinIT
Tests run: 67, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 319.393 sec
<<< FAILURE! - in org.apache.phoenix.end2end.index.IndexExpressionIT
testGroupByCountImmutableLocalIndex(org.apache.phoenix.end2end.index.IndexExpressionIT)
Time elapsed: 6.401 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. (A.INT_COL1 + B.INT_COL2)
at
org.apache.phoenix.end2end.index.IndexExpressionIT.helpTestGroupByCount(IndexExpressionIT.java:497)
at
org.apache.phoenix.end2end.index.IndexExpressionIT.testGroupByCountImmutableLocalIndex(IndexExpressionIT.java:467)
testGroupByCountImmutableIndex(org.apache.phoenix.end2end.index.IndexExpressionIT)
Time elapsed: 2.602 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. (A.INT_COL1 + B.INT_COL2)
at
org.apache.phoenix.end2end.index.IndexExpressionIT.helpTestGroupByCount(IndexExpressionIT.java:497)
at
org.apache.phoenix.end2end.index.IndexExpressionIT.testGroupByCountImmutableIndex(IndexExpressionIT.java:462)
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 101.088 sec -
in org.apache.phoenix.tx.TxCheckpointIT
Tests run: 152, Failures: 0, Errors: 4, Skipped: 0, Time elapsed: 706.946 sec
<<< FAILURE! - in org.apache.phoenix.end2end.index.IndexIT
testGroupByCount[IndexIT_localIndex=false,mutable=false,transactional=false](org.apache.phoenix.end2end.index.IndexIT)
Time elapsed: 2.596 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. B.INT_COL2
at
org.apache.phoenix.end2end.index.IndexIT.testGroupByCount(IndexIT.java:403)
testGroupByCount[IndexIT_localIndex=false,mutable=false,transactional=true](org.apache.phoenix.end2end.index.IndexIT)
Time elapsed: 2.601 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. B.INT_COL2
at
org.apache.phoenix.end2end.index.IndexIT.testGroupByCount(IndexIT.java:403)
testGroupByCount[IndexIT_localIndex=true,mutable=false,transactional=false](org.apache.phoenix.end2end.index.IndexIT)
Time elapsed: 6.773 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. B.INT_COL2
at
org.apache.phoenix.end2end.index.IndexIT.testGroupByCount(IndexIT.java:403)
testGroupByCount[IndexIT_localIndex=true,mutable=false,transactional=true](org.apache.phoenix.end2end.index.IndexIT)
Time elapsed: 7.152 sec <<< ERROR!
java.sql.SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns
not in GROUP BY. B.INT_COL2
at
org.apache.phoenix.end2end.index.IndexIT.testGroupByCount(IndexIT.java:403)
Results :
Tests in error:
IndexExpressionIT.testGroupByCountImmutableIndex:462->helpTestGroupByCount:497
» SQL
IndexExpressionIT.testGroupByCountImmutableLocalIndex:467->helpTestGroupByCount:497
» SQL
IndexIT.testGroupByCount:403 » SQL ERROR 1018 (42Y27): Aggregate may not
conta...
IndexIT.testGroupByCount:403 » SQL ERROR 1018 (42Y27): Aggregate may not
conta...
IndexIT.testGroupByCount:403 » SQL ERROR 1018 (42Y27): Aggregate may not
conta...
IndexIT.testGroupByCount:403 » SQL ERROR 1018 (42Y27): Aggregate may not
conta...
Tests run: 1768, Failures: 0, Errors: 6, Skipped: 13
[INFO]
[INFO] --- maven-failsafe-plugin:2.19.1:integration-test
(ClientManagedTimeTests) @ phoenix-core ---
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.phoenix.end2end.ArrayIT
Running org.apache.phoenix.end2end.ClientTimeArithmeticQueryIT
Running org.apache.phoenix.end2end.AggregateQueryIT
Running org.apache.phoenix.end2end.CastAndCoerceIT
Running org.apache.phoenix.end2end.CaseStatementIT
Tests run: 49, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 36.027 sec -
in org.apache.phoenix.end2end.CastAndCoerceIT
Running org.apache.phoenix.end2end.ColumnProjectionOptimizationIT
Tests run: 63, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 43.479 sec -
in org.apache.phoenix.end2end.CaseStatementIT
Running org.apache.phoenix.end2end.CreateSchemaIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.279 sec - in
org.apache.phoenix.end2end.CreateSchemaIT
Running org.apache.phoenix.end2end.CreateTableIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.784 sec - in
org.apache.phoenix.end2end.ColumnProjectionOptimizationIT
Tests run: 49, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 54.863 sec -
in org.apache.phoenix.end2end.AggregateQueryIT
Running org.apache.phoenix.end2end.CustomEntityDataIT
Running org.apache.phoenix.end2end.DerivedTableIT
Tests run: 79, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 57.927 sec -
in org.apache.phoenix.end2end.ArrayIT
Running org.apache.phoenix.end2end.DistinctCountIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.154 sec - in
org.apache.phoenix.end2end.CustomEntityDataIT
Running org.apache.phoenix.end2end.DropSchemaIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.655 sec - in
org.apache.phoenix.end2end.DropSchemaIT
Running org.apache.phoenix.end2end.ExtendedQueryExecIT
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.243 sec -
in org.apache.phoenix.end2end.DerivedTableIT
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.083 sec - in
org.apache.phoenix.end2end.ExtendedQueryExecIT
Running org.apache.phoenix.end2end.FunkyNamesIT
Running org.apache.phoenix.end2end.GroupByIT
Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.181 sec -
in org.apache.phoenix.end2end.DistinctCountIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.551 sec - in
org.apache.phoenix.end2end.FunkyNamesIT
Running org.apache.phoenix.end2end.NotQueryIT
Running org.apache.phoenix.end2end.NativeHBaseTypesIT
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.764 sec - in
org.apache.phoenix.end2end.NativeHBaseTypesIT
Running org.apache.phoenix.end2end.PointInTimeQueryIT
Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 48.099 sec -
in org.apache.phoenix.end2end.CreateTableIT
Running org.apache.phoenix.end2end.ProductMetricsIT
Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.353 sec -
in org.apache.phoenix.end2end.PointInTimeQueryIT
Running org.apache.phoenix.end2end.QueryDatabaseMetaDataIT
Tests run: 77, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 43.287 sec -
in org.apache.phoenix.end2end.NotQueryIT
Running org.apache.phoenix.end2end.QueryIT
Tests run: 61, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 27.516 sec -
in org.apache.phoenix.end2end.ProductMetricsIT
Running org.apache.phoenix.end2end.ReadIsolationLevelIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.416 sec - in
org.apache.phoenix.end2end.ReadIsolationLevelIT
Running org.apache.phoenix.end2end.RowValueConstructorIT
Tests run: 105, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 61.791 sec -
in org.apache.phoenix.end2end.GroupByIT
Tests run: 245, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 135.308 sec -
in org.apache.phoenix.end2end.ClientTimeArithmeticQueryIT
Running org.apache.phoenix.end2end.ScanQueryIT
Running org.apache.phoenix.end2end.SequenceBulkAllocationIT
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 81.529 sec -
in org.apache.phoenix.end2end.QueryDatabaseMetaDataIT
Running org.apache.phoenix.end2end.SequenceIT
Tests run: 56, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.49 sec - in
org.apache.phoenix.end2end.SequenceBulkAllocationIT
Running org.apache.phoenix.end2end.ToNumberFunctionIT
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 6.732 sec - in
org.apache.phoenix.end2end.ToNumberFunctionIT
Tests run: 46, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 64.125 sec -
in org.apache.phoenix.end2end.RowValueConstructorIT
Running org.apache.phoenix.end2end.TopNIT
Tests run: 126, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 75.13 sec -
in org.apache.phoenix.end2end.QueryIT
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.274 sec - in
org.apache.phoenix.end2end.TopNIT
Running org.apache.phoenix.end2end.TruncateFunctionIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.514 sec - in
org.apache.phoenix.end2end.TruncateFunctionIT
Running org.apache.phoenix.end2end.VariableLengthPKIT
Tests run: 119, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 51.972 sec -
in org.apache.phoenix.end2end.ScanQueryIT
Running org.apache.phoenix.end2end.salted.SaltedTableIT
Tests run: 54, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 31.281 sec -
in org.apache.phoenix.end2end.SequenceIT
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.845 sec - in
org.apache.phoenix.end2end.salted.SaltedTableIT
Running org.apache.phoenix.rpc.UpdateCacheWithScnIT
Running org.apache.phoenix.end2end.UpsertValuesIT
Running org.apache.phoenix.end2end.UpsertSelectIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.366 sec - in
org.apache.phoenix.rpc.UpdateCacheWithScnIT
Tests run: 50, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 36.874 sec -
in org.apache.phoenix.end2end.VariableLengthPKIT
Tests run: 25, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 51.714 sec -
in org.apache.phoenix.end2end.UpsertValuesIT
Tests run: 22, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 68.077 sec -
in org.apache.phoenix.end2end.UpsertSelectIT
Results :
Tests run: 1360, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] --- maven-failsafe-plugin:2.19.1:integration-test
(HBaseManagedTimeTests) @ phoenix-core ---
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Results :
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] --- maven-failsafe-plugin:2.19.1:integration-test
(NeedTheirOwnClusterTests) @ phoenix-core ---
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
Running org.apache.phoenix.end2end.ConnectionUtilIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.081 sec - in
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
Running org.apache.phoenix.end2end.ContextClassloaderIT
Running org.apache.phoenix.end2end.CountDistinctCompressionIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.932 sec - in
org.apache.phoenix.end2end.ConnectionUtilIT
Running org.apache.phoenix.end2end.CsvBulkLoadToolIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.116 sec - in
org.apache.phoenix.end2end.ContextClassloaderIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.976 sec - in
org.apache.phoenix.end2end.CountDistinctCompressionIT
Running org.apache.phoenix.end2end.FlappingLocalIndexIT
Running org.apache.phoenix.end2end.IndexExtendedIT
Running org.apache.phoenix.end2end.QueryWithLimitIT
Running org.apache.phoenix.end2end.QueryTimeoutIT
Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.573 sec -
in org.apache.phoenix.end2end.CsvBulkLoadToolIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.206 sec - in
org.apache.phoenix.end2end.QueryWithLimitIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.896 sec - in
org.apache.phoenix.end2end.QueryTimeoutIT
Running org.apache.phoenix.end2end.RenewLeaseIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.002 sec - in
org.apache.phoenix.end2end.RenewLeaseIT
Tests run: 40, Failures: 0, Errors: 0, Skipped: 16, Time elapsed: 44.203 sec -
in org.apache.phoenix.end2end.IndexExtendedIT
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.897 sec - in
org.apache.phoenix.end2end.FlappingLocalIndexIT
Running org.apache.phoenix.end2end.StatsCollectorIT
Running org.apache.phoenix.end2end.SpillableGroupByIT
Running org.apache.phoenix.end2end.SysTableNamespaceMappedStatsCollectorIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.391 sec - in
org.apache.phoenix.end2end.SpillableGroupByIT
Running org.apache.phoenix.end2end.UserDefinedFunctionsIT
Running org.apache.phoenix.end2end.index.ImmutableIndexIT
Running org.apache.phoenix.end2end.index.LocalIndexIT
Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 26.302 sec -
in org.apache.phoenix.end2end.UserDefinedFunctionsIT
Running org.apache.phoenix.end2end.index.MutableIndexFailureIT
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 135.789 sec -
in org.apache.phoenix.end2end.index.ImmutableIndexIT
Tests run: 120, Failures: 0, Errors: 0, Skipped: 24, Time elapsed: 169.931 sec
- in org.apache.phoenix.end2end.StatsCollectorIT
Tests run: 120, Failures: 0, Errors: 0, Skipped: 24, Time elapsed: 179.043 sec
- in org.apache.phoenix.end2end.SysTableNamespaceMappedStatsCollectorIT
Running org.apache.phoenix.end2end.index.MutableIndexReplicationIT
Running org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT
Tests run: 26, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 158.846 sec -
in org.apache.phoenix.end2end.index.LocalIndexIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.732 sec - in
org.apache.phoenix.end2end.index.MutableIndexReplicationIT
Running org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT
Running org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 25.164 sec - in
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 19.331 sec - in
org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT
Running
org.apache.phoenix.hbase.index.covered.EndToEndCoveredColumnsIndexBuilderIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.905 sec - in
org.apache.phoenix.hbase.index.covered.EndToEndCoveredColumnsIndexBuilderIT
Running org.apache.phoenix.execute.PartialCommitIT
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 6.619 sec - in
org.apache.phoenix.execute.PartialCommitIT
Running org.apache.phoenix.hbase.index.covered.example.EndToEndCoveredIndexingIT
Running org.apache.phoenix.hbase.index.covered.example.FailWithoutRetriesIT
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 43.291 sec - in
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.868 sec - in
org.apache.phoenix.hbase.index.covered.example.FailWithoutRetriesIT
Running
org.apache.phoenix.hbase.index.covered.example.EndtoEndIndexingWithCompressionIT
Running org.apache.phoenix.iterate.RoundRobinResultIteratorWithStatsIT
Running org.apache.phoenix.iterate.ScannerLeaseRenewalIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.146 sec - in
org.apache.phoenix.iterate.RoundRobinResultIteratorWithStatsIT
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.351 sec -
in org.apache.phoenix.hbase.index.covered.example.EndToEndCoveredIndexingIT
Running org.apache.phoenix.monitoring.PhoenixMetricsIT
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 61.031 sec -
in
org.apache.phoenix.hbase.index.covered.example.EndtoEndIndexingWithCompressionIT
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 255.792 sec -
in org.apache.phoenix.end2end.index.MutableIndexFailureIT
Running org.apache.phoenix.rpc.PhoenixClientRpcIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.364 sec - in
org.apache.phoenix.rpc.PhoenixClientRpcIT
Running org.apache.phoenix.rpc.PhoenixServerRpcIT
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 41.127 sec -
in org.apache.phoenix.monitoring.PhoenixMetricsIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.263 sec - in
org.apache.phoenix.rpc.PhoenixServerRpcIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 162.947 sec -
in org.apache.phoenix.iterate.ScannerLeaseRenewalIT
Results :
Tests run: 445, Failures: 0, Errors: 0, Skipped: 65
[INFO]
[INFO] --- maven-failsafe-plugin:2.19.1:verify (ParallelStatsEnabledTest) @
phoenix-core ---
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Apache Phoenix ..................................... SUCCESS [ 3.079 s]
[INFO] Phoenix Core ....................................... FAILURE [50:29 min]
[INFO] Phoenix - Flume .................................... SKIPPED
[INFO] Phoenix - Pig ...................................... SKIPPED
[INFO] Phoenix Query Server Client ........................ SKIPPED
[INFO] Phoenix Query Server ............................... SKIPPED
[INFO] Phoenix - Pherf .................................... SKIPPED
[INFO] Phoenix - Spark .................................... SKIPPED
[INFO] Phoenix - Hive ..................................... SKIPPED
[INFO] Phoenix Client ..................................... SKIPPED
[INFO] Phoenix Server ..................................... SKIPPED
[INFO] Phoenix Assembly ................................... SKIPPED
[INFO] Phoenix - Tracing Web Application .................. SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 50:34 min
[INFO] Finished at: 2017-01-31T20:45:01+00:00
[INFO] Final Memory: 59M/566M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.apache.maven.plugins:maven-failsafe-plugin:2.19.1:verify
(ParallelStatsEnabledTest) on project phoenix-core: There are test failures.
[ERROR]
[ERROR] Please refer to
<https://builds.apache.org/job/Phoenix-encode-columns/ws/phoenix-core/target/failsafe-reports>
for the individual test results.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please
read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :phoenix-core
Build step 'Invoke top-level Maven targets' marked build as failure
Archiving artifacts
Compressed 1.79 GB of artifacts by 53.1% relative to #51
Recording test results
