date:20180126

Build failed in Jenkins: Phoenix | Master #1922

2018-01-26 Thread Apache Jenkins Server

See 


Changes:

[jtaylor] PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on 
pk

--
[...truncated 1.17 MB...]
[INFO] Tests run: 33, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 79.778 
s - in org.apache.phoenix.end2end.RoundFloorCeilFuncIT
[INFO] Tests run: 56, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.096 
s - in org.apache.phoenix.end2end.SequenceBulkAllocationIT
[INFO] Running org.apache.phoenix.end2end.SetPropertyOnEncodedTableIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 12.73 s 
- in org.apache.phoenix.end2end.SerialIteratorsIT
[INFO] Running org.apache.phoenix.end2end.SequenceIT
[INFO] Running org.apache.phoenix.end2end.ServerExceptionIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.25 s - 
in org.apache.phoenix.end2end.ServerExceptionIT
[INFO] Running org.apache.phoenix.end2end.SignFunctionEnd2EndIT
[INFO] Running org.apache.phoenix.end2end.SetPropertyOnNonEncodedTableIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.067 s 
- in org.apache.phoenix.end2end.SignFunctionEnd2EndIT
[INFO] Running org.apache.phoenix.end2end.SkipScanAfterManualSplitIT
[INFO] Tests run: 42, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 248.986 
s - in org.apache.phoenix.end2end.QueryIT
[INFO] Tests run: 42, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 255.591 
s - in org.apache.phoenix.end2end.PointInTimeQueryIT
[INFO] Tests run: 54, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 38.141 
s - in org.apache.phoenix.end2end.SequenceIT
[INFO] Running org.apache.phoenix.end2end.SortOrderIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 29.392 s 
- in org.apache.phoenix.end2end.SkipScanAfterManualSplitIT
[INFO] Running org.apache.phoenix.end2end.SpooledTmpFileDeleteIT
[INFO] Running org.apache.phoenix.end2end.SkipScanQueryIT
[INFO] Running org.apache.phoenix.end2end.SortMergeJoinMoreIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.452 s 
- in org.apache.phoenix.end2end.SpooledTmpFileDeleteIT
[INFO] Running org.apache.phoenix.end2end.SqrtFunctionEnd2EndIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.043 s 
- in org.apache.phoenix.end2end.SqrtFunctionEnd2EndIT
[INFO] Running org.apache.phoenix.end2end.StatementHintsIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.306 s 
- in org.apache.phoenix.end2end.StatementHintsIT
[INFO] Running org.apache.phoenix.end2end.StddevIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.086 s 
- in org.apache.phoenix.end2end.StddevIT
[INFO] Running org.apache.phoenix.end2end.StoreNullsIT
[INFO] Tests run: 13, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 29.745 
s - in org.apache.phoenix.end2end.SkipScanQueryIT
[INFO] Running org.apache.phoenix.end2end.StoreNullsPropIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.364 s 
- in org.apache.phoenix.end2end.StoreNullsPropIT
[INFO] Running org.apache.phoenix.end2end.StringIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 43.436 s 
- in org.apache.phoenix.end2end.SortMergeJoinMoreIT
[INFO] Running org.apache.phoenix.end2end.StringToArrayFunctionIT
[INFO] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 61.416 
s - in org.apache.phoenix.end2end.StringIT
[INFO] Running org.apache.phoenix.end2end.TenantIdTypeIT
[INFO] Tests run: 22, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.702 
s - in org.apache.phoenix.end2end.StringToArrayFunctionIT
[INFO] Tests run: 46, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 153.83 
s - in org.apache.phoenix.end2end.SortOrderIT
[INFO] Running org.apache.phoenix.end2end.TenantSpecificViewIndexIT
[INFO] Tests run: 56, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 332.655 
s - in org.apache.phoenix.end2end.RangeScanIT
[INFO] Running org.apache.phoenix.end2end.TenantSpecificViewIndexSaltedIT
[INFO] Tests run: 32, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 195.5 s 
- in org.apache.phoenix.end2end.SetPropertyOnNonEncodedTableIT
[INFO] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 68.851 
s - in org.apache.phoenix.end2end.TenantIdTypeIT
[INFO] Running org.apache.phoenix.end2end.TimezoneOffsetFunctionIT
[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.763 s 
- in org.apache.phoenix.end2end.TimezoneOffsetFunctionIT
[INFO] Running org.apache.phoenix.end2end.ToCharFunctionIT
[INFO] Running org.apache.phoenix.end2end.ToDateFunctionIT
[INFO] Running org.apache.phoenix.end2end.ToNumberFunctionIT
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.105 s 
- in org.apache.phoenix.end2end.ToNumberFunctionIT
[INFO] Running org.apache.phoenix.end2end.TopNIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #653

2018-01-26 Thread Apache Jenkins Server

See 


Changes:

[jtaylor] PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on 
pk

--
[...truncated 325.52 KB...]
125254 [RpcServer.reader=5,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49968 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
- Can create schema RDD and execute query
128245 [RpcServer.reader=8,bindAddress=asf934.gq1.ygridcore.net,port=41693] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49018 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
128260 [RpcServer.reader=6,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49976 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
- Can create schema RDD and execute query on case sensitive table (no config)
128756 [RpcServer.reader=9,bindAddress=asf934.gq1.ygridcore.net,port=41693] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49024 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
128777 [RpcServer.reader=7,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49982 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
128886 [RpcServer.reader=0,bindAddress=asf934.gq1.ygridcore.net,port=41693] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49030 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
128904 [RpcServer.reader=8,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49988 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
- Can create schema RDD and execute constrained query
130262 [RpcServer.reader=1,bindAddress=asf934.gq1.ygridcore.net,port=41693] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49036 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
130274 [RpcServer.reader=9,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49994 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
- Can create schema RDD with predicate that will never match
130645 [RpcServer.reader=2,bindAddress=asf934.gq1.ygridcore.net,port=41693] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 49042 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase" revision: 
"0d1feabed5295495ed2257d31fab9e6553e8a9d7" user: "ndimiduk" date: "Mon Feb 20 
22:35:28 PST 2017" src_checksum: "b68339108ddccd1dfc44a76646588a58"
130660 [RpcServer.reader=0,bindAddress=asf934.gq1.ygridcore.net,port=41617] 
INFO  SecurityLogger.org.apache.hadoop.hbase.Server  - Connection from 
67.195.81.168 port: 5 with version info: version: "1.1.9" url: 
"git://diocles.local/Volumes/hbase-1.1.9/hbase"

Jenkins build is back to normal : Phoenix-4.x-HBase-1.3 #22

2018-01-26 Thread Apache Jenkins Server

See

Apache-Phoenix | 4.x-HBase-1.2 | Build Successful

2018-01-26 Thread Apache Jenkins Server

4.x-HBase-1.2 branch build status Successful

Source repository https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/4.x-HBase-1.2

Compiled Artifacts https://builds.apache.org/job/Phoenix-4.x-HBase-1.2/lastSuccessfulBuild/artifact/

Test Report https://builds.apache.org/job/Phoenix-4.x-HBase-1.2/lastCompletedBuild/testReport/

Changes
[jtaylor] PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk



Build times for last couple of runsLatest build time is the right most | Legend blue: normal, red: test failure, gray: timeout

Apache-Phoenix | 4.x-HBase-0.98 | Build Successful

2018-01-26 Thread Apache Jenkins Server

4.x-HBase-0.98 branch build status Successful

Source repository https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/4.x-HBase-0.98

Compiled Artifacts https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/lastSuccessfulBuild/artifact/

Test Report https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/lastCompletedBuild/testReport/

Changes
[jtaylor] PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk



Build times for last couple of runsLatest build time is the right most | Legend blue: normal, red: test failure, gray: timeout

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #652

2018-01-26 Thread Apache Jenkins Server

See 

--
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-eu2 (ubuntu trusty) in workspace 

java.io.IOException: Failed to mkdirs: 

at hudson.FilePath.mkdirs(FilePath.java:1170)
at hudson.model.AbstractProject.checkout(AbstractProject.java:1200)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.defaultCheckout(AbstractBuild.java:574)
at jenkins.scm.SCMCheckoutStrategy.checkout(SCMCheckoutStrategy.java:86)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:499)
at hudson.model.Run.execute(Run.java:1724)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:97)
at hudson.model.Executor.run(Executor.java:421)
Retrying after 10 seconds
java.io.IOException: Failed to mkdirs: 

at hudson.FilePath.mkdirs(FilePath.java:1170)
at hudson.model.AbstractProject.checkout(AbstractProject.java:1200)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.defaultCheckout(AbstractBuild.java:574)
at jenkins.scm.SCMCheckoutStrategy.checkout(SCMCheckoutStrategy.java:86)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:499)
at hudson.model.Run.execute(Run.java:1724)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:97)
at hudson.model.Executor.run(Executor.java:421)
Retrying after 10 seconds
java.io.IOException: Failed to mkdirs: 

at hudson.FilePath.mkdirs(FilePath.java:1170)
at hudson.model.AbstractProject.checkout(AbstractProject.java:1200)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.defaultCheckout(AbstractBuild.java:574)
at jenkins.scm.SCMCheckoutStrategy.checkout(SCMCheckoutStrategy.java:86)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:499)
at hudson.model.Run.execute(Run.java:1724)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:97)
at hudson.model.Executor.run(Executor.java:421)
Archiving artifacts
ERROR: Build step failed with exception
Also:   hudson.remoting.Channel$CallSiteStackTrace: Remote call to ubuntu-eu2
at 
hudson.remoting.Channel.attachCallSiteStackTrace(Channel.java:1693)
at hudson.remoting.UserResponse.retrieve(UserRequest.java:310)
at hudson.remoting.Channel.call(Channel.java:908)
at hudson.FilePath.act(FilePath.java:986)
at hudson.FilePath.act(FilePath.java:975)
at 
hudson.tasks.ArtifactArchiver.perform(ArtifactArchiver.java:243)
at 
hudson.tasks.BuildStepCompatibilityLayer.perform(BuildStepCompatibilityLayer.java:81)
at 
hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:744)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.performAllBuildSteps(AbstractBuild.java:690)
at hudson.model.Build$BuildExecution.post2(Build.java:186)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.post(AbstractBuild.java:635)
at hudson.model.Run.execute(Run.java:1749)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at 
hudson.model.ResourceController.execute(ResourceController.java:97)
at hudson.model.Executor.run(Executor.java:421)
 does not exist.
