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

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

Rahul Kumar created CARBONDATA-2274:
---------------------------------------

             Summary: 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


 

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)