[
https://issues.apache.org/jira/browse/CARBONDATA-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangsen updated CARBONDATA-2646:
--------------------------------
Description:
!log.png! 【Test step】：
1. Create a table with 'sort_column' tblproperty.
2. Load data into that table with the 'SORT_COLUMN_BOUNDS' property.
Test queries:
drop table if exists sortcolumnboundtable1;
CREATE TABLE sortcolumnboundtable1 (ID Int, date Timestamp, country String,
name String, phonetype String, serialname String, salary Int) STORED BY
'carbondata' tblproperties('sort_columns'='ID,name');
LOAD DATA INPATH '/user/prasanna/source_for_sort_column_bounds.csv' INTO TABLE
sortcolumnboundtable1
OPTIONS('fileheader'='ID,date,country,name,phonetype,serialname,salary','sort_column_bounds'='10,aab1;20,aab1;100,aab1;1000,aab1','timestampformat'='yyyy/MM/dd');
【check the log】
!log_error.png!
was:
!log.png! 【Test step】：
1. Create a table with 'sort_column' tblproperty.
2. Load data into that table with the 'SORT_COLUMN_BOUNDS' property.
Test queries:
drop table if exists sortcolumnboundtable1;
CREATE TABLE sortcolumnboundtable1 (ID Int, date Timestamp, country String,
name String, phonetype String, serialname String, salary Int) STORED BY
'carbondata' tblproperties('sort_columns'='ID,name');
LOAD DATA INPATH '/user/prasanna/source_for_sort_column_bounds.csv' INTO TABLE
sortcolumnboundtable1
OPTIONS('fileheader'='ID,date,country,name,phonetype,serialname,salary','sort_column_bounds'='10,aab1;20,aab1;100,aab1;1000,aab1','timestampformat'='yyyy/MM/dd');
【check the log】
!log.png!
> While loading data into into a table with 'SORT_COLUMN_BOUNDS' property,
> 'ERROR' flag is displayed instead of 'WARN' flag.
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-2646
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2646
> Project: CarbonData
> Issue Type: Bug
> Components: data-load
> Affects Versions: 1.4.0
> Reporter: wangsen
> Assignee: wangsen
> Priority: Minor
> Fix For: 1.4.1
>
>
> !log.png! 【Test step】：
> 1. Create a table with 'sort_column' tblproperty.
> 2. Load data into that table with the 'SORT_COLUMN_BOUNDS' property.
> Test queries:
> drop table if exists sortcolumnboundtable1;
> CREATE TABLE sortcolumnboundtable1 (ID Int, date Timestamp, country String,
> name String, phonetype String, serialname String, salary Int) STORED BY
> 'carbondata' tblproperties('sort_columns'='ID,name');
> LOAD DATA INPATH '/user/prasanna/source_for_sort_column_bounds.csv' INTO
> TABLE sortcolumnboundtable1
> OPTIONS('fileheader'='ID,date,country,name,phonetype,serialname,salary','sort_column_bounds'='10,aab1;20,aab1;100,aab1;1000,aab1','timestampformat'='yyyy/MM/dd');
>
> 【check the log】
> !log_error.png!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
