You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Divya Gupta (JIRA)" <ji...@apache.org> on 2017/09/05 05:19:01 UTC
[jira] [Updated] (CARBONDATA-1441) schema change does not reflect
back in hive when schema is alter in carbon
[ https://issues.apache.org/jira/browse/CARBONDATA-1441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Divya Gupta updated CARBONDATA-1441:
------------------------------------
Affects Version/s: 1.2.0
> schema change does not reflect back in hive when schema is alter in carbon
> --------------------------------------------------------------------------
>
> Key: CARBONDATA-1441
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1441
> Project: CarbonData
> Issue Type: Bug
> Components: hive-integration
> Affects Versions: 1.2.0
> Environment: spark2.1,hadoop2.7,hive 1.2.1
> Reporter: anubhav tarar
> Assignee: anubhav tarar
> Priority: Minor
> Fix For: 1.2.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> steps to reproduce
> 1. alter table schema in hive
> 0: jdbc:hive2://localhost:10000> desc uniqdata;
> +----------------------+-----------------+----------+--+
> | col_name | data_type | comment |
> +----------------------+-----------------+----------+--+
> | CUST_ID | int | NULL |
> | CUST_NAME | string | NULL |
> | ACTIVE_EMUI_VERSION | string | NULL |
> | DOB | timestamp | NULL |
> | DOJ | timestamp | NULL |
> | BIGINT_COLUMN1 | bigint | NULL |
> | BIGINT_COLUMN2 | bigint | NULL |
> | DECIMAL_COLUMN1 | decimal(30,10) | NULL |
> | DECIMAL_COLUMN2 | decimal(36,10) | NULL |
> | Double_COLUMN1 | double | NULL |
> | Double_COLUMN2 | double | NULL |
> | INTEGER_COLUMN1 | int | NULL |
> +----------------------+-----------------+----------+--+
> 12 rows selected (0.638 seconds)
> 0: jdbc:hive2://localhost:10000> alter table uniqdata change cust_id cust_id long;
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (7.619 seconds)
> 0: jdbc:hive2://localhost:10000> desc uniqdata;
> +----------------------+-----------------+----------+--+
> | col_name | data_type | comment |
> +----------------------+-----------------+----------+--+
> | cust_id | bigint | NULL |
> | cust_name | string | NULL |
> | active_emui_version | string | NULL |
> | dob | timestamp | NULL |
> | doj | timestamp | NULL |
> | bigint_column1 | bigint | NULL |
> | bigint_column2 | bigint | NULL |
> | decimal_column1 | decimal(30,10) | NULL |
> | decimal_column2 | decimal(36,10) | NULL |
> | double_column1 | double | NULL |
> | double_column2 | double | NULL |
> | integer_column1 | int | NULL |
> +----------------------+-----------------+----------+--+
> 12 rows selected (0.431 seconds)
> 2.start hive cli and desc same table
> 0: jdbc:hive2://localhost:10000> desc uniqdata;
> +----------------------+-----------------+----------+--+
> | col_name | data_type | comment |
> +----------------------+-----------------+----------+--+
> | cust_id | int | |
> | cust_name | string | |
> | active_emui_version | string | |
> | dob | timestamp | |
> | doj | timestamp | |
> | bigint_column1 | bigint | |
> | bigint_column2 | bigint | |
> | decimal_column1 | decimal(30,10) | |
> | decimal_column2 | decimal(36,10) | |
> | double_column1 | double | |
> | double_column2 | double | |
> | integer_column1 | int | |
> +----------------------+------------
> schema change is not reflected in hive when reading carbondata file
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)