at 
org.apache.tools.ant.types.AbstractFileSet.getDirectoryScanner(AbstractFileSet.java:483)
at 
org.apache.tools.ant.types.AbstractFileSet.getDirectoryScanner(AbstractFileSet.java:460)
at 
hudson.tasks.ArtifactArchiver$ListFiles.invoke(ArtifactArchiver.java:298)
at 
hudson.tasks.ArtifactArchiver$ListFiles.invoke(ArtifactArchiver.java:278)
at hudson.FilePath$FileCallableWrapper.call(FilePath.java:2760)
at hudson.remoting.UserRequest.perform(UserRequest.java:207)
at hudson.remoting.UserRequest.perform(UserRequest.java:53)
at hudson.remoting.Request$2.run(Request.java:358)
at

Build failed in Jenkins: Phoenix | Master #1921

2018-01-26 Thread Apache Jenkins Server

See 

--
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-eu2 (ubuntu trusty) in workspace 

Cloning the remote Git repository
Cloning repository https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git init  # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git --version # timeout=10
 > git fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
ERROR: Error cloning remote repo 'origin'
hudson.plugins.git.GitException: Command "git fetch --tags --progress 
https://git-wip-us.apache.org/repos/asf/phoenix.git 
+refs/heads/*:refs/remotes/origin/*" returned status code 128:
stdout: 
stderr: remote: Counting objects: 108009   remote: Counting objects: 
142775, done.
remote: Compressing objects:   0% (1/57015)   remote: Compressing 
objects:   1% (571/57015)   remote: Compressing objects:   2% 
(1141/57015)   remote: Compressing objects:   3% (1711/57015)   
remote: Compressing objects:   4% (2281/57015)   remote: Compressing 
objects:   5% (2851/57015)   remote: Compressing objects:   6% 
(3421/57015)   remote: Compressing objects:   7% (3992/57015)   
remote: Compressing objects:   8% (4562/57015)   remote: Compressing 
objects:   9% (5132/57015)   remote: Compressing objects:  10% 
(5702/57015)   remote: Compressing objects:  11% (6272/57015)   
remote: Compressing objects:  12% (6842/57015)   remote: Compressing 
objects:  13% (7412/57015)   remote: Compressing objects:  14% 
(7983/57015)   remote: Compressing objects:  15% (8553/57015)   
remote: Compressing objects:  16% (9123/57015)   remote: Compressing 
objects:  17% (9693/57015)   remote: Compressing objects:  18% 
(10263/57015)   remote: Compressing objects:  19% (10833/57015) 
  remote: Compressing objects:  20% (11403/57015)   remote: Compressing 
objects:  21% (11974/57015)   remote: Compressing objects:  22% 
(12544/57015)   remote: Compressing objects:  23% (13114/57015) 
  remote: Compressing objects:  24% (13684/57015)   remote: Compressing 
objects:  25% (14254/57015)   remote: Compressing objects:  26% 
(14824/57015)   remote: Compressing objects:  27% (15395/57015) 
  remote: Compressing objects:  28% (15965/57015)   remote: Compressing 
objects:  29% (16535/57015)   remote: Compressing objects:  30% 
(17105/57015)   remote: Compressing objects:  31% (17675/57015) 
  remote: Compressing objects:  32% (18245/57015)   remote: Compressing 
objects:  33% (18815/57015)   remote: Compressing objects:  34% 
(19386/57015)   remote: Compressing objects:  35% (19956/57015) 
  remote: Compressing objects:  36% (20526/57015)   remote: Compressing 
objects:  37% (21096/57015)   remote: Compressing objects:  38% 
(21666/57015)   remote: Compressing objects:  39% (22236/57015) 
  remote: Compressing objects:  40% (22806/57015)   remote: Compressing 
objects:  41% (23377/57015)   remote: Compressing objects:  42% 
(23947/57015)   remote: Compressing objects:  43% (24517/57015) 
  remote: Compressing objects:  44% (25087/57015)   remote: Compressing 
objects:  45% (25657/57015)   remote: Compressing objects:  46% 
(26227/57015)   remote: Compressing objects:  47% (26798/57015) 
  remote: Compressing objects:  48% (27368/57015)   remote: Compressing 
objects:  49% (27938/57015)   remote: Compressing objects:  50% 
(28508/57015)   remote: Compressing objects:  51% (29078/57015) 
  remote: Compressing objects:  52% (29648/57015)   remote: Compressing 
objects:  53% (30218/57015)   remote: Compressing objects:  54% 
(30789/57015)   remote: Compressing objects:  55% (31359/57015) 
  remote: Compressing objects:  56% (31929/57015)   remote: Compressing 
objects:  57% (32499/57015)   remote: Compressing objects:  58% 
(33069/57015)   remote: Compressing objects:  59% (33639/57015) 
  remote: Compressing objects:  60% (34209/57015)   remote: Compressing 
objects:  61% (34780/57015)   remote: Compressing objects:  62% 
(35350/57015)   remote: Compressing objects:  63% (35920/57015) 
  remote: Compressing

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/5.x-HBase-2.0 b5d0bd789 -> a7d410bf8


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/a7d410bf
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/a7d410bf
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/a7d410bf

Branch: refs/heads/5.x-HBase-2.0
Commit: a7d410bf8566e9c3537bb42e3d74dcbaa9a22068
Parents: b5d0bd7
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 14:38:20 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/a7d410bf/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.3 37478531b -> 5819bd69f


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/5819bd69
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/5819bd69
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/5819bd69

Branch: refs/heads/4.x-HBase-1.3
Commit: 5819bd69f56bf0855c5ea030f03de28cb6d57ef2
Parents: 3747853
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 14:36:38 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/5819bd69/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.2 ace9b76f6 -> d4a69bcb8


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/d4a69bcb
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/d4a69bcb
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/d4a69bcb

Branch: refs/heads/4.x-HBase-1.2
Commit: d4a69bcb881121b6cfe41fd574316a2909a311f9
Parents: ace9b76
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 14:35:18 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/d4a69bcb/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 3cb0a1d89 -> f98f16f0e


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/f98f16f0
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/f98f16f0
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/f98f16f0

Branch: refs/heads/4.x-HBase-1.1
Commit: f98f16f0e17472fa7c007d588ebe21e830e3a918
Parents: 3cb0a1d
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 14:33:58 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/f98f16f0/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 00a6a03c2 -> 57a713724


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/57a71372
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/57a71372
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/57a71372

Branch: refs/heads/4.x-HBase-0.98
Commit: 57a71372468e1488d495d8fa9d768d62d4bb2b36
Parents: 00a6a03
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 14:32:29 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/57a71372/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

2018-01-26 Thread jamestaylor

Repository: phoenix
Updated Branches:
  refs/heads/master 3a6c76f12 -> 8c46d3273


PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/8c46d327
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/8c46d327
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/8c46d327

Branch: refs/heads/master
Commit: 8c46d3273e04e2ff0b749bfeabb1f7974e738a1d
Parents: 3a6c76f
Author: James Taylor 
Authored: Thu Jan 25 16:43:06 2018 -0800
Committer: James Taylor 
Committed: Fri Jan 26 13:15:41 2018 -0800

--
 .../org/apache/phoenix/end2end/OrderByIT.java   | 111 +++
 .../org/apache/phoenix/compile/ScanRanges.java  |   5 -
 .../phoenix/compile/QueryCompilerTest.java  |  15 +++
 3 files changed, 126 insertions(+), 5 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/8c46d327/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
--
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
index ebbeeb4..3bce9c7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
@@ -39,6 +39,7 @@ import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.Properties;
 
+import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.util.PropertiesUtil;
 import org.junit.Test;
 
@@ -544,6 +545,116 @@ public class OrderByIT extends ParallelStatsDisabledIT {
 }
 
 @Test
+public void testAggregateOrderBy() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+String tableName = generateUniqueName();
+String ddl = "create table " + tableName + " (ID VARCHAR NOT NULL 
PRIMARY KEY, VAL1 VARCHAR, VAL2 INTEGER)";
+conn.createStatement().execute(ddl);
+
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABC','aa123', 11)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABD','ba124', 1)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABE','cf125', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABF','dan126', 4)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABG','elf127', 15)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('ABH','fan128', 6)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAA','get211', 100)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAB','hat212', 7)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAC','aap12', 2)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAD','ball12', 3)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAE','inn2110', 13)");
+conn.createStatement().execute("upsert into " + tableName + " values 
('AAF','key2112', 40)");
+conn.commit();
+
+ResultSet rs;
+PhoenixStatement stmt = 
conn.createStatement().unwrap(PhoenixStatement.class);
+rs = stmt.executeQuery("select distinct ID, VAL1, VAL2 from " + 
tableName + " where ID in ('ABC','ABD','ABE','ABF','ABG','ABH','AAA', 'AAB', 
'AAC','AAD','AAE','AAF') order by VAL1");
+
assertFalse(stmt.getQueryPlan().getOrderBy().getOrderByExpressions().isEmpty());
+assertTrue(rs.next());
+assertEquals("ABC", rs.getString(1));
+assertEquals("aa123", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("aap12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ba124", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("ball12", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("cf125", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("dan126", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("elf127", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("fan128", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("get211", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("hat212", rs.getString(2));
+assertTrue(rs.next());
+assertEquals("inn2110", rs.getString(2));
+assertTrue(rs.next());
+

Build failed in Jenkins: Phoenix Compile Compatibility with HBase #529

2018-01-26 Thread Apache Jenkins Server

See 


--
Started by timer
[EnvInject] - Loading node environment variables.
Building remotely on H33 (ubuntu xenial) in workspace 

[Phoenix_Compile_Compat_wHBase] $ /bin/bash /tmp/jenkins4070901076726202440.sh
core file size  (blocks, -c) 0
data seg size   (kbytes, -d) unlimited
scheduling priority (-e) 0
file size   (blocks, -f) unlimited
pending signals (-i) 386525
max locked memory   (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files  (-n) 6
pipe size(512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority  (-r) 0
stack size  (kbytes, -s) 8192
cpu time   (seconds, -t) unlimited
max user processes  (-u) 10240
virtual memory  (kbytes, -v) unlimited
file locks  (-x) unlimited
core id : 0
core id : 1
core id : 2
core id : 3
core id : 4
core id : 5
physical id : 0
physical id : 1
MemTotal:   98986032 kB
MemFree:25357036 kB
Filesystem  Size  Used Avail Use% Mounted on
udev 48G 0   48G   0% /dev
tmpfs   9.5G  426M  9.1G   5% /run
/dev/sda1   364G  160G  186G  47% /
tmpfs48G  540K   48G   1% /dev/shm
tmpfs   5.0M 0  5.0M   0% /run/lock
tmpfs48G 0   48G   0% /sys/fs/cgroup
tmpfs   9.5G 0  9.5G   0% /run/user/910
apache-maven-2.2.1
apache-maven-3.0.4
apache-maven-3.0.5
apache-maven-3.2.1
apache-maven-3.2.5
apache-maven-3.3.3
apache-maven-3.3.9
apache-maven-3.5.0
apache-maven-3.5.2
latest
latest2
latest3


===
Verifying compile level compatibility with HBase 0.98 with Phoenix 
4.x-HBase-0.98
===

Cloning into 'hbase'...
Switched to a new branch '0.98'
Branch 0.98 set up to track remote branch 0.98 from origin.
[ERROR] Failed to execute goal on project hbase-common: Could not resolve 
dependencies for project org.apache.hbase:hbase-common:jar:0.98.25-SNAPSHOT: 
Failed to collect dependencies at 
org.apache.hadoop:hadoop-mapreduce-client-core:jar:2.2.0 -> 
org.apache.hadoop:hadoop-yarn-common:jar:2.2.0 -> 
org.apache.hadoop:hadoop-yarn-api:jar:2.2.0 -> 
com.sun.jersey.jersey-test-framework:jersey-test-framework-grizzly2:jar:1.9 -> 
com.sun.jersey:jersey-grizzly2:jar:1.9 -> 
org.glassfish.grizzly:grizzly-http:jar:2.1.2 -> 
org.glassfish.grizzly:grizzly-framework:jar:2.1.2 -> 
org.glassfish.gmbal:gmbal-api-only:jar:3.0.0-b023 -> 
org.glassfish.external:management-api:jar:3.0.0-b012: Failed to read artifact 
descriptor for org.glassfish.external:management-api:jar:3.0.0-b012: Could not 
transfer artifact org.glassfish.external:management-api:pom:3.0.0-b012 from/to 
apache release (https://repository.apache.org/content/repositories/releases/): 
/home/jenkins/.m2/repository/org/glassfish/external/management-api/3.0.0-b012/management-api-3.0.0-b012.pom.part.lock
 (No such file or directory) -> [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/DependencyResolutionException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR]   mvn  -rf :hbase-common
Build step 'Execute shell' marked build as failure

Build failed in Jenkins: Phoenix | Master #1922

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #653

Jenkins build is back to normal : Phoenix-4.x-HBase-1.3 #22

Apache-Phoenix | 4.x-HBase-1.2 | Build Successful

Apache-Phoenix | 4.x-HBase-0.98 | Build Successful

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #652

Build failed in Jenkins: Phoenix | Master #1921

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

phoenix git commit: PHOENIX-4560 ORDER BY with GROUP BY doesn't work if there is WHERE on pk column

Build failed in Jenkins: Phoenix Compile Compatibility with HBase #529

14 matches

Site Navigation

Mail list logo

Footer information