carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chenliang...@apache.org
Subject [11/20] carbondata git commit: [CARBONDATA-1346] SDV cluster tests
Date Tue, 01 Aug 2017 06:00:18 GMT
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>

Mime
View raw message