[4/6] phoenix git commit: PHOENIX-4981 Add tests for ORDER BY, GROUP BY and salted tables using phoenix-spark
http://git-wip-us.apache.org/repos/asf/phoenix/blob/6053ee63/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java -- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java new file mode 100644 index 000..31bf050 --- /dev/null +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java @@ -0,0 +1,940 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.phoenix.end2end; + +import static org.apache.phoenix.util.TestUtil.ROW1; +import static org.apache.phoenix.util.TestUtil.ROW2; +import static org.apache.phoenix.util.TestUtil.ROW3; +import static org.apache.phoenix.util.TestUtil.ROW4; +import static org.apache.phoenix.util.TestUtil.ROW5; +import static org.apache.phoenix.util.TestUtil.ROW6; +import static org.apache.phoenix.util.TestUtil.ROW7; +import static org.apache.phoenix.util.TestUtil.ROW8; +import static org.apache.phoenix.util.TestUtil.ROW9; +import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES; +import static org.apache.phoenix.util.TestUtil.assertResultSet; +import static org.junit.Assert.assertEquals; +import static org.junit.Assert.assertFalse; +import static org.junit.Assert.assertTrue; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.util.Properties; + +import com.google.common.collect.Lists; +import org.apache.phoenix.util.PropertiesUtil; +import org.apache.phoenix.util.QueryBuilder; +import org.junit.Test; + + +public abstract class BaseOrderByIT extends ParallelStatsDisabledIT { + +@Test +public void testMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING, ENTITY_ID"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW1,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW4,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW7,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW2,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW5,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW8,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); + +assertFalse(rs.next()); +} +} + + +@Test +public void testDescMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING || ENTITY_ID DESC"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue
[4/6] phoenix git commit: PHOENIX-4981 Add tests for ORDER BY, GROUP BY and salted tables using phoenix-spark
http://git-wip-us.apache.org/repos/asf/phoenix/blob/51d38d7f/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java -- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java new file mode 100644 index 000..31bf050 --- /dev/null +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java @@ -0,0 +1,940 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.phoenix.end2end; + +import static org.apache.phoenix.util.TestUtil.ROW1; +import static org.apache.phoenix.util.TestUtil.ROW2; +import static org.apache.phoenix.util.TestUtil.ROW3; +import static org.apache.phoenix.util.TestUtil.ROW4; +import static org.apache.phoenix.util.TestUtil.ROW5; +import static org.apache.phoenix.util.TestUtil.ROW6; +import static org.apache.phoenix.util.TestUtil.ROW7; +import static org.apache.phoenix.util.TestUtil.ROW8; +import static org.apache.phoenix.util.TestUtil.ROW9; +import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES; +import static org.apache.phoenix.util.TestUtil.assertResultSet; +import static org.junit.Assert.assertEquals; +import static org.junit.Assert.assertFalse; +import static org.junit.Assert.assertTrue; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.util.Properties; + +import com.google.common.collect.Lists; +import org.apache.phoenix.util.PropertiesUtil; +import org.apache.phoenix.util.QueryBuilder; +import org.junit.Test; + + +public abstract class BaseOrderByIT extends ParallelStatsDisabledIT { + +@Test +public void testMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING, ENTITY_ID"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW1,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW4,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW7,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW2,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW5,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW8,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); + +assertFalse(rs.next()); +} +} + + +@Test +public void testDescMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING || ENTITY_ID DESC"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue
[4/6] phoenix git commit: PHOENIX-4981 Add tests for ORDER BY, GROUP BY and salted tables using phoenix-spark
http://git-wip-us.apache.org/repos/asf/phoenix/blob/9bfaf183/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java -- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java new file mode 100644 index 000..31bf050 --- /dev/null +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java @@ -0,0 +1,940 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.phoenix.end2end; + +import static org.apache.phoenix.util.TestUtil.ROW1; +import static org.apache.phoenix.util.TestUtil.ROW2; +import static org.apache.phoenix.util.TestUtil.ROW3; +import static org.apache.phoenix.util.TestUtil.ROW4; +import static org.apache.phoenix.util.TestUtil.ROW5; +import static org.apache.phoenix.util.TestUtil.ROW6; +import static org.apache.phoenix.util.TestUtil.ROW7; +import static org.apache.phoenix.util.TestUtil.ROW8; +import static org.apache.phoenix.util.TestUtil.ROW9; +import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES; +import static org.apache.phoenix.util.TestUtil.assertResultSet; +import static org.junit.Assert.assertEquals; +import static org.junit.Assert.assertFalse; +import static org.junit.Assert.assertTrue; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.util.Properties; + +import com.google.common.collect.Lists; +import org.apache.phoenix.util.PropertiesUtil; +import org.apache.phoenix.util.QueryBuilder; +import org.junit.Test; + + +public abstract class BaseOrderByIT extends ParallelStatsDisabledIT { + +@Test +public void testMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING, ENTITY_ID"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW1,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW4,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW7,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW2,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW5,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW8,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); + +assertFalse(rs.next()); +} +} + + +@Test +public void testDescMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING || ENTITY_ID DESC"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue
[4/6] phoenix git commit: PHOENIX-4981 Add tests for ORDER BY, GROUP BY and salted tables using phoenix-spark
http://git-wip-us.apache.org/repos/asf/phoenix/blob/c509d58f/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java -- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java new file mode 100644 index 000..31bf050 --- /dev/null +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseOrderByIT.java @@ -0,0 +1,940 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.phoenix.end2end; + +import static org.apache.phoenix.util.TestUtil.ROW1; +import static org.apache.phoenix.util.TestUtil.ROW2; +import static org.apache.phoenix.util.TestUtil.ROW3; +import static org.apache.phoenix.util.TestUtil.ROW4; +import static org.apache.phoenix.util.TestUtil.ROW5; +import static org.apache.phoenix.util.TestUtil.ROW6; +import static org.apache.phoenix.util.TestUtil.ROW7; +import static org.apache.phoenix.util.TestUtil.ROW8; +import static org.apache.phoenix.util.TestUtil.ROW9; +import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES; +import static org.apache.phoenix.util.TestUtil.assertResultSet; +import static org.junit.Assert.assertEquals; +import static org.junit.Assert.assertFalse; +import static org.junit.Assert.assertTrue; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.util.Properties; + +import com.google.common.collect.Lists; +import org.apache.phoenix.util.PropertiesUtil; +import org.apache.phoenix.util.QueryBuilder; +import org.junit.Test; + + +public abstract class BaseOrderByIT extends ParallelStatsDisabledIT { + +@Test +public void testMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING, ENTITY_ID"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW1,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW4,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW7,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW2,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW5,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW8,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); + +assertFalse(rs.next()); +} +} + + +@Test +public void testDescMultiOrderByExpr() throws Exception { +String tenantId = getOrganizationId(); +String tableName = initATableValues(tenantId, getDefaultSplits(tenantId), getUrl()); +QueryBuilder queryBuilder = new QueryBuilder() +.setSelectColumns( +Lists.newArrayList("ENTITY_ID", "B_STRING")) +.setFullTableName(tableName) +.setOrderByClause("B_STRING || ENTITY_ID DESC"); +Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); +try (Connection conn = DriverManager.getConnection(getUrl(), props)) { +ResultSet rs = executeQuery(conn, queryBuilder); +assertTrue (rs.next()); +assertEquals(ROW9,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW6,rs.getString(1)); +assertTrue (rs.next()); +assertEquals(ROW3,rs.getString(1)); +assertTrue