akashrn5 commented on a change in pull request #3645: [CARBONDATA-3728] Fix
insert failure on partition table with local sort
URL: https://github.com/apache/carbondata/pull/3645#discussion_r386082916
##########
File path:
integration/spark/src/test/scala/org/apache/carbondata/spark/testsuite/standardpartition/StandardPartitionTableLoadingTestCase.scala
##########
@@ -502,6 +502,51 @@ class StandardPartitionTableLoadingTestCase extends
QueryTest with BeforeAndAfte
assert(result.get(0).get(7).equals(dataAndIndexSize._2))
}
+ test("test partition with all sort scope") {
+ sql("drop table if exists origin_csv")
+ sql(
+ s"""
+ | create table origin_csv(col1 int, col2 string, col3 date)
+ | using csv
+ | options('dateFormat'='yyyy-MM-dd', 'timestampFormat'='yyyy-MM-dd
HH:mm:ss')
+ | """.stripMargin)
+ sql("insert into origin_csv select 1, '3aa', to_date('2019-11-11')")
+ sql("insert into origin_csv select 2, '2bb', to_date('2019-11-12')")
+ sql("insert into origin_csv select 3, '1cc', to_date('2019-11-13')")
+ verifyInsertForPartitionTable("tbl_p_ns", "no_sort")
+ verifyInsertForPartitionTable("tbl_p_ls", "local_sort")
+ verifyInsertForPartitionTable("tbl_p_gs", "global_sort")
+ sql("drop table origin_csv")
+ }
+
+ def verifyInsertForPartitionTable(tableName: String, sort_scope: String):
Unit = {
+ sql(s"drop table if exists $tableName")
+ sql(
Review comment:
include one int column also in test
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
