Github user rahulforallp commented on a diff in the pull request:
https://github.com/apache/carbondata/pull/2096#discussion_r177705701
--- Diff:
integration/spark-common-test/src/test/scala/org/apache/carbondata/spark/testsuite/standardpartition/StandardPartitionTableLoadingTestCase.scala
---
@@ -135,6 +135,23 @@ class StandardPartitionTableLoadingTestCase extends
QueryTest with BeforeAndAfte
sql("select empno, empname, designation, doj, workgroupcategory,
workgroupcategoryname, deptno, deptname, projectcode, projectjoindate,
projectenddate, attendance, utilization, salary from originTable order by
empno"))
}
+ test("data loading for partition table for five partition column") {
+ sql(
+ """
+ | CREATE TABLE partitionfive (empno int, doj Timestamp,
+ | workgroupcategoryname String, deptno int, deptname String,
+ | projectcode int, projectjoindate Timestamp, projectenddate
Timestamp,attendance int)
+ | PARTITIONED BY (utilization int,salary int,workgroupcategory
int, empname String,
+ | designation String)
+ | STORED BY 'org.apache.carbondata.format'
+ """.stripMargin)
+ sql(s"""LOAD DATA local inpath '$resourcesPath/data.csv' INTO TABLE
partitionfive OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '"')""")
+
+ validateDataFiles("default_partitionfive", "0", 10)
+
+ checkAnswer(sql("select empno, empname, designation, doj,
workgroupcategory, workgroupcategoryname, deptno, deptname, projectcode,
projectjoindate, projectenddate, attendance, utilization, salary from
partitionfive order by empno"),
--- End diff --
@ravipesala you mean i should add filter query also in test case?
without filter also i was able to reproduce it.
---
