carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neha Bhardwaj (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-1420) Partition Feature doesn't support a Partition Column of Date Type.
Date Mon, 04 Sep 2017 11:05:00 GMT

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

Neha Bhardwaj updated CARBONDATA-1420:
--------------------------------------
    Description: 
*Create Table :
DROP TABLE IF EXISTS list_partition_table_date;

CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG, doubleField
DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), charField
CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField DATE)
STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010-7-23 , 2011-7-23,
2012-7-23');

*Output : 
Error: java.lang.RuntimeException: 
BaseSqlParser>>>> null
CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)ALTER expected

CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG, doubleField
DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), charField
CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField DATE)
STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010-7-23 , 2011-7-23,
2012-7-23')
^ (state=,code=0)


  was:
*Create Table :
DROP TABLE IF EXISTS list_partition_table_date;

CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG, doubleField
DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), charField
CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField DATE)
STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010/7/23 , 2011/7/23,
2012/7/23');

*Output : 
Error: java.lang.RuntimeException: 
BaseSqlParser>>>> null
CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)ALTER expected

CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG, doubleField
DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), charField
CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField DATE)
STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010/7/23 , 2011/7/23,
2012/7/23')
^ (state=,code=0)



> Partition Feature doesn't support a Partition Column of Date Type.
> ------------------------------------------------------------------
>
>                 Key: CARBONDATA-1420
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1420
>             Project: CarbonData
>          Issue Type: Bug
>         Environment: spark 2.1
>            Reporter: Neha Bhardwaj
>
> *Create Table :
> DROP TABLE IF EXISTS list_partition_table_date;
> CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG,
doubleField DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2),
charField CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField
DATE) STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010-7-23
, 2011-7-23, 2012-7-23');
> *Output : 
> Error: java.lang.RuntimeException: 
> BaseSqlParser>>>> null
> CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)ALTER expected
> CREATE TABLE list_partition_table_date(shortField SHORT, intField INT, bigintField LONG,
doubleField DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2),
charField CHAR(5), floatField FLOAT, complexData ARRAY<STRING> ) PARTITIONED BY (dateField
DATE) STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='2010-7-23
, 2011-7-23, 2012-7-23')
> ^ (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message