You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "anubhav tarar (JIRA)" <ji...@apache.org> on 2017/08/31 11:53:01 UTC
[jira] [Created] (CARBONDATA-1441) schema change does not reflect
back in hive when schema is alter in carbon
anubhav tarar created CARBONDATA-1441:
-----------------------------------------
Summary: 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
Environment: spark2.1,hadoop2.7,hive 1.2.1
Reporter: anubhav tarar
Assignee: anubhav tarar
Priority: Minor
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)