carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jack...@apache.org
Subject [09/17] carbondata git commit: [CARBONDATA-1453]Optimize test case IDs
Date Wed, 06 Sep 2017 12:39:44 GMT
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/PartitionTestCase.scala
----------------------------------------------------------------------
diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/PartitionTestCase.scala
b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/PartitionTestCase.scala
index c274f30..3060be9 100644
--- a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/PartitionTestCase.scala
+++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/PartitionTestCase.scala
@@ -30,7 +30,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
          
 
   //Verify exception if column in partitioned by is already specified in table schema
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC001", Include) {
+  test("Partition-Local-sort_TC001", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (INTEGER_COLUMN1 int)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='List','LIST_INFO'='1,3')""").collect
@@ -43,7 +43,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify table is created with Partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC002", Include) {
+  ignore("Partition-Local-sort_TC002", Include) {
      sql(s"""drop table if exists uniqdata""").collect
     sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST','LIST_INFO'='3')""").collect
      sql(s"""drop table if exists uniqdata""").collect
@@ -51,7 +51,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception partitioned by is not specified in the DDL
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC003", Include) {
+  test("Partition-Local-sort_TC003", Include) {
      sql(s"""drop table if exists uniqdata""").collect
     sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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' TBLPROPERTIES('PARTITION_TYPE'='List','NUM_PARTITIONS'='3')""").collect
      sql(s"""drop table if exists uniqdata""").collect
@@ -59,7 +59,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if List info is not given with List type partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC004", Include) {
+  test("Partition-Local-sort_TC004", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='List')""").collect
@@ -72,7 +72,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition type is not given
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC005", Include) {
+  test("Partition-Local-sort_TC005", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('LIST_INFO'='1,2')""").collect
@@ -85,7 +85,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition type is 'range' and LIST_INFO Is provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC006", Include) {
+  test("Partition-Local-sort_TC006", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10),
DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double) PARTITIONED BY
(DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'LIST_INFO'='1,2')""").collect
@@ -98,7 +98,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition type is 'range' and NUM_PARTITIONS Is provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC007", Include) {
+  test("Partition-Local-sort_TC007", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'NUM_PARTITIONS'='1')""").collect
@@ -111,7 +111,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify table is created if Partition type is 'range' and RANGE_INFO Is provided
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC008", Include) {
+  ignore("Partition-Local-sort_TC008", Include) {
      sql(s"""drop table if exists uniqdata""").collect
     sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='20160302,20150302')""").collect
      sql(s"""drop table if exists uniqdata""").collect
@@ -119,7 +119,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify table is created if Partition type is 'LIST' and LIST_INFO Is provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC009", Include) {
+  test("Partition-Local-sort_TC009", Include) {
      sql(s"""drop table if exists uniqdata""").collect
     sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10),
DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double) PARTITIONED BY
(DOJ int)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='1,2')""").collect
      sql(s"""drop table if exists uniqdata""").collect
