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