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)