[jira] [Commented] (CARBONDATA-1688) Carbon 1.3.0-Partitioning: Hash Partitioning is not working for Date Column

[Akash R Nilugal (Jira)]

    [ 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)