You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Ravindra Pesala (JIRA)" <ji...@apache.org> on 2018/03/29 01:57:00 UTC

[jira] [Resolved] (CARBONDATA-2274) Partition table having more than 4 column giving zero record

     [ https://issues.apache.org/jira/browse/CARBONDATA-2274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ravindra Pesala resolved CARBONDATA-2274.
-----------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.4.0

> Partition table having more than 4 column giving zero record
> ------------------------------------------------------------
>
>                 Key: CARBONDATA-2274
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2274
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Rahul Kumar
>            Assignee: Rahul Kumar
>            Priority: Major
>             Fix For: 1.4.0
>
>         Attachments: 2278.png
>
>          Time Spent: 4h 10m
>  Remaining Estimate: 0h
>
>  
> Partition table having more than 4 column giving zero record.
> Steps to reproduce :
> spark.sql({color:#008000}"drop table if exists stats"{color})
>  spark.sql({color:#008000}s"""
> {color}{color:#008000} |CREATE TABLE stats (
> {color}{color:#008000} | ad STRING,
> {color}{color:#008000} | impressions INT
> {color}{color:#008000} |) PARTITIONED BY (clicks INT,country STRING, year INT, month INT, day INT)
> {color}{color:#008000} |stored by 'carbondata'
> {color}{color:#008000} """{color}.stripMargin
> ){color:#808080}
> {color} spark.sql(
>  {color:#008000}s"""
> {color}{color:#008000} | LOAD DATA LOCAL INPATH '{color}{color:#00b8bb}${color}path{color:#008000}'
> {color}{color:#008000} | INTO TABLE stats
> {color}{color:#008000} | OPTIONS('HEADER'='false')
> {color}{color:#008000} """{color}.stripMargin)
>  {color:#808080}
> {color} spark.sql(
>  {color:#008000}s"""
> {color}{color:#008000} | SELECT * from stats
> {color}{color:#008000} """{color}.stripMargin).show()
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)