You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Geetika Gupta (JIRA)" <ji...@apache.org> on 2018/01/02 10:35:00 UTC
[jira] [Updated] (CARBONDATA-1965) SET command is not setting the
parameter carbon.options.sort.scope
[ https://issues.apache.org/jira/browse/CARBONDATA-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Geetika Gupta updated CARBONDATA-1965:
--------------------------------------
Description:
I use set command as:
set carbon.options.sort.scope=GLOBAL_SORT;
then I create table as
create table xyz_sort1(id int) stored by 'carbondata';
use desc command:
desc formatted xyz_sort1;
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| col_name | data_type | comment |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| id | int | MEASURE,null |
| | | |
| ##Detailed Table Information | | |
| Database Name | 28dec | |
| Table Name | xyz_sort1 | |
| CARBON Store Path | hdfs://localhost:54311/opt/carbonStore | |
| Comment | | |
| Table Block Size | 1024 MB | |
| Table Data Size | 0 | |
| Table Index Size | 0 | |
| Last Update Time | 0 | |
| SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
| Streaming | false | |
| SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
| | | |
| ##Detailed Column property | | |
| ADAPTIVE | | |
| SORT_COLUMNS | | |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
18 rows selected (0.169 seconds)
The sort_scope for table should be global_sort
was:
I use set command as:
set carbon.options.sort.scope=GLOBAL_SORT;
then I create table as
> SET command is not setting the parameter carbon.options.sort.scope
> ------------------------------------------------------------------
>
> Key: CARBONDATA-1965
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1965
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.3.0
> Environment: spark2.1
> Reporter: Geetika Gupta
> Fix For: 1.3.0
>
>
> I use set command as:
> set carbon.options.sort.scope=GLOBAL_SORT;
> then I create table as
> create table xyz_sort1(id int) stored by 'carbondata';
> use desc command:
> desc formatted xyz_sort1;
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | col_name | data_type | comment |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | id | int | MEASURE,null |
> | | | |
> | ##Detailed Table Information | | |
> | Database Name | 28dec | |
> | Table Name | xyz_sort1 | |
> | CARBON Store Path | hdfs://localhost:54311/opt/carbonStore | |
> | Comment | | |
> | Table Block Size | 1024 MB | |
> | Table Data Size | 0 | |
> | Table Index Size | 0 | |
> | Last Update Time | 0 | |
> | SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
> | Streaming | false | |
> | SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
> | | | |
> | ##Detailed Column property | | |
> | ADAPTIVE | | |
> | SORT_COLUMNS | | |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> 18 rows selected (0.169 seconds)
> The sort_scope for table should be global_sort
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)