You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "anubhav tarar (JIRA)" <ji...@apache.org> on 2018/01/09 08:41:00 UTC
[jira] [Commented] (CARBONDATA-1688) Carbon 1.3.0-Partitioning:
Hash Partitioning is not working for Date Column
[ https://issues.apache.org/jira/browse/CARBONDATA-1688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16318039#comment-16318039 ]
anubhav tarar commented on CARBONDATA-1688:
-------------------------------------------
please check bad_records_action is force if it is force then you have null values in your table please confirm using select * from tablename;
> Carbon 1.3.0-Partitioning: Hash Partitioning is not working for Date Column
> ---------------------------------------------------------------------------
>
> Key: CARBONDATA-1688
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1688
> Project: CarbonData
> Issue Type: Bug
> Components: sql
> Affects Versions: 1.3.0
> Reporter: Ayushi Sharma
> Attachments: Date_hash.PNG, Segment_0.PNG, Segment_1.PNG, Segment_2.PNG
>
>
> On applying hash partition on date column, all the data by default goes to Default partition.
> create table if not exists date_hash(col_A String) partitioned by (col_F Timestamp) stored by 'carbondata' tblproperties('partition_type'='hash','num_partitions'='5');
> insert into table date_hash select 'ayushi','2016-02-02';
> insert into table date_hash select 'ayushi','2016-02-05';
> insert into table date_hash select 'ayushi','2016-01-05';
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)