@@ -127,7 +127,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition type is 'LIST' and NUM_PARTITIONS Is provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC010", Include) {
+  test("Partition-Local-sort_TC010", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ int)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'NUM_PARTITIONS'='1')""").collect
@@ -140,7 +140,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition type is 'LIST' and RANGE_INFO Is provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC011", Include) {
+  test("Partition-Local-sort_TC011", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'RANGE_INFO'='20160302,20150302')""").collect
@@ -153,7 +153,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if datatype is not provided with partition column
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC012", Include) {
+  test("Partition-Local-sort_TC012", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='20160302,20150302')""").collect
@@ -166,7 +166,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if a non existent file header  is provided in partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC013", Include) {
+  test("Partition-Local-sort_TC013", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string,
DOB 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) PARTITIONED BY (DOJ timestamp)STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='20160302,20150302')
@@ -181,7 +181,7 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify exception if Partition By Is empty
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC014", Include) {
+  test("Partition-Local-sort_TC014", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY ()STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')
@@ -195,46 +195,46 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify load with List Partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC015", Include) {
+  test("Partition-Local-sort_TC015", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata""",
-      Seq(Row(28)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC015")
+      Seq(Row(28)), "partitionTestCase_Partition-Local-sort_TC015")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify load with List Partition and limit 1
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC016", Include) {
+  test("Partition-Local-sort_TC016", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select * from uniqdata limit 1""",
-      Seq(Row("CUST_NAME_00002","ACTIVE_EMUI_VERSION_00002",null,null,null,12345678903.0000000000,22345678903.0000000000,1.123456749E10,-1.123456749E10,3,null,2)),
"partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC016")
+      Seq(Row("CUST_NAME_00002","ACTIVE_EMUI_VERSION_00002",null,null,null,12345678903.0000000000,22345678903.0000000000,1.123456749E10,-1.123456749E10,3,null,2)),
"partitionTestCase_Partition-Local-sort_TC016")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify load with List Partition and select partition column
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC017", Include) {
+  test("Partition-Local-sort_TC017", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select CUST_ID from uniqdata limit 1""",
-      Seq(Row(2)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC017")
+      Seq(Row(2)), "partitionTestCase_Partition-Local-sort_TC017")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify exception if 2 partition columns are provided
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC018", Include) {
+  test("Partition-Local-sort_TC018", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""
@@ -248,18 +248,18 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify data load with range partition with limit 1
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC019", Include) {
+  ignore("Partition-Local-sort_TC019", Include) {
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='0,5,10,29')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select * from uniqdata limit 1""",
-      Seq(Row("CUST_NAME_00003","ACTIVE_EMUI_VERSION_00003",null,null,null,12345678904.0000000000,22345678904.0000000000,1.123456749E10,-1.123456749E10,4,null,5)),
"partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC019")
+      Seq(Row("CUST_NAME_00003","ACTIVE_EMUI_VERSION_00003",null,null,null,12345678904.0000000000,22345678904.0000000000,1.123456749E10,-1.123456749E10,4,null,5)),
"partitionTestCase_Partition-Local-sort_TC019")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify data load with range partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC020", Include) {
+  ignore("Partition-Local-sort_TC020", Include) {
     dropTable("uniqdata")
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='0,5,10,29')""").collect
 
@@ -271,31 +271,31 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify data load with hash partition with limit 1
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC021", Include) {
+  ignore("Partition-Local-sort_TC021", Include) {
      sql(s"""drop table if exists uniqdata""").collect
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='5')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select * from uniqdata limit 1""",
-      Seq(Row("CUST_NAME_00003","ACTIVE_EMUI_VERSION_00003",null,null,null,12345678904.0000000000,22345678904.0000000000,1.123456749E10,-1.123456749E10,4,null,5)),
"partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC021")
+      Seq(Row("CUST_NAME_00003","ACTIVE_EMUI_VERSION_00003",null,null,null,12345678904.0000000000,22345678904.0000000000,1.123456749E10,-1.123456749E10,4,null,5)),
"partitionTestCase_Partition-Local-sort_TC021")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify data load with hash partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC022", Include) {
+  ignore("Partition-Local-sort_TC022", Include) {
     dropTable("uniqdata")
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='5')""").collect
 
    sql(s"""LOAD DATA INPATH  ''$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata limit 1""",
-      Seq(Row(28)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC022")
+      Seq(Row(28)), "partitionTestCase_Partition-Local-sort_TC022")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify data load with List partition after compaction
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC023", Include) {
+  test("Partition-Local-sort_TC023", Include) {
     dropTable("uniqdata")
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
 
@@ -309,13 +309,13 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
    sql(s"""alter table uniqdata compact 'minor'""").collect
     checkAnswer(s"""select count(*) from uniqdata limit 1""",
-      Seq(Row(112)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC023")
+      Seq(Row(112)), "partitionTestCase_Partition-Local-sort_TC023")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify data load with Range partition after compaction
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC024", Include) {
+  test("Partition-Local-sort_TC024", Include) {
     dropTable("uniqdata")
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='Range',
'RANGE_INFO'='0,5,10,30')""").collect
 
@@ -329,13 +329,13 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
    sql(s"""alter table uniqdata compact 'minor'""").collect
     checkAnswer(s"""select count(*) from uniqdata limit 1""",
-      Seq(Row(112)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC024")
+      Seq(Row(112)), "partitionTestCase_Partition-Local-sort_TC024")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify data load with Hash partition after compaction
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC025", Include) {
+  test("Partition-Local-sort_TC025", Include) {
     dropTable("uniqdata")
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='5')""").collect
 
@@ -349,13 +349,13 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
    sql(s"""alter table uniqdata compact 'minor'""").collect
     checkAnswer(s"""select count(*) from uniqdata limit 1""",
-      Seq(Row(112)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC025")
+      Seq(Row(112)), "partitionTestCase_Partition-Local-sort_TC025")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify join operation on List partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC026", Include) {
+  test("Partition-Local-sort_TC026", Include) {
      sql(s"""drop table if exists uniqdata1""").collect
    sql(s"""drop table if exists uniqdata""").collect
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
@@ -372,18 +372,18 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify data when sublist is provided in LIST_INFO
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC028", Include) {
+  test("Partition-Local-sort_TC028", Include) {
      sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,(1,2),3')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata""",
-      Seq(Row(28)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC028")
+      Seq(Row(28)), "partitionTestCase_Partition-Local-sort_TC028")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify exception is thrown if partition column is dropped
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC029", Include) {
+  test("Partition-Local-sort_TC029", Include) {
     try {
        sql(s"""drop table if exists uniqdata""").collect
       sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')
@@ -400,33 +400,33 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify insert is successful on list partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC030", Include) {
+  ignore("Partition-Local-sort_TC030", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='0,1')""").collect
    sql(s"""insert into table uniqdata values ('a', '1','2015-07-01 00:00:00', 5678,7654,23.4,
55.6, 7654, 8765,33,'2015-07-01 00:00:00', 1)""").collect
    sql(s"""insert into table uniqdata values ('a', '1', '2015-07-01 00:00:00', 5678,7654,23.4,
55.6, 7654, 8765,33,'2015-07-01 00:00:00', 0)""").collect
     checkAnswer(s"""select * from uniqdata""",
-      Seq(Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",1),Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",0)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC030")
+      Seq(Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",1),Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",0)), "partitionTestCase_Partition-Local-sort_TC030")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify insert is successful on range partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC031", Include) {
+  ignore("Partition-Local-sort_TC031", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='0,3,5')""").collect
    sql(s"""insert into table uniqdata values ('a', '1','2015-07-01 00:00:00', 5678,7654,23.4,
55.6, 7654, 8765,33,'2015-07-01 00:00:00', 1)""").collect
    sql(s"""insert into table uniqdata values ('a', '1', '2015-07-01 00:00:00', 5678,7654,23.4,
55.6, 7654, 8765,33,'2015-07-01 00:00:00', 0)""").collect
     checkAnswer(s"""select * from uniqdata""",
-      Seq(Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",1),Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",0)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC031")
+      Seq(Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",1),Row("a",1,"2015-07-01 00:00:00.0",5678,7654,23.4000000000,55.6000000000,7654.0,8765.0,33,"2015-07-01
00:00:00.0",0)), "partitionTestCase_Partition-Local-sort_TC031")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify insert is successful on HASH partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC032", Include) {
+  ignore("Partition-Local-sort_TC032", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='10')""").collect
@@ -439,111 +439,111 @@ class PartitionTestCase extends QueryTest with BeforeAndAfterAll {
 
 
   //Verify date with > filter condition and list partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC033", Include) {
+  test("Partition-Local-sort_TC033", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='1,0,3,4')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID>3""",
-      Seq(Row(4)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC033")
+      Seq(Row(4)), "partitionTestCase_Partition-Local-sort_TC033")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = filter condition and list partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC034", Include) {
+  test("Partition-Local-sort_TC034", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='1,0,3,4')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=3""",
-      Seq(Row(8)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC034")
+      Seq(Row(8)), "partitionTestCase_Partition-Local-sort_TC034")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = value not in list_info and list partition
-  test("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC035", Include) {
+  test("Partition-Local-sort_TC035", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='LIST',
'LIST_INFO'='1,0,3,4')""").collect
 
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=10""",
-      Seq(Row(0)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC035")
+      Seq(Row(0)), "partitionTestCase_Partition-Local-sort_TC035")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with > filter condition and range partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC036", Include) {
+  ignore("Partition-Local-sort_TC036", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='1,0,3,4')""").collect
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID>3""",
-      Seq(Row(4)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC036")
+      Seq(Row(4)), "partitionTestCase_Partition-Local-sort_TC036")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = filter condition and list partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC037", Include) {
+  ignore("Partition-Local-sort_TC037", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='1,0,3,4')""").collect
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=3""",
-      Seq(Row(8)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC037")
+      Seq(Row(8)), "partitionTestCase_Partition-Local-sort_TC037")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = value not in list_info and list partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC038", Include) {
+  ignore("Partition-Local-sort_TC038", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='RANGE',
'RANGE_INFO'='1,0,3,4')""").collect
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=10""",
-      Seq(Row(0)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC038")
+      Seq(Row(0)), "partitionTestCase_Partition-Local-sort_TC038")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with > filter condition and hash partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC039", Include) {
+  ignore("Partition-Local-sort_TC039", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='1,0,3,4')""").collect
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID>3""",
-      Seq(Row(4)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC039")
+      Seq(Row(4)), "partitionTestCase_Partition-Local-sort_TC039")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = filter condition and hash partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC040", Include) {
+  ignore("Partition-Local-sort_TC040", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='1,0,3,4')""").collect
    sql(s"""LOAD DATA INPATH  '$resourcesPath/Data/partition/2000_UniqData_partition.csv'
into table uniqdata OPTIONS('DELIMITER'=',' , 'BAD_RECORDS_ACTION'='FORCE','QUOTECHAR'='"','FILEHEADER'='CUST_NAME,ACTIVE_EMUI_VERSION,DOB,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1,DOJ,CUST_ID')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=3""",
-      Seq(Row(8)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC040")
+      Seq(Row(8)), "partitionTestCase_Partition-Local-sort_TC040")
      sql(s"""drop table if exists uniqdata""").collect
   }
 
 
   //Verify date with = value not in list_info and hash partition
-  ignore("SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC041", Include) {
+  ignore("Partition-Local-sort_TC041", Include) {
      sql(s"""drop table if exists uniqdata""").collect
 
    sql(s"""CREATE TABLE uniqdata (CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB 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, DOJ timestamp)
PARTITIONED BY (CUST_ID int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('PARTITION_TYPE'='HASH',
'NUM_PARTITIONS'='1,0,3,4')""").collect
     checkAnswer(s"""select count(*) from uniqdata where CUST_ID=10""",
-      Seq(Row(0)), "partitionTestCase_SR-DataSight-Carbon-Partition-Local-sort-PTS001_TC041")
+      Seq(Row(0)), "partitionTestCase_Partition-Local-sort_TC041")
      sql(s"""drop table if exists uniqdata""").collect
   }
 


Mime
View raw message