You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ch...@apache.org on 2017/08/01 06:00:18 UTC
[11/20] carbondata git commit: [CARBONDATA-1346] SDV cluster tests
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>