You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by manishgupta88 <gi...@git.apache.org> on 2018/05/02 05:54:44 UTC
[GitHub] carbondata pull request #2225: [CARBONDATA-2396] Create Table As Select Fix ...
Github user manishgupta88 commented on a diff in the pull request:
https://github.com/apache/carbondata/pull/2225#discussion_r185398816
--- Diff: integration/spark-common-test/src/test/scala/org/apache/carbondata/sql/commands/UsingCarbondataSuite.scala ---
@@ -69,4 +73,11 @@ class UsingCarbondataSuite extends QueryTest with BeforeAndAfterEach {
res3.foreach(row => assert(row.getString(1).trim.toLong > 0))
}
+ test("CARBONDATA-2396 Support Create Table As Select with'using carbondata'") {
+ sql("CREATE TABLE src_carbondata3(key INT, value STRING) USING carbondata")
+ sql("INSERT INTO src_carbondata3 VALUES(1,'source')")
+ checkAnswer(sql("SELECT * FROM src_carbondata3"), Row(1, "source"))
+ sql("CREATE TABLE src_carbondata4 USING carbondata as select * from src_carbondata3")
+ checkAnswer(sql("SELECT * FROM src_carbondata4"), Row(1, "source"))
+ }
--- End diff --
Add a test case for CTAS with create table if not exists as select
---