carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anubhav100 <...@git.apache.org>
Subject [GitHub] carbondata issue #959: [CARBONDATA-1053] supported char Type for hive
Date Mon, 05 Jun 2017 17:52:35 GMT
Github user anubhav100 commented on the issue:

    https://github.com/apache/carbondata/pull/959
  
    @chenliang613 i tested it manually here are logs can you merge it
                          INSIDE SPARK SHELL
    scala> carbon.sql("create table chartypes(name string,nickname char) stored by 'carbondata'")
    scala> carbon.sql("""load data inpath 'hdfs://localhost:54310/chartypetest.csv' into
table chartypes""").show
                          INSIDE HIVE SHELL
    hive> CREATE TABLE CHARTYPEHIVE (name string,nickname char(10));
    OK
    Time taken: 1.214 seconds
    hive> ALTER TABLE CHARTYPEHIVE SET FILEFORMAT
        > INPUTFORMAT "org.apache.carbondata.hive.MapredCarbonInputFormat"
        > OUTPUTFORMAT "org.apache.carbondata.hive.MapredCarbonOutputFormat"
        > SERDE "org.apache.carbondata.hive.CarbonHiveSerDe";
    OK
    Time taken: 0.396 seconds
    hive> ALTER TABLE CHARTYPEHIVE SET LOCATION 'hdfs://localhost:54310/opt/carbonStore/default/chartypes'
;
    
    hive> set hive.mapred.supports.subdirectories=true;
    hive> set mapreduce.input.fileinputformat.input.dir.recursive=true;
    hive> select * from chartypehive;
    OK
    ANUBHAV	'ANU'
    Time taken: 0.083 seconds, Fetched: 1 row(s)
    hive> 



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message