http://git-wip-us.apache.org/repos/asf/carbondata/blob/14624953/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBVATestCase.scala ---------------------------------------------------------------------- diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBVATestCase.scala b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBVATestCase.scala new file mode 100644 index 0000000..1aac73b --- /dev/null +++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBVATestCase.scala @@ -0,0 +1,12328 @@ + +/* + * 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.carbondata.cluster.sdv.generated + +import org.apache.spark.sql.common.util._ +import org.scalatest.BeforeAndAfterAll + +/** + * Test Class for QueriesBVATestCase to verify all scenerios + */ + +class QueriesBVATestCase extends QueryTest with BeforeAndAfterAll { + + + //BVA_SPL_DATA_CreateTable1 + test("BVA_SPL_DATA_CreateTable1", Include) { + sql(s"""drop table if exists Test_Boundary""").collect + sql(s"""drop table if exists Test_Boundary_hive""").collect + + sql(s"""create table Test_Boundary (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string) STORED BY 'org.apache.carbondata.format'""").collect + + sql(s"""create table Test_Boundary_hive (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','""").collect + + + } + + + //BVA_SPL_DATA_CreateTable_count + test("BVA_SPL_DATA_CreateTable_count", Include) { + + sql(s"""select count(*) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_DataLoad1 + test("BVA_SPL_DATA_DataLoad1", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/Test_Data1.csv' INTO table Test_Boundary OPTIONS('DELIMITER'=',','QUOTECHAR'='', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/Test_Data1.csv' INTO table Test_Boundary_hive """).collect + + + } + + + //BVA_SPL_DATA_CreateTable2 + test("BVA_SPL_DATA_CreateTable2", Include) { + sql(s"""drop table if exists Test_Boundary1""").collect + sql(s"""drop table if exists Test_Boundary1_hive""").collect + + sql(s"""create table Test_Boundary1 (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string) STORED BY 'org.apache.carbondata.format'""").collect + + sql(s"""create table Test_Boundary1_hive (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','""").collect + + + } + + + //BVA_SPL_DATA_DataLoad2 + test("BVA_SPL_DATA_DataLoad2", Include) { + + sql(s""" LOAD DATA INPATH '$resourcesPath/Data/Test_Data1.csv' INTO table Test_Boundary1 OPTIONS('DELIMITER'=',','QUOTECHAR'='', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc')""").collect + + sql(s""" LOAD DATA INPATH '$resourcesPath/Data/Test_Data1.csv' INTO table Test_Boundary1_hive """).collect + + + } + + + //BVA_SPL_DATA_INT_001 + test("BVA_SPL_DATA_INT_001", Include) { + + checkAnswer(s"""select c1_int from test_boundary where c1_int in (2.147483647E9,2345.0,1234.0)""", + s"""select c1_int from test_boundary_hive where c1_int in (2.147483647E9,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_INT_001") + + } + + + //BVA_SPL_DATA_INT_002 + test("BVA_SPL_DATA_INT_002", Include) { + + checkAnswer(s"""select c1_int from test_boundary where c1_int in (-2.147483647E9,2345.0,-1234.0)""", + s"""select c1_int from test_boundary_hive where c1_int in (-2.147483647E9,2345.0,-1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_INT_002") + + } + + + //BVA_SPL_DATA_INT_003 + test("BVA_SPL_DATA_INT_003", Include) { + + checkAnswer(s"""select c1_int from test_boundary where c1_int in (0,-1234.0)""", + s"""select c1_int from test_boundary_hive where c1_int in (0,-1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_INT_003") + + } + + + //BVA_SPL_DATA_INT_004 + test("BVA_SPL_DATA_INT_004", Include) { + + checkAnswer(s"""select c1_int from test_boundary where c1_int not in (2.147483647E9,2345.0,1234.0)""", + s"""select c1_int from test_boundary_hive where c1_int not in (2.147483647E9,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_INT_004") + + } + + + //BVA_SPL_DATA_INT_005 + test("BVA_SPL_DATA_INT_005", Include) { + + checkAnswer(s"""select c1_int from test_boundary where c1_int in (2.147483647E9,2345.0,1234.0)""", + s"""select c1_int from test_boundary_hive where c1_int in (2.147483647E9,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_INT_005") + + } + + + //BVA_SPL_DATA_INT_006 + test("BVA_SPL_DATA_INT_006", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int < 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int < 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_006") + + } + + + //BVA_SPL_DATA_INT_007 + test("BVA_SPL_DATA_INT_007", Include) { + + checkAnswer(s"""select c1_int+0.9 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int+0.9 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_007") + + } + + + //BVA_SPL_DATA_INT_008 + test("BVA_SPL_DATA_INT_008", Include) { + + checkAnswer(s"""select c1_int+0.9 from Test_Boundary where c1_int >= 2.147483647E9 """, + s"""select c1_int+0.9 from Test_Boundary_hive where c1_int >= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_008") + + } + + + //BVA_SPL_DATA_INT_009 + test("BVA_SPL_DATA_INT_009", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int <= 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int <= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_009") + + } + + + //BVA_SPL_DATA_INT_010 + test("BVA_SPL_DATA_INT_010", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int <> 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int <> 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_010") + + } + + + //BVA_SPL_DATA_INT_011 + test("BVA_SPL_DATA_INT_011", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_011") + + } + + + //BVA_SPL_DATA_INT_012 + test("BVA_SPL_DATA_INT_012", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_012") + + } + + + //BVA_SPL_DATA_INT_013 + test("BVA_SPL_DATA_INT_013", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 or c1_int <> 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 or c1_int <> 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_013") + + } + + + //BVA_SPL_DATA_INT_014 + test("BVA_SPL_DATA_INT_014", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 or c1_int = 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 or c1_int = 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_014") + + } + + + //BVA_SPL_DATA_INT_015 + test("BVA_SPL_DATA_INT_015", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 or c1_int = 4567 group by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 or c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_015") + + } + + + //BVA_SPL_DATA_INT_016 + test("BVA_SPL_DATA_INT_016", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int <> 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int <> 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_016") + + } + + + //BVA_SPL_DATA_INT_017 + test("BVA_SPL_DATA_INT_017", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_017") + + } + + + //BVA_SPL_DATA_INT_018 + test("BVA_SPL_DATA_INT_018", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_018") + + } + + + //BVA_SPL_DATA_INT_019 + test("BVA_SPL_DATA_INT_019", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int is null""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int is null""", "QueriesBVATestCase_BVA_SPL_DATA_INT_019") + + } + + + //BVA_SPL_DATA_INT_020 + test("BVA_SPL_DATA_INT_020", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int is not null""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int is not null""", "QueriesBVATestCase_BVA_SPL_DATA_INT_020") + + } + + + //BVA_SPL_DATA_INT_021 + test("BVA_SPL_DATA_INT_021", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =2345 and c1_int <> 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =2345 and c1_int <> 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_021") + + } + + + //BVA_SPL_DATA_INT_022 + test("BVA_SPL_DATA_INT_022", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =2345 and c1_int = 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =2345 and c1_int = 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_022") + + } + + + //BVA_SPL_DATA_INT_023 + test("BVA_SPL_DATA_INT_023", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary where c1_int =2345 and c1_int = 4567 group by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive where c1_int =2345 and c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_023") + + } + + + //BVA_SPL_DATA_INT_024 + test("BVA_SPL_DATA_INT_024", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =2345 or c1_int <> 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =2345 or c1_int <> 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_024") + + } + + + //BVA_SPL_DATA_INT_025 + test("BVA_SPL_DATA_INT_025", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int =2345 or c1_int = 4567""", + s"""select c1_int from Test_Boundary_hive where c1_int =2345 or c1_int = 4567""", "QueriesBVATestCase_BVA_SPL_DATA_INT_025") + + } + + + //BVA_SPL_DATA_INT_026 + test("BVA_SPL_DATA_INT_026", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary where c1_int =2345 or c1_int = 4567 group by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive where c1_int =2345 or c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_026") + + } + + + //BVA_SPL_DATA_INT_027 + test("BVA_SPL_DATA_INT_027", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int between -2.147483648E9 and 2.147483647E9) e """, + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int between -2.147483648E9 and 2.147483647E9) e """, "QueriesBVATestCase_BVA_SPL_DATA_INT_027") + + } + + + //BVA_SPL_DATA_INT_028 + test("BVA_SPL_DATA_INT_028", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int not between -2.147483648E9 and 0) e""", + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int not between -2.147483648E9 and 0) e""", "QueriesBVATestCase_BVA_SPL_DATA_INT_028") + + } + + + //BVA_SPL_DATA_INT_029 + test("BVA_SPL_DATA_INT_029", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int not between 0 and 2.147483647E9) e""", + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int not between 0 and 2.147483647E9) e""", "QueriesBVATestCase_BVA_SPL_DATA_INT_029") + + } + + + //BVA_SPL_DATA_INT_030 + test("BVA_SPL_DATA_INT_030", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int between -2.147483648E9 and 2.147483647E9 """, + s"""select c1_int from Test_Boundary_hive where c1_int between -2.147483648E9 and 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_030") + + } + + + //BVA_SPL_DATA_INT_031 + test("BVA_SPL_DATA_INT_031", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int between -2.147483648E9 and 0 """, + s"""select c1_int from Test_Boundary_hive where c1_int between -2.147483648E9 and 0 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_031") + + } + + + //BVA_SPL_DATA_INT_032 + test("BVA_SPL_DATA_INT_032", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int between 0 and 2.147483647E9""", + s"""select c1_int from Test_Boundary_hive where c1_int between 0 and 2.147483647E9""", "QueriesBVATestCase_BVA_SPL_DATA_INT_032") + + } + + + //BVA_SPL_DATA_INT_033 + test("BVA_SPL_DATA_INT_033", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int between -2.147483648E9 and 2.147483647E9) e """, + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int between -2.147483648E9 and 2.147483647E9) e """, "QueriesBVATestCase_BVA_SPL_DATA_INT_033") + + } + + + //BVA_SPL_DATA_INT_034 + test("BVA_SPL_DATA_INT_034", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int between -2.147483648E9 and 0) e""", + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int between -2.147483648E9 and 0) e""", "QueriesBVATestCase_BVA_SPL_DATA_INT_034") + + } + + + //BVA_SPL_DATA_INT_035 + test("BVA_SPL_DATA_INT_035", Include) { + + checkAnswer(s"""select c1_int from (select c1_int from Test_Boundary where c1_int between 0 and 2.147483647E9) e""", + s"""select c1_int from (select c1_int from Test_Boundary_hive where c1_int between 0 and 2.147483647E9) e""", "QueriesBVATestCase_BVA_SPL_DATA_INT_035") + + } + + + //BVA_SPL_DATA_INT_036 + test("BVA_SPL_DATA_INT_036", Include) { + + checkAnswer(s"""select count(*) from Test_Boundary""", + s"""select count(*) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_036") + + } + + + //BVA_SPL_DATA_INT_037 + test("BVA_SPL_DATA_INT_037", Include) { + + checkAnswer(s"""select distinct count(*) from Test_Boundary""", + s"""select distinct count(*) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_037") + + } + + + //BVA_SPL_DATA_INT_038 + test("BVA_SPL_DATA_INT_038", Include) { + + checkAnswer(s"""select distinct count(c1_int) from Test_Boundary""", + s"""select distinct count(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_038") + + } + + + //BVA_SPL_DATA_INT_039 + test("BVA_SPL_DATA_INT_039", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int not between -2.147483648E9 and 2.147483647E9 """, + s"""select c1_int from Test_Boundary_hive where c1_int not between -2.147483648E9 and 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_039") + + } + + + //BVA_SPL_DATA_INT_040 + test("BVA_SPL_DATA_INT_040", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int not between -2.147483648E9 and 0 """, + s"""select c1_int from Test_Boundary_hive where c1_int not between -2.147483648E9 and 0 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_040") + + } + + + //BVA_SPL_DATA_INT_041 + test("BVA_SPL_DATA_INT_041", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int not between 0 and 2.147483647E9""", + s"""select c1_int from Test_Boundary_hive where c1_int not between 0 and 2.147483647E9""", "QueriesBVATestCase_BVA_SPL_DATA_INT_041") + + } + + + //BVA_SPL_DATA_INT_042 + test("BVA_SPL_DATA_INT_042", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_042") + + } + + + //BVA_SPL_DATA_INT_043 + test("BVA_SPL_DATA_INT_043", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_043") + + } + + + //BVA_SPL_DATA_INT_044 + test("BVA_SPL_DATA_INT_044", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int < 2.147483647E9 and c1_int >3.147483647E9""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int < 2.147483647E9 and c1_int >3.147483647E9""", "QueriesBVATestCase_BVA_SPL_DATA_INT_044") + + } + + + //BVA_SPL_DATA_INT_045 + test("BVA_SPL_DATA_INT_045", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int < 2.147483647E9 and c1_int >3.147483647E9""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int < 2.147483647E9 and c1_int >3.147483647E9""", "QueriesBVATestCase_BVA_SPL_DATA_INT_045") + + } + + + //BVA_SPL_DATA_INT_046 + test("BVA_SPL_DATA_INT_046", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int +0.1000= 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int +0.1000= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_046") + + } + + + //BVA_SPL_DATA_INT_047 + test("BVA_SPL_DATA_INT_047", Include) { + + checkAnswer(s"""SELECT test_boundary.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary1 ON test_boundary.c1_int = test_boundary1.c1_int WHERE test_boundary.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary.c1_int ORDER BY test_boundary.c1_int ASC""", + s"""SELECT test_boundary_hive.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 ON test_boundary_hive.c1_int = test_boundary_hive1.c1_int WHERE test_boundary_hive.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary_hive.c1_int ORDER BY test_boundary_hive.c1_int ASC""", "QueriesBVATestCase_BVA_SPL_DATA_INT_047") + + } + + + //BVA_SPL_DATA_INT_048 + ignore("BVA_SPL_DATA_INT_048", Include) { + + checkAnswer(s"""SELECT test_boundary.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary1) SUB_QRY ) test_boundary1 ON test_boundary.c1_int = test_boundary1.c1_int WHERE test_boundary.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary.c1_int ORDER BY test_-boundary.c1_int ASC""", + s"""SELECT test_boundary_hive.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 ON test_boundary_hive1.c1_int = test_boundary_hive.c1_int WHERE test_boundary_hive.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary_hive.c1_int ORDER BY test_boundary_hive.c1_int ASC""", "QueriesBVATestCase_BVA_SPL_DATA_INT_048") + + } + + + //BVA_SPL_DATA_INT_049 + test("BVA_SPL_DATA_INT_049", Include) { + + checkAnswer(s"""SELECT test_boundary.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary1 ON test_boundary.c1_int = test_boundary1.c1_int WHERE test_boundary.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary.c1_int ORDER BY test_boundary.c1_int ASC""", + s"""SELECT test_boundary_hive.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 ON test_boundary_hive.c1_int = test_boundary_hive1.c1_int WHERE test_boundary_hive.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary_hive.c1_int ORDER BY test_boundary_hive.c1_int ASC""", "QueriesBVATestCase_BVA_SPL_DATA_INT_049") + + } + + + //BVA_SPL_DATA_INT_050 + test("BVA_SPL_DATA_INT_050", Include) { + + checkAnswer(s"""SELECT test_boundary.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary1 ON test_boundary.c1_int = test_boundary1.c1_int WHERE test_boundary.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary.c1_int ORDER BY test_boundary.c1_int ASC""", + s"""SELECT test_boundary_hive.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 ON test_boundary_hive.c1_int = test_boundary_hive1.c1_int WHERE test_boundary_hive.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary_hive.c1_int ORDER BY test_boundary_hive.c1_int ASC""", "QueriesBVATestCase_BVA_SPL_DATA_INT_050") + + } + + + //BVA_SPL_DATA_INT_051 + test("BVA_SPL_DATA_INT_051", Include) { + + checkAnswer(s"""SELECT test_boundary.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary) SUB_QRY ) test_boundary1 ON test_boundary.c1_int = test_boundary1.c1_int WHERE test_boundary.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary.c1_int ORDER BY test_boundary.c1_int ASC""", + s"""SELECT test_boundary_hive.c1_int AS c1_int FROM ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive full JOIN ( SELECT c1_int FROM (select c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc from test_boundary_hive) SUB_QRY ) test_boundary_hive1 ON test_boundary_hive.c1_int = test_boundary_hive1.c1_int WHERE test_boundary_hive.c1_int <>12345678900987654321123456789012345678 GROUP BY test_boundary_hive.c1_int ORDER BY test_boundary_hive.c1_int ASC""", "QueriesBVATestCase_BVA_SPL_DATA_INT_051") + + } + + + //BVA_SPL_DATA_INT_052 + test("BVA_SPL_DATA_INT_052", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary group by c1_int having max(c1_int) >5000""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive group by c1_int having max(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_052") + + } + + + //BVA_SPL_DATA_INT_053 + test("BVA_SPL_DATA_INT_053", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary group by c1_int having max(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive group by c1_int having max(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_053") + + } + + + //BVA_SPL_DATA_INT_054 + test("BVA_SPL_DATA_INT_054", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary group by c1_int having max(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive group by c1_int having max(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_054") + + } + + + //BVA_SPL_DATA_INT_055 + test("BVA_SPL_DATA_INT_055", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary group by c1_int having max(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive group by c1_int having max(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_055") + + } + + + //BVA_SPL_DATA_INT_056 + test("BVA_SPL_DATA_INT_056", Include) { + + checkAnswer(s"""select c1_int,max(c1_int) from Test_Boundary group by c1_int having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,max(c1_int) from Test_Boundary_hive group by c1_int having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_056") + + } + + + //BVA_SPL_DATA_INT_060 + test("BVA_SPL_DATA_INT_060", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_060") + + } + + + //BVA_SPL_DATA_INT_062 + test("BVA_SPL_DATA_INT_062", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary group by c1_int having count(c1_int) >5000""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive group by c1_int having count(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_062") + + } + + + //BVA_SPL_DATA_INT_063 + test("BVA_SPL_DATA_INT_063", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary group by c1_int having count(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive group by c1_int having count(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_063") + + } + + + //BVA_SPL_DATA_INT_064 + test("BVA_SPL_DATA_INT_064", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary group by c1_int having count(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive group by c1_int having count(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_064") + + } + + + //BVA_SPL_DATA_INT_065 + test("BVA_SPL_DATA_INT_065", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary group by c1_int having count(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive group by c1_int having count(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_065") + + } + + + //BVA_SPL_DATA_INT_066 + test("BVA_SPL_DATA_INT_066", Include) { + + checkAnswer(s"""select c1_int,count(c1_int) from Test_Boundary group by c1_int having count(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,count(c1_int) from Test_Boundary_hive group by c1_int having count(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_066") + + } + + + //BVA_SPL_DATA_INT_071 + test("BVA_SPL_DATA_INT_071", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >5000""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_071") + + } + + + //BVA_SPL_DATA_INT_072 + test("BVA_SPL_DATA_INT_072", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_072") + + } + + + //BVA_SPL_DATA_INT_073 + test("BVA_SPL_DATA_INT_073", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_073") + + } + + + //BVA_SPL_DATA_INT_074 + test("BVA_SPL_DATA_INT_074", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_074") + + } + + + //BVA_SPL_DATA_INT_075 + test("BVA_SPL_DATA_INT_075", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_075") + + } + + + //BVA_SPL_DATA_INT_080 + test("BVA_SPL_DATA_INT_080", Include) { + + checkAnswer(s"""select c1_int,sum(c1_int) from Test_Boundary group by c1_int having sum(c1_int) >5000""", + s"""select c1_int,sum(c1_int) from Test_Boundary_hive group by c1_int having sum(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_080") + + } + + + //BVA_SPL_DATA_INT_081 + test("BVA_SPL_DATA_INT_081", Include) { + + checkAnswer(s"""select c1_int,sum(c1_int) from Test_Boundary group by c1_int having sum(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,sum(c1_int) from Test_Boundary_hive group by c1_int having sum(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_081") + + } + + + //BVA_SPL_DATA_INT_082 + test("BVA_SPL_DATA_INT_082", Include) { + + checkAnswer(s"""select c1_int,sum(c1_int) from Test_Boundary group by c1_int having sum(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,sum(c1_int) from Test_Boundary_hive group by c1_int having sum(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_082") + + } + + + //BVA_SPL_DATA_INT_083 + test("BVA_SPL_DATA_INT_083", Include) { + + checkAnswer(s"""select c1_int,sum(c1_int) from Test_Boundary group by c1_int having sum(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,sum(c1_int) from Test_Boundary_hive group by c1_int having sum(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_083") + + } + + + //BVA_SPL_DATA_INT_084 + test("BVA_SPL_DATA_INT_084", Include) { + + checkAnswer(s"""select c1_int,sum(c1_int) from Test_Boundary group by c1_int having sum(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,sum(c1_int) from Test_Boundary_hive group by c1_int having sum(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_084") + + } + + + //BVA_SPL_DATA_INT_089 + test("BVA_SPL_DATA_INT_089", Include) { + + checkAnswer(s"""select c1_int,avg(c1_int) from Test_Boundary group by c1_int having avg(c1_int) >5000""", + s"""select c1_int,avg(c1_int) from Test_Boundary_hive group by c1_int having avg(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_089") + + } + + + //BVA_SPL_DATA_INT_090 + test("BVA_SPL_DATA_INT_090", Include) { + + checkAnswer(s"""select c1_int,avg(c1_int) from Test_Boundary group by c1_int having avg(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,avg(c1_int) from Test_Boundary_hive group by c1_int having avg(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_090") + + } + + + //BVA_SPL_DATA_INT_091 + test("BVA_SPL_DATA_INT_091", Include) { + + checkAnswer(s"""select c1_int,avg(c1_int) from Test_Boundary group by c1_int having avg(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,avg(c1_int) from Test_Boundary_hive group by c1_int having avg(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_091") + + } + + + //BVA_SPL_DATA_INT_092 + test("BVA_SPL_DATA_INT_092", Include) { + + checkAnswer(s"""select c1_int,avg(c1_int) from Test_Boundary group by c1_int having avg(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,avg(c1_int) from Test_Boundary_hive group by c1_int having avg(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_092") + + } + + + //BVA_SPL_DATA_INT_093 + test("BVA_SPL_DATA_INT_093", Include) { + + checkAnswer(s"""select c1_int,avg(c1_int) from Test_Boundary group by c1_int having avg(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,avg(c1_int) from Test_Boundary_hive group by c1_int having avg(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_093") + + } + + + //BVA_SPL_DATA_INT_097 + test("BVA_SPL_DATA_INT_097", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) >5000""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_097") + + } + + + //BVA_SPL_DATA_INT_098 + test("BVA_SPL_DATA_INT_098", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_098") + + } + + + //BVA_SPL_DATA_INT_099 + test("BVA_SPL_DATA_INT_099", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_099") + + } + + + //BVA_SPL_DATA_INT_100 + test("BVA_SPL_DATA_INT_100", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_100") + + } + + + //BVA_SPL_DATA_INT_101 + test("BVA_SPL_DATA_INT_101", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_101") + + } + + + //BVA_SPL_DATA_INT_105 + test("BVA_SPL_DATA_INT_105", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive where c1_int =-2.147483648E9 or c1_int =2345 and c1_int = 4567 group by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_105") + + } + + + //BVA_SPL_DATA_INT_107 + test("BVA_SPL_DATA_INT_107", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having count(c1_int) >5000""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having count(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_107") + + } + + + //BVA_SPL_DATA_INT_108 + test("BVA_SPL_DATA_INT_108", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having count(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having count(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_108") + + } + + + //BVA_SPL_DATA_INT_109 + test("BVA_SPL_DATA_INT_109", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having count(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having count(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_109") + + } + + + //BVA_SPL_DATA_INT_110 + test("BVA_SPL_DATA_INT_110", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having count(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having count(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_110") + + } + + + //BVA_SPL_DATA_INT_111 + test("BVA_SPL_DATA_INT_111", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having count(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,count(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having count(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_111") + + } + + + //BVA_SPL_DATA_INT_116 + test("BVA_SPL_DATA_INT_116", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >5000""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_116") + + } + + + //BVA_SPL_DATA_INT_117 + test("BVA_SPL_DATA_INT_117", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_117") + + } + + + //BVA_SPL_DATA_INT_118 + test("BVA_SPL_DATA_INT_118", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_118") + + } + + + //BVA_SPL_DATA_INT_119 + test("BVA_SPL_DATA_INT_119", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_119") + + } + + + //BVA_SPL_DATA_INT_120 + test("BVA_SPL_DATA_INT_120", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_120") + + } + + + //BVA_SPL_DATA_INT_125 + test("BVA_SPL_DATA_INT_125", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having sum(c1_int) >5000""", + s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having sum(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_125") + + } + + + //BVA_SPL_DATA_INT_126 + test("BVA_SPL_DATA_INT_126", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_126") + + } + + + //BVA_SPL_DATA_INT_127 + test("BVA_SPL_DATA_INT_127", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_127") + + } + + + //BVA_SPL_DATA_INT_128 + test("BVA_SPL_DATA_INT_128", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having sum(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_128") + + } + + + //BVA_SPL_DATA_INT_129 + test("BVA_SPL_DATA_INT_129", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having sum(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,sum(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having sum(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_129") + + } + + + //BVA_SPL_DATA_INT_134 + test("BVA_SPL_DATA_INT_134", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having avg(c1_int) >5000""", + s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having avg(c1_int) >5000""", "QueriesBVATestCase_BVA_SPL_DATA_INT_134") + + } + + + //BVA_SPL_DATA_INT_135 + test("BVA_SPL_DATA_INT_135", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_135") + + } + + + //BVA_SPL_DATA_INT_136 + test("BVA_SPL_DATA_INT_136", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483648E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483648E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_136") + + } + + + //BVA_SPL_DATA_INT_137 + test("BVA_SPL_DATA_INT_137", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having avg(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_137") + + } + + + //BVA_SPL_DATA_INT_138 + test("BVA_SPL_DATA_INT_138", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having avg(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,avg(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having avg(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_138") + + } + + + //BVA_SPL_DATA_INT_142 + test("BVA_SPL_DATA_INT_142", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_142") + + } + + + //BVA_SPL_DATA_INT_143 + test("BVA_SPL_DATA_INT_143", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,max(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having max(c1_int) <-2.147483646E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_143") + + } + + + //BVA_SPL_DATA_INT_147 + test("BVA_SPL_DATA_INT_147", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >2.147483646E9 order by c1_int""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >2.147483646E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_147") + + } + + + //BVA_SPL_DATA_INT_148 + test("BVA_SPL_DATA_INT_148", Include) { + + checkAnswer(s"""select c1_int,min(c1_int) from Test_Boundary group by c1_int having min(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,min(c1_int) from Test_Boundary_hive group by c1_int having min(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_148") + + } + + + //BVA_SPL_DATA_INT_149 + test("BVA_SPL_DATA_INT_149", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_149") + + } + + + //BVA_SPL_DATA_INT_150 + test("BVA_SPL_DATA_INT_150", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int""", "QueriesBVATestCase_BVA_SPL_DATA_INT_150") + + } + + + //BVA_SPL_DATA_INT_151 + test("BVA_SPL_DATA_INT_151", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc asc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc asc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_151") + + } + + + //BVA_SPL_DATA_INT_152 + test("BVA_SPL_DATA_INT_152", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int asc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int asc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_152") + + } + + + //BVA_SPL_DATA_INT_153 + test("BVA_SPL_DATA_INT_153", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc desc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_153") + + } + + + //BVA_SPL_DATA_INT_154 + test("BVA_SPL_DATA_INT_154", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int desc""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int desc""", "QueriesBVATestCase_BVA_SPL_DATA_INT_154") + + } + + + //BVA_SPL_DATA_INT_155 + test("BVA_SPL_DATA_INT_155", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc limit 5""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483646E9 order by c1_int,c7_datatype_desc limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_155") + + } + + + //BVA_SPL_DATA_INT_156 + test("BVA_SPL_DATA_INT_156", Include) { + + checkAnswer(s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int limit 5""", + s"""select c1_int,c7_datatype_desc,min(c1_int) from Test_Boundary_hive group by c1_int,c7_datatype_desc having min(c1_int) >2.147483648E9 order by c1_int limit 5""", "QueriesBVATestCase_BVA_SPL_DATA_INT_156") + + } + + + //BVA_SPL_DATA_INT_166 + test("BVA_SPL_DATA_INT_166", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int between -9223372036854775808 and 9223372036854775807 """, + s"""select c1_int from Test_Boundary_hive where c1_int between -9223372036854775808 and 9223372036854775807 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_166") + + } + + + //BVA_SPL_DATA_INT_167 + test("BVA_SPL_DATA_INT_167", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int not between -9223372036854775808 and 0 """, + s"""select c1_int from Test_Boundary_hive where c1_int not between -9223372036854775808 and 0 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_167") + + } + + + //BVA_SPL_DATA_INT_168 + test("BVA_SPL_DATA_INT_168", Include) { + + checkAnswer(s"""select c1_int from Test_Boundary where c1_int not between 0 and 9223372036854775807""", + s"""select c1_int from Test_Boundary_hive where c1_int not between 0 and 9223372036854775807""", "QueriesBVATestCase_BVA_SPL_DATA_INT_168") + + } + + + //BVA_SPL_DATA_INT_169 + test("BVA_SPL_DATA_INT_169", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int is null""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int is null""", "QueriesBVATestCase_BVA_SPL_DATA_INT_169") + + } + + + //BVA_SPL_DATA_INT_170 + test("BVA_SPL_DATA_INT_170", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int is not null""", + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int is not null""", "QueriesBVATestCase_BVA_SPL_DATA_INT_170") + + } + + + //BVA_SPL_DATA_INT_171 + test("BVA_SPL_DATA_INT_171", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int not like 123 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int not like 123 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_171") + + } + + + //BVA_SPL_DATA_INT_172 + test("BVA_SPL_DATA_INT_172", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int like 123 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int like 123 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_172") + + } + + + //BVA_SPL_DATA_INT_173 + test("BVA_SPL_DATA_INT_173", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int rlike 123 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int rlike 123 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_173") + + } + + + //BVA_SPL_DATA_INT_174 + test("BVA_SPL_DATA_INT_174", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int regexp 123 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int regexp 123 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_174") + + } + + + //BVA_SPL_DATA_INT_175 + test("BVA_SPL_DATA_INT_175", Include) { + + checkAnswer(s"""select c1_int+0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int+0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_175") + + } + + + //BVA_SPL_DATA_INT_176 + test("BVA_SPL_DATA_INT_176", Include) { + + checkAnswer(s"""select c1_int+0.00100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int+0.00100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_176") + + } + + + //BVA_SPL_DATA_INT_177 + test("BVA_SPL_DATA_INT_177", Include) { + + sql(s"""select c1_int+23 from Test_Boundary where c1_int < 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_178 + test("BVA_SPL_DATA_INT_178", Include) { + + sql(s"""select c1_int+50 from Test_Boundary where c1_int <= 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_179 + test("BVA_SPL_DATA_INT_179", Include) { + + checkAnswer(s"""select c1_int+0.50 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int+0.50 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_179") + + } + + + //BVA_SPL_DATA_INT_180 + test("BVA_SPL_DATA_INT_180", Include) { + + sql(s"""select c1_int+75 from Test_Boundary where c1_int >= 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_181 + test("BVA_SPL_DATA_INT_181", Include) { + + checkAnswer(s"""select c1_int-0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int-0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_181") + + } + + + //BVA_SPL_DATA_INT_182 + test("BVA_SPL_DATA_INT_182", Include) { + + checkAnswer(s"""select c1_int-0.00100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int-0.00100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_182") + + } + + + //BVA_SPL_DATA_INT_183 + test("BVA_SPL_DATA_INT_183", Include) { + + sql(s"""select c1_int-23 from Test_Boundary where c1_int < 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_184 + test("BVA_SPL_DATA_INT_184", Include) { + + sql(s"""select c1_int-50 from Test_Boundary where c1_int <= 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_185 + test("BVA_SPL_DATA_INT_185", Include) { + + checkAnswer(s"""select c1_int-0.50 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int-0.50 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_185") + + } + + + //BVA_SPL_DATA_INT_186 + test("BVA_SPL_DATA_INT_186", Include) { + + checkAnswer(s"""select c1_int-75 from Test_Boundary where c1_int >= 2.147483647E9 """, + s"""select c1_int-75 from Test_Boundary_hive where c1_int >= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_186") + + } + + + //BVA_SPL_DATA_INT_187 + test("BVA_SPL_DATA_INT_187", Include) { + + checkAnswer(s"""select c1_int*0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int*0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_187") + + } + + + //BVA_SPL_DATA_INT_188 + test("BVA_SPL_DATA_INT_188", Include) { + + checkAnswer(s"""select c1_int*0.00100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int*0.00100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_188") + + } + + + //BVA_SPL_DATA_INT_189 + test("BVA_SPL_DATA_INT_189", Include) { + + sql(s"""select c1_int*23 from Test_Boundary where c1_int < 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_190 + test("BVA_SPL_DATA_INT_190", Include) { + + sql(s"""select c1_int*50 from Test_Boundary where c1_int <= 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_191 + test("BVA_SPL_DATA_INT_191", Include) { + + checkAnswer(s"""select c1_int*0.50 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int*0.50 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_191") + + } + + + //BVA_SPL_DATA_INT_192 + test("BVA_SPL_DATA_INT_192", Include) { + + sql(s"""select c1_int*75 from Test_Boundary where c1_int >= 2.147483647E9 """).collect + + } + + + //BVA_SPL_DATA_INT_193 + test("BVA_SPL_DATA_INT_193", Include) { + + checkAnswer(s"""select c1_int/0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int/0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_193") + + } + + + //BVA_SPL_DATA_INT_194 + test("BVA_SPL_DATA_INT_194", Include) { + + checkAnswer(s"""select c1_int/0.00100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int/0.00100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_194") + + } + + + //BVA_SPL_DATA_INT_195 + test("BVA_SPL_DATA_INT_195", Include) { + + checkAnswer(s"""select c1_int/23 from Test_Boundary where c1_int < 2.147483647E9 """, + s"""select c1_int/23 from Test_Boundary_hive where c1_int < 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_195") + + } + + + //BVA_SPL_DATA_INT_196 + test("BVA_SPL_DATA_INT_196", Include) { + + checkAnswer(s"""select c1_int/50 from Test_Boundary where c1_int <= 2.147483647E9 """, + s"""select c1_int/50 from Test_Boundary_hive where c1_int <= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_196") + + } + + + //BVA_SPL_DATA_INT_197 + test("BVA_SPL_DATA_INT_197", Include) { + + checkAnswer(s"""select c1_int/0.50 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int/0.50 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_197") + + } + + + //BVA_SPL_DATA_INT_198 + test("BVA_SPL_DATA_INT_198", Include) { + + checkAnswer(s"""select c1_int/75 from Test_Boundary where c1_int >= 2.147483647E9 """, + s"""select c1_int/75 from Test_Boundary_hive where c1_int >= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_198") + + } + + + //BVA_SPL_DATA_INT_199 + test("BVA_SPL_DATA_INT_199", Include) { + + checkAnswer(s"""select c1_int%0.100 from Test_Boundary where c1_int <> 2.147483647E9 """, + s"""select c1_int%0.100 from Test_Boundary_hive where c1_int <> 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_199") + + } + + + //BVA_SPL_DATA_INT_200 + test("BVA_SPL_DATA_INT_200", Include) { + + checkAnswer(s"""select c1_int%0.00100 from Test_Boundary where c1_int = 2.147483647E9 """, + s"""select c1_int%0.00100 from Test_Boundary_hive where c1_int = 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_200") + + } + + + //BVA_SPL_DATA_INT_201 + test("BVA_SPL_DATA_INT_201", Include) { + + checkAnswer(s"""select c1_int%23 from Test_Boundary where c1_int < 2.147483647E9 """, + s"""select c1_int%23 from Test_Boundary_hive where c1_int < 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_201") + + } + + + //BVA_SPL_DATA_INT_202 + test("BVA_SPL_DATA_INT_202", Include) { + + checkAnswer(s"""select c1_int%50 from Test_Boundary where c1_int <= 2.147483647E9 """, + s"""select c1_int%50 from Test_Boundary_hive where c1_int <= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_202") + + } + + + //BVA_SPL_DATA_INT_203 + test("BVA_SPL_DATA_INT_203", Include) { + + checkAnswer(s"""select c1_int%0.50 from Test_Boundary where c1_int > 2.147483647E9 """, + s"""select c1_int%0.50 from Test_Boundary_hive where c1_int > 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_203") + + } + + + //BVA_SPL_DATA_INT_204 + test("BVA_SPL_DATA_INT_204", Include) { + + checkAnswer(s"""select c1_int%75 from Test_Boundary where c1_int >= 2.147483647E9 """, + s"""select c1_int%75 from Test_Boundary_hive where c1_int >= 2.147483647E9 """, "QueriesBVATestCase_BVA_SPL_DATA_INT_204") + + } + + + //BVA_SPL_DATA_INT_205 + test("BVA_SPL_DATA_INT_205", Include) { + + checkAnswer(s"""select round(c1_int,1) from test_boundary""", + s"""select round(c1_int,1) from test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_205") + + } + + + //BVA_SPL_DATA_INT_206 + test("BVA_SPL_DATA_INT_206", Include) { + + checkAnswer(s"""select round(c1_int,1) from test_boundary""", + s"""select round(c1_int,1) from test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_206") + + } + + + //BVA_SPL_DATA_INT_207 + test("BVA_SPL_DATA_INT_207", Include) { + + checkAnswer(s"""select bround(c1_int) from test_boundary""", + s"""select bround(c1_int) from test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_207") + + } + + + //BVA_SPL_DATA_INT_208 + test("BVA_SPL_DATA_INT_208", Include) { + + checkAnswer(s"""select bround(c1_int) from test_boundary""", + s"""select bround(c1_int) from test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_208") + + } + + + //BVA_SPL_DATA_INT_209 + test("BVA_SPL_DATA_INT_209", Include) { + + checkAnswer(s"""select floor(c1_int) from test_boundary """, + s"""select floor(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_209") + + } + + + //BVA_SPL_DATA_INT_210 + test("BVA_SPL_DATA_INT_210", Include) { + + checkAnswer(s"""select ceil(c1_int) from test_boundary""", + s"""select ceil(c1_int) from test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_210") + + } + + + //BVA_SPL_DATA_INT_211 + test("BVA_SPL_DATA_INT_211", Include) { + + sql(s"""select rand(5) from test_boundary """).collect + + } + + + //BVA_SPL_DATA_INT_212 + test("BVA_SPL_DATA_INT_212", Include) { + + checkAnswer(s"""select exp(c1_int) from Test_Boundary""", + s"""select exp(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_212") + + } + + + //BVA_SPL_DATA_INT_213 + test("BVA_SPL_DATA_INT_213", Include) { + + checkAnswer(s"""select ln(c1_int) from Test_Boundary""", + s"""select ln(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_213") + + } + + + //BVA_SPL_DATA_INT_214 + test("BVA_SPL_DATA_INT_214", Include) { + + checkAnswer(s"""select log10(c1_int) from Test_Boundary""", + s"""select log10(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_214") + + } + + + //BVA_SPL_DATA_INT_215 + test("BVA_SPL_DATA_INT_215", Include) { + + checkAnswer(s"""select log2(c1_int) from Test_Boundary""", + s"""select log2(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_215") + + } + + + //BVA_SPL_DATA_INT_216 + test("BVA_SPL_DATA_INT_216", Include) { + + checkAnswer(s"""select log(c1_int) from Test_Boundary""", + s"""select log(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_216") + + } + + + //BVA_SPL_DATA_INT_217 + test("BVA_SPL_DATA_INT_217", Include) { + + checkAnswer(s"""select log(c1_int) from Test_Boundary""", + s"""select log(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_217") + + } + + + //BVA_SPL_DATA_INT_218 + test("BVA_SPL_DATA_INT_218", Include) { + + checkAnswer(s"""select pow(c1_int,c1_int) from Test_Boundary""", + s"""select pow(c1_int,c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_218") + + } + + + //BVA_SPL_DATA_INT_219 + test("BVA_SPL_DATA_INT_219", Include) { + + checkAnswer(s"""select sqrt(c1_int) from Test_Boundary""", + s"""select sqrt(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_219") + + } + + + //BVA_SPL_DATA_INT_220 + test("BVA_SPL_DATA_INT_220", Include) { + + checkAnswer(s"""select pmod(c1_int,1) from Test_Boundary""", + s"""select pmod(c1_int,1) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_220") + + } + + + //BVA_SPL_DATA_INT_221 + test("BVA_SPL_DATA_INT_221", Include) { + + checkAnswer(s"""select sin(c1_int) from test_boundary """, + s"""select sin(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_221") + + } + + + //BVA_SPL_DATA_INT_222 + test("BVA_SPL_DATA_INT_222", Include) { + + checkAnswer(s"""select asin(c1_int) from test_boundary """, + s"""select asin(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_222") + + } + + + //BVA_SPL_DATA_INT_223 + test("BVA_SPL_DATA_INT_223", Include) { + + checkAnswer(s"""select cos(c1_int) from test_boundary """, + s"""select cos(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_223") + + } + + + //BVA_SPL_DATA_INT_224 + test("BVA_SPL_DATA_INT_224", Include) { + + checkAnswer(s"""select acos(c1_int) from test_boundary """, + s"""select acos(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_224") + + } + + + //BVA_SPL_DATA_INT_225 + test("BVA_SPL_DATA_INT_225", Include) { + + checkAnswer(s"""select tan(c1_int) from test_boundary """, + s"""select tan(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_225") + + } + + + //BVA_SPL_DATA_INT_226 + test("BVA_SPL_DATA_INT_226", Include) { + + checkAnswer(s"""select atan(c1_int) from test_boundary """, + s"""select atan(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_226") + + } + + + //BVA_SPL_DATA_INT_227 + test("BVA_SPL_DATA_INT_227", Include) { + + checkAnswer(s"""select degrees(c1_int) from test_boundary """, + s"""select degrees(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_227") + + } + + + //BVA_SPL_DATA_INT_228 + test("BVA_SPL_DATA_INT_228", Include) { + + checkAnswer(s"""select radians(c1_int) from test_boundary """, + s"""select radians(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_228") + + } + + + //BVA_SPL_DATA_INT_229 + test("BVA_SPL_DATA_INT_229", Include) { + + checkAnswer(s"""select positive(c1_int) from test_boundary """, + s"""select positive(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_229") + + } + + + //BVA_SPL_DATA_INT_230 + test("BVA_SPL_DATA_INT_230", Include) { + + sql(s"""select negative(c1_int) from test_boundary """).collect + + } + + + //BVA_SPL_DATA_INT_231 + test("BVA_SPL_DATA_INT_231", Include) { + + checkAnswer(s"""select sign(c1_int) from test_boundary """, + s"""select sign(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_231") + + } + + + //BVA_SPL_DATA_INT_232 + test("BVA_SPL_DATA_INT_232", Include) { + + checkAnswer(s"""select exp(c1_int) from test_boundary """, + s"""select exp(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_232") + + } + + + //BVA_SPL_DATA_INT_234 + test("BVA_SPL_DATA_INT_234", Include) { + + checkAnswer(s"""select factorial(c1_int) from test_boundary """, + s"""select factorial(c1_int) from test_boundary_hive """, "QueriesBVATestCase_BVA_SPL_DATA_INT_234") + + } + + + //BVA_SPL_DATA_INT_235 + test("BVA_SPL_DATA_INT_235", Include) { + + checkAnswer(s"""select cbrt(c1_int) from Test_Boundary""", + s"""select cbrt(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_235") + + } + + + //BVA_SPL_DATA_INT_236 + test("BVA_SPL_DATA_INT_236", Include) { + + sql(s"""select shiftleft(c1_int,2) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_238 + test("BVA_SPL_DATA_INT_238", Include) { + + checkAnswer(s"""select shiftright(c1_int,2) from Test_Boundary""", + s"""select shiftright(c1_int,2) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_238") + + } + + + //BVA_SPL_DATA_INT_239 + test("BVA_SPL_DATA_INT_239", Include) { + + checkAnswer(s"""select shiftright(c1_int,2) from Test_Boundary""", + s"""select shiftright(c1_int,2) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_239") + + } + + + //BVA_SPL_DATA_INT_240 + test("BVA_SPL_DATA_INT_240", Include) { + + sql(s"""select shiftrightunsigned(c1_int,2) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_242 + test("BVA_SPL_DATA_INT_242", Include) { + + checkAnswer(s"""select greatest(1,2,3,4,5) from Test_Boundary""", + s"""select greatest(1,2,3,4,5) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_242") + + } + + + //BVA_SPL_DATA_INT_243 + test("BVA_SPL_DATA_INT_243", Include) { + + checkAnswer(s"""select least(1,2,3,4,5) from Test_Boundary""", + s"""select least(1,2,3,4,5) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_243") + + } + + + //BVA_SPL_DATA_INT_244 + test("BVA_SPL_DATA_INT_244", Include) { + + checkAnswer(s"""select cast(c1_int as double) from Test_Boundary""", + s"""select cast(c1_int as double) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_244") + + } + + + //BVA_SPL_DATA_INT_245 + test("BVA_SPL_DATA_INT_245", Include) { + + checkAnswer(s"""select if(c1_int<5000,'t','f') from Test_Boundary""", + s"""select if(c1_int<5000,'t','f') from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_245") + + } + + + //BVA_SPL_DATA_INT_246 + test("BVA_SPL_DATA_INT_246", Include) { + + checkAnswer(s"""select isnull(c1_int) from Test_Boundary""", + s"""select isnull(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_246") + + } + + + //BVA_SPL_DATA_INT_247 + test("BVA_SPL_DATA_INT_247", Include) { + + checkAnswer(s"""select isnotnull(c1_int) from Test_Boundary""", + s"""select isnotnull(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_247") + + } + + + //BVA_SPL_DATA_INT_248 + test("BVA_SPL_DATA_INT_248", Include) { + + checkAnswer(s"""select nvl(c1_int,10) from Test_Boundary""", + s"""select nvl(c1_int,10) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_248") + + } + + + //BVA_SPL_DATA_INT_249 + test("BVA_SPL_DATA_INT_249", Include) { + + checkAnswer(s"""select nvl(c1_int,0) from Test_Boundary""", + s"""select nvl(c1_int,0) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_249") + + } + + + //BVA_SPL_DATA_INT_250 + test("BVA_SPL_DATA_INT_250", Include) { + + checkAnswer(s"""select nvl(c1_int,null) from Test_Boundary""", + s"""select nvl(c1_int,null) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_250") + + } + + + //BVA_SPL_DATA_INT_251 + test("BVA_SPL_DATA_INT_251", Include) { + + checkAnswer(s"""select coalesce(c1_int,null,null,null,756) from Test_Boundary""", + s"""select coalesce(c1_int,null,null,null,756) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_251") + + } + + + //BVA_SPL_DATA_INT_252 + test("BVA_SPL_DATA_INT_252", Include) { + + checkAnswer(s"""select coalesce(c1_int,1,null,null,756) from Test_Boundary""", + s"""select coalesce(c1_int,1,null,null,756) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_252") + + } + + + //BVA_SPL_DATA_INT_253 + test("BVA_SPL_DATA_INT_253", Include) { + + checkAnswer(s"""select coalesce(c1_int,345,null,756) from Test_Boundary""", + s"""select coalesce(c1_int,345,null,756) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_253") + + } + + + //BVA_SPL_DATA_INT_254 + test("BVA_SPL_DATA_INT_254", Include) { + + checkAnswer(s"""select coalesce(c1_int,345,0.1,456,756) from Test_Boundary""", + s"""select coalesce(c1_int,345,0.1,456,756) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_254") + + } + + + //BVA_SPL_DATA_INT_255 + test("BVA_SPL_DATA_INT_255", Include) { + + checkAnswer(s"""select coalesce(c1_int,756,null,null,null) from Test_Boundary""", + s"""select coalesce(c1_int,756,null,null,null) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_255") + + } + + + //BVA_SPL_DATA_INT_256 + test("BVA_SPL_DATA_INT_256", Include) { + + checkAnswer(s"""select case c1_int when 2345 then true else false end from Test_boundary""", + s"""select case c1_int when 2345 then true else false end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_256") + + } + + + //BVA_SPL_DATA_INT_257 + test("BVA_SPL_DATA_INT_257", Include) { + + checkAnswer(s"""select case c1_int when 2345 then true end from Test_boundary""", + s"""select case c1_int when 2345 then true end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_257") + + } + + + //BVA_SPL_DATA_INT_258 + test("BVA_SPL_DATA_INT_258", Include) { + + checkAnswer(s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary""", + s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_258") + + } + + + //BVA_SPL_DATA_INT_259 + test("BVA_SPL_DATA_INT_259", Include) { + + checkAnswer(s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary""", + s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_259") + + } + + + //BVA_SPL_DATA_INT_260 + test("BVA_SPL_DATA_INT_260", Include) { + + checkAnswer(s"""select case when c1_int <2345 then 1000 else c1_int end from Test_boundary""", + s"""select case when c1_int <2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_260") + + } + + + //BVA_SPL_DATA_INT_261 + test("BVA_SPL_DATA_INT_261", Include) { + + checkAnswer(s"""select case c1_int when 2345 then true else false end from Test_boundary""", + s"""select case c1_int when 2345 then true else false end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_261") + + } + + + //BVA_SPL_DATA_INT_262 + test("BVA_SPL_DATA_INT_262", Include) { + + checkAnswer(s"""select case c1_int when 2345 then true end from Test_boundary""", + s"""select case c1_int when 2345 then true end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_262") + + } + + + //BVA_SPL_DATA_INT_263 + test("BVA_SPL_DATA_INT_263", Include) { + + checkAnswer(s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary""", + s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_263") + + } + + + //BVA_SPL_DATA_INT_264 + test("BVA_SPL_DATA_INT_264", Include) { + + checkAnswer(s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary""", + s"""select case c1_int when 2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_264") + + } + + + //BVA_SPL_DATA_INT_265 + test("BVA_SPL_DATA_INT_265", Include) { + + checkAnswer(s"""select case when c1_int <2345 then 1000 else c1_int end from Test_boundary""", + s"""select case when c1_int <2345 then 1000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_265") + + } + + + //BVA_SPL_DATA_INT_266 + test("BVA_SPL_DATA_INT_266", Include) { + + checkAnswer(s"""select case when c1_int <2345 then 1000 when c1_int >2535353535 then 1000000000 else c1_int end from Test_boundary""", + s"""select case when c1_int <2345 then 1000 when c1_int >2535353535 then 1000000000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_266") + + } + + + //BVA_SPL_DATA_INT_267 + test("BVA_SPL_DATA_INT_267", Include) { + + checkAnswer(s"""select case when c1_int <2345 then 1000 when c1_int is null then 1000000000 else c1_int end from Test_boundary""", + s"""select case when c1_int <2345 then 1000 when c1_int is null then 1000000000 else c1_int end from Test_boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_267") + + } + + + //BVA_SPL_DATA_INT_268 + test("BVA_SPL_DATA_INT_268", Include) { + + checkAnswer(s"""select distinct count(*) from Test_Boundary""", + s"""select distinct count(*) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_268") + + } + + + //BVA_SPL_DATA_INT_269 + test("BVA_SPL_DATA_INT_269", Include) { + + checkAnswer(s"""select distinct count(c1_int) from Test_Boundary""", + s"""select distinct count(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_269") + + } + + + //BVA_SPL_DATA_INT_270 + test("BVA_SPL_DATA_INT_270", Include) { + + checkAnswer(s"""select max(c1_int) from Test_Boundary""", + s"""select max(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_270") + + } + + + //BVA_SPL_DATA_INT_271 + test("BVA_SPL_DATA_INT_271", Include) { + + checkAnswer(s"""select count(distinct (c1_int)) from Test_Boundary""", + s"""select count(distinct (c1_int)) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_271") + + } + + + //BVA_SPL_DATA_INT_272 + test("BVA_SPL_DATA_INT_272", Include) { + + checkAnswer(s"""select distinct sum(c1_int) from Test_Boundary""", + s"""select distinct sum(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_272") + + } + + + //BVA_SPL_DATA_INT_273 + test("BVA_SPL_DATA_INT_273", Include) { + + checkAnswer(s"""select sum(distinct c1_int) from Test_Boundary""", + s"""select sum(distinct c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_273") + + } + + + //BVA_SPL_DATA_INT_274 + test("BVA_SPL_DATA_INT_274", Include) { + + checkAnswer(s"""select distinct avg(c1_int) from Test_Boundary""", + s"""select distinct avg(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_274") + + } + + + //BVA_SPL_DATA_INT_275 + test("BVA_SPL_DATA_INT_275", Include) { + + checkAnswer(s"""select avg( c1_int) from Test_Boundary""", + s"""select avg( c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_275") + + } + + + //BVA_SPL_DATA_INT_276 + test("BVA_SPL_DATA_INT_276", Include) { + + checkAnswer(s"""select min(c1_int) from Test_Boundary""", + s"""select min(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_276") + + } + + + //BVA_SPL_DATA_INT_277 + test("BVA_SPL_DATA_INT_277", Include) { + + checkAnswer(s"""select distinct min(c1_int) from Test_Boundary""", + s"""select distinct min(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_277") + + } + + + //BVA_SPL_DATA_INT_278 + test("BVA_SPL_DATA_INT_278", Include) { + + checkAnswer(s"""select max(c1_int) from Test_Boundary""", + s"""select max(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_278") + + } + + + //BVA_SPL_DATA_INT_279 + test("BVA_SPL_DATA_INT_279", Include) { + + sql(s"""select variance(c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_280 + test("BVA_SPL_DATA_INT_280", Include) { + + sql(s"""select var_samp(c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_281 + test("BVA_SPL_DATA_INT_281", Include) { + + checkAnswer(s"""select stddev_pop(c1_int) from Test_Boundary""", + s"""select stddev_pop(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_281") + + } + + + //BVA_SPL_DATA_INT_282 + test("BVA_SPL_DATA_INT_282", Include) { + + checkAnswer(s"""select stddev_samp(c1_int) from Test_Boundary""", + s"""select stddev_samp(c1_int) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_282") + + } + + + //BVA_SPL_DATA_INT_283 + test("BVA_SPL_DATA_INT_283", Include) { + + sql(s"""select covar_pop(c1_int,c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_284 + test("BVA_SPL_DATA_INT_284", Include) { + + sql(s"""select covar_samp(c1_int,c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_285 + test("BVA_SPL_DATA_INT_285", Include) { + + checkAnswer(s"""select corr(c1_int,1) from Test_Boundary""", + s"""select corr(c1_int,1) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_285") + + } + + + //BVA_SPL_DATA_INT_286 + test("BVA_SPL_DATA_INT_286", Include) { + + checkAnswer(s"""select percentile(c1_int,0.5) from Test_Boundary""", + s"""select percentile(c1_int,0.5) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_286") + + } + + + //BVA_SPL_DATA_INT_287 + test("BVA_SPL_DATA_INT_287", Include) { + + sql(s"""select histogram_numeric(c1_int,2) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_288 + test("BVA_SPL_DATA_INT_288", Include) { + + sql(s"""select collect_set(c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_289 + test("BVA_SPL_DATA_INT_289", Include) { + + sql(s"""select collect_list(c1_int) from Test_Boundary""").collect + + } + + + //BVA_SPL_DATA_INT_290 + test("BVA_SPL_DATA_INT_290", Include) { + + checkAnswer(s"""select cast(c1_int as double) from Test_Boundary""", + s"""select cast(c1_int as double) from Test_Boundary_hive""", "QueriesBVATestCase_BVA_SPL_DATA_INT_290") + + } + + + //BVA_SPL_DATA_BIGINT_001 + test("BVA_SPL_DATA_BIGINT_001", Include) { + + checkAnswer(s"""select c2_bigint from test_boundary where c2_bigint in (9223372036854775807,2345.0,1234.0)""", + s"""select c2_bigint from test_boundary_hive where c2_bigint in (9223372036854775807,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_001") + + } + + + //BVA_SPL_DATA_BIGINT_002 + test("BVA_SPL_DATA_BIGINT_002", Include) { + + checkAnswer(s"""select c2_bigint from test_boundary where c2_bigint in (-9223372036854775808,2345.0,-1234.0)""", + s"""select c2_bigint from test_boundary_hive where c2_bigint in (-9223372036854775808,2345.0,-1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_002") + + } + + + //BVA_SPL_DATA_BIGINT_003 + test("BVA_SPL_DATA_BIGINT_003", Include) { + + checkAnswer(s"""select c2_bigint from test_boundary where c2_bigint in (0,-1234.0)""", + s"""select c2_bigint from test_boundary_hive where c2_bigint in (0,-1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_003") + + } + + + //BVA_SPL_DATA_BIGINT_004 + test("BVA_SPL_DATA_BIGINT_004", Include) { + + checkAnswer(s"""select c2_bigint from test_boundary where c2_bigint not in (9223372036854775807,2345.0,1234.0)""", + s"""select c2_bigint from test_boundary_hive where c2_bigint not in (9223372036854775807,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_004") + + } + + + //BVA_SPL_DATA_BIGINT_005 + test("BVA_SPL_DATA_BIGINT_005", Include) { + + checkAnswer(s"""select c2_bigint from test_boundary where c2_bigint in (9223372036854775807,2345.0,1234.0)""", + s"""select c2_bigint from test_boundary_hive where c2_bigint in (9223372036854775807,2345.0,1234.0)""", "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_005") + + } + + + //BVA_SPL_DATA_BIGINT_006 + test("BVA_SPL_DATA_BIGINT_006", Include) { + + checkAnswer(s"""select c2_bigint+0.100 from Test_Boundary where c2_bigint < 9223372036854775807 """, + s"""select c2_bigint+0.100 from Test_Boundary_hive where c2_bigint < 9223372036854775807 """, "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_006") + + } + + + //BVA_SPL_DATA_BIGINT_007 + test("BVA_SPL_DATA_BIGINT_007", Include) { + + checkAnswer(s"""select c2_bigint+0.9 from Test_Boundary where c2_bigint > 9223372036854775807 """, + s"""select c2_bigint+0.9 from Test_Boundary_hive where c2_bigint > 9223372036854775807 """, "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_007") + + } + + + //BVA_SPL_DATA_BIGINT_008 + test("BVA_SPL_DATA_BIGINT_008", Include) { + + checkAnswer(s"""select c2_bigint+0.9 from Test_Boundary where c2_bigint >= 9223372036854775807 """, + s"""select c2_bigint+0.9 from Test_Boundary_hive where c2_bigint >= 9223372036854775807 """, "QueriesBVATestCase_BVA_SPL_DATA_BIGINT_008") + + } + + + //BVA_SPL_DATA_BIGINT_009 + test("BVA_SPL_DATA_BIGINT_009", Include) { + + checkAnswer(s"""select c2_bigint+0.100 from Test_Boundary where c2_bigint <= 9223372036854775807 """, + s"""select c2_bigint+0.100 from Test_Boundary_hive where c2_bigint <= 92233720368547758
<TRUNCATED>
