carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Babulal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-1657) Partition column is empty when insert from a hive table
Date Wed, 01 Nov 2017 11:33:00 GMT

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

Babulal commented on CARBONDATA-1657:
-------------------------------------

Hi 
if possible please provide  create statement for hive_table  and dm_trd_wide_carbondata .

also  please check whether date format in carbon.properties is in yyyy-MM-dd format . 
Thanks
Babu

> Partition column is empty when insert from a hive table
> -------------------------------------------------------
>
>                 Key: CARBONDATA-1657
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1657
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-load
>    Affects Versions: 1.2.0
>         Environment: carbonata1.2.0 spark 2.1.1
>            Reporter: cen yuhai
>            Priority: Critical
>
> I create table a carbon table, the schema is like a hive table(dt is the partition column).
> And then
> {code}
> insert overwrite table dm_test.dm_trd_wide_carbondata select * from hive_table where
dt='2017-10-10';
> insert overwrite table dm_test.dm_trd_wide_parquet select * from hive_table where dt='2017-10-10';
> {code}
> {code}
> spark-sql> select dt from dm_test.dm_trd_wide_parquet limit 10;
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> 2017-10-10
> Time taken: 1.259 seconds, Fetched 10 row(s)
> spark-sql> select dt from dm_test.dm_trd_wide_carbondata limit 10;
> NULL
> NULL
> NULL
> NULL
> NULL
> NULL
> NULL
> NULL
> NULL
> NULL
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message