carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-201) Add comment Option
Date Tue, 06 Sep 2016 11:36:20 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15467201#comment-15467201
] 

ASF GitHub Bot commented on CARBONDATA-201:
-------------------------------------------

Github user lion-x commented on a diff in the pull request:

    https://github.com/apache/incubator-carbondata/pull/118#discussion_r77618003
  
    --- Diff: integration/spark/src/test/scala/org/apache/carbondata/spark/testsuite/dataload/TestLoadDataWithHiveSyntax.scala
---
    @@ -590,6 +590,23 @@ class TestLoadDataWithHiveSyntax extends QueryTest with BeforeAndAfterAll
{
         checkAnswer(sql("select * from carbontable1"), sql("select * from hivetable1"))
       }
     
    +  test("test data loading with comment option") {
    +    sql("drop table if exists comment_test")
    +    sql(
    +      "create table comment_test(imei string, age int, task bigint, num double, level
decimal(10," +
    +        "3), productdate timestamp, mark int, name string) STORED BY 'org.apache.carbondata.format'"
    +    )
    +    sql(
    +      "LOAD DATA local inpath './src/test/resources/comment.csv' INTO TABLE comment_test
" +
    +        "options('DELIMITER' = ',', 'QUOTECHAR' = '.', 'COMMENTCHAR' = '?','FILEHEADER'='imei,age,task,num,level,productdate,mark,name')"
    +    )
    +    checkAnswer(sql("select imei from comment_test"),Seq(Row("\"huawei"),Row("#huawei"),
Row(""),
    +      Row("~huawei")))
    +    sql("drop table if exists comment_test")
    --- End diff --
    
    ok


> Add comment Option 
> -------------------
>
>                 Key: CARBONDATA-201
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-201
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Lionx
>
> add csv comment option to csv paser, and fix one bug when passing qutochar.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message