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/QueriesBasicTestCase.scala ---------------------------------------------------------------------- diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBasicTestCase.scala b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBasicTestCase.scala new file mode 100644 index 0000000..3ca982c --- /dev/null +++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesBasicTestCase.scala @@ -0,0 +1,13884 @@ + +/* + * 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.Row +import org.apache.spark.sql.common.util._ +import org.scalatest.BeforeAndAfterAll + +import org.apache.carbondata.core.util.CarbonProperties + +/** + * Test Class for QueriesBasicTestCase to verify all scenerios + */ + +class QueriesBasicTestCase extends QueryTest with BeforeAndAfterAll { + + + + + + //UNIQDATA_CreateTable + test("UNIQDATA_CreateTable", Include) { + sql(s"""drop table if exists uniqdata""").collect + sql(s"""drop table if exists uniqdata_hive""").collect + + sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format'""").collect + + sql(s"""CREATE TABLE uniqdata_hive (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','""").collect + + + } + + + //UNIQDATA_DataLoad1 + test("UNIQDATA_DataLoad1", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/2000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/2000_UniqData.csv' into table uniqdata_hive """).collect + + + } + + + //UNIQDATA_DataLoad2 + test("UNIQDATA_DataLoad2", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/3000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + } + + + //UNIQDATA_DataLoad3 + test("UNIQDATA_DataLoad3", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/4000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/4000_UniqData.csv' into table uniqdata_hive """).collect + + + } + + + //UNIQDATA_DataLoad4 + test("UNIQDATA_DataLoad4", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/5000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + } + + + //UNIQDATA_DataLoad5 + test("UNIQDATA_DataLoad5", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/6000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/6000_UniqData.csv' into table uniqdata_hive """).collect + + + } + + + //UNIQDATA_DataLoad6 + test("UNIQDATA_DataLoad6", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/7000_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/7000_UniqData.csv' into table uniqdata_hive """).collect + + + } + + + //UNIQDATA_DataLoad7 + test("UNIQDATA_DataLoad7", Include) { + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/3000_1_UniqData.csv' into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect + + sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/3000_1_UniqData.csv' into table uniqdata_hive """).collect + } + + test("UNIQDATA_DeleteLoad1_3", Include) { + sql(s"""delete from table uniqdata where segment.id in (1,3)""").collect + } + + + //UNIQDATA_DEFAULT_TC001 + test("UNIQDATA_DEFAULT_TC001", Include) { + + checkAnswer(s"""Select count(CUST_NAME) from UNIQDATA""", + s"""Select count(CUST_NAME) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC001") + + } + + + //UNIQDATA_DEFAULT_TC002 + test("UNIQDATA_DEFAULT_TC002", Include) { + + checkAnswer(s"""select count(DISTINCT CUST_NAME) as a from UNIQDATA""", + s"""select count(DISTINCT CUST_NAME) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC002") + + } + + + //UNIQDATA_DEFAULT_TC003 + test("UNIQDATA_DEFAULT_TC003", Include) { + + checkAnswer(s"""select sum(INTEGER_COLUMN1)+10 as a ,CUST_NAME from UNIQDATA group by CUST_NAME order by CUST_NAME""", + s"""select sum(INTEGER_COLUMN1)+10 as a ,CUST_NAME from UNIQDATA_hive group by CUST_NAME order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC003") + + } + + + //UNIQDATA_DEFAULT_TC004 + test("UNIQDATA_DEFAULT_TC004", Include) { + + checkAnswer(s"""select max(CUST_NAME),min(CUST_NAME) from UNIQDATA""", + s"""select max(CUST_NAME),min(CUST_NAME) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC004") + + } + + + //UNIQDATA_DEFAULT_TC005 + test("UNIQDATA_DEFAULT_TC005", Include) { + + checkAnswer(s"""select min(CUST_NAME), max(CUST_NAME) Total from UNIQDATA group by ACTIVE_EMUI_VERSION order by Total""", + s"""select min(CUST_NAME), max(CUST_NAME) Total from UNIQDATA_hive group by ACTIVE_EMUI_VERSION order by Total""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC005") + + } + + + //UNIQDATA_DEFAULT_TC006 + test("UNIQDATA_DEFAULT_TC006", Include) { + + checkAnswer(s"""select last(CUST_NAME) a from UNIQDATA group by CUST_NAME order by CUST_NAME limit 1""", + s"""select last(CUST_NAME) a from UNIQDATA_hive group by CUST_NAME order by CUST_NAME limit 1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC006") + + } + + + //UNIQDATA_DEFAULT_TC007 + test("UNIQDATA_DEFAULT_TC007", Include) { + + checkAnswer(s"""select FIRST(CUST_NAME) a from UNIQDATA group by CUST_NAME order by CUST_NAME limit 1""", + s"""select FIRST(CUST_NAME) a from UNIQDATA_hive group by CUST_NAME order by CUST_NAME limit 1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC007") + + } + + + //UNIQDATA_DEFAULT_TC008 + test("UNIQDATA_DEFAULT_TC008", Include) { + + checkAnswer(s"""select CUST_NAME,count(CUST_NAME) a from UNIQDATA group by CUST_NAME order by CUST_NAME""", + s"""select CUST_NAME,count(CUST_NAME) a from UNIQDATA_hive group by CUST_NAME order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC008") + + } + + + //UNIQDATA_DEFAULT_TC009 + test("UNIQDATA_DEFAULT_TC009", Include) { + + checkAnswer(s"""select Lower(CUST_NAME) a from UNIQDATA order by CUST_NAME""", + s"""select Lower(CUST_NAME) a from UNIQDATA_hive order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC009") + + } + + + //UNIQDATA_DEFAULT_TC010 + test("UNIQDATA_DEFAULT_TC010", Include) { + + checkAnswer(s"""select distinct CUST_NAME from UNIQDATA order by CUST_NAME""", + s"""select distinct CUST_NAME from UNIQDATA_hive order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC010") + + } + + + //UNIQDATA_DEFAULT_TC011 + test("UNIQDATA_DEFAULT_TC011", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA order by CUST_NAME limit 101 """, + s"""select CUST_NAME from UNIQDATA_hive order by CUST_NAME limit 101 """, "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC011") + + } + + + //UNIQDATA_DEFAULT_TC012 + test("UNIQDATA_DEFAULT_TC012", Include) { + + checkAnswer(s"""select CUST_NAME as a from UNIQDATA order by a asc limit 10""", + s"""select CUST_NAME as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC012") + + } + + + //UNIQDATA_DEFAULT_TC013 + test("UNIQDATA_DEFAULT_TC013", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01844')""", + s"""select CUST_NAME from UNIQDATA_hive where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01844')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC013") + + } + + + //UNIQDATA_DEFAULT_TC014 + test("UNIQDATA_DEFAULT_TC014", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME !='CUST_NAME_01844' order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME !='CUST_NAME_01844' order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC014") + + } + + + //UNIQDATA_DEFAULT_TC015 + test("UNIQDATA_DEFAULT_TC015", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select CUST_NAME from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC015") + + } + + + //UNIQDATA_DEFAULT_TC016 + test("UNIQDATA_DEFAULT_TC016", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME !='CUST_NAME_01840' order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME !='CUST_NAME_01840' order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC016") + + } + + + //UNIQDATA_DEFAULT_TC017 + test("UNIQDATA_DEFAULT_TC017", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME >'CUST_NAME_01840' order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME >'CUST_NAME_01840' order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC017") + + } + + + //UNIQDATA_DEFAULT_TC018 + test("UNIQDATA_DEFAULT_TC018", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME<>CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME<>CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC018") + + } + + + //UNIQDATA_DEFAULT_TC019 + test("UNIQDATA_DEFAULT_TC019", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME != BIGINT_COLUMN2 order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME != BIGINT_COLUMN2 order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC019") + + } + + + //UNIQDATA_DEFAULT_TC020 + test("UNIQDATA_DEFAULT_TC020", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where BIGINT_COLUMN2<CUST_NAME order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where BIGINT_COLUMN2<CUST_NAME order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC020") + + } + + + //UNIQDATA_DEFAULT_TC021 + test("UNIQDATA_DEFAULT_TC021", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where DECIMAL_COLUMN1<=CUST_NAME order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where DECIMAL_COLUMN1<=CUST_NAME order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC021") + + } + + + //UNIQDATA_DEFAULT_TC022 + test("UNIQDATA_DEFAULT_TC022", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME <'CUST_NAME_01844' order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME <'CUST_NAME_01844' order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC022") + + } + + + //UNIQDATA_DEFAULT_TC023 + test("UNIQDATA_DEFAULT_TC023", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where CUST_NAME IS NULL""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where CUST_NAME IS NULL""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC023") + + } + + + //UNIQDATA_DEFAULT_TC024 + test("UNIQDATA_DEFAULT_TC024", Include) { + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where CUST_NAME IS NOT NULL order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where CUST_NAME IS NOT NULL order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC024") + } + + + //UNIQDATA_DEFAULT_TC025 + test("UNIQDATA_DEFAULT_TC025", Include) { + + checkAnswer(s"""Select count(CUST_NAME),min(CUST_NAME) from UNIQDATA """, + s"""Select count(CUST_NAME),min(CUST_NAME) from UNIQDATA_hive """, "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC025") + + } + + + //UNIQDATA_DEFAULT_TC026 + test("UNIQDATA_DEFAULT_TC026", Include) { + + checkAnswer(s"""select count(DISTINCT CUST_NAME,DECIMAL_COLUMN1) as a from UNIQDATA""", + s"""select count(DISTINCT CUST_NAME,DECIMAL_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC026") + + } + + + //UNIQDATA_DEFAULT_TC027 + test("UNIQDATA_DEFAULT_TC027", Include) { + + checkAnswer(s"""select max(CUST_NAME),min(CUST_NAME),count(CUST_NAME) from UNIQDATA""", + s"""select max(CUST_NAME),min(CUST_NAME),count(CUST_NAME) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC027") + + } + + + //UNIQDATA_DEFAULT_TC028 + test("UNIQDATA_DEFAULT_TC028", Include) { + + checkAnswer(s"""select sum(CUST_NAME),avg(CUST_NAME),count(CUST_NAME) a from UNIQDATA""", + s"""select sum(CUST_NAME),avg(CUST_NAME),count(CUST_NAME) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC028") + + } + + + //UNIQDATA_DEFAULT_TC029 + test("UNIQDATA_DEFAULT_TC029", Include) { + + sql(s"""select last(CUST_NAME),Min(CUST_NAME),max(CUST_NAME) a from UNIQDATA order by a""").collect + + } + + + //UNIQDATA_DEFAULT_TC030 + test("UNIQDATA_DEFAULT_TC030", Include) { + + sql(s"""select FIRST(CUST_NAME),Last(CUST_NAME) a from UNIQDATA group by CUST_NAME order by CUST_NAME limit 1""").collect + + } + + + //UNIQDATA_DEFAULT_TC031 + test("UNIQDATA_DEFAULT_TC031", Include) { + + checkAnswer(s"""select CUST_NAME,count(CUST_NAME) a from UNIQDATA group by CUST_NAME order by CUST_NAME""", + s"""select CUST_NAME,count(CUST_NAME) a from UNIQDATA_hive group by CUST_NAME order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC031") + + } + + + //UNIQDATA_DEFAULT_TC032 + test("UNIQDATA_DEFAULT_TC032", Include) { + + checkAnswer(s"""select Lower(CUST_NAME),upper(CUST_NAME) a from UNIQDATA order by CUST_NAME""", + s"""select Lower(CUST_NAME),upper(CUST_NAME) a from UNIQDATA_hive order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC032") + + } + + + //UNIQDATA_DEFAULT_TC033 + test("UNIQDATA_DEFAULT_TC033", Include) { + + checkAnswer(s"""select CUST_NAME as a from UNIQDATA order by a asc limit 10""", + s"""select CUST_NAME as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC033") + + } + + + //UNIQDATA_DEFAULT_TC034 + test("UNIQDATA_DEFAULT_TC034", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01840')""", + s"""select CUST_NAME from UNIQDATA_hive where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC034") + + } + + + //UNIQDATA_DEFAULT_TC035 + test("UNIQDATA_DEFAULT_TC035", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME !='CUST_NAME_01840' order by CUST_NAME""", + s"""select CUST_NAME from UNIQDATA_hive where CUST_NAME !='CUST_NAME_01840' order by CUST_NAME""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC035") + + } + + + //UNIQDATA_DEFAULT_TC036 + test("UNIQDATA_DEFAULT_TC036", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select CUST_NAME from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC036") + + } + + + //UNIQDATA_DEFAULT_TC037 + test("UNIQDATA_DEFAULT_TC037", Include) { + + checkAnswer(s"""Select count(BIGINT_COLUMN1) from UNIQDATA""", + s"""Select count(BIGINT_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC037") + + } + + + //UNIQDATA_DEFAULT_TC038 + test("UNIQDATA_DEFAULT_TC038", Include) { + + checkAnswer(s"""select count(DISTINCT BIGINT_COLUMN1) as a from UNIQDATA""", + s"""select count(DISTINCT BIGINT_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC038") + + } + + + //UNIQDATA_DEFAULT_TC039 + test("UNIQDATA_DEFAULT_TC039", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1)+10 as a ,BIGINT_COLUMN1 from UNIQDATA group by BIGINT_COLUMN1""", + s"""select sum(BIGINT_COLUMN1)+10 as a ,BIGINT_COLUMN1 from UNIQDATA_hive group by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC039") + + } + + + //UNIQDATA_DEFAULT_TC040 + test("UNIQDATA_DEFAULT_TC040", Include) { + + checkAnswer(s"""select max(BIGINT_COLUMN1),min(BIGINT_COLUMN1) from UNIQDATA""", + s"""select max(BIGINT_COLUMN1),min(BIGINT_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC040") + + } + + + //UNIQDATA_DEFAULT_TC041 + test("UNIQDATA_DEFAULT_TC041", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1) a from UNIQDATA""", + s"""select sum(BIGINT_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC041") + + } + + + //UNIQDATA_DEFAULT_TC042 + test("UNIQDATA_DEFAULT_TC042", Include) { + + checkAnswer(s"""select avg(BIGINT_COLUMN1) a from UNIQDATA""", + s"""select avg(BIGINT_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC042") + + } + + + //UNIQDATA_DEFAULT_TC043 + test("UNIQDATA_DEFAULT_TC043", Include) { + + checkAnswer(s"""select min(BIGINT_COLUMN1) a from UNIQDATA""", + s"""select min(BIGINT_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC043") + + } + + + //UNIQDATA_DEFAULT_TC044 + test("UNIQDATA_DEFAULT_TC044", Include) { + + sql(s"""select variance(BIGINT_COLUMN1) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC045 + test("UNIQDATA_DEFAULT_TC045", Include) { + + sql(s"""select var_pop(BIGINT_COLUMN1) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC046 + test("UNIQDATA_DEFAULT_TC046", Include) { + + sql(s"""select var_samp(BIGINT_COLUMN1) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC047 + test("UNIQDATA_DEFAULT_TC047", Include) { + + sql(s"""select stddev_pop(BIGINT_COLUMN1) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC048 + test("UNIQDATA_DEFAULT_TC048", Include) { + + sql(s"""select stddev_samp(BIGINT_COLUMN1) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC049 + test("UNIQDATA_DEFAULT_TC049", Include) { + + sql(s"""select covar_pop(BIGINT_COLUMN1,BIGINT_COLUMN1) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC050 + test("UNIQDATA_DEFAULT_TC050", Include) { + + sql(s"""select covar_samp(BIGINT_COLUMN1,BIGINT_COLUMN1) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC051 + test("UNIQDATA_DEFAULT_TC051", Include) { + + sql(s"""select corr(BIGINT_COLUMN1,BIGINT_COLUMN1) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC052 + test("UNIQDATA_DEFAULT_TC052", Include) { + + sql(s"""select percentile_approx(BIGINT_COLUMN1,0.2) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC053 + test("UNIQDATA_DEFAULT_TC053", Include) { + + sql(s"""select percentile_approx(BIGINT_COLUMN1,0.2,5) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC054 + test("UNIQDATA_DEFAULT_TC054", Include) { + + sql(s"""select percentile_approx(BIGINT_COLUMN1,array(0.2,0.3,0.99)) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC055 + test("UNIQDATA_DEFAULT_TC055", Include) { + + sql(s"""select percentile_approx(BIGINT_COLUMN1,array(0.2,0.3,0.99),5) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC056 + test("UNIQDATA_DEFAULT_TC056", Include) { + + sql(s"""select histogram_numeric(BIGINT_COLUMN1,2) as a from (select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC057 + test("UNIQDATA_DEFAULT_TC057", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1+ 10 as a from UNIQDATA order by a""", + s"""select BIGINT_COLUMN1+ 10 as a from UNIQDATA_hive order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC057") + + } + + + //UNIQDATA_DEFAULT_TC058 + test("UNIQDATA_DEFAULT_TC058", Include) { + + checkAnswer(s"""select min(BIGINT_COLUMN1), max(BIGINT_COLUMN1+ 10) Total from UNIQDATA group by ACTIVE_EMUI_VERSION order by Total""", + s"""select min(BIGINT_COLUMN1), max(BIGINT_COLUMN1+ 10) Total from UNIQDATA_hive group by ACTIVE_EMUI_VERSION order by Total""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC058") + + } + + + //UNIQDATA_DEFAULT_TC059 + test("UNIQDATA_DEFAULT_TC059", Include) { + + sql(s"""select last(BIGINT_COLUMN1) a from UNIQDATA order by a""").collect + + } + + + //UNIQDATA_DEFAULT_TC060 + test("UNIQDATA_DEFAULT_TC060", Include) { + + sql(s"""select FIRST(BIGINT_COLUMN1) a from UNIQDATA order by a""").collect + + } + + + //UNIQDATA_DEFAULT_TC061 + test("UNIQDATA_DEFAULT_TC061", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1,count(BIGINT_COLUMN1) a from UNIQDATA group by BIGINT_COLUMN1 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1,count(BIGINT_COLUMN1) a from UNIQDATA_hive group by BIGINT_COLUMN1 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC061") + + } + + + //UNIQDATA_DEFAULT_TC062 + test("UNIQDATA_DEFAULT_TC062", Include) { + + checkAnswer(s"""select Lower(BIGINT_COLUMN1) a from UNIQDATA order by BIGINT_COLUMN1""", + s"""select Lower(BIGINT_COLUMN1) a from UNIQDATA_hive order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC062") + + } + + + //UNIQDATA_DEFAULT_TC063 + test("UNIQDATA_DEFAULT_TC063", Include) { + + checkAnswer(s"""select distinct BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1""", + s"""select distinct BIGINT_COLUMN1 from UNIQDATA_hive order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC063") + + } + + + //UNIQDATA_DEFAULT_TC064 + test("UNIQDATA_DEFAULT_TC064", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA order by BIGINT_COLUMN1 limit 101""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive order by BIGINT_COLUMN1 limit 101""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC064") + + } + + + //UNIQDATA_DEFAULT_TC065 + test("UNIQDATA_DEFAULT_TC065", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 as a from UNIQDATA order by a asc limit 10""", + s"""select BIGINT_COLUMN1 as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC065") + + } + + + //UNIQDATA_DEFAULT_TC066 + test("UNIQDATA_DEFAULT_TC066", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01840')""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where (BIGINT_COLUMN1 == 123372038698) and (CUST_NAME=='CUST_NAME_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC066") + + } + + + //UNIQDATA_DEFAULT_TC067 + test("UNIQDATA_DEFAULT_TC067", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 !=123372038698 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 !=123372038698 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC067") + + } + + + //UNIQDATA_DEFAULT_TC068 + test("UNIQDATA_DEFAULT_TC068", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840') order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840') order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC068") + + } + + + //UNIQDATA_DEFAULT_TC069 + test("UNIQDATA_DEFAULT_TC069", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 !=123372038698 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 !=123372038698 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC069") + + } + + + //UNIQDATA_DEFAULT_TC070 + test("UNIQDATA_DEFAULT_TC070", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 >123372038698 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 >123372038698 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC070") + + } + + + //UNIQDATA_DEFAULT_TC071 + test("UNIQDATA_DEFAULT_TC071", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1<>BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1<>BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC071") + + } + + + //UNIQDATA_DEFAULT_TC072 + test("UNIQDATA_DEFAULT_TC072", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 != BIGINT_COLUMN2 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 != BIGINT_COLUMN2 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC072") + + } + + + //UNIQDATA_DEFAULT_TC073 + test("UNIQDATA_DEFAULT_TC073", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1, BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN2<BIGINT_COLUMN1 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1, BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN2<BIGINT_COLUMN1 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC073") + + } + + + //UNIQDATA_DEFAULT_TC074 + test("UNIQDATA_DEFAULT_TC074", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1, BIGINT_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1<=BIGINT_COLUMN1 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1, BIGINT_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1<=BIGINT_COLUMN1 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC074") + + } + + + //UNIQDATA_DEFAULT_TC075 + test("UNIQDATA_DEFAULT_TC075", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 <1000 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 <1000 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC075") + + } + + + //UNIQDATA_DEFAULT_TC076 + test("UNIQDATA_DEFAULT_TC076", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 >1000 order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 >1000 order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC076") + + } + + + //UNIQDATA_DEFAULT_TC077 + test("UNIQDATA_DEFAULT_TC077", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 IS NULL order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 IS NULL order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC077") + + } + + + //UNIQDATA_DEFAULT_TC078 + test("UNIQDATA_DEFAULT_TC078", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 IS NOT NULL order by BIGINT_COLUMN1""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 IS NOT NULL order by BIGINT_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC078") + + } + + + //UNIQDATA_DEFAULT_TC079 + test("UNIQDATA_DEFAULT_TC079", Include) { + + checkAnswer(s"""Select count(DECIMAL_COLUMN1) from UNIQDATA""", + s"""Select count(DECIMAL_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC079") + + } + + + //UNIQDATA_DEFAULT_TC080 + test("UNIQDATA_DEFAULT_TC080", Include) { + + checkAnswer(s"""select count(DISTINCT DECIMAL_COLUMN1) as a from UNIQDATA""", + s"""select count(DISTINCT DECIMAL_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC080") + + } + + + //UNIQDATA_DEFAULT_TC081 + test("UNIQDATA_DEFAULT_TC081", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1)+10 as a ,DECIMAL_COLUMN1 from UNIQDATA group by DECIMAL_COLUMN1 order by a""", + s"""select sum(DECIMAL_COLUMN1)+10 as a ,DECIMAL_COLUMN1 from UNIQDATA_hive group by DECIMAL_COLUMN1 order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC081") + + } + + + //UNIQDATA_DEFAULT_TC082 + test("UNIQDATA_DEFAULT_TC082", Include) { + + checkAnswer(s"""select max(DECIMAL_COLUMN1),min(DECIMAL_COLUMN1) from UNIQDATA""", + s"""select max(DECIMAL_COLUMN1),min(DECIMAL_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC082") + + } + + + //UNIQDATA_DEFAULT_TC083 + test("UNIQDATA_DEFAULT_TC083", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1) a from UNIQDATA""", + s"""select sum(DECIMAL_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC083") + + } + + + //UNIQDATA_DEFAULT_TC084 + test("UNIQDATA_DEFAULT_TC084", Include) { + + checkAnswer(s"""select avg(DECIMAL_COLUMN1) a from UNIQDATA""", + s"""select avg(DECIMAL_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC084") + + } + + + //UNIQDATA_DEFAULT_TC085 + test("UNIQDATA_DEFAULT_TC085", Include) { + + checkAnswer(s"""select min(DECIMAL_COLUMN1) a from UNIQDATA""", + s"""select min(DECIMAL_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC085") + + } + + + //UNIQDATA_DEFAULT_TC086 + test("UNIQDATA_DEFAULT_TC086", Include) { + + sql(s"""select variance(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC087 + test("UNIQDATA_DEFAULT_TC087", Include) { + + sql(s"""select var_pop(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC088 + test("UNIQDATA_DEFAULT_TC088", Include) { + + sql(s"""select var_samp(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC089 + test("UNIQDATA_DEFAULT_TC089", Include) { + + sql(s"""select stddev_pop(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC090 + test("UNIQDATA_DEFAULT_TC090", Include) { + + sql(s"""select stddev_samp(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC091 + test("UNIQDATA_DEFAULT_TC091", Include) { + + sql(s"""select covar_pop(DECIMAL_COLUMN1,DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC092 + test("UNIQDATA_DEFAULT_TC092", Include) { + + sql(s"""select covar_samp(DECIMAL_COLUMN1,DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC093 + test("UNIQDATA_DEFAULT_TC093", Include) { + + checkAnswer(s"""select corr(DECIMAL_COLUMN1,DECIMAL_COLUMN1) as a from UNIQDATA""", + s"""select corr(DECIMAL_COLUMN1,DECIMAL_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC093") + + } + + + //UNIQDATA_DEFAULT_TC094 + test("UNIQDATA_DEFAULT_TC094", Include) { + + sql(s"""select percentile_approx(DECIMAL_COLUMN1,0.2) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC095 + test("UNIQDATA_DEFAULT_TC095", Include) { + + sql(s"""select percentile_approx(DECIMAL_COLUMN1,0.2,5) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC096 + test("UNIQDATA_DEFAULT_TC096", Include) { + + sql(s"""select percentile_approx(DECIMAL_COLUMN1,array(0.2,0.3,0.99)) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC097 + test("UNIQDATA_DEFAULT_TC097", Include) { + + sql(s"""select percentile_approx(DECIMAL_COLUMN1,array(0.2,0.3,0.99),5) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC098 + test("UNIQDATA_DEFAULT_TC098", Include) { + + sql(s"""select histogram_numeric(DECIMAL_COLUMN1,2) as a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC099 + test("UNIQDATA_DEFAULT_TC099", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1+ 10 as a from UNIQDATA order by a""", + s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1+ 10 as a from UNIQDATA_hive order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC099") + + } + + + //UNIQDATA_DEFAULT_TC100 + test("UNIQDATA_DEFAULT_TC100", Include) { + + checkAnswer(s"""select min(DECIMAL_COLUMN1), max(DECIMAL_COLUMN1+ 10) Total from UNIQDATA group by ACTIVE_EMUI_VERSION order by Total""", + s"""select min(DECIMAL_COLUMN1), max(DECIMAL_COLUMN1+ 10) Total from UNIQDATA_hive group by ACTIVE_EMUI_VERSION order by Total""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC100") + + } + + + //UNIQDATA_DEFAULT_TC101 + test("UNIQDATA_DEFAULT_TC101", Include) { + + sql(s"""select last(DECIMAL_COLUMN1) a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC102 + test("UNIQDATA_DEFAULT_TC102", Include) { + + sql(s"""select FIRST(DECIMAL_COLUMN1) a from (select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC103 + test("UNIQDATA_DEFAULT_TC103", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1,count(DECIMAL_COLUMN1) a from UNIQDATA group by DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1,count(DECIMAL_COLUMN1) a from UNIQDATA_hive group by DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC103") + + } + + + //UNIQDATA_DEFAULT_TC104 + test("UNIQDATA_DEFAULT_TC104", Include) { + + checkAnswer(s"""select Lower(DECIMAL_COLUMN1) a from UNIQDATA order by a""", + s"""select Lower(DECIMAL_COLUMN1) a from UNIQDATA_hive order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC104") + + } + + + //UNIQDATA_DEFAULT_TC105 + test("UNIQDATA_DEFAULT_TC105", Include) { + + checkAnswer(s"""select distinct DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1""", + s"""select distinct DECIMAL_COLUMN1 from UNIQDATA_hive order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC105") + + } + + + //UNIQDATA_DEFAULT_TC106 + test("UNIQDATA_DEFAULT_TC106", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA order by DECIMAL_COLUMN1 limit 101""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive order by DECIMAL_COLUMN1 limit 101""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC106") + + } + + + //UNIQDATA_DEFAULT_TC107 + test("UNIQDATA_DEFAULT_TC107", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 as a from UNIQDATA order by a asc limit 10""", + s"""select DECIMAL_COLUMN1 as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC107") + + } + + + //UNIQDATA_DEFAULT_TC108 + test("UNIQDATA_DEFAULT_TC108", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where (DECIMAL_COLUMN1 == 12345680745.1234000000) and (CUST_NAME=='CUST_NAME_01844')""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where (DECIMAL_COLUMN1 == 12345680745.1234000000) and (CUST_NAME=='CUST_NAME_01844')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC108") + + } + + + //UNIQDATA_DEFAULT_TC109 + test("UNIQDATA_DEFAULT_TC109", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 !=12345680745.1234000000 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 !=12345680745.1234000000 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC109") + + } + + + //UNIQDATA_DEFAULT_TC110 + test("UNIQDATA_DEFAULT_TC110", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC110") + + } + + + //UNIQDATA_DEFAULT_TC111 + test("UNIQDATA_DEFAULT_TC111", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 !=12345680745.1234000000 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 !=12345680745.1234000000 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC111") + + } + + + //UNIQDATA_DEFAULT_TC112 + test("UNIQDATA_DEFAULT_TC112", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 >12345680745.1234000000 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 >12345680745.1234000000 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC112") + + } + + + //UNIQDATA_DEFAULT_TC113 + test("UNIQDATA_DEFAULT_TC113", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1<>DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1<>DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC113") + + } + + + //UNIQDATA_DEFAULT_TC114 + test("UNIQDATA_DEFAULT_TC114", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 != BIGINT_COLUMN2 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 != BIGINT_COLUMN2 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC114") + + } + + + //UNIQDATA_DEFAULT_TC115 + test("UNIQDATA_DEFAULT_TC115", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1 from UNIQDATA where BIGINT_COLUMN2<DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN2<DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC115") + + } + + + //UNIQDATA_DEFAULT_TC116 + test("UNIQDATA_DEFAULT_TC116", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1<=DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1, DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1<=DECIMAL_COLUMN1 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC116") + + } + + + //UNIQDATA_DEFAULT_TC117 + test("UNIQDATA_DEFAULT_TC117", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 <1000 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 <1000 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC117") + + } + + + //UNIQDATA_DEFAULT_TC118 + test("UNIQDATA_DEFAULT_TC118", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 >1000 order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 >1000 order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC118") + + } + + + //UNIQDATA_DEFAULT_TC119 + test("UNIQDATA_DEFAULT_TC119", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 IS NULL order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 IS NULL order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC119") + + } + + + //UNIQDATA_DEFAULT_TC120 + test("UNIQDATA_DEFAULT_TC120", Include) { + + checkAnswer(s"""select DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 IS NOT NULL order by DECIMAL_COLUMN1""", + s"""select DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 IS NOT NULL order by DECIMAL_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC120") + + } + + + //UNIQDATA_DEFAULT_TC121 + test("UNIQDATA_DEFAULT_TC121", Include) { + + checkAnswer(s"""Select count(Double_COLUMN1) from UNIQDATA""", + s"""Select count(Double_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC121") + + } + + + //UNIQDATA_DEFAULT_TC122 + test("UNIQDATA_DEFAULT_TC122", Include) { + + checkAnswer(s"""select count(DISTINCT Double_COLUMN1) as a from UNIQDATA""", + s"""select count(DISTINCT Double_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC122") + + } + + + //UNIQDATA_DEFAULT_TC123 + test("UNIQDATA_DEFAULT_TC123", Include) { + + sql(s"""select sum(Double_COLUMN1)+10 as a ,Double_COLUMN1 from UNIQDATA group by Double_COLUMN1 order by a""").collect + + } + + + //UNIQDATA_DEFAULT_TC124 + test("UNIQDATA_DEFAULT_TC124", Include) { + + checkAnswer(s"""select max(Double_COLUMN1),min(Double_COLUMN1) from UNIQDATA""", + s"""select max(Double_COLUMN1),min(Double_COLUMN1) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC124") + + } + + + //UNIQDATA_DEFAULT_TC125 + test("UNIQDATA_DEFAULT_TC125", Include) { + + sql(s"""select sum(Double_COLUMN1) a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC126 + ignore("UNIQDATA_DEFAULT_TC126", Include) { + + checkAnswer(s"""select avg(Double_COLUMN1) a from UNIQDATA""", + Seq(Row(1.1234567489797018E10d)), "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC126") + } + + + //UNIQDATA_DEFAULT_TC127 + test("UNIQDATA_DEFAULT_TC127", Include) { + + checkAnswer(s"""select min(Double_COLUMN1) a from UNIQDATA""", + s"""select min(Double_COLUMN1) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC127") + + } + + + //UNIQDATA_DEFAULT_TC128 + test("UNIQDATA_DEFAULT_TC128", Include) { + + sql(s"""select variance(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC129 + test("UNIQDATA_DEFAULT_TC129", Include) { + + sql(s"""select var_pop(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC130 + test("UNIQDATA_DEFAULT_TC130", Include) { + + sql(s"""select var_samp(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC131 + test("UNIQDATA_DEFAULT_TC131", Include) { + + sql(s"""select stddev_pop(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC132 + test("UNIQDATA_DEFAULT_TC132", Include) { + + sql(s"""select stddev_samp(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC133 + test("UNIQDATA_DEFAULT_TC133", Include) { + + sql(s"""select covar_pop(Double_COLUMN1,Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC134 + test("UNIQDATA_DEFAULT_TC134", Include) { + + sql(s"""select covar_samp(Double_COLUMN1,Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC135 + test("UNIQDATA_DEFAULT_TC135", Include) { + + checkAnswer(s"""select corr(Double_COLUMN1,Double_COLUMN1) as a from UNIQDATA""", + s"""select corr(Double_COLUMN1,Double_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC135") + + } + + + //UNIQDATA_DEFAULT_TC136 + test("UNIQDATA_DEFAULT_TC136", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,0.2) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC137 + test("UNIQDATA_DEFAULT_TC137", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,0.2,5) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC138 + test("UNIQDATA_DEFAULT_TC138", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,array(0.2,0.3,0.99)) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC139 + test("UNIQDATA_DEFAULT_TC139", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,array(0.2,0.3,0.99),5) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC140 + test("UNIQDATA_DEFAULT_TC140", Include) { + + sql(s"""select histogram_numeric(Double_COLUMN1,2) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC141 + test("UNIQDATA_DEFAULT_TC141", Include) { + + checkAnswer(s"""select Double_COLUMN1, Double_COLUMN1+ 10 as a from UNIQDATA order by a""", + s"""select Double_COLUMN1, Double_COLUMN1+ 10 as a from UNIQDATA_hive order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC141") + + } + + + //UNIQDATA_DEFAULT_TC142 + test("UNIQDATA_DEFAULT_TC142", Include) { + + checkAnswer(s"""select min(Double_COLUMN1), max(Double_COLUMN1+ 10) Total from UNIQDATA group by ACTIVE_EMUI_VERSION order by Total""", + s"""select min(Double_COLUMN1), max(Double_COLUMN1+ 10) Total from UNIQDATA_hive group by ACTIVE_EMUI_VERSION order by Total""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC142") + + } + + + //UNIQDATA_DEFAULT_TC143 + test("UNIQDATA_DEFAULT_TC143", Include) { + + sql(s"""select last(Double_COLUMN1) a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC144 + test("UNIQDATA_DEFAULT_TC144", Include) { + + checkAnswer(s"""select FIRST(Double_COLUMN1) a from UNIQDATA order by a""", + s"""select FIRST(Double_COLUMN1) a from UNIQDATA_hive order by a""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC144") + + } + + + //UNIQDATA_DEFAULT_TC145 + test("UNIQDATA_DEFAULT_TC145", Include) { + + checkAnswer(s"""select Double_COLUMN1,count(Double_COLUMN1) a from UNIQDATA group by Double_COLUMN1 order by Double_COLUMN1""", + s"""select Double_COLUMN1,count(Double_COLUMN1) a from UNIQDATA_hive group by Double_COLUMN1 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC145") + + } + + + //UNIQDATA_DEFAULT_TC146 + test("UNIQDATA_DEFAULT_TC146", Include) { + + checkAnswer(s"""select Lower(Double_COLUMN1) a from UNIQDATA order by Double_COLUMN1""", + s"""select Lower(Double_COLUMN1) a from UNIQDATA_hive order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC146") + + } + + + //UNIQDATA_DEFAULT_TC147 + test("UNIQDATA_DEFAULT_TC147", Include) { + + checkAnswer(s"""select distinct Double_COLUMN1 from UNIQDATA order by Double_COLUMN1""", + s"""select distinct Double_COLUMN1 from UNIQDATA_hive order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC147") + + } + + + //UNIQDATA_DEFAULT_TC148 + test("UNIQDATA_DEFAULT_TC148", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1 limit 101""", + s"""select Double_COLUMN1 from UNIQDATA_hive order by Double_COLUMN1 limit 101""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC148") + + } + + + //UNIQDATA_DEFAULT_TC149 + test("UNIQDATA_DEFAULT_TC149", Include) { + + checkAnswer(s"""select Double_COLUMN1 as a from UNIQDATA order by a asc limit 10""", + s"""select Double_COLUMN1 as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC149") + + } + + + //UNIQDATA_DEFAULT_TC150 + test("UNIQDATA_DEFAULT_TC150", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where (Double_COLUMN1 == 12345680745.1234000000) and (CUST_NAME=='CUST_NAME_01844')""", + s"""select Double_COLUMN1 from UNIQDATA_hive where (Double_COLUMN1 == 12345680745.1234000000) and (CUST_NAME=='CUST_NAME_01844')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC150") + + } + + + //UNIQDATA_DEFAULT_TC151 + test("UNIQDATA_DEFAULT_TC151", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 !=12345680745.1234000000 order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 !=12345680745.1234000000 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC151") + + } + + + //UNIQDATA_DEFAULT_TC152 + test("UNIQDATA_DEFAULT_TC152", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select Double_COLUMN1 from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC152") + + } + + + //UNIQDATA_DEFAULT_TC153 + test("UNIQDATA_DEFAULT_TC153", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 !=12345680745.1234000000""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 !=12345680745.1234000000""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC153") + + } + + + //UNIQDATA_DEFAULT_TC154 + test("UNIQDATA_DEFAULT_TC154", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 >12345680745.1234000000""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 >12345680745.1234000000""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC154") + + } + + + //UNIQDATA_DEFAULT_TC155 + test("UNIQDATA_DEFAULT_TC155", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1<>Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1<>Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC155") + + } + + + //UNIQDATA_DEFAULT_TC156 + test("UNIQDATA_DEFAULT_TC156", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 != BIGINT_COLUMN2 order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 != BIGINT_COLUMN2 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC156") + + } + + + //UNIQDATA_DEFAULT_TC157 + test("UNIQDATA_DEFAULT_TC157", Include) { + + checkAnswer(s"""select Double_COLUMN1, Double_COLUMN1 from UNIQDATA where BIGINT_COLUMN2<Double_COLUMN1 order by Double_COLUMN1""", + s"""select Double_COLUMN1, Double_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN2<Double_COLUMN1 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC157") + + } + + + //UNIQDATA_DEFAULT_TC158 + test("UNIQDATA_DEFAULT_TC158", Include) { + + checkAnswer(s"""select Double_COLUMN1, Double_COLUMN1 from UNIQDATA where Double_COLUMN1<=Double_COLUMN1 order by Double_COLUMN1""", + s"""select Double_COLUMN1, Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1<=Double_COLUMN1 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC158") + + } + + + //UNIQDATA_DEFAULT_TC159 + test("UNIQDATA_DEFAULT_TC159", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 <1000 order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 <1000 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC159") + + } + + + //UNIQDATA_DEFAULT_TC160 + test("UNIQDATA_DEFAULT_TC160", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 >1000 order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 >1000 order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC160") + + } + + + //UNIQDATA_DEFAULT_TC161 + test("UNIQDATA_DEFAULT_TC161", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 IS NULL order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 IS NULL order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC161") + + } + + + //UNIQDATA_DEFAULT_TC162 + test("UNIQDATA_DEFAULT_TC162", Include) { + + checkAnswer(s"""select Double_COLUMN1 from UNIQDATA where Double_COLUMN1 IS NOT NULL order by Double_COLUMN1""", + s"""select Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 IS NOT NULL order by Double_COLUMN1""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC162") + + } + + + //UNIQDATA_DEFAULT_TC163 + test("UNIQDATA_DEFAULT_TC163", Include) { + + checkAnswer(s"""Select count(DOB) from UNIQDATA""", + s"""Select count(DOB) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC163") + + } + + + //UNIQDATA_DEFAULT_TC164 + test("UNIQDATA_DEFAULT_TC164", Include) { + + checkAnswer(s"""select count(DISTINCT DOB) as a from UNIQDATA""", + s"""select count(DISTINCT DOB) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC164") + + } + + + //UNIQDATA_DEFAULT_TC165 + test("UNIQDATA_DEFAULT_TC165", Include) { + + checkAnswer(s"""select sum(DOB)+10 as a ,DOB from UNIQDATA group by DOB order by DOB""", + s"""select sum(DOB)+10 as a ,DOB from UNIQDATA_hive group by DOB order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC165") + + } + + + //UNIQDATA_DEFAULT_TC166 + test("UNIQDATA_DEFAULT_TC166", Include) { + + checkAnswer(s"""select max(DOB),min(DOB) from UNIQDATA""", + s"""select max(DOB),min(DOB) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC166") + + } + + + //UNIQDATA_DEFAULT_TC167 + test("UNIQDATA_DEFAULT_TC167", Include) { + + checkAnswer(s"""select sum(DOB) a from UNIQDATA""", + s"""select sum(DOB) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC167") + + } + + + //UNIQDATA_DEFAULT_TC168 + test("UNIQDATA_DEFAULT_TC168", Include) { + + checkAnswer(s"""select avg(DOB) a from UNIQDATA""", + s"""select avg(DOB) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC168") + + } + + + //UNIQDATA_DEFAULT_TC169 + test("UNIQDATA_DEFAULT_TC169", Include) { + + checkAnswer(s"""select min(DOB) a from UNIQDATA""", + s"""select min(DOB) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC169") + + } + + + //UNIQDATA_DEFAULT_TC170 + test("UNIQDATA_DEFAULT_TC170", Include) { + + sql(s"""select variance(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC171 + test("UNIQDATA_DEFAULT_TC171", Include) { + + sql(s"""select var_pop(Double_COLUMN1) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC172 + test("UNIQDATA_DEFAULT_TC172", Include) { + + sql(s"""select var_samp(Double_COLUMN1) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC173 + test("UNIQDATA_DEFAULT_TC173", Include) { + + sql(s"""select stddev_pop(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC174 + test("UNIQDATA_DEFAULT_TC174", Include) { + + sql(s"""select stddev_samp(Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC175 + test("UNIQDATA_DEFAULT_TC175", Include) { + + sql(s"""select covar_pop(Double_COLUMN1,Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC176 + test("UNIQDATA_DEFAULT_TC176", Include) { + + sql(s"""select covar_samp(Double_COLUMN1,Double_COLUMN1) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC177 + test("UNIQDATA_DEFAULT_TC177", Include) { + + checkAnswer(s"""select corr(Double_COLUMN1,Double_COLUMN1) as a from UNIQDATA""", + s"""select corr(Double_COLUMN1,Double_COLUMN1) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC177") + + } + + + //UNIQDATA_DEFAULT_TC178 + test("UNIQDATA_DEFAULT_TC178", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,0.2) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC179 + test("UNIQDATA_DEFAULT_TC179", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,0.2,5) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC180 + test("UNIQDATA_DEFAULT_TC180", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,array(0.2,0.3,0.99)) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC181 + test("UNIQDATA_DEFAULT_TC181", Include) { + + sql(s"""select percentile_approx(Double_COLUMN1,array(0.2,0.3,0.99),5) as a from (select Double_COLUMN1 from UNIQDATA order by Double_COLUMN1) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC182 + test("UNIQDATA_DEFAULT_TC182", Include) { + + sql(s"""select histogram_numeric(DOB,2) as a from (select DOB from UNIQDATA order by DOB) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC183 + test("UNIQDATA_DEFAULT_TC183", Include) { + + sql(s"""select last(DOB) a from (select DOB from UNIQDATA order by DOB) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC184 + test("UNIQDATA_DEFAULT_TC184", Include) { + + sql(s"""select FIRST(DOB) a from (select DOB from UNIQDATA order by DOB) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC185 + test("UNIQDATA_DEFAULT_TC185", Include) { + + checkAnswer(s"""select DOB,count(DOB) a from UNIQDATA group by DOB order by DOB""", + s"""select DOB,count(DOB) a from UNIQDATA_hive group by DOB order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC185") + + } + + + //UNIQDATA_DEFAULT_TC186 + test("UNIQDATA_DEFAULT_TC186", Include) { + + checkAnswer(s"""select Lower(DOB) a from UNIQDATA order by DOB""", + s"""select Lower(DOB) a from UNIQDATA_hive order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC186") + + } + + + //UNIQDATA_DEFAULT_TC187 + test("UNIQDATA_DEFAULT_TC187", Include) { + + checkAnswer(s"""select distinct DOB from UNIQDATA order by DOB""", + s"""select distinct DOB from UNIQDATA_hive order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC187") + + } + + + //UNIQDATA_DEFAULT_TC188 + test("UNIQDATA_DEFAULT_TC188", Include) { + + sql(s"""select DOB from UNIQDATA order by DOB limit 101""").collect + + } + + + //UNIQDATA_DEFAULT_TC189 + test("UNIQDATA_DEFAULT_TC189", Include) { + + sql(s"""select DOB as a from UNIQDATA order by a asc limit 10""").collect + + } + + + //UNIQDATA_DEFAULT_TC190 + test("UNIQDATA_DEFAULT_TC190", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where (DOB == '1970-06-19 01:00:03') and (DOJ=='1970-06-19 02:00:03')""", + s"""select DOB from UNIQDATA_hive where (DOB == '1970-06-19 01:00:03') and (DOJ=='1970-06-19 02:00:03')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC190") + + } + + + //UNIQDATA_DEFAULT_TC191 + test("UNIQDATA_DEFAULT_TC191", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB !='1970-06-19 01:00:03' order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB !='1970-06-19 01:00:03' order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC191") + + } + + + //UNIQDATA_DEFAULT_TC192 + test("UNIQDATA_DEFAULT_TC192", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select DOB from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC192") + + } + + + //UNIQDATA_DEFAULT_TC193 + test("UNIQDATA_DEFAULT_TC193", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB !='1970-06-19 01:00:03' order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB !='1970-06-19 01:00:03' order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC193") + + } + + + //UNIQDATA_DEFAULT_TC194 + ignore("UNIQDATA_DEFAULT_TC194", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB >'1970-06-19 01:00:03' order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB >'1970-06-19 01:00:03' order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC194") + + } + + + //UNIQDATA_DEFAULT_TC195 + test("UNIQDATA_DEFAULT_TC195", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB<>DOB order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB<>DOB order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC195") + + } + + + //UNIQDATA_DEFAULT_TC196 + test("UNIQDATA_DEFAULT_TC196", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB != DOJ order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB != DOJ order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC196") + + } + + + //UNIQDATA_DEFAULT_TC197 + test("UNIQDATA_DEFAULT_TC197", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOJ<DOB order by DOB""", + s"""select DOB from UNIQDATA_hive where DOJ<DOB order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC197") + + } + + + //UNIQDATA_DEFAULT_TC198 + test("UNIQDATA_DEFAULT_TC198", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB<=DOB order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB<=DOB order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC198") + + } + + + //UNIQDATA_DEFAULT_TC199 + test("UNIQDATA_DEFAULT_TC199", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB <cast('1970-06-19 01:00:03' as timestamp) order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB <cast('1970-06-19 01:00:03' as timestamp) order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC199") + + } + + + //UNIQDATA_DEFAULT_TC200 + test("UNIQDATA_DEFAULT_TC200", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB IS NULL""", + s"""select DOB from UNIQDATA_hive where DOB IS NULL""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC200") + + } + + + //UNIQDATA_DEFAULT_TC201 + test("UNIQDATA_DEFAULT_TC201", Include) { + + checkAnswer(s"""select DOB from UNIQDATA where DOB IS NOT NULL order by DOB""", + s"""select DOB from UNIQDATA_hive where DOB IS NOT NULL order by DOB""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC201") + + } + + + //UNIQDATA_DEFAULT_TC202 + test("UNIQDATA_DEFAULT_TC202", Include) { + + checkAnswer(s"""Select count(CUST_ID) from UNIQDATA""", + s"""Select count(CUST_ID) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC202") + + } + + + //UNIQDATA_DEFAULT_TC203 + test("UNIQDATA_DEFAULT_TC203", Include) { + + checkAnswer(s"""select count(DISTINCT CUST_ID) as a from UNIQDATA""", + s"""select count(DISTINCT CUST_ID) as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC203") + + } + + + //UNIQDATA_DEFAULT_TC204 + test("UNIQDATA_DEFAULT_TC204", Include) { + + checkAnswer(s"""select sum(CUST_ID)+10 as a ,CUST_ID from UNIQDATA group by CUST_ID order by CUST_ID""", + s"""select sum(CUST_ID)+10 as a ,CUST_ID from UNIQDATA_hive group by CUST_ID order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC204") + + } + + + //UNIQDATA_DEFAULT_TC205 + test("UNIQDATA_DEFAULT_TC205", Include) { + + checkAnswer(s"""select max(CUST_ID),min(CUST_ID) from UNIQDATA""", + s"""select max(CUST_ID),min(CUST_ID) from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC205") + + } + + + //UNIQDATA_DEFAULT_TC206 + test("UNIQDATA_DEFAULT_TC206", Include) { + + checkAnswer(s"""select sum(CUST_ID) a from UNIQDATA""", + s"""select sum(CUST_ID) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC206") + + } + + + //UNIQDATA_DEFAULT_TC207 + test("UNIQDATA_DEFAULT_TC207", Include) { + + checkAnswer(s"""select avg(CUST_ID) a from UNIQDATA""", + s"""select avg(CUST_ID) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC207") + + } + + + //UNIQDATA_DEFAULT_TC208 + test("UNIQDATA_DEFAULT_TC208", Include) { + + checkAnswer(s"""select min(CUST_ID) a from UNIQDATA""", + s"""select min(CUST_ID) a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC208") + + } + + + //UNIQDATA_DEFAULT_TC209 + test("UNIQDATA_DEFAULT_TC209", Include) { + + sql(s"""select variance(CUST_ID) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC210 + test("UNIQDATA_DEFAULT_TC210", Include) { + + sql(s"""select var_pop(CUST_ID) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC211 + test("UNIQDATA_DEFAULT_TC211", Include) { + + sql(s"""select var_samp(CUST_ID) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC212 + test("UNIQDATA_DEFAULT_TC212", Include) { + + sql(s"""select stddev_pop(CUST_ID) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC213 + test("UNIQDATA_DEFAULT_TC213", Include) { + + sql(s"""select stddev_samp(CUST_ID) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC214 + test("UNIQDATA_DEFAULT_TC214", Include) { + + sql(s"""select covar_pop(CUST_ID,CUST_ID) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC215 + test("UNIQDATA_DEFAULT_TC215", Include) { + + sql(s"""select covar_samp(CUST_ID,CUST_ID) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC216 + test("UNIQDATA_DEFAULT_TC216", Include) { + + sql(s"""select corr(CUST_ID,CUST_ID) as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC217 + test("UNIQDATA_DEFAULT_TC217", Include) { + + sql(s"""select percentile_approx(CUST_ID,0.2) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC218 + test("UNIQDATA_DEFAULT_TC218", Include) { + + sql(s"""select percentile_approx(CUST_ID,0.2,5) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC219 + test("UNIQDATA_DEFAULT_TC219", Include) { + + sql(s"""select percentile_approx(CUST_ID,array(0.2,0.3,0.99)) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC220 + test("UNIQDATA_DEFAULT_TC220", Include) { + + sql(s"""select percentile_approx(CUST_ID,array(0.2,0.3,0.99),5) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC221 + test("UNIQDATA_DEFAULT_TC221", Include) { + + sql(s"""select histogram_numeric(CUST_ID,2) as a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC222 + test("UNIQDATA_DEFAULT_TC222", Include) { + + checkAnswer(s"""select CUST_ID, CUST_ID+ 10 as a from UNIQDATA order by CUST_ID""", + s"""select CUST_ID, CUST_ID+ 10 as a from UNIQDATA_hive order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC222") + + } + + + //UNIQDATA_DEFAULT_TC223 + test("UNIQDATA_DEFAULT_TC223", Include) { + + checkAnswer(s"""select min(CUST_ID), max(CUST_ID+ 10) Total from UNIQDATA group by ACTIVE_EMUI_VERSION order by Total""", + s"""select min(CUST_ID), max(CUST_ID+ 10) Total from UNIQDATA_hive group by ACTIVE_EMUI_VERSION order by Total""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC223") + + } + + + //UNIQDATA_DEFAULT_TC224 + test("UNIQDATA_DEFAULT_TC224", Include) { + + sql(s"""select last(CUST_ID) a from (select CUST_ID from UNIQDATA order by CUST_ID) t""").collect + + } + + + //UNIQDATA_DEFAULT_TC225 + test("UNIQDATA_DEFAULT_TC225", Include) { + + sql(s"""select FIRST(CUST_ID) a from UNIQDATA order by a""").collect + + } + + + //UNIQDATA_DEFAULT_TC226 + test("UNIQDATA_DEFAULT_TC226", Include) { + + checkAnswer(s"""select CUST_ID,count(CUST_ID) a from UNIQDATA group by CUST_ID order by CUST_ID""", + s"""select CUST_ID,count(CUST_ID) a from UNIQDATA_hive group by CUST_ID order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC226") + + } + + + //UNIQDATA_DEFAULT_TC227 + test("UNIQDATA_DEFAULT_TC227", Include) { + + checkAnswer(s"""select Lower(CUST_ID) a from UNIQDATA order by CUST_ID""", + s"""select Lower(CUST_ID) a from UNIQDATA_hive order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC227") + + } + + + //UNIQDATA_DEFAULT_TC228 + test("UNIQDATA_DEFAULT_TC228", Include) { + + checkAnswer(s"""select distinct CUST_ID from UNIQDATA order by CUST_ID""", + s"""select distinct CUST_ID from UNIQDATA_hive order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC228") + + } + + + //UNIQDATA_DEFAULT_TC229 + test("UNIQDATA_DEFAULT_TC229", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA order by CUST_ID limit 101""", + s"""select CUST_ID from UNIQDATA_hive order by CUST_ID limit 101""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC229") + + } + + + //UNIQDATA_DEFAULT_TC230 + test("UNIQDATA_DEFAULT_TC230", Include) { + + checkAnswer(s"""select CUST_ID as a from UNIQDATA order by a asc limit 10""", + s"""select CUST_ID as a from UNIQDATA_hive order by a asc limit 10""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC230") + + } + + + //UNIQDATA_DEFAULT_TC231 + test("UNIQDATA_DEFAULT_TC231", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where (CUST_ID == 100084) and (CUST_ID==100084)""", + s"""select CUST_ID from UNIQDATA_hive where (CUST_ID == 100084) and (CUST_ID==100084)""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC231") + + } + + + //UNIQDATA_DEFAULT_TC232 + test("UNIQDATA_DEFAULT_TC232", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID !='100084' order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID !='100084' order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC232") + + } + + + //UNIQDATA_DEFAULT_TC233 + test("UNIQDATA_DEFAULT_TC233", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", + s"""select CUST_ID from UNIQDATA_hive where (CUST_ID=10844 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01844') OR (CUST_ID=10840 and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_01840')""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC233") + + } + + + //UNIQDATA_DEFAULT_TC234 + test("UNIQDATA_DEFAULT_TC234", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID !=100084 order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID !=100084 order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC234") + + } + + + //UNIQDATA_DEFAULT_TC235 + test("UNIQDATA_DEFAULT_TC235", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID >100084 order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID >100084 order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC235") + + } + + + //UNIQDATA_DEFAULT_TC236 + test("UNIQDATA_DEFAULT_TC236", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID<>CUST_ID order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID<>CUST_ID order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC236") + + } + + + //UNIQDATA_DEFAULT_TC237 + test("UNIQDATA_DEFAULT_TC237", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID != BIGINT_COLUMN2 order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID != BIGINT_COLUMN2 order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC237") + + } + + + //UNIQDATA_DEFAULT_TC238 + test("UNIQDATA_DEFAULT_TC238", Include) { + + checkAnswer(s"""select CUST_ID, CUST_ID from UNIQDATA where BIGINT_COLUMN2<CUST_ID order by CUST_ID""", + s"""select CUST_ID, CUST_ID from UNIQDATA_hive where BIGINT_COLUMN2<CUST_ID order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC238") + + } + + + //UNIQDATA_DEFAULT_TC239 + test("UNIQDATA_DEFAULT_TC239", Include) { + + checkAnswer(s"""select CUST_ID, CUST_ID from UNIQDATA where CUST_ID<=CUST_ID order by CUST_ID""", + s"""select CUST_ID, CUST_ID from UNIQDATA_hive where CUST_ID<=CUST_ID order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC239") + + } + + + //UNIQDATA_DEFAULT_TC240 + test("UNIQDATA_DEFAULT_TC240", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID <1000 order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID <1000 order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC240") + + } + + + //UNIQDATA_DEFAULT_TC241 + test("UNIQDATA_DEFAULT_TC241", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID >1000 order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID >1000 order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC241") + + } + + + //UNIQDATA_DEFAULT_TC242 + test("UNIQDATA_DEFAULT_TC242", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID IS NULL order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID IS NULL order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC242") + + } + + + //UNIQDATA_DEFAULT_TC243 + test("UNIQDATA_DEFAULT_TC243", Include) { + + checkAnswer(s"""select CUST_ID from UNIQDATA where CUST_ID IS NOT NULL order by CUST_ID""", + s"""select CUST_ID from UNIQDATA_hive where CUST_ID IS NOT NULL order by CUST_ID""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC243") + + } + + + //UNIQDATA_DEFAULT_TC244 + test("UNIQDATA_DEFAULT_TC244", Include) { + + checkAnswer(s"""select sum(CUST_NAME)+10 as a from UNIQDATA""", + s"""select sum(CUST_NAME)+10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC244") + + } + + + //UNIQDATA_DEFAULT_TC245 + test("UNIQDATA_DEFAULT_TC245", Include) { + + checkAnswer(s"""select sum(CUST_NAME)*10 as a from UNIQDATA""", + s"""select sum(CUST_NAME)*10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC245") + + } + + + //UNIQDATA_DEFAULT_TC246 + test("UNIQDATA_DEFAULT_TC246", Include) { + + checkAnswer(s"""select sum(CUST_NAME)/10 as a from UNIQDATA""", + s"""select sum(CUST_NAME)/10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC246") + + } + + + //UNIQDATA_DEFAULT_TC247 + test("UNIQDATA_DEFAULT_TC247", Include) { + + checkAnswer(s"""select sum(CUST_NAME)-10 as a from UNIQDATA""", + s"""select sum(CUST_NAME)-10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC247") + + } + + + //UNIQDATA_DEFAULT_TC248 + test("UNIQDATA_DEFAULT_TC248", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1)+10 as a from UNIQDATA""", + s"""select sum(BIGINT_COLUMN1)+10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC248") + + } + + + //UNIQDATA_DEFAULT_TC249 + test("UNIQDATA_DEFAULT_TC249", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1)*10 as a from UNIQDATA""", + s"""select sum(BIGINT_COLUMN1)*10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC249") + + } + + + //UNIQDATA_DEFAULT_TC250 + test("UNIQDATA_DEFAULT_TC250", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1)/10 as a from UNIQDATA""", + s"""select sum(BIGINT_COLUMN1)/10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC250") + + } + + + //UNIQDATA_DEFAULT_TC251 + test("UNIQDATA_DEFAULT_TC251", Include) { + + checkAnswer(s"""select sum(BIGINT_COLUMN1)-10 as a from UNIQDATA""", + s"""select sum(BIGINT_COLUMN1)-10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC251") + + } + + + //UNIQDATA_DEFAULT_TC252 + test("UNIQDATA_DEFAULT_TC252", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1)+10 as a from UNIQDATA""", + s"""select sum(DECIMAL_COLUMN1)+10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC252") + + } + + + //UNIQDATA_DEFAULT_TC253 + test("UNIQDATA_DEFAULT_TC253", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1)*10 as a from UNIQDATA""", + s"""select sum(DECIMAL_COLUMN1)*10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC253") + + } + + + //UNIQDATA_DEFAULT_TC254 + test("UNIQDATA_DEFAULT_TC254", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1)/10 as a from UNIQDATA""", + s"""select sum(DECIMAL_COLUMN1)/10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC254") + + } + + + //UNIQDATA_DEFAULT_TC255 + test("UNIQDATA_DEFAULT_TC255", Include) { + + checkAnswer(s"""select sum(DECIMAL_COLUMN1)-10 as a from UNIQDATA""", + s"""select sum(DECIMAL_COLUMN1)-10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC255") + + } + + + //UNIQDATA_DEFAULT_TC256 + test("UNIQDATA_DEFAULT_TC256", Include) { + + sql(s"""select sum(Double_COLUMN1)+10 as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC257 + test("UNIQDATA_DEFAULT_TC257", Include) { + + sql(s"""select sum(Double_COLUMN1)*10 as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC258 + test("UNIQDATA_DEFAULT_TC258", Include) { + + sql(s"""select sum(Double_COLUMN1)/10 as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC259 + test("UNIQDATA_DEFAULT_TC259", Include) { + + sql(s"""select sum(Double_COLUMN1)-10 as a from UNIQDATA""").collect + + } + + + //UNIQDATA_DEFAULT_TC260 + test("UNIQDATA_DEFAULT_TC260", Include) { + + checkAnswer(s"""select sum(DOB)+10 as a from UNIQDATA""", + s"""select sum(DOB)+10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC260") + + } + + + //UNIQDATA_DEFAULT_TC261 + test("UNIQDATA_DEFAULT_TC261", Include) { + + checkAnswer(s"""select sum(DOB)*10 as a from UNIQDATA""", + s"""select sum(DOB)*10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC261") + + } + + + //UNIQDATA_DEFAULT_TC262 + test("UNIQDATA_DEFAULT_TC262", Include) { + + checkAnswer(s"""select sum(DOB)/10 as a from UNIQDATA""", + s"""select sum(DOB)/10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC262") + + } + + + //UNIQDATA_DEFAULT_TC263 + test("UNIQDATA_DEFAULT_TC263", Include) { + + checkAnswer(s"""select sum(DOB)-10 as a from UNIQDATA""", + s"""select sum(DOB)-10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC263") + + } + + + //UNIQDATA_DEFAULT_TC264 + test("UNIQDATA_DEFAULT_TC264", Include) { + + checkAnswer(s"""select sum(CUST_ID)+10 as a from UNIQDATA""", + s"""select sum(CUST_ID)+10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC264") + + } + + + //UNIQDATA_DEFAULT_TC265 + test("UNIQDATA_DEFAULT_TC265", Include) { + + checkAnswer(s"""select sum(CUST_ID)*10 as a from UNIQDATA""", + s"""select sum(CUST_ID)*10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC265") + + } + + + //UNIQDATA_DEFAULT_TC266 + test("UNIQDATA_DEFAULT_TC266", Include) { + + checkAnswer(s"""select sum(CUST_ID)/10 as a from UNIQDATA""", + s"""select sum(CUST_ID)/10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC266") + + } + + + //UNIQDATA_DEFAULT_TC267 + test("UNIQDATA_DEFAULT_TC267", Include) { + + checkAnswer(s"""select sum(CUST_ID)-10 as a from UNIQDATA""", + s"""select sum(CUST_ID)-10 as a from UNIQDATA_hive""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC267") + + } + + + //UNIQDATA_DEFAULT_TC292 + test("UNIQDATA_DEFAULT_TC292", Include) { + + checkAnswer(s"""SELECT DOB from UNIQDATA where DOB LIKE '2015-09-30%'""", + s"""SELECT DOB from UNIQDATA_hive where DOB LIKE '2015-09-30%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC292") + + } + + + //UNIQDATA_DEFAULT_TC293 + test("UNIQDATA_DEFAULT_TC293", Include) { + + checkAnswer(s"""SELECT DOB from UNIQDATA where DOB LIKE '% %'""", + s"""SELECT DOB from UNIQDATA_hive where DOB LIKE '% %'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC293") + + } + + + //UNIQDATA_DEFAULT_TC294 + test("UNIQDATA_DEFAULT_TC294", Include) { + + checkAnswer(s"""SELECT DOB from UNIQDATA where DOB LIKE '%01:00:03'""", + s"""SELECT DOB from UNIQDATA_hive where DOB LIKE '%01:00:03'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC294") + + } + + + //UNIQDATA_DEFAULT_TC295 + test("UNIQDATA_DEFAULT_TC295", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 like '123372038%' """, + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 like '123372038%' """, "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC295") + + } + + + //UNIQDATA_DEFAULT_TC296 + test("UNIQDATA_DEFAULT_TC296", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 like '%2038'""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 like '%2038'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC296") + + } + + + //UNIQDATA_DEFAULT_TC297 + test("UNIQDATA_DEFAULT_TC297", Include) { + + checkAnswer(s"""select BIGINT_COLUMN1 from UNIQDATA where BIGINT_COLUMN1 like '%2038%'""", + s"""select BIGINT_COLUMN1 from UNIQDATA_hive where BIGINT_COLUMN1 like '%2038%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC297") + + } + + + //UNIQDATA_DEFAULT_TC298 + test("UNIQDATA_DEFAULT_TC298", Include) { + + checkAnswer(s"""SELECT DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 like '123456790%'""", + s"""SELECT DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 like '123456790%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC298") + + } + + + //UNIQDATA_DEFAULT_TC299 + test("UNIQDATA_DEFAULT_TC299", Include) { + + checkAnswer(s"""SELECT DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 like '%456790%'""", + s"""SELECT DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 like '%456790%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC299") + + } + + + //UNIQDATA_DEFAULT_TC300 + test("UNIQDATA_DEFAULT_TC300", Include) { + + checkAnswer(s"""SELECT DECIMAL_COLUMN1 from UNIQDATA where DECIMAL_COLUMN1 like '123456790%'""", + s"""SELECT DECIMAL_COLUMN1 from UNIQDATA_hive where DECIMAL_COLUMN1 like '123456790%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC300") + + } + + + //UNIQDATA_DEFAULT_TC301 + test("UNIQDATA_DEFAULT_TC301", Include) { + + checkAnswer(s"""SELECT Double_COLUMN1 from UNIQDATA where Double_COLUMN1 like '1.123456748%'""", + s"""SELECT Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 like '1.123456748%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC301") + + } + + + //UNIQDATA_DEFAULT_TC302 + test("UNIQDATA_DEFAULT_TC302", Include) { + + checkAnswer(s"""SELECT Double_COLUMN1 from UNIQDATA where Double_COLUMN1 like '%23456%'""", + s"""SELECT Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 like '%23456%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC302") + + } + + + //UNIQDATA_DEFAULT_TC303 + test("UNIQDATA_DEFAULT_TC303", Include) { + + checkAnswer(s"""SELECT Double_COLUMN1 from UNIQDATA where Double_COLUMN1 like '%976E10'""", + s"""SELECT Double_COLUMN1 from UNIQDATA_hive where Double_COLUMN1 like '%976E10'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC303") + + } + + + //UNIQDATA_DEFAULT_TC304 + test("UNIQDATA_DEFAULT_TC304", Include) { + + checkAnswer(s"""SELECT CUST_ID from UNIQDATA where CUST_ID like '1000%'""", + s"""SELECT CUST_ID from UNIQDATA_hive where CUST_ID like '1000%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC304") + + } + + + //UNIQDATA_DEFAULT_TC305 + test("UNIQDATA_DEFAULT_TC305", Include) { + + checkAnswer(s"""SELECT CUST_ID from UNIQDATA where CUST_ID like '%00%'""", + s"""SELECT CUST_ID from UNIQDATA_hive where CUST_ID like '%00%'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC305") + + } + + + //UNIQDATA_DEFAULT_TC306 + test("UNIQDATA_DEFAULT_TC306", Include) { + + checkAnswer(s"""SELECT CUST_ID from UNIQDATA where CUST_ID like '%0084'""", + s"""SELECT CUST_ID from UNIQDATA_hive where CUST_ID like '%0084'""", "QueriesBasicTestCase_UNIQDATA_DEFAULT_TC306") + + } + + + //UNIQDATA_DEFAULT_TC307 + test("UNIQDATA_DEFAULT_TC307", Include) { + + checkAnswer(s"""select CUST_NAME from UNIQDATA where CUST_NAME like 'CUST_NAME_0184%'""", + s"""select CUST_NAME from U
<TRUNCATED>
