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/06 12:39:50 UTC
[15/17] 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/BatchSortQueryTestCase.scala
----------------------------------------------------------------------
diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/BatchSortQueryTestCase.scala b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/BatchSortQueryTestCase.scala
index 2c7b35b..46665c7 100644
--- a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/BatchSortQueryTestCase.scala
+++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/BatchSortQueryTestCase.scala
@@ -32,7 +32,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select query with limit
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_001", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_001", Include) {
sql(s"""drop table if exists uniqdataquery1""").collect
sql(s"""CREATE TABLE uniqdataquery1 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'carbondata'""").collect
@@ -43,7 +43,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select query with limit as string
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_002", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_002", Include) {
try {
sql(s"""select * from uniqdataquery1 limit """"").collect
@@ -57,14 +57,14 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select query with no input given at limit
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_003", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_003", Include) {
sql(s"""select * from uniqdataquery1 limit""").collect
}
//To check select count query with where and group by clause
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_004", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_004", Include) {
sql(s"""select count(*) from uniqdataquery1 where cust_name="CUST_NAME_00000" group by cust_name""").collect
@@ -73,7 +73,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count query and group by cust_name using like operator
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_005", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_005", Include) {
sql(s"""select count(*) from uniqdataquery1 where cust_name like "cust_name_0%" group by cust_name""").collect
@@ -82,7 +82,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count query and group by name using IN operator with empty values
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_006", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_006", Include) {
sql(s"""select count(*) from uniqdataquery1 where cust_name IN("","") group by cust_name""").collect
@@ -91,7 +91,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count query and group by name using IN operator with specific values
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_007", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_007", Include) {
sql(s"""select count(*) from uniqdataquery1 where cust_name IN(1,2,3) group by cust_name""").collect
@@ -100,7 +100,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select distinct query
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_008", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_008", Include) {
sql(s"""select distinct cust_name from uniqdataquery1 group by cust_name""").collect
@@ -109,7 +109,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check where clause with OR and no operand
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_009", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_009", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id > 1 OR """).collect
@@ -123,7 +123,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check OR clause with LHS and RHS having no arguments
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_010", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_010", Include) {
try {
sql(s"""select * from uniqdataquery1 where OR """).collect
@@ -137,7 +137,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check OR clause with LHS having no arguments
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_011", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_011", Include) {
try {
sql(s"""select * from uniqdataquery1 where OR cust_id > "1"""").collect
@@ -151,7 +151,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check incorrect query
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_013", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_013", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id > 0 OR name """).collect
@@ -165,7 +165,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select query with rhs false
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_014", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_014", Include) {
sql(s"""select * from uniqdataquery1 where cust_id > 9005 OR false""").collect
@@ -174,7 +174,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check count on multiple arguments
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_015", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_015", Include) {
sql(s"""select count(cust_id,cust_name) from uniqdataquery1 where cust_id > 10544""").collect
@@ -183,7 +183,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check count with no argument
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_016", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_016", Include) {
sql(s"""select count() from uniqdataquery1 where cust_id > 10544""").collect
@@ -192,7 +192,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check count with * as an argument
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_017", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_017", Include) {
sql(s"""select count(*) from uniqdataquery1 where cust_id>10544""").collect
@@ -201,7 +201,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count query execution with entire column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_018", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_018", Include) {
sql(s"""select count(*) from uniqdataquery1""").collect
@@ -210,7 +210,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select distinct query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_019", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_019", Include) {
sql(s"""select distinct * from uniqdataquery1""").collect
@@ -219,7 +219,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select multiple column query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_020", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_020", Include) {
sql(s"""select cust_name,cust_id,count(cust_name) from uniqdataquery1 group by cust_name,cust_id""").collect
@@ -228,7 +228,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count and distinct query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_021", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_021", Include) {
try {
sql(s"""select count(cust_id),distinct(cust_name) from uniqdataquery1""").collect
@@ -242,7 +242,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check sum query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_022", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_022", Include) {
sql(s"""select sum(cust_id) as sum,cust_name from uniqdataquery1 group by cust_name""").collect
@@ -251,7 +251,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check sum of names query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_023", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_023", Include) {
sql(s"""select sum(cust_name) from uniqdataquery1""").collect
@@ -260,7 +260,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select distinct and groupby query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_024", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_024", Include) {
sql(s"""select distinct(cust_name,cust_id) from uniqdataquery1 group by cust_name,cust_id""").collect
@@ -269,7 +269,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select with where clause on cust_name query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_025", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_025", Include) {
sql(s"""select cust_id from uniqdataquery1 where cust_name="cust_name_00000"""").collect
@@ -278,7 +278,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check query execution with IN operator without paranthesis
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_027", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_027", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id IN 9000,9005""").collect
@@ -292,7 +292,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check query execution with IN operator with paranthesis
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_028", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_028", Include) {
sql(s"""select * from uniqdataquery1 where cust_id IN (9000,9005)""").collect
@@ -301,7 +301,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check query execution with IN operator with out specifying any field.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_029", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_029", Include) {
try {
sql(s"""select * from uniqdataquery1 where IN(1,2)""").collect
@@ -315,7 +315,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check OR with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_030", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_030", Include) {
sql(s"""select * from uniqdataquery1 where cust_id>9005 or cust_id=9005""").collect
@@ -324,7 +324,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check OR with boolean expression
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_031", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_031", Include) {
sql(s"""select * from uniqdataquery1 where cust_id>9005 or false""").collect
@@ -333,7 +333,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_032", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_032", Include) {
sql(s"""select * from uniqdataquery1 where true AND true""").collect
@@ -342,7 +342,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND with using booleans
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_033", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_033", Include) {
sql(s"""select * from uniqdataquery1 where true AND false""").collect
@@ -351,7 +351,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND with using booleans in invalid syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_034", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_034", Include) {
try {
sql(s"""select * from uniqdataquery1 where AND true""").collect
@@ -365,7 +365,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND Passing two conditions on same input
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_035", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_035", Include) {
sql(s"""select * from uniqdataquery1 where cust_id=6 and cust_id>5""").collect
@@ -374,7 +374,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND changing case
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_036", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_036", Include) {
sql(s"""select * from uniqdataquery1 where cust_id=6 aND cust_id>5""").collect
@@ -383,7 +383,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND using 0 and 1 treated as boolean values
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_037", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_037", Include) {
try {
sql(s"""select * from uniqdataquery1 where true aNd 0""").collect
@@ -397,7 +397,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check AND on two columns
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_038", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_038", Include) {
sql(s"""select * from uniqdataquery1 where cust_id=9000 and cust_name='cust_name_00000'""").collect
@@ -406,7 +406,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '='operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_039", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_039", Include) {
sql(s"""select * from uniqdataquery1 where cust_id=9000 and cust_name='cust_name_00000' and ACTIVE_EMUI_VERSION='ACTIVE_EMUI_VERSION_00000'""").collect
@@ -415,7 +415,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '='operator without Passing any value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_040", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_040", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id=""").collect
@@ -429,7 +429,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '='operator without Passing columnname and value.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_041", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_041", Include) {
try {
sql(s"""select * from uniqdataquery1 where =""").collect
@@ -443,7 +443,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '!='operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_042", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_042", Include) {
sql(s"""select * from uniqdataquery1 where cust_id!=9000""").collect
@@ -452,7 +452,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '!='operator by keeping space between them
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_043", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_043", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id ! = 9001""").collect
@@ -466,7 +466,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '!='operator by Passing boolean value whereas column expects an integer
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_044", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_044", Include) {
sql(s"""select * from uniqdataquery1 where cust_id != true""").collect
@@ -475,7 +475,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '!='operator without providing any value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_045", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_045", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id != """).collect
@@ -489,7 +489,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '!='operator without providing any column name
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_046", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_046", Include) {
try {
sql(s"""select * from uniqdataquery1 where != false""").collect
@@ -503,7 +503,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' with valid syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_047", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_047", Include) {
sql(s"""select * from uniqdataquery1 where NOT(cust_id=9000)""").collect
@@ -512,7 +512,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' using boolean values
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_048", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_048", Include) {
sql(s"""select * from uniqdataquery1 where NOT(false)""").collect
@@ -521,7 +521,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' applying it on a value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_049", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_049", Include) {
sql(s"""select * from uniqdataquery1 where cust_id = 'NOT(false)'""").collect
@@ -530,7 +530,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' with between operator
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_050", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_050", Include) {
sql(s"""select * from uniqdataquery1 where cust_id NOT BETWEEN 9000 and 9005""").collect
@@ -539,7 +539,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' operator in nested way
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_051", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_051", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id NOT (NOT(true))""").collect
@@ -553,7 +553,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' operator with parenthesis.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_052", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_052", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id NOT ()""").collect
@@ -567,7 +567,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' operator without condition.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_053", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_053", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id NOT""").collect
@@ -581,7 +581,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT' operator checking case sensitivity.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_054", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_054", Include) {
sql(s"""select * from uniqdataquery1 where nOt(false)""").collect
@@ -590,7 +590,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '>' operator without specifying column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_055", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_055", Include) {
try {
sql(s"""select * from uniqdataquery1 where > 20""").collect
@@ -604,7 +604,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '>' operator without specifying value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_056", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_056", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id > """).collect
@@ -618,7 +618,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '>' operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_057", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_057", Include) {
sql(s"""select * from uniqdataquery1 where cust_id >9005""").collect
@@ -627,7 +627,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '>' operator for Integer value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_058", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_058", Include) {
sql(s"""select * from uniqdataquery1 where cust_id > 9010""").collect
@@ -636,7 +636,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '>' operator for String value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_059", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_059", Include) {
sql(s"""select * from uniqdataquery1 where cust_name > 'cust_name_00000'""").collect
@@ -645,7 +645,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<' operator without specifying column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_060", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_060", Include) {
try {
sql(s"""select * from uniqdataquery1 where < 5""").collect
@@ -659,7 +659,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<' operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_061", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_061", Include) {
sql(s"""select * from uniqdataquery1 where cust_id < 9005""").collect
@@ -668,7 +668,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<' operator for String value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_062", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_062", Include) {
sql(s"""select * from uniqdataquery1 where cust_name < "cust_name_00001"""").collect
@@ -677,7 +677,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<=' operator without specifying column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_063", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_063", Include) {
try {
sql(s"""select * from uniqdataquery1 where <= 2""").collect
@@ -691,7 +691,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<=' operator without providing value
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_064", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_064", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id <= """).collect
@@ -705,7 +705,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<=' operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_065", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_065", Include) {
sql(s"""select * from uniqdataquery1 where cust_id <=9002""").collect
@@ -714,7 +714,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check '<=' operator adding space between'<' and '='
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_066", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_066", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id < = 9002""").collect
@@ -728,7 +728,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'BETWEEN' operator without providing range
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_067", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_067", Include) {
try {
sql(s"""select * from uniqdataquery1 where age between""").collect
@@ -742,7 +742,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'BETWEEN' operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_068", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_068", Include) {
sql(s"""select * from uniqdataquery1 where cust_id between 9002 and 9030""").collect
@@ -751,7 +751,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'BETWEEN' operator providing two same values
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_069", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_069", Include) {
sql(s"""select * from uniqdataquery1 where cust_name beTWeen 'CU%' and 'CU%'""").collect
@@ -760,7 +760,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT BETWEEN' operator for integer
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_070", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_070", Include) {
sql(s"""select * from uniqdataquery1 where cust_id NOT between 9024 and 9030""").collect
@@ -769,7 +769,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'NOT BETWEEN' operator for string
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_071", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_071", Include) {
sql(s"""select * from uniqdataquery1 where cust_name NOT beTWeen 'cust_name_00000' and 'cust_name_00001'""").collect
@@ -778,7 +778,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'IS NULL' for case sensitiveness.
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_072", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_072", Include) {
sql(s"""select * from uniqdataquery1 where cust_id Is NulL""").collect
@@ -787,7 +787,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'IS NULL' for null field
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_073", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_073", Include) {
sql(s"""select * from uniqdataquery1 where cust_name Is NulL""").collect
@@ -796,7 +796,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'IS NULL' without providing column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_074", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_074", Include) {
try {
sql(s"""select * from uniqdataquery1 where Is NulL""").collect
@@ -810,7 +810,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'IS NOT NULL' without providing column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_075", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_075", Include) {
try {
sql(s"""select * from uniqdataquery1 where IS NOT NULL""").collect
@@ -824,7 +824,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check ''IS NOT NULL' operator with correct syntax
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_076", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_076", Include) {
sql(s"""select * from uniqdataquery1 where cust_id IS NOT NULL""").collect
@@ -833,7 +833,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check 'Like' operator for integer
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_077", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_077", Include) {
sql(s"""select * from uniqdataquery1 where cust_id Like '9%'""").collect
@@ -842,7 +842,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Limit clause with where condition
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_078", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_078", Include) {
sql(s"""select * from uniqdataquery1 where cust_id>10987 limit 15""").collect
@@ -851,7 +851,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Limit clause with where condition and no argument
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_079", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_079", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id=10987 limit""").collect
@@ -865,7 +865,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Limit clause with where condition and decimal argument
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_080", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_080", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id=10987 limit 0.0""").collect
@@ -879,7 +879,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check where clause with distinct and group by
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_081", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_081", Include) {
sql(s"""select distinct cust_name from uniqdataquery1 where cust_name IN("CUST_NAME_01999") group by cust_name""").collect
@@ -888,7 +888,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check subqueries
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_082", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_082", Include) {
sql(s"""select * from (select cust_id from uniqdataquery1 where cust_id IN (10987,10988)) uniqdataquery1 where cust_id IN (10987, 10988)""").collect
@@ -897,7 +897,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To count with where clause
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_083", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_083", Include) {
sql(s"""select count(cust_id) from uniqdataquery1 where cust_id > 10874""").collect
@@ -906,7 +906,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Join query
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_084", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_084", Include) {
sql(s"""drop table if exists uniqdataquery11""").collect
sql(s"""CREATE TABLE uniqdataquery11 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA INPATH '$resourcesPath/Data/uniqdata/2000_UniqData.csv' into table uniqdataquery11 OPTIONS('DELIMITER'=',' , 'SORT_SCOPE'='BATCH_SORT','QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1')""").collect
@@ -917,7 +917,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Left join with where clause
- ignore("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_085", Include) {
+ ignore("Batch_sort_Querying_001-01-01-01_001-TC_085", Include) {
sql(s"""select uniqdataquery1.CUST_ID from uniqdataquery1 LEFT join uniqdataquery11 where uniqdataquery1.CUST_ID > 10000""").collect
@@ -926,7 +926,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Full join
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_086", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_086", Include) {
try {
sql(s"""select uniqdataquery1.CUST_ID from uniqdataquery1 FULL JOIN uniqdataquery11 where CUST_ID""").collect
@@ -940,7 +940,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Broadcast join
- ignore("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_087", Include) {
+ ignore("Batch_sort_Querying_001-01-01-01_001-TC_087", Include) {
sql(s"""select broadcast.cust_id from uniqdataquery1 broadcast join uniqdataquery11 where broadcast.cust_id > 10900""").collect
@@ -949,7 +949,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To avg function
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_088", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_088", Include) {
sql(s"""select avg(cust_name) from uniqdataquery1 where cust_id > 10544 group by cust_name""").collect
@@ -958,7 +958,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check subquery with aggrgate function avg
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_089", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_089", Include) {
sql(s"""select cust_id,avg(cust_id) from uniqdataquery1 where cust_id IN (select cust_id from uniqdataquery1 where cust_id > 0) group by cust_id""").collect
@@ -967,7 +967,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check HAVING on Measure
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_090", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_090", Include) {
sql(s"""select cust_id from uniqdataquery1 where cust_id > 10543 group by cust_id having cust_id = 10546""").collect
@@ -976,7 +976,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check HAVING on dimension
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_091", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_091", Include) {
sql(s"""select cust_name from uniqdataquery1 where cust_id > 10544 group by cust_name having cust_name like 'C%'""").collect
@@ -985,7 +985,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check HAVING on multiple columns
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_092", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_092", Include) {
sql(s"""select cust_id,cust_name from uniqdataquery1 where cust_id > 10544 group by cust_id,cust_name having cust_id = 10545 AND cust_name like 'C%'""").collect
@@ -994,7 +994,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check HAVING with empty condition
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_094", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_094", Include) {
sql(s"""select cust_name from uniqdataquery1 where cust_id > 10544 group by cust_name having """"").collect
@@ -1003,7 +1003,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check SORT on measure
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_095", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_095", Include) {
sql(s"""select * from uniqdataquery1 where cust_id > 10544 sort by cust_id asc""").collect
@@ -1012,7 +1012,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check SORT on dimemsion
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_096", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_096", Include) {
sql(s"""select * from uniqdataquery1 where cust_id > 10544 sort by cust_name desc""").collect
@@ -1021,7 +1021,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check SORT using 'AND' on multiple column
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_097", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_097", Include) {
try {
sql(s"""select * from uniqdataquery1 where cust_id > 10544 sort by cust_name desc and cust_id asc""").collect
@@ -1035,7 +1035,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Select average names and group by name query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_098", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_098", Include) {
sql(s"""select avg(cust_name) from uniqdataquery1 group by cust_name""").collect
@@ -1044,7 +1044,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Select average id and group by id query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_099", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_099", Include) {
sql(s"""select avg(cust_id) from uniqdataquery1 group by cust_id""").collect
@@ -1053,7 +1053,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check average aggregate function with no arguments
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_100", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_100", Include) {
try {
sql(s"""select cust_id,avg() from uniqdataquery1 group by cust_id""").collect
@@ -1067,7 +1067,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check average aggregate function with empty string
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_101", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_101", Include) {
sql(s"""select cust_id,avg("") from uniqdataquery1 group by cust_id""").collect
@@ -1076,7 +1076,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check nested average aggregate function
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_102", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_102", Include) {
try {
sql(s"""select cust_id,avg(count(cust_id)) from uniqdataquery1 group by cust_id""").collect
@@ -1090,7 +1090,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Multilevel query
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_103", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_103", Include) {
sql(s"""select cust_id,avg(cust_id) from uniqdataquery1 where cust_id IN (select cust_id from uniqdataquery1) group by cust_id""").collect
@@ -1099,7 +1099,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Using first() with group by clause
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_104", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_104", Include) {
sql(s"""select first(cust_id) from uniqdataquery1 group by cust_id""").collect
@@ -1108,7 +1108,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check max with groupby clause query execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_105", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_105", Include) {
sql(s"""select max(cust_name) from uniqdataquery1 group by(cust_name)""").collect
@@ -1117,7 +1117,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check max with groupby clause query with id execution
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_106", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_106", Include) {
sql(s"""select max(cust_name) from uniqdataquery1 group by(cust_name),cust_id""").collect
@@ -1126,7 +1126,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check multiple aggregate functions
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_107", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_107", Include) {
sql(s"""select max(cust_name),sum(cust_name),count(cust_id) from uniqdataquery1 group by(cust_name),cust_id""").collect
@@ -1135,7 +1135,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check max with empty string as argument
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_108", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_108", Include) {
sql(s"""select max("") from uniqdataquery1 group by(cust_name)""").collect
@@ -1144,7 +1144,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check select count of names with group by clause
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_109", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_109", Include) {
sql(s"""select count(cust_name) from uniqdataquery1 group by cust_name""").collect
@@ -1153,7 +1153,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Order by ASC
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_110", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_110", Include) {
sql(s"""select * from uniqdataquery1 order by cust_id ASC""").collect
@@ -1162,7 +1162,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Order by DESC
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_111", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_111", Include) {
sql(s"""select * from uniqdataquery1 order by cust_id DESC""").collect
@@ -1171,7 +1171,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Order by without column name
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_112", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_112", Include) {
try {
sql(s"""select * from uniqdataquery1 order by ASC""").collect
@@ -1185,7 +1185,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check cast Int to String
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_113", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_113", Include) {
sql(s"""select cast(bigint_column1 as STRING) from uniqdataquery1""").collect
@@ -1194,7 +1194,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check cast string to int
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_114", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_114", Include) {
sql(s"""select cast(cust_name as INT) from uniqdataquery1""").collect
@@ -1203,7 +1203,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check cast int to decimal
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_115", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_115", Include) {
sql(s"""select cast(bigint_column1 as DECIMAL(10,4)) from uniqdataquery1""").collect
@@ -1212,7 +1212,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Using window with order by
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_116", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_116", Include) {
sql(s"""select cust_name, sum(bigint_column1) OVER w from uniqdataquery1 WINDOW w AS (PARTITION BY bigint_column2 ORDER BY cust_id)""").collect
@@ -1221,7 +1221,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Using window without partition
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_117", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_117", Include) {
try {
sql(s"""select cust_name, sum(bigint_column1) OVER w from uniqdataquery1 WINDOW w""").collect
@@ -1235,7 +1235,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Using ROLLUP with group by
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_118", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_118", Include) {
sql(s"""select cust_name from uniqdataquery1 group by cust_name with ROLLUP""").collect
@@ -1244,7 +1244,7 @@ class BatchSortQueryTestCase extends QueryTest with BeforeAndAfterAll {
//To check Using ROLLUP without group by clause
- test("PTS-AR-Batch_sort_Querying_001-01-01-01_001-TC_119", Include) {
+ test("Batch_sort_Querying_001-01-01-01_001-TC_119", Include) {
try {
sql(s"""select cust_name from uniqdataquery1 with ROLLUP""").collect
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/ColumndictTestCase.scala
----------------------------------------------------------------------
diff --git a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/ColumndictTestCase.scala b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/ColumndictTestCase.scala
index 3e886e9..f702254 100644
--- a/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/ColumndictTestCase.scala
+++ b/integration/spark-common-cluster-test/src/test/scala/org/apache/carbondata/cluster/sdv/generated/ColumndictTestCase.scala
@@ -29,7 +29,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load history data from CSV with/without header and specify/dont specify headers in command using external ALL_dictionary_PATH
- test("AR-Develop-Feature-columndict-001_PTS001_TC001", Include) {
+ test("Columndict-TC001", Include) {
sql(s"""drop table if exists t3""").collect
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -38,7 +38,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load history data from CSV with/without header and specify/dont specify headers in command using external columndict
- test("AR-Develop-Feature-columndict-001_PTS001_TC002", Include) {
+ test("Columndict-TC002", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -46,7 +46,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external All_dictionary_path for CSV having incomplete/wrong data/no data/null data
- test("AR-Develop-Feature-columndict-001_PTS001_TC003", Include) {
+ test("Columndict-TC003", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/inValidData.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -54,7 +54,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external columndict for CSV having incomplete/wrong data/no data/null data
- test("AR-Develop-Feature-columndict-001_PTS001_TC004", Include) {
+ test("Columndict-TC004", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/inValidData.csv', 'SINGLE_PASS'='true')""").collect
@@ -67,7 +67,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load multiple CSV from folder into table , Multiple level of folders using external all_dictionary_path
- test("AR-Develop-Feature-columndict-001_PTS001_TC005", Include) {
+ test("Columndict-TC005", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data1' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -75,7 +75,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load multiple CSV from folder into table , Multiple level of folders using external columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC006", Include) {
+ ignore("Columndict-TC006", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data1' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -83,7 +83,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using CSV file with different extension (.dat, .xls, .doc,.txt) and without extension from external dictionary
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC007", Include) {
+ ignore("Columndict-TC007", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.dat' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -91,7 +91,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using CSV file with different extension (.dat, .xls, .doc,.txt) and without extension from external dictionary
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC008", Include) {
+ ignore("Columndict-TC008", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.dat' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -99,7 +99,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using MAXCOLUMNS during loading with external all_dictionary_path
- test("AR-Develop-Feature-columndict-001_PTS001_TC009", Include) {
+ test("Columndict-TC009", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.dat' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary','maxcolumns'='8', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -107,7 +107,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using MAXCOLUMNS during loading with external columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC010", Include) {
+ ignore("Columndict-TC010", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.dat' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv','maxcolumns'='8', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -115,7 +115,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Bad records logging after load using external all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC011", Include) {
+ ignore("Columndict-TC011", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary','BAD_RECORDS_LOGGER_ENABLE'='FALSE', 'BAD_RECORDS_ACTION'='FORCE', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -123,7 +123,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Bad records logging after load using external columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC012", Include) {
+ ignore("Columndict-TC012", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'=
'country:$resourcesPath/Data/columndict/country.csv','BAD_RECORDS_LOGGER_ENABLE'='FALSE', 'BAD_RECORDS_ACTION'='FORCE', 'SINGLE_PASS'='true')""").collect
@@ -132,7 +132,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Incremental Load using external dictionary
- test("AR-Develop-Feature-columndict-001_PTS001_TC013", Include) {
+ test("Columndict-TC013", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -144,7 +144,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Incremental Load using external dictionary
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC014", Include) {
+ ignore("Columndict-TC014", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
@@ -156,7 +156,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external dictionary for table without table properties
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC015", Include) {
+ ignore("Columndict-TC015", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -164,7 +164,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external dictionary for table without table properties
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC016", Include) {
+ ignore("Columndict-TC016", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -172,7 +172,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external all_dictionary_path for table with table properties(DICTIONARY_EXCLUDE, DICTIONARY_INCLUDE, BLOCKSIZE)
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC017", Include) {
+ ignore("Columndict-TC017", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 MB','DICTIONARY_INCLUDE'='salary','DICTIONARY_EXCLUDE'='phonetype')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -180,7 +180,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external columndict for table with table properties(DICTIONARY_EXCLUDE, DICTIONARY_INCLUDE, BLOCKSIZE)
- test("AR-Develop-Feature-columndict-001_PTS001_TC018", Include) {
+ test("Columndict-TC018", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 MB','DICTIONARY_INCLUDE'='salary','DICTIONARY_EXCLUDE'='phonetype')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -188,7 +188,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external all_dictionary_path for measure and table properties(DICTIONARY_EXCLUDE, DICTIONARY_INCLUDE, BLOCKSIZE)
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC019", Include) {
+ ignore("Columndict-TC019", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 MB','DICTIONARY_INCLUDE'='salary','DICTIONARY_EXCLUDE'='country')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='salary:$resourcesPath/Data/columndict/salary.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -196,7 +196,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Load using external columndict for table with measure and tableproperties(DICTIONARY_EXCLUDE, DICTIONARY_INCLUDE, BLOCKSIZE)
- test("AR-Develop-Feature-columndict-001_PTS001_TC020", Include) {
+ test("Columndict-TC020", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 MB','DICTIONARY_EXCLUDE'='country')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:'resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
@@ -209,7 +209,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Columndict parameter name validation
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC021", Include) {
+ ignore("Columndict-TC021", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata' TBLPROPERTIES ('TABLE_BLOCKSIZE'= '256 MB','DICTIONARY_EXCLUDE'='country')""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='countries:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
@@ -222,7 +222,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Columndict parameter value validation
- test("AR-Develop-Feature-columndict-001_PTS001_TC022", Include) {
+ test("Columndict-TC022", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='salary:$resourcesPath/Data/columndict/country.csv', 'SINGLE_PASS'='true')""").collect
@@ -235,7 +235,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for data validation in csv(empty/null/wrong data) for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC023", Include) {
+ ignore("Columndict-TC023", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/inValidData.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -248,7 +248,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for data validation in csv(empty/null/wrong data) for columndict
- test("AR-Develop-Feature-columndict-001_PTS001_TC024", Include) {
+ test("Columndict-TC024", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('COLUMNDICT'='country:'resourcesPath/Data/columndict/inValidData.csv', 'SINGLE_PASS'='true')""").collect
@@ -261,7 +261,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for validation of external all_dictionary_path folder with incorrect path
- test("AR-Develop-Feature-columndict-001_PTS001_TC025", Include) {
+ test("Columndict-TC025", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('ALL_DICTIONARY_PATH'=''resourcesPath/Data/*.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -274,7 +274,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for validation of external all_dictionary_path folder with correct path
- test("AR-Develop-Feature-columndict-001_PTS001_TC026", Include) {
+ test("Columndict-TC026", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/*.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -287,7 +287,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for validation of external columndict folder with correct path
- test("AR-Develop-Feature-columndict-001_PTS001_TC027", Include) {
+ test("Columndict-TC027", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('COLUMNDICT'='country:'resourcesPath/Data/columndict/*.csv', 'SINGLE_PASS'='true')""").collect
@@ -300,7 +300,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for validation of external all_dictionary_path file( missing /wrong path / wrong name)
- test("AR-Develop-Feature-columndict-001_PTS001_TC028", Include) {
+ test("Columndict-TC028", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('ALL_DICTIONARY_PATH'=''resourcesPath/Data/columndict/wrongName.dictionary', 'SINGLE_PASS'='true')""").collect
@@ -313,7 +313,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for validation of external columndict file( missing /wrong path / wrong name)
- test("AR-Develop-Feature-columndict-001_PTS001_TC029", Include) {
+ test("Columndict-TC029", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('COLUMNDICT'='country:'resourcesPath/Data/columndict/wrongName.csv', 'SINGLE_PASS'='true')""").collect
@@ -326,7 +326,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for different dictionary file extensions for all_dictionary_path
- test("AR-Develop-Feature-columndict-001_PTS001_TC030", Include) {
+ test("Columndict-TC030", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.txt', 'SINGLE_PASS'='true')""").collect
sql(s"""drop table if exists t3""").collect
@@ -334,7 +334,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//Check for different dictionary file extensions for columndict
- test("AR-Develop-Feature-columndict-001_PTS001_TC031", Include) {
+ test("Columndict-TC031", Include) {
try {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/inValidData.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data/columndict/country.txt', 'SINGLE_PASS'='true')""").collect
@@ -347,7 +347,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check limit for all_dictionary_path
- test("AR-Develop-Feature-columndict-001_PTS001_TC032", Include) {
+ test("Columndict-TC032", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 limit 100""").collect
@@ -357,7 +357,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check count for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC033", Include) {
+ ignore("Columndict-TC033", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select count(*) from t3""").collect
@@ -367,7 +367,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check sum for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC034", Include) {
+ ignore("Columndict-TC034", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select sum(salary) from t3""").collect
@@ -377,7 +377,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check >= for all_dictionary_path
- test("AR-Develop-Feature-columndict-001_PTS001_TC035", Include) {
+ test("Columndict-TC035", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where ID >=5""").collect
@@ -387,7 +387,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check != for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC036", Include) {
+ ignore("Columndict-TC036", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where ID != 9""").collect
@@ -397,7 +397,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check between for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC037", Include) {
+ ignore("Columndict-TC037", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id between 2 and 9""").collect
@@ -407,7 +407,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check like for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC038", Include) {
+ ignore("Columndict-TC038", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id Like '9%'""").collect
@@ -417,7 +417,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check group by for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC039", Include) {
+ ignore("Columndict-TC039", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id > 3 group by id,name having id = 2""").collect
@@ -427,7 +427,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check sort by for all_dictionary_path
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC040", Include) {
+ ignore("Columndict-TC040", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('ALL_DICTIONARY_PATH'='$resourcesPath/Data/columndict/data.dictionary', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id > 4 sort by name desc""").collect
@@ -437,7 +437,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check limit for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC041", Include) {
+ ignore("Columndict-TC041", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 limit 100""").collect
@@ -447,7 +447,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check count for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC042", Include) {
+ ignore("Columndict-TC042", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select count(*) from t3""").collect
@@ -457,7 +457,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check sum for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC043", Include) {
+ ignore("Columndict-TC043", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select sum(salary) from t3""").collect
@@ -467,7 +467,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check >= for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC044", Include) {
+ ignore("Columndict-TC044", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where ID >=5""").collect
@@ -477,7 +477,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check != for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC045", Include) {
+ ignore("Columndict-TC045", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where ID != 9""").collect
@@ -487,7 +487,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check between for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC046", Include) {
+ ignore("Columndict-TC046", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id between 2 and 9""").collect
@@ -497,7 +497,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check like for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC047", Include) {
+ ignore("Columndict-TC047", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id Like '9%'""").collect
@@ -507,7 +507,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check group by for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC048", Include) {
+ ignore("Columndict-TC048", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id > 3 group by id,name having id = 2""").collect
@@ -517,7 +517,7 @@ class ColumndictTestCase extends QueryTest with BeforeAndAfterAll {
//To check sort by for columndict
- ignore("AR-Develop-Feature-columndict-001_PTS001_TC049", Include) {
+ ignore("Columndict-TC049", Include) {
sql(s"""CREATE TABLE IF NOT EXISTS t3 (ID Int, country String, name String, phonetype String, serialname String, salary Int,floatField float) STORED BY 'carbondata'""").collect
sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/Data/columndict/data.csv' into table t3 options('COLUMNDICT'='country:$resourcesPath/Data//columndict/country.csv', 'SINGLE_PASS'='true')""").collect
sql(s"""select ID,name from t3 where id > 4 sort by name desc""").collect