You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ja...@apache.org on 2017/09/14 09:19:59 UTC
[06/54] [abbrv] carbondata git commit: [CARBONDATA-1453]Optimize test
case IDs
http://git-wip-us.apache.org/repos/asf/carbondata/blob/588f009e/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesExcludeDictionaryTestCase.scala
----------------------------------------------------------------------
diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesExcludeDictionaryTestCase.scala b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesExcludeDictionaryTestCase.scala
index 03c2f98..03ceffe 100644
--- a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesExcludeDictionaryTestCase.scala
+++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/QueriesExcludeDictionaryTestCase.scala
@@ -28,3850 +28,3850 @@ import org.scalatest.BeforeAndAfterAll
class QueriesExcludeDictionaryTestCase extends QueryTest with BeforeAndAfterAll {
- //VMALL_DICTIONARY_EXCLUDE_CreateCube
- test("VMALL_DICTIONARY_EXCLUDE_CreateCube", Include) {
- sql(s"""drop table if exists VMALL_DICTIONARY_EXCLUDE""").collect
- sql(s"""drop table if exists VMALL_DICTIONARY_EXCLUDE1_hive""").collect
+ //DICTIONARY_EXCLUDE_CreateCube
+ test("Queries_DICTIONARY_EXCLUDE_CreateCube", Include) {
+ sql(s"""drop table if exists TABLE_DICTIONARY_EXCLUDE""").collect
+ sql(s"""drop table if exists TABLE_DICTIONARY_EXCLUDE1_hive""").collect
- sql(s"""create table VMALL_DICTIONARY_EXCLUDE (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string, deliveryTime string, channelsId string, channelsName string , deliveryAreaId string, deliveryCountry string, deliveryProvince string, deliveryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion string, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, Active_phonePA
DPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Latest_DAY Decimal(30,10), Latest_HOUR string, Latest_areaId string, Latest_country string, Latest_province string, Latest_city string, Latest_district string, Latest_street string, Latest_releaseId string, Latest_EMUIVersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, Latest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber BigInt) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_EXCLUDE'='imei')""").collect
+ sql(s"""create table TABLE_DICTIONARY_EXCLUDE (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string, deliveryTime string, channelsId string, channelsName string , deliveryAreaId string, deliveryCountry string, deliveryProvince string, deliveryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion string, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, Active_phonePA
DPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Latest_DAY Decimal(30,10), Latest_HOUR string, Latest_areaId string, Latest_country string, Latest_province string, Latest_city string, Latest_district string, Latest_street string, Latest_releaseId string, Latest_EMUIVersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, Latest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber BigInt) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_EXCLUDE'='imei')""").collect
- sql(s"""create table VMALL_DICTIONARY_EXCLUDE1_hive (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string,deliveryTime string,channelsId string,channelsName string,deliveryAreaId string,deliveryCountry string,deliveryProvince string,deliveryCity string,deliveryDistrict string,deliveryStreet string,oxSingleNumber string,contractNumber BigInt,ActiveCheckTime string,ActiveAreaId string,ActiveCountry string,ActiveProvince string,Activecity string,ActiveDistrict string,ActiveStreet string,ActiveOperatorId string,Active_releaseId string,Active_EMUIVersion string,Active_operaSysVersion string,Active_BacVerNumber string,Active_BacFlashVer string,Active_webUIVersion string,Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string,Active_operatorsVersion string,Active_phoneP
ADPartitionedVersions string,Latest_YEAR int,Latest_MONTH int,Latest_DAY Decimal(30,10),Latest_HOUR string,Latest_areaId string,Latest_country string,Latest_province string,Latest_city string,Latest_district string,Latest_street string,Latest_releaseId string,Latest_EMUIVersion string,Latest_operaSysVersion string,Latest_BacVerNumber string,Latest_BacFlashVer string,Latest_webUIVersion string,Latest_webUITypeCarrVer string,Latest_webTypeDataVerNumber string,Latest_operatorsVersion string,Latest_phonePADPartitionedVersions string,Latest_operatorId string,gamePointId double,gamePointDescription string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','""").collect
+ sql(s"""create table TABLE_DICTIONARY_EXCLUDE1_hive (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string,deliveryTime string,channelsId string,channelsName string,deliveryAreaId string,deliveryCountry string,deliveryProvince string,deliveryCity string,deliveryDistrict string,deliveryStreet string,oxSingleNumber string,contractNumber BigInt,ActiveCheckTime string,ActiveAreaId string,ActiveCountry string,ActiveProvince string,Activecity string,ActiveDistrict string,ActiveStreet string,ActiveOperatorId string,Active_releaseId string,Active_EMUIVersion string,Active_operaSysVersion string,Active_BacVerNumber string,Active_BacFlashVer string,Active_webUIVersion string,Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string,Active_operatorsVersion string,Active_phoneP
ADPartitionedVersions string,Latest_YEAR int,Latest_MONTH int,Latest_DAY Decimal(30,10),Latest_HOUR string,Latest_areaId string,Latest_country string,Latest_province string,Latest_city string,Latest_district string,Latest_street string,Latest_releaseId string,Latest_EMUIVersion string,Latest_operaSysVersion string,Latest_BacVerNumber string,Latest_BacFlashVer string,Latest_webUIVersion string,Latest_webUITypeCarrVer string,Latest_webTypeDataVerNumber string,Latest_operatorsVersion string,Latest_phonePADPartitionedVersions string,Latest_operatorId string,gamePointId double,gamePointDescription string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_CreateCube_count
- test("VMALL_DICTIONARY_EXCLUDE_CreateCube_count", Include) {
+ //DICTIONARY_EXCLUDE_CreateCube_count
+ test("Queries_DICTIONARY_EXCLUDE_CreateCube_count", Include) {
- sql(s"""select count(*) from VMALL_DICTIONARY_EXCLUDE""").collect
+ sql(s"""select count(*) from TABLE_DICTIONARY_EXCLUDE""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_DataLoad
- test("VMALL_DICTIONARY_EXCLUDE_DataLoad", Include) {
+ //DICTIONARY_EXCLUDE_DataLoad
+ test("Queries_DICTIONARY_EXCLUDE_DataLoad", Include) {
- sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table VMALL_DICTIONARY_EXCLUDE options ('DELIMITER'=',', 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_rele
aseId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription')""").collect
+ sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table TABLE_DICTIONARY_EXCLUDE options ('DELIMITER'=',', 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_rele
aseId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription')""").collect
- sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table VMALL_DICTIONARY_EXCLUDE1_hive """).collect
+ sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table TABLE_DICTIONARY_EXCLUDE1_hive """).collect
}
- //VMALL_DICTIONARY_EXCLUDE_CreateCube1
- test("VMALL_DICTIONARY_EXCLUDE_CreateCube1", Include) {
- sql(s"""drop table if exists VMALL_DICTIONARY_EXCLUDE1""").collect
+ //DICTIONARY_EXCLUDE_CreateCube1
+ test("Queries_DICTIONARY_EXCLUDE_CreateCube1", Include) {
+ sql(s"""drop table if exists TABLE_DICTIONARY_EXCLUDE1""").collect
- sql(s"""create table VMALL_DICTIONARY_EXCLUDE1 (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string, deliveryTime string, channelsId string, channelsName string , deliveryAreaId string, deliveryCountry string, deliveryProvince string, deliveryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion string, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, Active_phoneP
ADPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Latest_DAY Decimal(30,10), Latest_HOUR string, Latest_areaId string, Latest_country string, Latest_province string, Latest_city string, Latest_district string, Latest_street string, Latest_releaseId string, Latest_EMUIVersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, Latest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber BigInt) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_EXCLUDE'='imei')""").collect
+ sql(s"""create table TABLE_DICTIONARY_EXCLUDE1 (imei string,deviceInformationId int,MAC string,deviceColor string,device_backColor string,modelId string,marketName string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series string,productionDate timestamp,bomCode string,internalModels string, deliveryTime string, channelsId string, channelsName string , deliveryAreaId string, deliveryCountry string, deliveryProvince string, deliveryCity string,deliveryDistrict string, deliveryStreet string, oxSingleNumber string, ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion string, Active_operaSysVersion string, Active_BacVerNumber string, Active_BacFlashVer string, Active_webUIVersion string, Active_webUITypeCarrVer string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, Active_phoneP
ADPartitionedVersions string, Latest_YEAR int, Latest_MONTH int, Latest_DAY Decimal(30,10), Latest_HOUR string, Latest_areaId string, Latest_country string, Latest_province string, Latest_city string, Latest_district string, Latest_street string, Latest_releaseId string, Latest_EMUIVersion string, Latest_operaSysVersion string, Latest_BacVerNumber string, Latest_BacFlashVer string, Latest_webUIVersion string, Latest_webUITypeCarrVer string, Latest_webTypeDataVerNumber string, Latest_operatorsVersion string, Latest_phonePADPartitionedVersions string, Latest_operatorId string, gamePointDescription string,gamePointId double,contractNumber BigInt) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_EXCLUDE'='imei')""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_DataLoad1
- test("VMALL_DICTIONARY_EXCLUDE_DataLoad1", Include) {
+ //DICTIONARY_EXCLUDE_DataLoad1
+ test("Queries_DICTIONARY_EXCLUDE_DataLoad1", Include) {
- sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table VMALL_DICTIONARY_EXCLUDE1 options ('DELIMITER'=',', 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_rel
easeId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription')""").collect
+ sql(s"""LOAD DATA INPATH '$resourcesPath/Data/100_olap_C20.csv' INTO table TABLE_DICTIONARY_EXCLUDE1 options ('DELIMITER'=',', 'QUOTECHAR'='"', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_rel
easeId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription')""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_001
- test("VMALL_DICTIONARY_EXCLUDE_001", Include) {
+ //DICTIONARY_EXCLUDE_001
+ test("Queries_DICTIONARY_EXCLUDE_001", Include) {
- checkAnswer(s"""Select count(imei) from VMALL_DICTIONARY_EXCLUDE""",
- s"""Select count(imei) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_001")
+ checkAnswer(s"""Select count(imei) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""Select count(imei) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_001")
}
- //VMALL_DICTIONARY_EXCLUDE_002
- test("VMALL_DICTIONARY_EXCLUDE_002", Include) {
+ //DICTIONARY_EXCLUDE_002
+ test("Queries_DICTIONARY_EXCLUDE_002", Include) {
- checkAnswer(s"""select count(DISTINCT imei) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select count(DISTINCT imei) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_002")
+ checkAnswer(s"""select count(DISTINCT imei) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select count(DISTINCT imei) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_002")
}
- //VMALL_DICTIONARY_EXCLUDE_003
- test("VMALL_DICTIONARY_EXCLUDE_003", Include) {
+ //DICTIONARY_EXCLUDE_003
+ test("Queries_DICTIONARY_EXCLUDE_003", Include) {
- checkAnswer(s"""select sum(Latest_month)+10 as a ,imei from VMALL_DICTIONARY_EXCLUDE group by imei order by imei""",
- s"""select sum(Latest_month)+10 as a ,imei from VMALL_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_003")
+ checkAnswer(s"""select sum(Latest_month)+10 as a ,imei from TABLE_DICTIONARY_EXCLUDE group by imei order by imei""",
+ s"""select sum(Latest_month)+10 as a ,imei from TABLE_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_003")
}
- //VMALL_DICTIONARY_EXCLUDE_004
- test("VMALL_DICTIONARY_EXCLUDE_004", Include) {
+ //DICTIONARY_EXCLUDE_004
+ test("Queries_DICTIONARY_EXCLUDE_004", Include) {
- checkAnswer(s"""select max(imei),min(imei) from VMALL_DICTIONARY_EXCLUDE""",
- s"""select max(imei),min(imei) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_004")
+ checkAnswer(s"""select max(imei),min(imei) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select max(imei),min(imei) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_004")
}
- //VMALL_DICTIONARY_EXCLUDE_005
- test("VMALL_DICTIONARY_EXCLUDE_005", Include) {
+ //DICTIONARY_EXCLUDE_005
+ test("Queries_DICTIONARY_EXCLUDE_005", Include) {
- checkAnswer(s"""select min(imei), max(imei) Total from VMALL_DICTIONARY_EXCLUDE group by channelsId order by Total""",
- s"""select min(imei), max(imei) Total from VMALL_DICTIONARY_EXCLUDE1_hive group by channelsId order by Total""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_005")
+ checkAnswer(s"""select min(imei), max(imei) Total from TABLE_DICTIONARY_EXCLUDE group by channelsId order by Total""",
+ s"""select min(imei), max(imei) Total from TABLE_DICTIONARY_EXCLUDE1_hive group by channelsId order by Total""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_005")
}
- //VMALL_DICTIONARY_EXCLUDE_006
- test("VMALL_DICTIONARY_EXCLUDE_006", Include) {
+ //DICTIONARY_EXCLUDE_006
+ test("Queries_DICTIONARY_EXCLUDE_006", Include) {
- sql(s"""select last(imei) a from VMALL_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
+ sql(s"""select last(imei) a from TABLE_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_007
- test("VMALL_DICTIONARY_EXCLUDE_007", Include) {
+ //DICTIONARY_EXCLUDE_007
+ test("Queries_DICTIONARY_EXCLUDE_007", Include) {
- sql(s"""select FIRST(imei) a from VMALL_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
+ sql(s"""select FIRST(imei) a from TABLE_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_008
- test("VMALL_DICTIONARY_EXCLUDE_008", Include) {
+ //DICTIONARY_EXCLUDE_008
+ test("Queries_DICTIONARY_EXCLUDE_008", Include) {
- checkAnswer(s"""select imei,count(imei) a from VMALL_DICTIONARY_EXCLUDE group by imei order by imei""",
- s"""select imei,count(imei) a from VMALL_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_008")
+ checkAnswer(s"""select imei,count(imei) a from TABLE_DICTIONARY_EXCLUDE group by imei order by imei""",
+ s"""select imei,count(imei) a from TABLE_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_008")
}
- //VMALL_DICTIONARY_EXCLUDE_009
- test("VMALL_DICTIONARY_EXCLUDE_009", Include) {
+ //DICTIONARY_EXCLUDE_009
+ test("Queries_DICTIONARY_EXCLUDE_009", Include) {
- checkAnswer(s"""select Lower(imei) a from VMALL_DICTIONARY_EXCLUDE order by imei""",
- s"""select Lower(imei) a from VMALL_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_009")
+ checkAnswer(s"""select Lower(imei) a from TABLE_DICTIONARY_EXCLUDE order by imei""",
+ s"""select Lower(imei) a from TABLE_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_009")
}
- //VMALL_DICTIONARY_EXCLUDE_010
- test("VMALL_DICTIONARY_EXCLUDE_010", Include) {
+ //DICTIONARY_EXCLUDE_010
+ test("Queries_DICTIONARY_EXCLUDE_010", Include) {
- checkAnswer(s"""select distinct imei from VMALL_DICTIONARY_EXCLUDE order by imei""",
- s"""select distinct imei from VMALL_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_010")
+ checkAnswer(s"""select distinct imei from TABLE_DICTIONARY_EXCLUDE order by imei""",
+ s"""select distinct imei from TABLE_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_010")
}
- //VMALL_DICTIONARY_EXCLUDE_011
- test("VMALL_DICTIONARY_EXCLUDE_011", Include) {
+ //DICTIONARY_EXCLUDE_011
+ test("Queries_DICTIONARY_EXCLUDE_011", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE order by imei limit 101 """,
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive order by imei limit 101 """, "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_011")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE order by imei limit 101 """,
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive order by imei limit 101 """, "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_011")
}
- //VMALL_DICTIONARY_EXCLUDE_012
- test("VMALL_DICTIONARY_EXCLUDE_012", Include) {
+ //DICTIONARY_EXCLUDE_012
+ test("Queries_DICTIONARY_EXCLUDE_012", Include) {
- sql(s"""select imei as a from VMALL_DICTIONARY_EXCLUDE order by a asc limit 10""").collect
+ sql(s"""select imei as a from TABLE_DICTIONARY_EXCLUDE order by a asc limit 10""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_013
- test("VMALL_DICTIONARY_EXCLUDE_013", Include) {
+ //DICTIONARY_EXCLUDE_013
+ test("Queries_DICTIONARY_EXCLUDE_013", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100004')""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100004')""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_013")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100004')""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100004')""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_013")
}
- //VMALL_DICTIONARY_EXCLUDE_014
- test("VMALL_DICTIONARY_EXCLUDE_014", Include) {
+ //DICTIONARY_EXCLUDE_014
+ test("Queries_DICTIONARY_EXCLUDE_014", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei !='1AA100064' order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei !='1AA100064' order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_014")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei !='1AA100064' order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei !='1AA100064' order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_014")
}
- //VMALL_DICTIONARY_EXCLUDE_015
- test("VMALL_DICTIONARY_EXCLUDE_015", Include) {
+ //DICTIONARY_EXCLUDE_015
+ test("Queries_DICTIONARY_EXCLUDE_015", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_015")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_015")
}
- //VMALL_DICTIONARY_EXCLUDE_016
- test("VMALL_DICTIONARY_EXCLUDE_016", Include) {
+ //DICTIONARY_EXCLUDE_016
+ test("Queries_DICTIONARY_EXCLUDE_016", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei !='1AA100012' order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei !='1AA100012' order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_016")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei !='1AA100012' order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei !='1AA100012' order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_016")
}
- //VMALL_DICTIONARY_EXCLUDE_017
- test("VMALL_DICTIONARY_EXCLUDE_017", Include) {
+ //DICTIONARY_EXCLUDE_017
+ test("Queries_DICTIONARY_EXCLUDE_017", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei >'1AA100012' order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei >'1AA100012' order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_017")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei >'1AA100012' order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei >'1AA100012' order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_017")
}
- //VMALL_DICTIONARY_EXCLUDE_018
- test("VMALL_DICTIONARY_EXCLUDE_018", Include) {
+ //DICTIONARY_EXCLUDE_018
+ test("Queries_DICTIONARY_EXCLUDE_018", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei<>imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei<>imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_018")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei<>imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei<>imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_018")
}
- //VMALL_DICTIONARY_EXCLUDE_019
- test("VMALL_DICTIONARY_EXCLUDE_019", Include) {
+ //DICTIONARY_EXCLUDE_019
+ test("Queries_DICTIONARY_EXCLUDE_019", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei != Latest_areaId order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei != Latest_areaId order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_019")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei != Latest_areaId order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei != Latest_areaId order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_019")
}
- //VMALL_DICTIONARY_EXCLUDE_020
- test("VMALL_DICTIONARY_EXCLUDE_020", Include) {
+ //DICTIONARY_EXCLUDE_020
+ test("Queries_DICTIONARY_EXCLUDE_020", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where Latest_areaId<imei order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where Latest_areaId<imei order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_020")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where Latest_areaId<imei order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where Latest_areaId<imei order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_020")
}
- //VMALL_DICTIONARY_EXCLUDE_021
- test("VMALL_DICTIONARY_EXCLUDE_021", Include) {
+ //DICTIONARY_EXCLUDE_021
+ test("Queries_DICTIONARY_EXCLUDE_021", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where Latest_DAY<=imei order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where Latest_DAY<=imei order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_021")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where Latest_DAY<=imei order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where Latest_DAY<=imei order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_021")
}
- //VMALL_DICTIONARY_EXCLUDE_022
- test("VMALL_DICTIONARY_EXCLUDE_022", Include) {
+ //DICTIONARY_EXCLUDE_022
+ test("Queries_DICTIONARY_EXCLUDE_022", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei <'1AA10002' order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei <'1AA10002' order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_022")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei <'1AA10002' order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei <'1AA10002' order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_022")
}
- //VMALL_DICTIONARY_EXCLUDE_023
- test("VMALL_DICTIONARY_EXCLUDE_023", Include) {
+ //DICTIONARY_EXCLUDE_023
+ test("Queries_DICTIONARY_EXCLUDE_023", Include) {
- checkAnswer(s"""select Latest_day from VMALL_DICTIONARY_EXCLUDE where imei IS NULL""",
- s"""select Latest_day from VMALL_DICTIONARY_EXCLUDE1_hive where imei IS NULL""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_023")
+ checkAnswer(s"""select Latest_day from TABLE_DICTIONARY_EXCLUDE where imei IS NULL""",
+ s"""select Latest_day from TABLE_DICTIONARY_EXCLUDE1_hive where imei IS NULL""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_023")
}
- //VMALL_DICTIONARY_EXCLUDE_024
- test("VMALL_DICTIONARY_EXCLUDE_024", Include) {
+ //DICTIONARY_EXCLUDE_024
+ test("Queries_DICTIONARY_EXCLUDE_024", Include) {
- checkAnswer(s"""select Latest_day from VMALL_DICTIONARY_EXCLUDE where imei IS NOT NULL order by Latest_day""",
- s"""select Latest_day from VMALL_DICTIONARY_EXCLUDE1_hive where imei IS NOT NULL order by Latest_day""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_024")
+ checkAnswer(s"""select Latest_day from TABLE_DICTIONARY_EXCLUDE where imei IS NOT NULL order by Latest_day""",
+ s"""select Latest_day from TABLE_DICTIONARY_EXCLUDE1_hive where imei IS NOT NULL order by Latest_day""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_024")
}
- //VMALL_DICTIONARY_EXCLUDE_025
- test("VMALL_DICTIONARY_EXCLUDE_025", Include) {
+ //DICTIONARY_EXCLUDE_025
+ test("Queries_DICTIONARY_EXCLUDE_025", Include) {
- checkAnswer(s"""Select count(imei),min(imei) from VMALL_DICTIONARY_EXCLUDE """,
- s"""Select count(imei),min(imei) from VMALL_DICTIONARY_EXCLUDE1_hive """, "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_025")
+ checkAnswer(s"""Select count(imei),min(imei) from TABLE_DICTIONARY_EXCLUDE """,
+ s"""Select count(imei),min(imei) from TABLE_DICTIONARY_EXCLUDE1_hive """, "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_025")
}
- //VMALL_DICTIONARY_EXCLUDE_026
- test("VMALL_DICTIONARY_EXCLUDE_026", Include) {
+ //DICTIONARY_EXCLUDE_026
+ test("Queries_DICTIONARY_EXCLUDE_026", Include) {
- checkAnswer(s"""select count(DISTINCT imei,latest_day) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select count(DISTINCT imei,latest_day) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_026")
+ checkAnswer(s"""select count(DISTINCT imei,latest_day) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select count(DISTINCT imei,latest_day) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_026")
}
- //VMALL_DICTIONARY_EXCLUDE_027
- test("VMALL_DICTIONARY_EXCLUDE_027", Include) {
+ //DICTIONARY_EXCLUDE_027
+ test("Queries_DICTIONARY_EXCLUDE_027", Include) {
- checkAnswer(s"""select max(imei),min(imei),count(imei) from VMALL_DICTIONARY_EXCLUDE""",
- s"""select max(imei),min(imei),count(imei) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_027")
+ checkAnswer(s"""select max(imei),min(imei),count(imei) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select max(imei),min(imei),count(imei) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_027")
}
- //VMALL_DICTIONARY_EXCLUDE_028
- test("VMALL_DICTIONARY_EXCLUDE_028", Include) {
+ //DICTIONARY_EXCLUDE_028
+ test("Queries_DICTIONARY_EXCLUDE_028", Include) {
- checkAnswer(s"""select sum(imei),avg(imei),count(imei) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select sum(imei),avg(imei),count(imei) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_028")
+ checkAnswer(s"""select sum(imei),avg(imei),count(imei) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select sum(imei),avg(imei),count(imei) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_028")
}
- //VMALL_DICTIONARY_EXCLUDE_029
- test("VMALL_DICTIONARY_EXCLUDE_029", Include) {
+ //DICTIONARY_EXCLUDE_029
+ test("Queries_DICTIONARY_EXCLUDE_029", Include) {
- sql(s"""select last(imei),Min(imei),max(imei) a from VMALL_DICTIONARY_EXCLUDE order by a""").collect
+ sql(s"""select last(imei),Min(imei),max(imei) a from TABLE_DICTIONARY_EXCLUDE order by a""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_030
- test("VMALL_DICTIONARY_EXCLUDE_030", Include) {
+ //DICTIONARY_EXCLUDE_030
+ test("Queries_DICTIONARY_EXCLUDE_030", Include) {
- sql(s"""select FIRST(imei),Last(imei) a from VMALL_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
+ sql(s"""select FIRST(imei),Last(imei) a from TABLE_DICTIONARY_EXCLUDE group by imei order by imei limit 1""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_031
- test("VMALL_DICTIONARY_EXCLUDE_031", Include) {
+ //DICTIONARY_EXCLUDE_031
+ test("Queries_DICTIONARY_EXCLUDE_031", Include) {
- checkAnswer(s"""select imei,count(imei) a from VMALL_DICTIONARY_EXCLUDE group by imei order by imei""",
- s"""select imei,count(imei) a from VMALL_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_031")
+ checkAnswer(s"""select imei,count(imei) a from TABLE_DICTIONARY_EXCLUDE group by imei order by imei""",
+ s"""select imei,count(imei) a from TABLE_DICTIONARY_EXCLUDE1_hive group by imei order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_031")
}
- //VMALL_DICTIONARY_EXCLUDE_032
- test("VMALL_DICTIONARY_EXCLUDE_032", Include) {
+ //DICTIONARY_EXCLUDE_032
+ test("Queries_DICTIONARY_EXCLUDE_032", Include) {
- checkAnswer(s"""select Lower(imei),upper(imei) a from VMALL_DICTIONARY_EXCLUDE order by imei""",
- s"""select Lower(imei),upper(imei) a from VMALL_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_032")
+ checkAnswer(s"""select Lower(imei),upper(imei) a from TABLE_DICTIONARY_EXCLUDE order by imei""",
+ s"""select Lower(imei),upper(imei) a from TABLE_DICTIONARY_EXCLUDE1_hive order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_032")
}
- //VMALL_DICTIONARY_EXCLUDE_033
- test("VMALL_DICTIONARY_EXCLUDE_033", Include) {
+ //DICTIONARY_EXCLUDE_033
+ test("Queries_DICTIONARY_EXCLUDE_033", Include) {
- checkAnswer(s"""select imei as a from VMALL_DICTIONARY_EXCLUDE order by a asc limit 10""",
- s"""select imei as a from VMALL_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_033")
+ checkAnswer(s"""select imei as a from TABLE_DICTIONARY_EXCLUDE order by a asc limit 10""",
+ s"""select imei as a from TABLE_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_033")
}
- //VMALL_DICTIONARY_EXCLUDE_034
- test("VMALL_DICTIONARY_EXCLUDE_034", Include) {
+ //DICTIONARY_EXCLUDE_034
+ test("Queries_DICTIONARY_EXCLUDE_034", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100012')""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100012')""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_034")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100012')""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100012')""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_034")
}
- //VMALL_DICTIONARY_EXCLUDE_035
- test("VMALL_DICTIONARY_EXCLUDE_035", Include) {
+ //DICTIONARY_EXCLUDE_035
+ test("Queries_DICTIONARY_EXCLUDE_035", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where imei !='8imei' order by imei""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where imei !='8imei' order by imei""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_035")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where imei !='8imei' order by imei""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where imei !='8imei' order by imei""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_035")
}
- //VMALL_DICTIONARY_EXCLUDE_036
- test("VMALL_DICTIONARY_EXCLUDE_036", Include) {
+ //DICTIONARY_EXCLUDE_036
+ test("Queries_DICTIONARY_EXCLUDE_036", Include) {
- checkAnswer(s"""select imei from VMALL_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""",
- s"""select imei from VMALL_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_036")
+ checkAnswer(s"""select imei from TABLE_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""",
+ s"""select imei from TABLE_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color')""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_036")
}
- //VMALL_DICTIONARY_EXCLUDE_037
- test("VMALL_DICTIONARY_EXCLUDE_037", Include) {
+ //DICTIONARY_EXCLUDE_037
+ test("Queries_DICTIONARY_EXCLUDE_037", Include) {
- checkAnswer(s"""Select count(contractNumber) from VMALL_DICTIONARY_EXCLUDE""",
- s"""Select count(contractNumber) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_037")
+ checkAnswer(s"""Select count(contractNumber) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""Select count(contractNumber) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_037")
}
- //VMALL_DICTIONARY_EXCLUDE_038
- test("VMALL_DICTIONARY_EXCLUDE_038", Include) {
+ //DICTIONARY_EXCLUDE_038
+ test("Queries_DICTIONARY_EXCLUDE_038", Include) {
- checkAnswer(s"""select count(DISTINCT contractNumber) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select count(DISTINCT contractNumber) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_038")
+ checkAnswer(s"""select count(DISTINCT contractNumber) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select count(DISTINCT contractNumber) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_038")
}
- //VMALL_DICTIONARY_EXCLUDE_039
- test("VMALL_DICTIONARY_EXCLUDE_039", Include) {
+ //DICTIONARY_EXCLUDE_039
+ test("Queries_DICTIONARY_EXCLUDE_039", Include) {
- checkAnswer(s"""select sum(contractNumber)+10 as a ,contractNumber from VMALL_DICTIONARY_EXCLUDE group by contractNumber""",
- s"""select sum(contractNumber)+10 as a ,contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive group by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_039")
+ checkAnswer(s"""select sum(contractNumber)+10 as a ,contractNumber from TABLE_DICTIONARY_EXCLUDE group by contractNumber""",
+ s"""select sum(contractNumber)+10 as a ,contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive group by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_039")
}
- //VMALL_DICTIONARY_EXCLUDE_040
- test("VMALL_DICTIONARY_EXCLUDE_040", Include) {
+ //DICTIONARY_EXCLUDE_040
+ test("Queries_DICTIONARY_EXCLUDE_040", Include) {
- checkAnswer(s"""select max(contractNumber),min(contractNumber) from VMALL_DICTIONARY_EXCLUDE""",
- s"""select max(contractNumber),min(contractNumber) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_040")
+ checkAnswer(s"""select max(contractNumber),min(contractNumber) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select max(contractNumber),min(contractNumber) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_040")
}
- //VMALL_DICTIONARY_EXCLUDE_041
- test("VMALL_DICTIONARY_EXCLUDE_041", Include) {
+ //DICTIONARY_EXCLUDE_041
+ test("Queries_DICTIONARY_EXCLUDE_041", Include) {
- checkAnswer(s"""select sum(contractNumber) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select sum(contractNumber) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_041")
+ checkAnswer(s"""select sum(contractNumber) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select sum(contractNumber) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_041")
}
- //VMALL_DICTIONARY_EXCLUDE_042
- test("VMALL_DICTIONARY_EXCLUDE_042", Include) {
+ //DICTIONARY_EXCLUDE_042
+ test("Queries_DICTIONARY_EXCLUDE_042", Include) {
- checkAnswer(s"""select avg(contractNumber) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select avg(contractNumber) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_042")
+ checkAnswer(s"""select avg(contractNumber) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select avg(contractNumber) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_042")
}
- //VMALL_DICTIONARY_EXCLUDE_043
- test("VMALL_DICTIONARY_EXCLUDE_043", Include) {
+ //DICTIONARY_EXCLUDE_043
+ test("Queries_DICTIONARY_EXCLUDE_043", Include) {
- checkAnswer(s"""select min(contractNumber) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select min(contractNumber) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_043")
+ checkAnswer(s"""select min(contractNumber) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select min(contractNumber) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_043")
}
- //VMALL_DICTIONARY_EXCLUDE_044
- test("VMALL_DICTIONARY_EXCLUDE_044", Include) {
+ //DICTIONARY_EXCLUDE_044
+ test("Queries_DICTIONARY_EXCLUDE_044", Include) {
- sql(s"""select variance(contractNumber) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select variance(contractNumber) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_045
- ignore("VMALL_DICTIONARY_EXCLUDE_045", Include) {
+ //DICTIONARY_EXCLUDE_045
+ ignore("Queries_DICTIONARY_EXCLUDE_045", Include) {
- checkAnswer(s"""select var_pop(contractNumber) as a from (select * from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""",
- s"""select var_pop(contractNumber) as a from (select * from VMALL_DICTIONARY_EXCLUDE1_hive order by contractNumber) t""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_045")
+ checkAnswer(s"""select var_pop(contractNumber) as a from (select * from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""",
+ s"""select var_pop(contractNumber) as a from (select * from TABLE_DICTIONARY_EXCLUDE1_hive order by contractNumber) t""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_045")
}
- //VMALL_DICTIONARY_EXCLUDE_046
- ignore("VMALL_DICTIONARY_EXCLUDE_046", Include) {
+ //DICTIONARY_EXCLUDE_046
+ ignore("Queries_DICTIONARY_EXCLUDE_046", Include) {
- checkAnswer(s"""select var_samp(contractNumber) as a from (select * from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""",
- s"""select var_samp(contractNumber) as a from (select * from VMALL_DICTIONARY_EXCLUDE1_hive order by contractNumber) t""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_046")
+ checkAnswer(s"""select var_samp(contractNumber) as a from (select * from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""",
+ s"""select var_samp(contractNumber) as a from (select * from TABLE_DICTIONARY_EXCLUDE1_hive order by contractNumber) t""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_046")
}
- //VMALL_DICTIONARY_EXCLUDE_047
- test("VMALL_DICTIONARY_EXCLUDE_047", Include) {
+ //DICTIONARY_EXCLUDE_047
+ test("Queries_DICTIONARY_EXCLUDE_047", Include) {
- sql(s"""select stddev_pop(contractNumber) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select stddev_pop(contractNumber) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_048
- test("VMALL_DICTIONARY_EXCLUDE_048", Include) {
+ //DICTIONARY_EXCLUDE_048
+ test("Queries_DICTIONARY_EXCLUDE_048", Include) {
- sql(s"""select stddev_samp(contractNumber) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select stddev_samp(contractNumber) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_049
- test("VMALL_DICTIONARY_EXCLUDE_049", Include) {
+ //DICTIONARY_EXCLUDE_049
+ test("Queries_DICTIONARY_EXCLUDE_049", Include) {
- sql(s"""select covar_pop(contractNumber,contractNumber) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select covar_pop(contractNumber,contractNumber) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_050
- test("VMALL_DICTIONARY_EXCLUDE_050", Include) {
+ //DICTIONARY_EXCLUDE_050
+ test("Queries_DICTIONARY_EXCLUDE_050", Include) {
- sql(s"""select covar_samp(contractNumber,contractNumber) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select covar_samp(contractNumber,contractNumber) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_051
- test("VMALL_DICTIONARY_EXCLUDE_051", Include) {
+ //DICTIONARY_EXCLUDE_051
+ test("Queries_DICTIONARY_EXCLUDE_051", Include) {
- checkAnswer(s"""select corr(contractNumber,contractNumber) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select corr(contractNumber,contractNumber) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_051")
+ checkAnswer(s"""select corr(contractNumber,contractNumber) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select corr(contractNumber,contractNumber) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_051")
}
- //VMALL_DICTIONARY_EXCLUDE_052
- test("VMALL_DICTIONARY_EXCLUDE_052", Include) {
+ //DICTIONARY_EXCLUDE_052
+ test("Queries_DICTIONARY_EXCLUDE_052", Include) {
- sql(s"""select percentile_approx(contractNumber,0.2) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select percentile_approx(contractNumber,0.2) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_053
- test("VMALL_DICTIONARY_EXCLUDE_053", Include) {
+ //DICTIONARY_EXCLUDE_053
+ test("Queries_DICTIONARY_EXCLUDE_053", Include) {
- sql(s"""select percentile_approx(contractNumber,0.2,5) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select percentile_approx(contractNumber,0.2,5) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_054
- test("VMALL_DICTIONARY_EXCLUDE_054", Include) {
+ //DICTIONARY_EXCLUDE_054
+ test("Queries_DICTIONARY_EXCLUDE_054", Include) {
- sql(s"""select percentile_approx(contractNumber,array(0.2,0.3,0.99)) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select percentile_approx(contractNumber,array(0.2,0.3,0.99)) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_055
- test("VMALL_DICTIONARY_EXCLUDE_055", Include) {
+ //DICTIONARY_EXCLUDE_055
+ test("Queries_DICTIONARY_EXCLUDE_055", Include) {
- sql(s"""select percentile_approx(contractNumber,array(0.2,0.3,0.99),5) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select percentile_approx(contractNumber,array(0.2,0.3,0.99),5) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_056
- test("VMALL_DICTIONARY_EXCLUDE_056", Include) {
+ //DICTIONARY_EXCLUDE_056
+ test("Queries_DICTIONARY_EXCLUDE_056", Include) {
- sql(s"""select histogram_numeric(contractNumber,2) as a from (select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
+ sql(s"""select histogram_numeric(contractNumber,2) as a from (select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_057
- test("VMALL_DICTIONARY_EXCLUDE_057", Include) {
+ //DICTIONARY_EXCLUDE_057
+ test("Queries_DICTIONARY_EXCLUDE_057", Include) {
- checkAnswer(s"""select contractNumber+ 10 as a from VMALL_DICTIONARY_EXCLUDE order by a""",
- s"""select contractNumber+ 10 as a from VMALL_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_057")
+ checkAnswer(s"""select contractNumber+ 10 as a from TABLE_DICTIONARY_EXCLUDE order by a""",
+ s"""select contractNumber+ 10 as a from TABLE_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_057")
}
- //VMALL_DICTIONARY_EXCLUDE_058
- test("VMALL_DICTIONARY_EXCLUDE_058", Include) {
+ //DICTIONARY_EXCLUDE_058
+ test("Queries_DICTIONARY_EXCLUDE_058", Include) {
- checkAnswer(s"""select min(contractNumber), max(contractNumber+ 10) Total from VMALL_DICTIONARY_EXCLUDE group by channelsId order by Total""",
- s"""select min(contractNumber), max(contractNumber+ 10) Total from VMALL_DICTIONARY_EXCLUDE1_hive group by channelsId order by Total""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_058")
+ checkAnswer(s"""select min(contractNumber), max(contractNumber+ 10) Total from TABLE_DICTIONARY_EXCLUDE group by channelsId order by Total""",
+ s"""select min(contractNumber), max(contractNumber+ 10) Total from TABLE_DICTIONARY_EXCLUDE1_hive group by channelsId order by Total""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_058")
}
- //VMALL_DICTIONARY_EXCLUDE_059
- test("VMALL_DICTIONARY_EXCLUDE_059", Include) {
+ //DICTIONARY_EXCLUDE_059
+ test("Queries_DICTIONARY_EXCLUDE_059", Include) {
- sql(s"""select last(contractNumber) a from VMALL_DICTIONARY_EXCLUDE order by a""").collect
+ sql(s"""select last(contractNumber) a from TABLE_DICTIONARY_EXCLUDE order by a""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_060
- test("VMALL_DICTIONARY_EXCLUDE_060", Include) {
+ //DICTIONARY_EXCLUDE_060
+ test("Queries_DICTIONARY_EXCLUDE_060", Include) {
- sql(s"""select FIRST(contractNumber) a from VMALL_DICTIONARY_EXCLUDE order by a""").collect
+ sql(s"""select FIRST(contractNumber) a from TABLE_DICTIONARY_EXCLUDE order by a""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_061
- test("VMALL_DICTIONARY_EXCLUDE_061", Include) {
+ //DICTIONARY_EXCLUDE_061
+ test("Queries_DICTIONARY_EXCLUDE_061", Include) {
- checkAnswer(s"""select contractNumber,count(contractNumber) a from VMALL_DICTIONARY_EXCLUDE group by contractNumber order by contractNumber""",
- s"""select contractNumber,count(contractNumber) a from VMALL_DICTIONARY_EXCLUDE1_hive group by contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_061")
+ checkAnswer(s"""select contractNumber,count(contractNumber) a from TABLE_DICTIONARY_EXCLUDE group by contractNumber order by contractNumber""",
+ s"""select contractNumber,count(contractNumber) a from TABLE_DICTIONARY_EXCLUDE1_hive group by contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_061")
}
- //VMALL_DICTIONARY_EXCLUDE_062
- test("VMALL_DICTIONARY_EXCLUDE_062", Include) {
+ //DICTIONARY_EXCLUDE_062
+ test("Queries_DICTIONARY_EXCLUDE_062", Include) {
- checkAnswer(s"""select Lower(contractNumber) a from VMALL_DICTIONARY_EXCLUDE order by contractNumber""",
- s"""select Lower(contractNumber) a from VMALL_DICTIONARY_EXCLUDE1_hive order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_062")
+ checkAnswer(s"""select Lower(contractNumber) a from TABLE_DICTIONARY_EXCLUDE order by contractNumber""",
+ s"""select Lower(contractNumber) a from TABLE_DICTIONARY_EXCLUDE1_hive order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_062")
}
- //VMALL_DICTIONARY_EXCLUDE_063
- test("VMALL_DICTIONARY_EXCLUDE_063", Include) {
+ //DICTIONARY_EXCLUDE_063
+ test("Queries_DICTIONARY_EXCLUDE_063", Include) {
- checkAnswer(s"""select distinct contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber""",
- s"""select distinct contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_063")
+ checkAnswer(s"""select distinct contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber""",
+ s"""select distinct contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_063")
}
- //VMALL_DICTIONARY_EXCLUDE_064
- test("VMALL_DICTIONARY_EXCLUDE_064", Include) {
+ //DICTIONARY_EXCLUDE_064
+ test("Queries_DICTIONARY_EXCLUDE_064", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE order by contractNumber limit 101""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive order by contractNumber limit 101""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_064")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE order by contractNumber limit 101""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive order by contractNumber limit 101""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_064")
}
- //VMALL_DICTIONARY_EXCLUDE_065
- test("VMALL_DICTIONARY_EXCLUDE_065", Include) {
+ //DICTIONARY_EXCLUDE_065
+ test("Queries_DICTIONARY_EXCLUDE_065", Include) {
- checkAnswer(s"""select contractNumber as a from VMALL_DICTIONARY_EXCLUDE order by a asc limit 10""",
- s"""select contractNumber as a from VMALL_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_065")
+ checkAnswer(s"""select contractNumber as a from TABLE_DICTIONARY_EXCLUDE order by a asc limit 10""",
+ s"""select contractNumber as a from TABLE_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_065")
}
- //VMALL_DICTIONARY_EXCLUDE_066
- test("VMALL_DICTIONARY_EXCLUDE_066", Include) {
+ //DICTIONARY_EXCLUDE_066
+ test("Queries_DICTIONARY_EXCLUDE_066", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100012')""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100012')""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_066")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where (contractNumber == 9223372047700) and (imei=='1AA100012')""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where (contractNumber == 9223372047700) and (imei=='1AA100012')""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_066")
}
- //VMALL_DICTIONARY_EXCLUDE_067
- test("VMALL_DICTIONARY_EXCLUDE_067", Include) {
+ //DICTIONARY_EXCLUDE_067
+ test("Queries_DICTIONARY_EXCLUDE_067", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber !=9223372047700 order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber !=9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_067")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber !=9223372047700 order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber !=9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_067")
}
- //VMALL_DICTIONARY_EXCLUDE_068
- test("VMALL_DICTIONARY_EXCLUDE_068", Include) {
+ //DICTIONARY_EXCLUDE_068
+ test("Queries_DICTIONARY_EXCLUDE_068", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color') order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color') order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_068")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color') order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where (deviceInformationId=100 and deviceColor='1Device Color') OR (deviceInformationId=10 and deviceColor='0Device Color') order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_068")
}
- //VMALL_DICTIONARY_EXCLUDE_069
- test("VMALL_DICTIONARY_EXCLUDE_069", Include) {
+ //DICTIONARY_EXCLUDE_069
+ test("Queries_DICTIONARY_EXCLUDE_069", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber !=9223372047700 order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber !=9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_069")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber !=9223372047700 order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber !=9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_069")
}
- //VMALL_DICTIONARY_EXCLUDE_070
- test("VMALL_DICTIONARY_EXCLUDE_070", Include) {
+ //DICTIONARY_EXCLUDE_070
+ test("Queries_DICTIONARY_EXCLUDE_070", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber >9223372047700 order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber >9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_070")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber >9223372047700 order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber >9223372047700 order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_070")
}
- //VMALL_DICTIONARY_EXCLUDE_071
- test("VMALL_DICTIONARY_EXCLUDE_071", Include) {
+ //DICTIONARY_EXCLUDE_071
+ test("Queries_DICTIONARY_EXCLUDE_071", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber<>contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber<>contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_071")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber<>contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber<>contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_071")
}
- //VMALL_DICTIONARY_EXCLUDE_072
- test("VMALL_DICTIONARY_EXCLUDE_072", Include) {
+ //DICTIONARY_EXCLUDE_072
+ test("Queries_DICTIONARY_EXCLUDE_072", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber != Latest_areaId order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber != Latest_areaId order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_072")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber != Latest_areaId order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber != Latest_areaId order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_072")
}
- //VMALL_DICTIONARY_EXCLUDE_073
- test("VMALL_DICTIONARY_EXCLUDE_073", Include) {
+ //DICTIONARY_EXCLUDE_073
+ test("Queries_DICTIONARY_EXCLUDE_073", Include) {
- checkAnswer(s"""select contractNumber, contractNumber from VMALL_DICTIONARY_EXCLUDE where Latest_areaId<contractNumber order by contractNumber""",
- s"""select contractNumber, contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where Latest_areaId<contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_073")
+ checkAnswer(s"""select contractNumber, contractNumber from TABLE_DICTIONARY_EXCLUDE where Latest_areaId<contractNumber order by contractNumber""",
+ s"""select contractNumber, contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where Latest_areaId<contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_073")
}
- //VMALL_DICTIONARY_EXCLUDE_074
- test("VMALL_DICTIONARY_EXCLUDE_074", Include) {
+ //DICTIONARY_EXCLUDE_074
+ test("Queries_DICTIONARY_EXCLUDE_074", Include) {
- checkAnswer(s"""select contractNumber, contractNumber from VMALL_DICTIONARY_EXCLUDE where Latest_DAY<=contractNumber order by contractNumber""",
- s"""select contractNumber, contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where Latest_DAY<=contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_074")
+ checkAnswer(s"""select contractNumber, contractNumber from TABLE_DICTIONARY_EXCLUDE where Latest_DAY<=contractNumber order by contractNumber""",
+ s"""select contractNumber, contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where Latest_DAY<=contractNumber order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_074")
}
- //VMALL_DICTIONARY_EXCLUDE_075
- test("VMALL_DICTIONARY_EXCLUDE_075", Include) {
+ //DICTIONARY_EXCLUDE_075
+ test("Queries_DICTIONARY_EXCLUDE_075", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber <1000 order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber <1000 order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_075")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber <1000 order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber <1000 order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_075")
}
- //VMALL_DICTIONARY_EXCLUDE_076
- test("VMALL_DICTIONARY_EXCLUDE_076", Include) {
+ //DICTIONARY_EXCLUDE_076
+ test("Queries_DICTIONARY_EXCLUDE_076", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber >1000 order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber >1000 order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_076")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber >1000 order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber >1000 order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_076")
}
- //VMALL_DICTIONARY_EXCLUDE_077
- test("VMALL_DICTIONARY_EXCLUDE_077", Include) {
+ //DICTIONARY_EXCLUDE_077
+ test("Queries_DICTIONARY_EXCLUDE_077", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where contractNumber IS NULL order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where contractNumber IS NULL order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_077")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where contractNumber IS NULL order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where contractNumber IS NULL order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_077")
}
- //VMALL_DICTIONARY_EXCLUDE_078
- test("VMALL_DICTIONARY_EXCLUDE_078", Include) {
+ //DICTIONARY_EXCLUDE_078
+ test("Queries_DICTIONARY_EXCLUDE_078", Include) {
- checkAnswer(s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE where Latest_DAY IS NOT NULL order by contractNumber""",
- s"""select contractNumber from VMALL_DICTIONARY_EXCLUDE1_hive where Latest_DAY IS NOT NULL order by contractNumber""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_078")
+ checkAnswer(s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE where Latest_DAY IS NOT NULL order by contractNumber""",
+ s"""select contractNumber from TABLE_DICTIONARY_EXCLUDE1_hive where Latest_DAY IS NOT NULL order by contractNumber""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_078")
}
- //VMALL_DICTIONARY_EXCLUDE_079
- test("VMALL_DICTIONARY_EXCLUDE_079", Include) {
+ //DICTIONARY_EXCLUDE_079
+ test("Queries_DICTIONARY_EXCLUDE_079", Include) {
- checkAnswer(s"""Select count(Latest_DAY) from VMALL_DICTIONARY_EXCLUDE""",
- s"""Select count(Latest_DAY) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_079")
+ checkAnswer(s"""Select count(Latest_DAY) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""Select count(Latest_DAY) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_079")
}
- //VMALL_DICTIONARY_EXCLUDE_080
- test("VMALL_DICTIONARY_EXCLUDE_080", Include) {
+ //DICTIONARY_EXCLUDE_080
+ test("Queries_DICTIONARY_EXCLUDE_080", Include) {
- checkAnswer(s"""select count(DISTINCT Latest_DAY) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select count(DISTINCT Latest_DAY) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_080")
+ checkAnswer(s"""select count(DISTINCT Latest_DAY) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select count(DISTINCT Latest_DAY) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_080")
}
- //VMALL_DICTIONARY_EXCLUDE_081
- test("VMALL_DICTIONARY_EXCLUDE_081", Include) {
+ //DICTIONARY_EXCLUDE_081
+ test("Queries_DICTIONARY_EXCLUDE_081", Include) {
- checkAnswer(s"""select sum(Latest_DAY)+10 as a ,Latest_DAY from VMALL_DICTIONARY_EXCLUDE group by Latest_DAY order by a""",
- s"""select sum(Latest_DAY)+10 as a ,Latest_DAY from VMALL_DICTIONARY_EXCLUDE1_hive group by Latest_DAY order by a""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_081")
+ checkAnswer(s"""select sum(Latest_DAY)+10 as a ,Latest_DAY from TABLE_DICTIONARY_EXCLUDE group by Latest_DAY order by a""",
+ s"""select sum(Latest_DAY)+10 as a ,Latest_DAY from TABLE_DICTIONARY_EXCLUDE1_hive group by Latest_DAY order by a""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_081")
}
- //VMALL_DICTIONARY_EXCLUDE_082
- test("VMALL_DICTIONARY_EXCLUDE_082", Include) {
+ //DICTIONARY_EXCLUDE_082
+ test("Queries_DICTIONARY_EXCLUDE_082", Include) {
- checkAnswer(s"""select max(Latest_DAY),min(Latest_DAY) from VMALL_DICTIONARY_EXCLUDE""",
- s"""select max(Latest_DAY),min(Latest_DAY) from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_082")
+ checkAnswer(s"""select max(Latest_DAY),min(Latest_DAY) from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select max(Latest_DAY),min(Latest_DAY) from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_082")
}
- //VMALL_DICTIONARY_EXCLUDE_083
- test("VMALL_DICTIONARY_EXCLUDE_083", Include) {
+ //DICTIONARY_EXCLUDE_083
+ test("Queries_DICTIONARY_EXCLUDE_083", Include) {
- checkAnswer(s"""select sum(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select sum(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_083")
+ checkAnswer(s"""select sum(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select sum(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_083")
}
- //VMALL_DICTIONARY_EXCLUDE_084
- test("VMALL_DICTIONARY_EXCLUDE_084", Include) {
+ //DICTIONARY_EXCLUDE_084
+ test("Queries_DICTIONARY_EXCLUDE_084", Include) {
- checkAnswer(s"""select avg(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select avg(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_084")
+ checkAnswer(s"""select avg(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select avg(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_084")
}
- //VMALL_DICTIONARY_EXCLUDE_085
- test("VMALL_DICTIONARY_EXCLUDE_085", Include) {
+ //DICTIONARY_EXCLUDE_085
+ test("Queries_DICTIONARY_EXCLUDE_085", Include) {
- checkAnswer(s"""select min(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select min(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_085")
+ checkAnswer(s"""select min(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select min(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_085")
}
- //VMALL_DICTIONARY_EXCLUDE_086
- test("VMALL_DICTIONARY_EXCLUDE_086", Include) {
+ //DICTIONARY_EXCLUDE_086
+ test("Queries_DICTIONARY_EXCLUDE_086", Include) {
- sql(s"""select variance(Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select variance(Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_087
- test("VMALL_DICTIONARY_EXCLUDE_087", Include) {
+ //DICTIONARY_EXCLUDE_087
+ test("Queries_DICTIONARY_EXCLUDE_087", Include) {
- sql(s"""select var_pop(Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select var_pop(Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_088
- test("VMALL_DICTIONARY_EXCLUDE_088", Include) {
+ //DICTIONARY_EXCLUDE_088
+ test("Queries_DICTIONARY_EXCLUDE_088", Include) {
- sql(s"""select var_samp(Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select var_samp(Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_089
- test("VMALL_DICTIONARY_EXCLUDE_089", Include) {
+ //DICTIONARY_EXCLUDE_089
+ test("Queries_DICTIONARY_EXCLUDE_089", Include) {
- sql(s"""select stddev_pop(Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select stddev_pop(Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_090
- test("VMALL_DICTIONARY_EXCLUDE_090", Include) {
+ //DICTIONARY_EXCLUDE_090
+ test("Queries_DICTIONARY_EXCLUDE_090", Include) {
- sql(s"""select stddev_samp(Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select stddev_samp(Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_091
- test("VMALL_DICTIONARY_EXCLUDE_091", Include) {
+ //DICTIONARY_EXCLUDE_091
+ test("Queries_DICTIONARY_EXCLUDE_091", Include) {
- sql(s"""select covar_pop(Latest_DAY,Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select covar_pop(Latest_DAY,Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_092
- test("VMALL_DICTIONARY_EXCLUDE_092", Include) {
+ //DICTIONARY_EXCLUDE_092
+ test("Queries_DICTIONARY_EXCLUDE_092", Include) {
- sql(s"""select covar_samp(Latest_DAY,Latest_DAY) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select covar_samp(Latest_DAY,Latest_DAY) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_093
- test("VMALL_DICTIONARY_EXCLUDE_093", Include) {
+ //DICTIONARY_EXCLUDE_093
+ test("Queries_DICTIONARY_EXCLUDE_093", Include) {
- checkAnswer(s"""select corr(Latest_DAY,Latest_DAY) as a from VMALL_DICTIONARY_EXCLUDE""",
- s"""select corr(Latest_DAY,Latest_DAY) as a from VMALL_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_093")
+ checkAnswer(s"""select corr(Latest_DAY,Latest_DAY) as a from TABLE_DICTIONARY_EXCLUDE""",
+ s"""select corr(Latest_DAY,Latest_DAY) as a from TABLE_DICTIONARY_EXCLUDE1_hive""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_093")
}
- //VMALL_DICTIONARY_EXCLUDE_094
- test("VMALL_DICTIONARY_EXCLUDE_094", Include) {
+ //DICTIONARY_EXCLUDE_094
+ test("Queries_DICTIONARY_EXCLUDE_094", Include) {
- sql(s"""select percentile_approx(Latest_DAY,0.2) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select percentile_approx(Latest_DAY,0.2) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_095
- test("VMALL_DICTIONARY_EXCLUDE_095", Include) {
+ //DICTIONARY_EXCLUDE_095
+ test("Queries_DICTIONARY_EXCLUDE_095", Include) {
- sql(s"""select percentile_approx(Latest_DAY,0.2,5) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select percentile_approx(Latest_DAY,0.2,5) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_096
- test("VMALL_DICTIONARY_EXCLUDE_096", Include) {
+ //DICTIONARY_EXCLUDE_096
+ test("Queries_DICTIONARY_EXCLUDE_096", Include) {
- sql(s"""select percentile_approx(Latest_DAY,array(0.2,0.3,0.99)) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select percentile_approx(Latest_DAY,array(0.2,0.3,0.99)) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_097
- test("VMALL_DICTIONARY_EXCLUDE_097", Include) {
+ //DICTIONARY_EXCLUDE_097
+ test("Queries_DICTIONARY_EXCLUDE_097", Include) {
- sql(s"""select percentile_approx(Latest_DAY,array(0.2,0.3,0.99),5) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select percentile_approx(Latest_DAY,array(0.2,0.3,0.99),5) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_098
- test("VMALL_DICTIONARY_EXCLUDE_098", Include) {
+ //DICTIONARY_EXCLUDE_098
+ test("Queries_DICTIONARY_EXCLUDE_098", Include) {
- sql(s"""select histogram_numeric(Latest_DAY,2) as a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select histogram_numeric(Latest_DAY,2) as a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_099
- test("VMALL_DICTIONARY_EXCLUDE_099", Include) {
+ //DICTIONARY_EXCLUDE_099
+ test("Queries_DICTIONARY_EXCLUDE_099", Include) {
- checkAnswer(s"""select Latest_DAY, Latest_DAY+ 10 as a from VMALL_DICTIONARY_EXCLUDE order by a""",
- s"""select Latest_DAY, Latest_DAY+ 10 as a from VMALL_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_099")
+ checkAnswer(s"""select Latest_DAY, Latest_DAY+ 10 as a from TABLE_DICTIONARY_EXCLUDE order by a""",
+ s"""select Latest_DAY, Latest_DAY+ 10 as a from TABLE_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_099")
}
- //VMALL_DICTIONARY_EXCLUDE_100
- test("VMALL_DICTIONARY_EXCLUDE_100", Include) {
+ //DICTIONARY_EXCLUDE_100
+ test("Queries_DICTIONARY_EXCLUDE_100", Include) {
- checkAnswer(s"""select min(Latest_DAY) d, max(Latest_DAY+ 10) Total from VMALL_DICTIONARY_EXCLUDE group by channelsId order by d, Total""",
- s"""select min(Latest_DAY) d, max(Latest_DAY+ 10) Total from VMALL_DICTIONARY_EXCLUDE1_hive group by channelsId order by d,Total""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_100")
+ checkAnswer(s"""select min(Latest_DAY) d, max(Latest_DAY+ 10) Total from TABLE_DICTIONARY_EXCLUDE group by channelsId order by d, Total""",
+ s"""select min(Latest_DAY) d, max(Latest_DAY+ 10) Total from TABLE_DICTIONARY_EXCLUDE1_hive group by channelsId order by d,Total""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_100")
}
- //VMALL_DICTIONARY_EXCLUDE_101
- test("VMALL_DICTIONARY_EXCLUDE_101", Include) {
+ //DICTIONARY_EXCLUDE_101
+ test("Queries_DICTIONARY_EXCLUDE_101", Include) {
- sql(s"""select last(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE order by a""").collect
+ sql(s"""select last(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE order by a""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_102
- test("VMALL_DICTIONARY_EXCLUDE_102", Include) {
+ //DICTIONARY_EXCLUDE_102
+ test("Queries_DICTIONARY_EXCLUDE_102", Include) {
- sql(s"""select FIRST(Latest_DAY) a from (select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
+ sql(s"""select FIRST(Latest_DAY) a from (select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY) t""").collect
}
- //VMALL_DICTIONARY_EXCLUDE_103
- test("VMALL_DICTIONARY_EXCLUDE_103", Include) {
+ //DICTIONARY_EXCLUDE_103
+ test("Queries_DICTIONARY_EXCLUDE_103", Include) {
- checkAnswer(s"""select Latest_DAY,count(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE group by Latest_DAY order by Latest_DAY""",
- s"""select Latest_DAY,count(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE1_hive group by Latest_DAY order by Latest_DAY""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_103")
+ checkAnswer(s"""select Latest_DAY,count(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE group by Latest_DAY order by Latest_DAY""",
+ s"""select Latest_DAY,count(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE1_hive group by Latest_DAY order by Latest_DAY""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_103")
}
- //VMALL_DICTIONARY_EXCLUDE_104
- test("VMALL_DICTIONARY_EXCLUDE_104", Include) {
+ //DICTIONARY_EXCLUDE_104
+ test("Queries_DICTIONARY_EXCLUDE_104", Include) {
- checkAnswer(s"""select Lower(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE order by a""",
- s"""select Lower(Latest_DAY) a from VMALL_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_104")
+ checkAnswer(s"""select Lower(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE order by a""",
+ s"""select Lower(Latest_DAY) a from TABLE_DICTIONARY_EXCLUDE1_hive order by a""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_104")
}
- //VMALL_DICTIONARY_EXCLUDE_105
- test("VMALL_DICTIONARY_EXCLUDE_105", Include) {
+ //DICTIONARY_EXCLUDE_105
+ test("Queries_DICTIONARY_EXCLUDE_105", Include) {
- checkAnswer(s"""select distinct Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY""",
- s"""select distinct Latest_DAY from VMALL_DICTIONARY_EXCLUDE1_hive order by Latest_DAY""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_105")
+ checkAnswer(s"""select distinct Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY""",
+ s"""select distinct Latest_DAY from TABLE_DICTIONARY_EXCLUDE1_hive order by Latest_DAY""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_105")
}
- //VMALL_DICTIONARY_EXCLUDE_106
- test("VMALL_DICTIONARY_EXCLUDE_106", Include) {
+ //DICTIONARY_EXCLUDE_106
+ test("Queries_DICTIONARY_EXCLUDE_106", Include) {
- checkAnswer(s"""select Latest_DAY from VMALL_DICTIONARY_EXCLUDE order by Latest_DAY limit 101""",
- s"""select Latest_DAY from VMALL_DICTIONARY_EXCLUDE1_hive order by Latest_DAY limit 101""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_106")
+ checkAnswer(s"""select Latest_DAY from TABLE_DICTIONARY_EXCLUDE order by Latest_DAY limit 101""",
+ s"""select Latest_DAY from TABLE_DICTIONARY_EXCLUDE1_hive order by Latest_DAY limit 101""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_106")
}
- //VMALL_DICTIONARY_EXCLUDE_107
- test("VMALL_DICTIONARY_EXCLUDE_107", Include) {
+ //DICTIONARY_EXCLUDE_107
+ test("Queries_DICTIONARY_EXCLUDE_107", Include) {
- checkAnswer(s"""select Latest_DAY as a from VMALL_DICTIONARY_EXCLUDE order by a asc limit 10""",
- s"""select Latest_DAY as a from VMALL_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_VMALL_DICTIONARY_EXCLUDE_107")
+ checkAnswer(s"""select Latest_DAY as a from TABLE_DICTIONARY_EXCLUDE order by a asc limit 10""",
+ s"""select Latest_DAY as a from TABLE_DICTIONARY_EXCLUDE1_hive order by a asc limit 10""", "QueriesExcludeDictionaryTestCase_DICTIONARY_EXCLUDE_107")
}
- //VMALL_DICTIONARY_EXCLUDE_108
- test("VMALL_DICTIONARY_EXCLUDE_108", In
<TRUNCATED>